librenms-external:/opt/librenms$ ./poller.php -h 17 -m bgp-peers -d LibreNMS Poller SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.52ms] SQL[select count(*) as aggregate from `migrations` [] 4.39ms] SQL[select version() [] 0.86ms] =========================================== Component | Version --------- | ------- LibreNMS | 23.1.1 (2023-02-09T19:33:37+00:00) DB Schema | 2022_09_03_091314_update_ports_adsl_table_with_defaults (248) PHP | 8.1.15 Python | 3.10.10 Database | MariaDB 10.5.16-MariaDB-1:10.5.16+maria~focal RRDTool | 1.7.2 SNMP | 5.9.3 =========================================== DEBUG! Updating os_def.cache Reporting disabled by user setting Override poller modules: bgp-peers Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = 17 ORDER BY `device_id` ASC [] 5.82ms] SQL[select * from `devices` where `device_id` = ? limit 1 [17] 0.97ms] SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [17] 0.83ms] Attempting to initialize OS: iosxe OS initialized: LibreNMS\OS\Iosxe Hostname: 194.X.X.X Device ID: 17 OS: iosxe (cisco) [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '5' '-p' '2500' '-t' '10000' '-O' '0' '194.X.X.X' response: xmt/rcv/%loss = 5/5/0%, min/avg/max = 2.83/5.5/13.1 SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '5' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.9.1.1525 SQL[insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [2.83,13.1,5.5,5,5,0,"{\"poller_name\":\"librenms-external.sip2sip.net\"}",17,"2023-03-13 09:40:03"] 1.56ms] SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [5.5,17] 1.22ms] RRD[update /data/rrd/194.X.X.X/ping-perf.rrd N:5.5] SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [17] 1.62ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-On' '-t' '5' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'] .*.*.0 = 1164373603 SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '5' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 11643711 HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 11643736 RRD[update /data/rrd/194.X.X.X/uptime.rrd N:11643736] Uptime: 4 months 3 weeks 1 day 18 hours 22 minutes 16 seconds SQL[update `devices` set `uptime` = ? where `device_id` = ? [11643736,17] 1.65ms] >> Runtime for poller module 'core': 0.1386 seconds with 41280 bytes >> SNMP: [2/0.13s] MySQL: [1/0.02s] RRD: [1/0.00s] #### Unload poller module core #### RRD[update /data/rrd/194.X.X.X/poller-perf-core.rrd N:0.1385760307312] Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [17] 1.72ms] >> Runtime for poller module 'bgp-peers': 0.0055 seconds with 6168 bytes >> SNMP: [0/0.00s] MySQL: [1/0.02s] RRD: [1/0.00s] #### Unload poller module bgp-peers #### RRD[update /data/rrd/194.X.X.X/poller-perf-bgp-peers.rrd N:0.0055069923400879] RRD[update /data/rrd/194.X.X.X/poller-perf.rrd N:10.277] Polled in 10.277 seconds ### Start Device Groups ### SQL[select * from `device_groups` [] 0.84ms] SQL[select `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3, 4, 5, 6) [] 1.44ms] SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [17] 0.95ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.018s ### #### Start Alerts #### SQL[select `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [17] 1.64ms] SQL[select * from `locations` where `locations`.`id` = ? limit 1 [3] 1.09ms] SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`start`) <= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` in (1, 3)) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` ["2023-03-13T09:40:03.292345Z","2023-03-13T09:40:03.292345Z",0,1,"09:40:03","09:40:03","09:40:03","09:40:03","%","device",17,"device_group","location",3] 1.68ms] SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [17] 0.6ms] SQL[SELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ? LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?)) OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL)) ) [17,17,17,17,17,17,17,17,17,17,17] 2.25ms]