1. librenms-external:/opt/librenms$ ./poller.php -h 17 -m bgp-peers -d
2. LibreNMS Poller
3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.52ms]
4.  
5. SQL[select count(*) as aggregate from `migrations` [] 4.39ms]
6.  
7. SQL[select version() [] 0.86ms]
8.  
9. ===========================================
10. Component | Version
11. --------- | -------
12. LibreNMS  | 23.1.1 (2023-02-09T19:33:37+00:00)
13. DB Schema | 2022_09_03_091314_update_ports_adsl_table_with_defaults (248)
14. PHP       | 8.1.15
15. Python    | 3.10.10
16. Database  | MariaDB 10.5.16-MariaDB-1:10.5.16+maria~focal
17. RRDTool   | 1.7.2
18. SNMP      | 5.9.3
19. ===========================================
20. DEBUG!
21. Updating os_def.cache
22. Reporting disabled by user setting
23. Override poller modules: bgp-peers
24. Starting polling run:
25.  
26. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = 17 ORDER BY `device_id` ASC [] 5.82ms]
27.  
28. SQL[select * from `devices` where `device_id` = ? limit 1 [17] 0.97ms]
29.  
30. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [17] 0.83ms]
31.  
32. Attempting to initialize OS: iosxe
33. OS initialized: LibreNMS\OS\Iosxe
34. Hostname:    194.X.X.X
35. Device ID:   17
36. OS:          iosxe
37.  (cisco)
38.  
39. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '5' '-p' '2500' '-t' '10000' '-O' '0' '194.X.X.X'
40.  
41. response: xmt/rcv/%loss = 5/5/0%, min/avg/max = 2.83/5.5/13.1
42. 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']
43. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.9.1.1525
44.  
45.  
46. 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]
47.  
48. SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [5.5,17] 1.22ms]
49.  
50. RRD[update /data/rrd/194.X.X.X/ping-perf.rrd N:5.5]
51. 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]
52.  
53. Modules status: Global+
54. OS
55. Device
56.  
57. #### Load poller module core ####
58. 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']
59. .*.*.0 = 1164373603
60.  
61.  
62. 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']
63. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 11643711
64. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
65.  
66.  
67. Uptime seconds: 11643736
68.  
69. RRD[update /data/rrd/194.X.X.X/uptime.rrd N:11643736]
70. Uptime: 4 months 3 weeks 1 day 18 hours 22 minutes 16 seconds
71. SQL[update `devices` set `uptime` = ? where `device_id` = ? [11643736,17] 1.65ms]
72.  
73.  
74. >> Runtime for poller module 'core': 0.1386 seconds with 41280 bytes
75. >> SNMP: [2/0.13s] MySQL: [1/0.02s] RRD: [1/0.00s]
76. #### Unload poller module core ####
77.  
78. RRD[update /data/rrd/194.X.X.X/poller-perf-core.rrd N:0.1385760307312]
79. Modules status: Global+
80. OS
81. Device
82.  
83. #### Load poller module bgp-peers ####
84. 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]
85.  
86.  
87. >> Runtime for poller module 'bgp-peers': 0.0055 seconds with 6168 bytes
88. >> SNMP: [0/0.00s] MySQL: [1/0.02s] RRD: [1/0.00s]
89. #### Unload poller module bgp-peers ####
90.  
91. RRD[update /data/rrd/194.X.X.X/poller-perf-bgp-peers.rrd N:0.0055069923400879]
92. RRD[update /data/rrd/194.X.X.X/poller-perf.rrd N:10.277]
93.  
94. Polled in 10.277 seconds
95. ### Start Device Groups ###
96. SQL[select * from `device_groups` [] 0.84ms]
97.  
98. 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]
99.  
100. SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [17] 0.95ms]
101.  
102. Groups Added:
103. Groups Removed:
104. ### End Device Groups, runtime: 0.018s ###
105.  
106. #### Start Alerts ####
107. 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]
108.  
109. SQL[select * from `locations` where `locations`.`id` = ? limit 1 [3] 1.09ms]
110.  
111. SQL[select exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`start`) &lt;= ? 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]
112.  
113. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [17] 0.6ms]
114.  
115. SQL[SELECT DISTINCT a.* FROM alert_rules a
116.         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 = ?)
117.         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 = ?))
118.         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 = ?))
119.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
120.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
121.         WHERE a.disabled = 0 AND (
122.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
123.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
124.             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))
125.         ) [17,17,17,17,17,17,17,17,17,17,17] 2.25ms]