1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.36ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.26ms]
5.  
6. SQL[[1;33mSELECT version() [0;33m[][0m 0.31ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA: 50dd6c1685c6725309d0558a841c294baf103aa2
11. Commit Date: 1624112162
12. DB Schema: 2021_06_07_123600_create_sessions_table (211)
13. PHP: 7.4.3
14. MySQL: 10.3.29-MariaDB-0ubuntu0.20.04.1
15. RRDTool: 1.7.2
16. SNMP: NET-SNMP 5.8
17. ==================================DEBUG!
18. Updating os_def.cache  
19. Starting polling run:
20.  
21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '1ACRAC1' ORDER BY `device_id` ASC [0;33m[][0m 0.91ms]
22.  
23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[28][0m 0.54ms]
24.  
25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[28][0m 0.21ms]
26.  
27. Attempting to initialize OS: generic  
28. OS initialized: LibreNMS\OS\Generic  
29. Hostname:    1acrac1
30. Device ID:   28
31. OS:          generic
32. Resolved IP: 137.189.128.227
33.  
34.  
35. SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["1acrac1"][0m 3.84ms]
36.  
37. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '1acrac1'
38.  
39. response:  {"xmt":3,"rcv":3,"loss":0,"min":1.44,"max":1.59,"avg":1.52,"dup":0,"exitcode":0}
40. SQL[[1;33mselect `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` = ? [0;33m[28][0m 0.48ms]
41.  
42. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[17][0m 0.37ms]
43.  
44. SQL[[1;33mselect 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(`end`) &lt;= ? or time(`start`) > ?))) 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 `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` [0;33m["2021-06-20T09:21:10.461286Z","2021-06-20T09:21:10.461286Z",0,1,"09:21:10","09:21:10","09:21:10","09:21:10","[47m%","device",28,"location",17][0m 1.32ms]
45.  
46. SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":3,"rcv":3,"loss":0,"min":1.44,"max":1.59,"avg":1.52,"device_id":28,"debug":"[]"}[0m 3.91ms]
47.  
48. SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-06-20 17:21:10",1.52,28][0m 3.68ms]
49.  
50. SNMP Check response code: 0  
51. Modules status: Global+  
52. OS  
53. Device  
54.  
55. #### Load poller module core ####
56. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
57. .*.*.0 = 269341302
58. .*.*.0 = RDU-HOST
59. .*.*.0 = .*.4.1.13400.250.10
60. .*.*.0 = Linux RDU-HOST *-670-g914558e #19 PREEMPT Tue Mar 31 11:44:12 CST 2015 armv5tejl  
61.  
62. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
63. snmpEngineTime.0 = 2693412
64. hrSystemUptime.0 = No Such Object available on this agent at this OID  
65.  
66. Uptime seconds: 2693413  
67. Uptime:  31 days 4 hours 10 minutes 13 seconds
68.  
69. >> Runtime for poller module 'core': 0.0719 seconds with 25496 bytes
70. >> SNMP: [2/0.07s] MySQL: [0/0.00s]
71. #### Unload poller module core ####
72.  
73. Modules status: Global+  
74. OS  
75. Device  
76.  
77. #### Load poller module availability ####
78. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[28][0m 0.65ms]
79.  
80. Availability:
81. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[28][0m 0.35ms]
82.  
83. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[28,1624094470][0m 0.34ms]
84.  
85. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,109][0m 0.21ms]
86.  
87. 1 day : 100%
88. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[28,1623576070][0m 0.28ms]
89.  
90. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,110][0m 0.24ms]
91.  
92. 7 days : 100%
93. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[28,1621588870][0m 0.28ms]
94.  
95. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,111][0m 0.2ms]
96.  
97. 30 days : 100%
98. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[28,1592644870][0m 0.24ms]
99.  
100. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,112][0m 0.18ms]
101.  
102. 365 days : 100%
103.  
104. >> Runtime for poller module 'availability': 0.0064 seconds with 39112 bytes
105. >> SNMP: [0/0.00s] MySQL: [5/0.00s]
106. #### Unload poller module availability ####
107.  
108. Modules status: Global-  
109. OS  
110. Device  
111. Module [ unix-agent ] disabled globally.
112.  
113. Modules status: Global+  
114. OS  
115. Device  
116.  
117. #### Load poller module os ####
118. Generic :(
119. Location: Unknown
120. Hardware:
121. OS Version:
122. OS Features:
123. Serial:
124.  
125. >> Runtime for poller module 'os': 0.0024 seconds with 94184 bytes
126. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
127. #### Unload poller module os ####
128.  
129. Modules status: Global+  
130. OS  
131. Device  
132.  
133. #### Load poller module ipmi ####
134. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[28][0m 0.23ms]
135.  
136. array (
137. )  
138.  
139. >> Runtime for poller module 'ipmi': 0.0007 seconds with 2992 bytes
140. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
141. #### Unload poller module ipmi ####
142.  
143. Modules status: Global+  
144. OS  
145. Device  
146.  
147. #### Load poller module sensors ####
148. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[28][0m 0.17ms]
149.  
150.  
151. >> Runtime for poller module 'sensors': 0.0005 seconds with 1584 bytes
152. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
153. #### Unload poller module sensors ####
154.  
155. Modules status: Global+  
156. OS  
157. Device  
158.  
159. #### Load poller module processors ####
160. Attempting to initialize OS: generic  
161. OS initialized: LibreNMS\OS\Generic  
162. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[28][0m 0.18ms]
163.  
164.  
165. >> Runtime for poller module 'processors': 0.0018 seconds with 125928 bytes
166. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
167. #### Unload poller module processors ####
168.  
169. Modules status: Global+  
170. OS  
171. Device  
172.  
173. #### Load poller module mempools ####
174. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[28][0m 0.21ms]
175.  
176.  
177. >> Runtime for poller module 'mempools': 0.0017 seconds with 75672 bytes
178. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
179. #### Unload poller module mempools ####
180.  
181. Modules status: Global+  
182. OS  
183. Device  
184.  
185. #### Load poller module storage ####
186. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[28][0m 0.67ms]
187.  
188.  
189. >> Runtime for poller module 'storage': 0.0010 seconds with 2032 bytes
190. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
191. #### Unload poller module storage ####
192.  
193. Modules status: Global+  
194. OS  
195. Device  
196.  
197. #### Load poller module netstats ####
198.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp'[0m]
199. icmp = No Such Object available on this agent at this OID  
200.  
201. Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID  
202.  IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m]
203. snmpInPkts.0 = 6355
204. snmpInPkts.0 = 6355
205. snmpInPkts.0 = 6355
206. snmpInPkts.0 = 6355
207. snmpInPkts.0 = 6355
208. snmpInPkts.0 = 6355
209. snmpInPkts.0 = 6355
210. snmpInPkts.0 = 6355
211. snmpInPkts.0 = 6355
212. snmpInPkts.0 = 6355
213. snmpInPkts.0 = 6355
214. snmpInPkts.0 = 6355
215. snmpInPkts.0 = 6355
216. snmpInPkts.0 = 6355
217. snmpInPkts.0 = 6355
218. snmpInPkts.0 = 6355  
219.  
220.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
221. No Such Object available on this agent at this OID  
222.  
223.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp'[0m]
224. snmpInPkts.0 = 6357
225. snmpOutPkts.0 = 6356
226. snmpInBadVersions.0 = 0
227. snmpInBadCommunityNames.0 = 14
228. snmpInBadCommunityUses.0 = 0
229. snmpInASNParseErrs.0 = 0
230. snmpInTooBigs.0 = 0
231. snmpInNoSuchNames.0 = 0
232. snmpInBadValues.0 = 0
233. snmpInReadOnlys.0 = 0
234. snmpInGenErrs.0 = 0
235. snmpInTotalReqVars.0 = 9233
236. snmpInTotalSetVars.0 = 0
237. snmpInGetRequests.0 = 6315
238. snmpInGetNexts.0 = 29
239. snmpInSetRequests.0 = 0
240. snmpInGetResponses.0 = 0
241. snmpInTraps.0 = 0
242. snmpOutTooBigs.0 = 0
243. snmpOutNoSuchNames.0 = 0
244. snmpOutBadValues.0 = 0
245. snmpOutGenErrs.0 = 0
246. snmpOutGetRequests.0 = 0
247. snmpOutGetNexts.0 = 0
248. snmpOutSetRequests.0 = 0
249. snmpOutGetResponses.0 = 6344
250. snmpOutTraps.0 = 14
251. snmpEnableAuthenTraps.0 = disabled  
252.  
253.  TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m]
254. mib-* = 6360
255. mib-* = 6360
256. mib-* = 6360
257. mib-* = 6360
258. mib-* = 6360
259. mib-* = 6360
260. mib-* = 6360
261. mib-* = 6360
262. mib-* = 6360
263. mib-* = 6360  
264.  
265.  TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m]
266. mib-* = 6361
267. mib-* = 6361  
268.  
269.  UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m]
270. mib-* = 6362
271. mib-* = 6362
272. mib-* = 6362
273. mib-* = 6362  
274.  
275.  
276.  
277. >> Runtime for poller module 'netstats': 0.2890 seconds with 3896 bytes
278. >> SNMP: [7/0.29s] MySQL: [0/0.00s]
279. #### Unload poller module netstats ####
280.  
281. Modules status: Global+  
282. OS  
283. Device  
284.  
285. #### Load poller module hr-mib ####
286. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
287. hrSystemProcesses.0 = No Such Object available on this agent at this OID
288. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
289.  
290.  
291.  
292. >> Runtime for poller module 'hr-mib': 0.0394 seconds with 1640 bytes
293. >> SNMP: [1/0.04s] MySQL: [0/0.00s]
294. #### Unload poller module hr-mib ####
295.  
296. Modules status: Global+  
297. OS  
298. Device  
299.  
300. #### Load poller module ucd-mib ####
301. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
302. systemStats = No Such Object available on this agent at this OID  
303.  
304. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
305. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
306. laLoadInt.1 = No Such Object available on this agent at this OID
307. laLoadInt.2 = No Such Object available on this agent at this OID
308. laLoadInt.3 = No Such Object available on this agent at this OID  
309.  
310.  
311. >> Runtime for poller module 'ucd-mib': 0.0801 seconds with 1896 bytes
312. >> SNMP: [2/0.08s] MySQL: [0/0.00s]
313. #### Unload poller module ucd-mib ####
314.  
315. Modules status: Global+  
316. OS  
317. Device  
318.  
319. #### Load poller module ipSystemStats ####
320. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
321. ipSystemStatsTable = No Such Object available on this agent at this OID  
322.  
323. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
324.  
325.  
326. >> Runtime for poller module 'ipSystemStats': 0.0505 seconds with 1976 bytes
327. >> SNMP: [1/0.05s] MySQL: [0/0.00s]
328. #### Unload poller module ipSystemStats ####
329.  
330. Modules status: Global+  
331. OS  
332. Device  
333.  
334. #### Load poller module ports ####
335. SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[28][0m 1.44ms]
336.  
337. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
338. ifXEntry = No Such Object available on this agent at this OID  
339.  
340. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
341. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m]
342. ifEntry = No Such Object available on this agent at this OID  
343.  
344. Invalid snmp_walk() data = ifEntry = No Such Object available on this agent at this OID  
345. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
346. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
347.  
348. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
349. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
350. dot1qPvid = No Such Object available on this agent at this OID  
351.  
352. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
353. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[28][0m 0.94ms]
354.  
355. array (
356. )  
357.  
358. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1624180871,null,1624180871][0m 0.21ms]
359.  
360. 0 updated  
361.  
362. >> Runtime for poller module 'ports': 0.1446 seconds with 34656 bytes
363. >> SNMP: [4/0.14s] MySQL: [1/0.00s]
364. #### Unload poller module ports ####
365.  
366. Modules status: Global+  
367. OS  
368. Device  
369.  
370. #### Load poller module customoid ####
371. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[28][0m 0.26ms]
372.  
373.  
374. >> Runtime for poller module 'customoid': 0.0008 seconds with 2488 bytes
375. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
376. #### Unload poller module customoid ####
377.  
378. Modules status: Global+  
379. OS  
380. Device  
381.  
382. #### Load poller module bgp-peers ####
383. SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[28][0m 0.27ms]
384.  
385.  
386. >> Runtime for poller module 'bgp-peers': 0.0020 seconds with 15320 bytes
387. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
388. #### Unload poller module bgp-peers ####
389.  
390. Modules status: Global-  
391. OS  
392. Device  
393. Module [ junose-atm-vp ] disabled globally.
394.  
395. Modules status: Global-  
396. OS  
397. Device  
398. Module [ printer-supplies ] disabled globally.
399.  
400. Modules status: Global+  
401. OS  
402. Device  
403.  
404. #### Load poller module ucd-diskio ####
405. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[28][0m 0.16ms]
406.  
407.  
408. >> Runtime for poller module 'ucd-diskio': 0.0005 seconds with 1944 bytes
409. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
410. #### Unload poller module ucd-diskio ####
411.  
412. Modules status: Global-  
413. OS  
414. Device  
415. Module [ wifi ] disabled globally.
416.  
417. Modules status: Global+  
418. OS  
419. Device  
420.  
421. #### Load poller module wireless ####
422. Attempting to initialize OS: generic  
423. OS initialized: LibreNMS\OS\Generic  
424. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[28][0m 0.21ms]
425.  
426.  
427. >> Runtime for poller module 'wireless': 0.0019 seconds with 104168 bytes
428. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
429. #### Unload poller module wireless ####
430.  
431. Modules status: Global+  
432. OS  
433. Device  
434.  
435. #### Load poller module ospf ####
436.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
437. ospfGeneralGroup = No Such Object available on this agent at this OID  
438.  
439. Invalid snmp_walk() data = ospfGeneralGroup = No Such Object available on this agent at this OID  
440. array (
441. )  
442. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[28][0m 0.63ms]
443.  
444. 0
445. >> Runtime for poller module 'ospf': 0.0437 seconds with 31432 bytes
446. >> SNMP: [1/0.04s] MySQL: [0/0.00s]
447. #### Unload poller module ospf ####
448.  
449. Modules status: Global-  
450. OS  
451. Device  
452. Module [ isis ] disabled globally.
453.  
454. Modules status: Global-  
455. OS  
456. Device  
457. Module [ cisco-ipsec-flow-monitor ] disabled globally.
458.  
459. Modules status: Global-  
460. OS  
461. Device  
462. Module [ cisco-remote-access-monitor ] disabled globally.
463.  
464. Modules status: Global-  
465. OS  
466. Device  
467. Module [ cisco-cef ] disabled globally.
468.  
469. Modules status: Global-  
470. OS  
471. Device  
472. Module [ slas ] disabled globally.
473.  
474. Modules status: Global-  
475. OS  
476. Device  
477. Module [ cisco-mac-accounting ] disabled globally.
478.  
479. Modules status: Global-  
480. OS  
481. Device  
482. Module [ cipsec-tunnels ] disabled globally.
483.  
484. Modules status: Global-  
485. OS  
486. Device  
487. Module [ cisco-ace-loadbalancer ] disabled globally.
488.  
489. Modules status: Global-  
490. OS  
491. Device  
492. Module [ cisco-ace-serverfarms ] disabled globally.
493.  
494. Modules status: Global-  
495. OS  
496. Device  
497. Module [ cisco-asa-firewall ] disabled globally.
498.  
499. Modules status: Global-  
500. OS  
501. Device  
502. Module [ cisco-voice ] disabled globally.
503.  
504. Modules status: Global-  
505. OS  
506. Device  
507. Module [ cisco-cbqos ] disabled globally.
508.  
509. Modules status: Global-  
510. OS  
511. Device  
512. Module [ cisco-otv ] disabled globally.
513.  
514. Modules status: Global-  
515. OS  
516. Device  
517. Module [ cisco-qfp ] disabled globally.
518.  
519. Modules status: Global-  
520. OS  
521. Device  
522. Module [ cisco-vpdn ] disabled globally.
523.  
524. Modules status: Global-  
525. OS  
526. Device  
527. Module [ nac ] disabled globally.
528.  
529. Modules status: Global-  
530. OS  
531. Device  
532. Module [ netscaler-vsvr ] disabled globally.
533.  
534. Modules status: Global-  
535. OS  
536. Device  
537. Module [ aruba-controller ] disabled globally.
538.  
539. Modules status: Global+  
540. OS  
541. Device  
542.  
543. #### Load poller module entity-physical ####
544. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[28][0m 0.4ms]
545.  
546.  
547. >> Runtime for poller module 'entity-physical': 0.0010 seconds with 2152 bytes
548. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
549. #### Unload poller module entity-physical ####
550.  
551. Modules status: Global-  
552. OS  
553. Device  
554. Module [ entity-state ] disabled globally.
555.  
556. Modules status: Global+  
557. OS  
558. Device  
559.  
560. #### Load poller module applications ####
561. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[28][0m 0.21ms]
562.  
563.  
564. >> Runtime for poller module 'applications': 0.0005 seconds with 1592 bytes
565. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
566. #### Unload poller module applications ####
567.  
568. Modules status: Global-  
569. OS  
570. Device  
571. Module [ mib ] disabled globally.
572.  
573. Modules status: Global+  
574. OS  
575. Device  
576.  
577. #### Load poller module stp ####
578. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[28][0m 0.56ms]
579.  
580. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
581. No Such Object available on this agent at this OID  
582.  
583.  
584.  
585. >> Runtime for poller module 'stp': 0.0376 seconds with 5784 bytes
586. >> SNMP: [1/0.04s] MySQL: [1/0.00s]
587. #### Unload poller module stp ####
588.  
589. Modules status: Global+  
590. OS  
591. Device  
592.  
593. #### Load poller module ntp ####
594.  
595. >> Runtime for poller module 'ntp': 0.0002 seconds with 400 bytes
596. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
597. #### Unload poller module ntp ####
598.  
599. Modules status: Global-  
600. OS  
601. Device  
602. Module [ loadbalancers ] disabled globally.
603.  
604. Modules status: Global-  
605. OS  
606. Device  
607. Module [ mef ] disabled globally.
608.  
609. Modules status: Global+  
610. OS  
611. Device  
612.  
613. #### Load poller module mpls ####
614.  
615. >> Runtime for poller module 'mpls': 0.0006 seconds with 24080 bytes
616. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
617. #### Unload poller module mpls ####
618.  
619. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[28][0m 0.77ms]
620.  
621.  
622. SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[2693413,1.52,1.879,28][0m 3.36ms]
623.  
624. Updating 1acrac1  
625.  
626. Polled in 1.879 seconds
627. ### Start Device Groups ###
628. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[28][0m 0.65ms]
629.  
630. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.16ms]
631.  
632. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[28][0m 0.14ms]
633.  
634. Groups Added:  
635. Groups Removed:  
636. ### End Device Groups, runtime: 0.002s ###
637.  
638. #### Start Alerts ####
639. SQL[[1;33mselect 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(`end`) &lt;= ? or time(`start`) > ?))) 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 `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` [0;33m["2021-06-20T09:21:11.312914Z","2021-06-20T09:21:11.312914Z",0,1,"09:21:11","09:21:11","09:21:11","09:21:11","[47m%","device",28,"location",17][0m 0.95ms]
640.  
641. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[28][0m 0.36ms]
642.  
643. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
644.         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 = ?)
645.         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 = ?))
646.         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 = ?))
647.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
648.         WHERE a.disabled = 0 AND (
649.             (d.device_id IS NULL AND g.group_id IS NULL)
650.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
651.             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))
652.         ) [0;33m[28,28,28,28,28,28,28,28][0m 6.59ms]
653.  
654. Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m  
655. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [0;33m[28][0m 0.55ms]
656.  
657. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,28][0m 0.63ms]
658.  
659. Status: [0;34mNOCHG[0m
660. Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m  
661. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [0;33m[28][0m 0.47ms]
662.  
663. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,28][0m 0.29ms]
664.  
665. Status: [0;34mNOCHG[0m
666. Rule [0;35m#3 (Device rebooted):[0m  
667. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed> 10 [0;33m[28][0m 0.43ms]
668.  
669. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,28][0m 0.3ms]
670.  
671. Status: [0;34mNOCHG[0m
672. Rule [0;35m#6 (Port utilisation over threshold):[0m  
673. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[28][0m 1.01ms]
674.  
675. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,28][0m 0.31ms]
676.  
677. Status: [0;34mNOCHG[0m
678. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
679. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[28][0m 0.65ms]
680.  
681. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,28][0m 0.43ms]
682.  
683. Status: [0;34mNOCHG[0m
684. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
685. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current &lt; sensors.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[28][0m 0.45ms]
686.  
687. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,28][0m 0.19ms]
688.  
689. Status: [0;34mNOCHG[0m
690. Rule [0;35m#9 (Service up/down):[0m  
691. SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[28][0m 0.46ms]
692.  
693. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,28][0m 0.19ms]
694.  
695. Status: [0;34mNOCHG[0m
696. Rule [0;35m#12 (State Sensor Critical):[0m  
697. SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 [0;33m[28][0m 0.6ms]
698.  
699. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,28][0m 0.22ms]
700.  
701. Status: [0;34mNOCHG[0m
702. #### End Alerts ####
703. ./poller.php 1ACRAC1 2021-06-20 17:21:11 - 1 devices polled in 2.276 secs  
704. SNMP [20/0.78s]: Get[7/0.26s] Getnext[4/0.16s] Walk[9/0.35s]
705. MySQL [31/0.03s]: Cell[11/0.01s] Row[-10/-0.00s] Rows[22/0.02s] Column[1/0.00s] Update[6/0.01s] Insert[1/0.00s] Delete[0/0.00s]
706.