1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.78ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.68ms]
5.  
6. SQL[[1;33mSELECT version() [0;33m[][0m 0.64ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA: a880643ba447c907bd86d71216fe2a6900bab245
11. Commit Date: 1621427246
12. DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208)
13. PHP: 7.4.16
14. MySQL: 10.5.10-MariaDB-0ubuntu0.21.04.1
15. RRDTool: 1.7.2
16. SNMP: NET-SNMP 5.9
17. ==================================DEBUG!
18. Updating os_def.cache  
19. Starting polling run:
20.  
21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.100.6.152' ORDER BY `device_id` ASC [0;33m[][0m 1.75ms]
22.  
23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[74][0m 1.06ms]
24.  
25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[74][0m 0.81ms]
26.  
27. Attempting to initialize OS: serverscheck  
28. OS initialized as Generic  
29. Hostname:    10.100.6.152
30. Device ID:   74
31. OS:          serverscheck
32.  
33.  
34. SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["10.100.6.152"][0m 0.84ms]
35.  
36. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '10.100.6.152'
37.  
38. response:  {"xmt":3,"rcv":3,"loss":0,"min":0.453,"max":0.533,"avg":0.499,"dup":0,"exitcode":0}
39. 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[74][0m 1.64ms]
40.  
41. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[14][0m 0.94ms]
42.  
43. 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-09T16:43:31.223224Z","2021-06-09T16:43:31.223224Z",0,1,"16:43:31","16:43:31","16:43:31","16:43:31","[43m%","device",74,"location",14][0m 2.16ms]
44.  
45. 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":0.453,"max":0.533,"avg":0.499,"device_id":74,"debug":"[]"}[0m 1.44ms]
46.  
47. SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-06-09 19:43:31",0.499,74][0m 1.25ms]
48.  
49. SNMP Check response code: 0  
50. Modules status: Global+  
51. OS  
52. Device  
53.  
54. #### Load poller module core ####
55. SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
56. .*.*.0 = 3002592
57. .*.*.0 = Controlbox
58. .*.*.0 = .*.4.1.17095.2
59. .*.*.0 = TH-332B  
60.  
61. SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
62. Exitcode: 2  
63. Error in packet
64. Reason: (noSuchName) There is no such variable name in this MIB.
65. Failed object: hrSystemUptime.0.0
66.  
67. Error in packet
68. Reason: (noSuchName) There is no such variable name in this MIB.
69. Failed object: snmpEngineTime.0.0.0  
70.  
71. Error in packet
72. Reason: (noSuchName) There is no such variable name in this MIB.
73. Failed object: hrSystemUptime.0.0
74.  
75. Error in packet
76. Reason: (noSuchName) There is no such variable name in this MIB.
77. Failed object: snmpEngineTime.0.0.0  
78. Uptime seconds: 30026  
79. Uptime:  8 hours 20 minutes 26 seconds
80.  
81. >> Runtime for poller module 'core': 0.0615 seconds with 25496 bytes
82. >> SNMP: [2/0.06s] MySQL: [0/0.00s]
83. #### Unload poller module core ####
84.  
85. Modules status: Global+  
86. OS  
87. Device  
88.  
89. #### Load poller module availability ####
90. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[74][0m 1.24ms]
91.  
92. Availability:
93. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[74][0m 0.93ms]
94.  
95. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[74,1623170611][0m 1.01ms]
96.  
97. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,273][0m 0.73ms]
98.  
99. 1 day : 100%
100. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[74,1622652211][0m 0.89ms]
101.  
102. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,274][0m 0.86ms]
103.  
104. 7 days : 100%
105. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[74,1620665011][0m 0.92ms]
106.  
107. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,275][0m 1.12ms]
108.  
109. 30 days : 100%
110. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[74,1591721011][0m 0.93ms]
111.  
112. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,276][0m 0.72ms]
113.  
114. 365 days : 100%
115.  
116. >> Runtime for poller module 'availability': 0.0159 seconds with 39112 bytes
117. >> SNMP: [0/0.00s] MySQL: [5/0.01s]
118. #### Unload poller module availability ####
119.  
120. Modules status: Global-  
121. OS  
122. Device  
123. Module [ unix-agent ] disabled globally.
124.  
125. Modules status: Global+  
126. OS  
127. Device  
128.  
129. #### Load poller module os ####
130. Generic :(
131. Location: Varna Bulgaria
132. Hardware:
133. OS Version:
134. OS Features:
135. Serial:
136.  
137. >> Runtime for poller module 'os': 0.0046 seconds with 93248 bytes
138. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
139. #### Unload poller module os ####
140.  
141. Modules status: Global+  
142. OS  
143. Device  
144.  
145. #### Load poller module ipmi ####
146. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[74][0m 1.08ms]
147.  
148. array (
149. )  
150.  
151. >> Runtime for poller module 'ipmi': 0.0021 seconds with 2992 bytes
152. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
153. #### Unload poller module ipmi ####
154.  
155. Modules status: Global+  
156. OS  
157. Device  
158.  
159. #### Load poller module sensors ####
160. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[74][0m 0.99ms]
161.  
162.  
163. >> Runtime for poller module 'sensors': 0.0015 seconds with 1584 bytes
164. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
165. #### Unload poller module sensors ####
166.  
167. Modules status: Global+  
168. OS  
169. Device  
170.  
171. #### Load poller module processors ####
172. Attempting to initialize OS: serverscheck  
173. OS initialized as Generic  
174. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[74][0m 0.95ms]
175.  
176.  
177. >> Runtime for poller module 'processors': 0.0038 seconds with 125928 bytes
178. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
179. #### Unload poller module processors ####
180.  
181. Modules status: Global+  
182. OS  
183. Device  
184.  
185. #### Load poller module mempools ####
186. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[74][0m 1.13ms]
187.  
188.  
189. >> Runtime for poller module 'mempools': 0.0039 seconds with 75032 bytes
190. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
191. #### Unload poller module mempools ####
192.  
193. Modules status: Global+  
194. OS  
195. Device  
196.  
197. #### Load poller module storage ####
198. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[74][0m 0.98ms]
199.  
200.  
201. >> Runtime for poller module 'storage': 0.0016 seconds with 2032 bytes
202. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
203. #### Unload poller module storage ####
204.  
205. Modules status: Global+  
206. OS  
207. Device  
208.  
209. #### Load poller module netstats ####
210.  ICMPSNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'icmp'[0m]
211. Exitcode: 1  
212. Error: OID not increasing: icmp
213.  >= sysDescr.0  
214. sysDescr.0 = TH-332B  
215. Error: OID not increasing: icmp
216.  >= sysDescr.0  
217.  IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m]
218. sysDescr.0 = TH-332B
219. sysDescr.0 = TH-332B
220. sysDescr.0 = TH-332B
221. sysDescr.0 = TH-332B
222. sysDescr.0 = TH-332B
223. sysDescr.0 = TH-332B
224. sysDescr.0 = TH-332B
225. sysDescr.0 = TH-332B
226. sysDescr.0 = TH-332B
227. sysDescr.0 = TH-332B
228. sysDescr.0 = TH-332B
229. sysDescr.0 = TH-332B
230. sysDescr.0 = TH-332B
231. sysDescr.0 = TH-332B
232. sysDescr.0 = TH-332B
233. sysDescr.0 = TH-332B  
234.  
235.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
236. Exitcode: 2  
237. Error in packet
238. Reason: (noSuchName) There is no such variable name in this MIB.
239. Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0.0  
240.  
241. Error in packet
242. Reason: (noSuchName) There is no such variable name in this MIB.
243. Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0.0  
244.  SNMPSNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'snmp'[0m]
245. Exitcode: 1  
246. Error: OID not increasing: snmp
247.  >= sysDescr.0  
248. sysDescr.0 = TH-332B  
249. Error: OID not increasing: snmp
250.  >= sysDescr.0  
251.  TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m]
252. mib-* = "TH-332B"
253. mib-* = "TH-332B"
254. mib-* = "TH-332B"
255. mib-* = "TH-332B"
256. mib-* = "TH-332B"
257. mib-* = "TH-332B"
258. mib-* = "TH-332B"
259. mib-* = "TH-332B"
260. mib-* = "TH-332B"
261. mib-* = "TH-332B"  
262.  
263.  TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m]
264. mib-* = "TH-332B"
265. mib-* = "TH-332B"  
266.  
267.  UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m]
268. mib-* = "TH-332B"
269. mib-* = "TH-332B"
270. mib-* = "TH-332B"
271. mib-* = "TH-332B"  
272.  
273.  
274.  
275. >> Runtime for poller module 'netstats': 0.2178 seconds with 3856 bytes
276. >> SNMP: [7/0.21s] MySQL: [0/0.00s]
277. #### Unload poller module netstats ####
278.  
279. Modules status: Global+  
280. OS  
281. Device  
282.  
283. #### Load poller module hr-mib ####
284. SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
285. Exitcode: 2  
286. Error in packet
287. Reason: (noSuchName) There is no such variable name in this MIB.
288. Failed object: hrSystemNumUsers.0.0
289.  
290. Error in packet
291. Reason: (noSuchName) There is no such variable name in this MIB.
292. Failed object: hrSystemProcesses.0.0.0  
293.  
294. Error in packet
295. Reason: (noSuchName) There is no such variable name in this MIB.
296. Failed object: hrSystemNumUsers.0.0
297.  
298. Error in packet
299. Reason: (noSuchName) There is no such variable name in this MIB.
300. Failed object: hrSystemProcesses.0.0.0  
301.  
302.  
303. >> Runtime for poller module 'hr-mib': 0.0321 seconds with 1640 bytes
304. >> SNMP: [1/0.03s] MySQL: [0/0.00s]
305. #### Unload poller module hr-mib ####
306.  
307. Modules status: Global+  
308. OS  
309. Device  
310.  
311. #### Load poller module ucd-mib ####
312. SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'systemStats'[0m]
313.  
314.  
315. SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
316. Exitcode: 2  
317. Error in packet
318. Reason: (noSuchName) There is no such variable name in this MIB.
319. Failed object: laLoadInt.3.0
320.  
321. Error in packet
322. Reason: (noSuchName) There is no such variable name in this MIB.
323. Failed object: laLoadInt.2.0.0
324.  
325. Error in packet
326. Reason: (noSuchName) There is no such variable name in this MIB.
327. Failed object: laLoadInt.1.0.0.0  
328.  
329. Error in packet
330. Reason: (noSuchName) There is no such variable name in this MIB.
331. Failed object: laLoadInt.3.0
332.  
333. Error in packet
334. Reason: (noSuchName) There is no such variable name in this MIB.
335. Failed object: laLoadInt.2.0.0
336.  
337. Error in packet
338. Reason: (noSuchName) There is no such variable name in this MIB.
339. Failed object: laLoadInt.1.0.0.0  
340.  
341. >> Runtime for poller module 'ucd-mib': 0.0589 seconds with 1936 bytes
342. >> SNMP: [2/0.06s] MySQL: [0/0.00s]
343. #### Unload poller module ucd-mib ####
344.  
345. Modules status: Global+  
346. OS  
347. Device  
348.  
349. #### Load poller module ipSystemStats ####
350. SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
351. Exitcode: 1  
352. Error: OID not increasing: ipSystemStatsTable
353.  >= sysDescr.0  
354. sysDescr.0 = TH-332B  
355. Error: OID not increasing: ipSystemStatsTable
356.  >= sysDescr.0  
357. 0
358.  
359. >> Runtime for poller module 'ipSystemStats': 0.0385 seconds with 11456 bytes
360. >> SNMP: [1/0.04s] MySQL: [0/0.00s]
361. #### Unload poller module ipSystemStats ####
362.  
363. Modules status: Global+  
364. OS  
365. Device  
366.  
367. #### Load poller module ports ####
368. 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[74][0m 2.24ms]
369.  
370. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
371. Exitcode: 1  
372. Error: OID not increasing: ifXEntry
373.  >= sysDescr.0  
374. sysDescr.0 = TH-332B  
375. Error: OID not increasing: ifXEntry
376.  >= sysDescr.0  
377. SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'ifEntry'[0m]
378. Exitcode: 1  
379. Error: OID not increasing: ifEntry
380.  >= sysDescr.0  
381. sysDescr.0 = TH-332B  
382. Error: OID not increasing: ifEntry
383.  >= sysDescr.0  
384. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
385. Exitcode: 1  
386. Error: OID not increasing: dot3StatsDuplexStatus
387.  >= sysDescr.0  
388. sysDescr.0 = TH-332B  
389. Error: OID not increasing: dot3StatsDuplexStatus
390.  >= sysDescr.0  
391. SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
392. Exitcode: 1  
393. Error: OID not increasing: dot1qPvid
394.  >= sysDescr.0  
395. sysDescr.0 = TH-332B  
396. Error: OID not increasing: dot1qPvid
397.  >= sysDescr.0  
398. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[74][0m 1.2ms]
399.  
400. array (
401.   0 =>
402.   array (
403.     'sysDescr' => 'TH-332B',
404.   ),
405. )  
406. ignored: empty ifDescr, ifAlias and ifName  
407. SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `port_id` = ? [0;33m["1",null][0m 0.55ms]
408.  
409.  
410. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1623257011,null,1623257011][0m 0.5ms]
411.  
412. 0 updated  
413.  
414. >> Runtime for poller module 'ports': 0.1448 seconds with 27696 bytes
415. >> SNMP: [4/0.13s] MySQL: [2/0.00s]
416. #### Unload poller module ports ####
417.  
418. Modules status: Global+  
419. OS  
420. Device  
421.  
422. #### Load poller module customoid ####
423. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[74][0m 1.04ms]
424.  
425. array (
426.   'customoid_id' => 1,
427.   'device_id' => 74,
428.   'customoid_descr' => 'controlboxTemperature',
429.   'customoid_deleted' => 0,
430.   'customoid_current' => 22.9,
431.   'customoid_prev' => 22.9,
432.   'customoid_oid' => '.1.3.6.1.4.1.17095.2.1.3.0',
433.   'customoid_datatype' => '',
434.   'customoid_unit' => 'Temp',
435.   'customoid_divisor' => 1,
436.   'customoid_multiplier' => 1,
437.   'customoid_limit' => 30.0,
438.   'customoid_limit_warn' => 30.0,
439.   'customoid_limit_low' => 15.0,
440.   'customoid_limit_low_warn' => 15.0,
441.   'customoid_alert' => 1,
442.   'customoid_passed' => 1,
443.   'lastupdate' => '2021-06-09 19:40:43',
444.   'user_func' => NULL,
445. )  
446. SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.17095.2.1.3.0'[0m]
447. "22.8"  
448.  
449. Custom OID controlboxTemperature: 22.8 Temp
450. SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[22.8,22.9,1][0m 1.49ms]
451.  
452. array (
453.   'customoid_id' => 2,
454.   'device_id' => 74,
455.   'customoid_descr' => 'Current Temperature',
456.   'customoid_deleted' => 0,
457.   'customoid_current' => 22.9,
458.   'customoid_prev' => 22.9,
459.   'customoid_oid' => '.1.3.6.1.4.1.17095.2.1.3.0',
460.   'customoid_datatype' => '',
461.   'customoid_unit' => 'Temp',
462.   'customoid_divisor' => 1,
463.   'customoid_multiplier' => 1,
464.   'customoid_limit' => 30.0,
465.   'customoid_limit_warn' => 30.0,
466.   'customoid_limit_low' => 15.0,
467.   'customoid_limit_low_warn' => 15.0,
468.   'customoid_alert' => 1,
469.   'customoid_passed' => 1,
470.   'lastupdate' => '2021-06-09 19:40:43',
471.   'user_func' => NULL,
472. )  
473. SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.17095.2.1.3.0'[0m]
474. "22.8"  
475.  
476. Custom OID Current Temperature: 22.8 Temp
477. SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[22.8,22.9,2][0m 1.08ms]
478.  
479.  
480. >> Runtime for poller module 'customoid': 0.0539 seconds with 3288 bytes
481. >> SNMP: [2/0.05s] MySQL: [3/0.00s]
482. #### Unload poller module customoid ####
483.  
484. Modules status: Global+  
485. OS  
486. Device  
487.  
488. #### Load poller module bgp-peers ####
489. 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[74][0m 1.33ms]
490.  
491.  
492. >> Runtime for poller module 'bgp-peers': 0.0054 seconds with 15272 bytes
493. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
494. #### Unload poller module bgp-peers ####
495.  
496. Modules status: Global-  
497. OS  
498. Device  
499. Module [ junose-atm-vp ] disabled globally.
500.  
501. Modules status: Global-  
502. OS  
503. Device  
504. Module [ printer-supplies ] disabled globally.
505.  
506. Modules status: Global+  
507. OS  
508. Device  
509.  
510. #### Load poller module ucd-diskio ####
511. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[74][0m 0.74ms]
512.  
513.  
514. >> Runtime for poller module 'ucd-diskio': 0.0013 seconds with 1944 bytes
515. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
516. #### Unload poller module ucd-diskio ####
517.  
518. Modules status: Global-  
519. OS  
520. Device  
521. Module [ wifi ] disabled globally.
522.  
523. Modules status: Global+  
524. OS  
525. Device  
526.  
527. #### Load poller module wireless ####
528. Attempting to initialize OS: serverscheck  
529. OS initialized as Generic  
530. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[74][0m 0.91ms]
531.  
532.  
533. >> Runtime for poller module 'wireless': 0.0041 seconds with 104168 bytes
534. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
535. #### Unload poller module wireless ####
536.  
537. Modules status: Global+  
538. OS  
539. Device  
540.  
541. #### Load poller module ospf ####
542.  Processes: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
543. Exitcode: 1  
544. Error: OID not increasing: ospfGeneralGroup
545.  >= sysDescr.0  
546. sysDescr.0 = TH-332B  
547. Error: OID not increasing: ospfGeneralGroup
548.  >= sysDescr.0  
549. array (
550.   0 =>
551.   array (
552.     'sysDescr' => 'TH-332B',
553.   ),
554. )  
555. SQL[[1;33mselect * from `ospf_instances` where (`device_id` = ? and `ospf_instance_id` = ? and `context_name` is null) limit 1 [0;33m[74,0][0m 1.38ms]
556.  
557. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and `id` not in (?) [0;33m[74,2][0m 0.68ms]
558.  
559. 1 Areas: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfAreaEntry'[0m]
560. Exitcode: 1  
561. Error: OID not increasing: ospfAreaEntry
562.  >= sysDescr.0  
563. sysDescr.0 = TH-332B  
564. Error: OID not increasing: ospfAreaEntry
565.  >= sysDescr.0  
566. array (
567.   0 =>
568.   array (
569.     'sysDescr' => 'TH-332B',
570.   ),
571. )  
572. SQL[[1;33mselect * from `ospf_areas` where (`device_id` = ? and `ospfAreaId` = ? and `context_name` is null) limit 1 [0;33m[74,0][0m 1.15ms]
573.  
574. SQL[[1;33mdelete from `ospf_areas` where (`device_id` = ? and `context_name` is null) and `id` not in (?) [0;33m[74,1][0m 0.65ms]
575.  
576. 1 Ports: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfIfEntry'[0m]
577. Exitcode: 1  
578. Error: OID not increasing: ospfIfEntry
579.  >= sysDescr.0  
580. sysDescr.0 = TH-332B  
581. Error: OID not increasing: ospfIfEntry
582.  >= sysDescr.0  
583. array (
584.   0 =>
585.   array (
586.     'sysDescr' => 'TH-332B',
587.   ),
588. )  
589. SQL[[1;33mselect `port_id` from `ipv4_addresses` where `ipv4_address` is null and `context_name` is null limit 1 [0;33m[][0m 0.84ms]
590.  
591. SQL[[1;33mselect * from `ospf_ports` where (`device_id` = ? and `ospf_port_id` = ? and `context_name` is null) limit 1 [0;33m[74,0][0m 1.19ms]
592.  
593. SQL[[1;33mdelete from `ospf_ports` where (`device_id` = ? and `context_name` is null) and `id` not in (?) [0;33m[74,1][0m 0.68ms]
594.  
595. 1 Neighbours: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfNbrEntry'[0m]
596. Exitcode: 1  
597. Error: OID not increasing: ospfNbrEntry
598.  >= sysDescr.0  
599. sysDescr.0 = TH-332B  
600. Error: OID not increasing: ospfNbrEntry
601.  >= sysDescr.0  
602. array (
603.   0 =>
604.   array (
605.     'sysDescr' => 'TH-332B',
606.   ),
607. )  
608. SQL[[1;33mselect `port_id` from `ipv4_addresses` where `ipv4_address` is null and `context_name` is null limit 1 [0;33m[][0m 0.85ms]
609.  
610. SQL[[1;33mselect * from `ospf_nbrs` where (`device_id` = ? and `ospf_nbr_id` = ? and `context_name` is null) limit 1 [0;33m[74,0][0m 1.04ms]
611.  
612. SQL[[1;33mdelete from `ospf_nbrs` where (`device_id` = ? and `context_name` is null) and `id` not in (?) [0;33m[74,1][0m 0.64ms]
613.  
614. 1 TOS Metrics: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfIfMetricEntry'[0m]
615. Exitcode: 1  
616. Error: OID not increasing: ospfIfMetricEntry
617.  >= sysDescr.0  
618. sysDescr.0 = TH-332B  
619. Error: OID not increasing: ospfIfMetricEntry
620.  >= sysDescr.0  
621. array (
622.   0 =>
623.   array (
624.     'sysDescr' => 'TH-332B',
625.   ),
626. )  
627. SQL[[1;33mselect `ospf_port_id` from `ospf_ports` where `ospfIfIpAddress` is null and `context_name` is null limit 1 [0;33m[][0m 0.87ms]
628.  
629. SQL[[1;33mselect * from `ospf_ports` where (`device_id` = ? and `ospf_port_id` is null and `context_name` is null) limit 1 [0;33m[74][0m 0.79ms]
630.  
631. #0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\Database\Connection->runQueryCallback()
632. #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(472): Illuminate\Database\Connection->run()
633. #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(424): Illuminate\Database\Connection->statement()
634. #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert()
635. #4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2882): Illuminate\Database\Query\Processors\Processor->processInsertGetId()
636. #5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1560): Illuminate\Database\Query\Builder->insertGetId()
637. #6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1052): Illuminate\Database\Eloquent\Builder->__call()
638. #7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1017): Illuminate\Database\Eloquent\Model->insertAndSetId()
639. #8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(858): Illuminate\Database\Eloquent\Model->performInsert()
640. #9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(485): Illuminate\Database\Eloquent\Model->save()
641. #10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/helpers.php(263): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}()
642. #11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(486): tap()
643. #12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate()
644. #13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1890): Illuminate\Database\Eloquent\Model->forwardCallTo()
645. #14 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1902): Illuminate\Database\Eloquent\Model->__call()
646. #15 /opt/librenms/includes/polling/ospf.inc.php(152): Illuminate\Database\Eloquent\Model::__callStatic()
647. #16 /opt/librenms/includes/polling/functions.inc.php(317): include('/opt/librenms/i...')
648. #17 /opt/librenms/poller.php(140): poll_device()
649. #18 {main}
650. [0;31mError in ospf module.[0m SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ospf_port_id' cannot be null (SQL: insert into `ospf_ports` (`device_id`, `ospf_port_id`, `context_name`) values (74, ?, ?))
651.  
652. >> Runtime for poller module 'ospf': 0.1891 seconds with 237176 bytes
653. >> SNMP: [5/0.16s] MySQL: [0/0.00s]
654. #### Unload poller module ospf ####
655.  
656. Modules status: Global-  
657. OS  
658. Device  
659. Module [ cisco-ipsec-flow-monitor ] disabled globally.
660.  
661. Modules status: Global-  
662. OS  
663. Device  
664. Module [ cisco-remote-access-monitor ] disabled globally.
665.  
666. Modules status: Global-  
667. OS  
668. Device  
669. Module [ cisco-cef ] disabled globally.
670.  
671. Modules status: Global-  
672. OS  
673. Device  
674. Module [ cisco-sla ] disabled globally.
675.  
676. Modules status: Global-  
677. OS  
678. Device  
679. Module [ cisco-mac-accounting ] disabled globally.
680.  
681. Modules status: Global-  
682. OS  
683. Device  
684. Module [ cipsec-tunnels ] disabled globally.
685.  
686. Modules status: Global-  
687. OS  
688. Device  
689. Module [ cisco-ace-loadbalancer ] disabled globally.
690.  
691. Modules status: Global-  
692. OS  
693. Device  
694. Module [ cisco-ace-serverfarms ] disabled globally.
695.  
696. Modules status: Global-  
697. OS  
698. Device  
699. Module [ cisco-asa-firewall ] disabled globally.
700.  
701. Modules status: Global-  
702. OS  
703. Device  
704. Module [ cisco-voice ] disabled globally.
705.  
706. Modules status: Global-  
707. OS  
708. Device  
709. Module [ cisco-cbqos ] disabled globally.
710.  
711. Modules status: Global-  
712. OS  
713. Device  
714. Module [ cisco-otv ] disabled globally.
715.  
716. Modules status: Global-  
717. OS  
718. Device  
719. Module [ cisco-qfp ] disabled globally.
720.  
721. Modules status: Global-  
722. OS  
723. Device  
724. Module [ cisco-vpdn ] disabled globally.
725.  
726. Modules status: Global-  
727. OS  
728. Device  
729. Module [ nac ] disabled globally.
730.  
731. Modules status: Global-  
732. OS  
733. Device  
734. Module [ netscaler-vsvr ] disabled globally.
735.  
736. Modules status: Global-  
737. OS  
738. Device  
739. Module [ aruba-controller ] disabled globally.
740.  
741. Modules status: Global+  
742. OS  
743. Device  
744.  
745. #### Load poller module entity-physical ####
746. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[74][0m 1.19ms]
747.  
748.  
749. >> Runtime for poller module 'entity-physical': 0.0020 seconds with 2152 bytes
750. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
751. #### Unload poller module entity-physical ####
752.  
753. Modules status: Global-  
754. OS  
755. Device  
756. Module [ entity-state ] disabled globally.
757.  
758. Modules status: Global+  
759. OS  
760. Device  
761.  
762. #### Load poller module applications ####
763. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[74][0m 0.95ms]
764.  
765.  
766. >> Runtime for poller module 'applications': 0.0015 seconds with 1592 bytes
767. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
768. #### Unload poller module applications ####
769.  
770. Modules status: Global-  
771. OS  
772. Device+  
773.  
774. #### Load poller module mib ####
775.  
776. Warning: include(includes/polling/mib.inc.php): failed to open stream: No such file or directory in /opt/librenms/includes/polling/functions.inc.php on line 317
777.  
778. Warning: include(): Failed opening 'includes/polling/mib.inc.php' for inclusion (include_path='.:/usr/share/php') in /opt/librenms/includes/polling/functions.inc.php on line 317
779.  
780. >> Runtime for poller module 'mib': 0.0001 seconds with 0 bytes
781. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
782. #### Unload poller module mib ####
783.  
784. Modules status: Global+  
785. OS  
786. Device  
787.  
788. #### Load poller module stp ####
789. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[74][0m 1.01ms]
790.  
791. SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
792. Exitcode: 2  
793. Error in packet
794. Reason: (noSuchName) There is no such variable name in this MIB.
795. Failed object: BRIDGE-MIB::dot1dStpProtocolSpecification.0.0  
796.  
797. Error in packet
798. Reason: (noSuchName) There is no such variable name in this MIB.
799. Failed object: BRIDGE-MIB::dot1dStpProtocolSpecification.0.0  
800.  
801.  
802. >> Runtime for poller module 'stp': 0.0316 seconds with 5784 bytes
803. >> SNMP: [1/0.03s] MySQL: [1/0.00s]
804. #### Unload poller module stp ####
805.  
806. Modules status: Global+  
807. OS  
808. Device  
809.  
810. #### Load poller module ntp ####
811.  
812. >> Runtime for poller module 'ntp': 0.0003 seconds with 400 bytes
813. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
814. #### Unload poller module ntp ####
815.  
816. Modules status: Global-  
817. OS  
818. Device  
819. Module [ loadbalancers ] disabled globally.
820.  
821. Modules status: Global-  
822. OS  
823. Device  
824. Module [ mef ] disabled globally.
825.  
826. Modules status: Global+  
827. OS  
828. Device  
829.  
830. #### Load poller module mpls ####
831.  
832. >> Runtime for poller module 'mpls': 0.0009 seconds with 24080 bytes
833. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
834. #### Unload poller module mpls ####
835.  
836. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[74][0m 1.26ms]
837.  
838.  
839. SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[30026,0.499,1.977,74][0m 1.65ms]
840.  
841. Updating 10.100.6.152  
842.  
843. Polled in 1.977 seconds
844. ### Start Device Groups ###
845. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[74][0m 1.31ms]
846.  
847. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.86ms]
848.  
849. SQL[[1;33mselect `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) [0;33m[][0m 1.71ms]
850.  
851. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[74][0m 1.12ms]
852.  
853. Groups Added:  
854. Groups Removed:  
855. ### End Device Groups, runtime: 0.0157s ###
856.  
857. #### Start Alerts ####
858. 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-09T16:43:32.198327Z","2021-06-09T16:43:32.198327Z",0,1,"16:43:32","16:43:32","16:43:32","16:43:32","[43m%","device",74,"location",14][0m 1.96ms]
859.  
860. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[74][0m 1.1ms]
861.  
862. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
863.         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 = ?)
864.         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 = ?))
865.         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 = ?))
866.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
867.         WHERE a.disabled = 0 AND (
868.             (d.device_id IS NULL AND g.group_id IS NULL)
869.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
870.             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))
871.         ) [0;33m[74,74,74,74,74,74,74,74][0m 3.71ms]
872.  
873. Rule [0;35m#1 (Devices up/down):[0m  
874. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[74][0m 1.12ms]
875.  
876. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,74][0m 0.77ms]
877.  
878. Status: [0;34mNOCHG[0m
879. Rule [0;35m#2 (Device rebooted):[0m  
880. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed> sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[74][0m 1.29ms]
881.  
882. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,74][0m 1.2ms]
883.  
884. Status: [0;34mNOCHG[0m
885. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
886. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[74][0m 1.22ms]
887.  
888. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,74][0m 0.64ms]
889.  
890. Status: [0;34mNOCHG[0m
891. Rule [0;35m#11 (Wireless Sensor under limit):[0m  
892. SQL[[1;33mSELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current &lt;= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[74][0m 1.19ms]
893.  
894. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,74][0m 0.63ms]
895.  
896. Status: [0;34mNOCHG[0m
897. Rule [0;35m#12 (State Sensor Critical):[0m  
898. 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[74][0m 1.49ms]
899.  
900. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,74][0m 0.64ms]
901.  
902. Status: [0;34mNOCHG[0m
903. #### End Alerts ####
904. ./poller.php 10.100.6.152 2021-06-09 19:43:32 - 1 devices polled in 2.481 secs  
905. SNMP [26/0.80s]: Get[9/0.26s] Getnext[4/0.12s] Walk[13/0.42s]
906. MySQL [36/0.06s]: Cell[13/0.01s] Row[-12/-0.01s] Rows[24/0.04s] Column[1/0.00s] Update[9/0.01s] Insert[1/0.00s] Delete[0/0.00s]
907.