DB::connection sbagliata #45

AlbertoSolaro · 2024-12-27T12:16:30Z

Mi sono accorto che sia sul BGP che sul DNS la connection è sbagliata quindi non sta più aggiornando correttamente il tutto

ComplianceGuard/ps.openaccessitalia.org-main/app/Http/Controllers/Admin/BGPController.php

Line 21 in 9c4a031

    
           $ipv4s_piracy = collect(DB::connection('piracy_shield')->select("select feedbacks.item from (select distinct item from ticket_items_log where item_type = 'ipv4' and `timestamp` > DATE_SUB(now(), INTERVAL ? MONTH)) as feedbacks INNER JOIN (select ipv4 as item from ipv4s where `timestamp` > DATE_SUB(now(), INTERVAL ? MONTH)) as lastitems on feedbacks.item = lastitems.item order by item",[$months,$months]))->pluck('item');

ComplianceGuard/ps.openaccessitalia.org-main/app/Http/Controllers/Admin/DNSController.php

Line 212 in 9c4a031

    
           $piracyshield = collect(DB::connection('piracy_shield')->select("select feedbacks.item from (select distinct item from ticket_items_log where item_type = 'fqdn' and `timestamp` > DATE_SUB(now(), INTERVAL ? MONTH)) as feedbacks INNER JOIN (select fqdn as item from fqdns where `timestamp` > DATE_SUB(now(), INTERVAL ? MONTH)) as lastitems on feedbacks.item = lastitems.item order by item",[$months,$months]))->pluck('item');

This was referenced Dec 27, 2024

Fix wrong db connection #46

Closed

Fix wrong db connection #47

Open

giuseppeRoar mentioned this issue Dec 27, 2024

mancanza config DB "piracy_shield" #48

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

DB::connection sbagliata #45

DB::connection sbagliata #45

AlbertoSolaro commented Dec 27, 2024

DB::connection sbagliata #45

DB::connection sbagliata #45

Comments

AlbertoSolaro commented Dec 27, 2024