1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.27ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.33ms]
5.  
6. SQL[[1;33mSELECT version() [0;33m[][0m 0.19ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA: fff8b8e8321e64057588ed34f13e4364cf4da3a7
11. Commit Date: 1620676608
12. DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208)
13. PHP: 7.3.27-1~deb10u1
14. MySQL: 10.3.27-MariaDB-0+deb10u1
15. RRDTool: 1.7.1
16. SNMP: NET-SNMP 5.7.3
17. ==================================DEBUG!
18. Updating os_def.cache  
19. Starting polling run:
20.  
21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'dsaw1917.infra.wobcom.de' ORDER BY `device_id` ASC [0;33m[][0m 0.63ms]
22.  
23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[84][0m 0.37ms]
24.  
25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[84][0m 0.18ms]
26.  
27. Attempting to initialize OS: generic  
28. OS initialized: LibreNMS\OS\Generic  
29. Hostname:    dsaw1917.infra.wobcom.de
30. Device ID:   84
31. OS:          generic
32. Resolved IP: 10.120.18.231
33.  
34.  
35. SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["dsaw1917.infra.wobcom.de"][0m 0.41ms]
36.  
37. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'dsaw1917.infra.wobcom.de'
38.  
39. response:  {"xmt":3,"rcv":3,"loss":0,"min":2.4,"max":4.38,"avg":3.25,"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[84][0m 0.31ms]
41.  
42. 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` = ?))) as `exists` [0;33m["2021-05-11T13:35:13.073148Z","2021-05-11T13:35:13.073148Z",0,1,"13:35:13","13:35:13","13:35:13","13:35:13","[42m%","device",84][0m 0.56ms]
43.  
44. 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":2.4,"max":4.38,"avg":3.25,"device_id":84,"debug":"[]"}[0m 5.89ms]
45.  
46. SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-05-11 15:35:13",3.25,84][0m 11.44ms]
47.  
48. SNMP Check response code: 0  
49. Modules status: Global+  
50. OS  
51. Device  
52.  
53. #### Load poller module core ####
54. 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]
55. .*.*.0 = 2288928508
56. .*.*.0 = DSAW1917
57. .*.*.0 = .*.4.1.3181.10.6
58. .*.*.0 = MICROSENS G6 Micro-Switch  
59.  
60. 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]
61. snmpEngineTime.0 = 108834877
62. hrSystemUptime.0 = No Such Object available on this agent at this OID  
63.  
64. Uptime seconds: 108834877  
65. Uptime:  3 years 164 days 15 hours 54 minutes 37 seconds
66.  
67. >> Runtime for poller module 'core': 2.3374 seconds with 25256 bytes
68. >> SNMP: [2/2.34s] MySQL: [0/0.00s]
69. #### Unload poller module core ####
70.  
71. Modules status: Global+  
72. OS  
73. Device  
74.  
75. #### Load poller module availability ####
76. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[84][0m 3.75ms]
77.  
78. Availability:
79. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[84][0m 0.27ms]
80.  
81. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[84,1620653716][0m 0.27ms]
82.  
83. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.877,333][0m 0.19ms]
84.  
85. 1 day : 99.877%
86. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[84,1620135316][0m 0.22ms]
87.  
88. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.982,334][0m 0.17ms]
89.  
90. 7 days : 99.982%
91. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[84,1618148116][0m 0.26ms]
92.  
93. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.996,335][0m 0.16ms]
94.  
95. 30 days : 99.996%
96. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[84,1589204116][0m 0.21ms]
97.  
98. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,336][0m 0.16ms]
99.  
100. 365 days : 100%
101.  
102. >> Runtime for poller module 'availability': 0.0081 seconds with 39504 bytes
103. >> SNMP: [0/0.00s] MySQL: [5/0.00s]
104. #### Unload poller module availability ####
105.  
106. Modules status: Global-  
107. OS  
108. Device  
109. Module [ unix-agent ] disabled globally.
110.  
111. Modules status: Global+  
112. OS  
113. Device  
114.  
115. #### Load poller module os ####
116. Generic :(
117. Location:
118. Hardware:
119. OS Version:
120. OS Features:
121. Serial:
122.  
123. >> Runtime for poller module 'os': 0.0012 seconds with 93088 bytes
124. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
125. #### Unload poller module os ####
126.  
127. Modules status: Global+  
128. OS  
129. Device  
130.  
131. #### Load poller module ipmi ####
132. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[84][0m 0.31ms]
133.  
134. array (
135. )  
136.  
137. >> Runtime for poller module 'ipmi': 0.0006 seconds with 2992 bytes
138. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
139. #### Unload poller module ipmi ####
140.  
141. Modules status: Global+  
142. OS  
143. Device  
144.  
145. #### Load poller module sensors ####
146. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[84][0m 0.25ms]
147.  
148.  
149. >> Runtime for poller module 'sensors': 0.0004 seconds with 1544 bytes
150. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
151. #### Unload poller module sensors ####
152.  
153. Modules status: Global+  
154. OS  
155. Device  
156.  
157. #### Load poller module processors ####
158. Attempting to initialize OS: generic  
159. OS initialized: LibreNMS\OS\Generic  
160. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[84][0m 0.28ms]
161.  
162. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.11.11.0'[0m]
163. .*.4.1.2* = 68  
164.  
165. array (
166.   '.1.3.6.1.4.1.2021.11.11.0' => '68',
167. )  
168. CPU: 32%
169.  
170. >> Runtime for poller module 'processors': 0.9049 seconds with 62432 bytes
171. >> SNMP: [1/0.90s] MySQL: [1/0.00s]
172. #### Unload poller module processors ####
173.  
174. Modules status: Global+  
175. OS  
176. Device  
177.  
178. #### Load poller module mempools ####
179. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[84][0m 0.44ms]
180.  
181. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.4.6.0' '.1.3.6.1.4.1.2021.4.14.0' '.1.3.6.1.4.1.2021.4.15.0'[0m]
182. .*.4.1.2* = 89648
183. .*.4.1.2* = 68184
184. .*.4.1.2* = 64348  
185.  
186. Free memory adjusted by availability calculation: 87.55 MiiB -> 216.97 MiiB
187.  
188. ucd [system]: Physical memory: 131.42 MiiB / 248.39 MiiB
189. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[32948224,227512320,168][0m 14.07ms]
190.  
191. ucd [buffers]: Memory buffers: 27f.59 MiiB / 248.39 MiiB
192. ucd [cached]: Cached memory: 25b.84 MiiB / 248.39 MiiB
193. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[65892352,194568192,170][0m 16.78ms]
194.  
195.  
196. >> Runtime for poller module 'mempools': 0.0971 seconds with 106904 bytes
197. >> SNMP: [1/0.06s] MySQL: [0/0.00s]
198. #### Unload poller module mempools ####
199.  
200. Modules status: Global+  
201. OS  
202. Device  
203.  
204. #### Load poller module storage ####
205. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[84][0m 0.38ms]
206.  
207.  
208. >> Runtime for poller module 'storage': 0.0007 seconds with 1984 bytes
209. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
210. #### Unload poller module storage ####
211.  
212. Modules status: Global+  
213. OS  
214. Device  
215.  
216. #### Load poller module netstats ####
217.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp'[0m]
218. icmp = No Such Object available on this agent at this OID  
219.  
220. Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID  
221.  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]
222. ipForwDatagrams.0 = 0
223. ipInDelivers.0 = 50157056
224. ipInReceives.0 = 61034886
225. ipOutRequests.0 = 36794474
226. ipInDiscards.0 = 0
227. ipOutDiscards.0 = 0
228. ipOutNoRoutes.0 = 0
229. ipReasmReqds.0 = 1099
230. ipReasmOKs.0 = 486
231. ipReasmFails.0 = 0
232. ipFragOKs.0 = 0
233. ipFragFails.0 = 0
234. ipFragCreates.0 = 0
235. ipInUnknownProtos.0 = 68
236. ipInHdrErrors.0 = 0
237. ipInAddrErrors.0 = 2070351  
238.  
239.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
240. No Such Object available on this agent at this OID  
241.  
242.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp'[0m]
243. snmp = No Such Object available on this agent at this OID  
244.  
245. Invalid snmp_walk() data = snmp = No Such Object available on this agent at this OID  
246.  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]
247. transmission.*.101 = 101
248. transmission.*.101 = 101
249. transmission.*.101 = 101
250. transmission.*.101 = 101
251. transmission.*.101 = 101
252. transmission.*.101 = 101
253. transmission.*.101 = 101
254. transmission.*.101 = 101
255. transmission.*.101 = 101
256. transmission.*.101 = 101  
257.  
258.  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]
259. transmission.*.101 = 101
260. transmission.*.101 = 101  
261.  
262.  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]
263. transmission.*.101 = 101
264. transmission.*.101 = 101
265. transmission.*.101 = 101
266. transmission.*.101 = 101  
267.  
268.  
269.  
270. >> Runtime for poller module 'netstats': 2.2578 seconds with 3704 bytes
271. >> SNMP: [7/2.26s] MySQL: [0/0.00s]
272. #### Unload poller module netstats ####
273.  
274. Modules status: Global+  
275. OS  
276. Device  
277.  
278. #### Load poller module hr-mib ####
279. 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]
280. hrSystemProcesses.0 = No Such Object available on this agent at this OID
281. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
282.  
283.  
284.  
285. >> Runtime for poller module 'hr-mib': 0.0158 seconds with 1640 bytes
286. >> SNMP: [1/0.02s] MySQL: [0/0.00s]
287. #### Unload poller module hr-mib ####
288.  
289. Modules status: Global+  
290. OS  
291. Device  
292.  
293. #### Load poller module ucd-mib ####
294. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
295. ssIndex.0 = 1
296. ssErrorName.0 = systemStats
297. ssSwapIn.0 = 0
298. ssSwapOut.0 = 0
299. ssIOSent.0 = 0
300. ssIOReceive.0 = 1
301. ssSysInterrupts.0 = 2
302. ssSysContext.0 = 1
303. ssCpuUser.0 = 5
304. ssCpuSystem.0 = 25
305. ssCpuIdle.0 = 68
306. ssCpuRawUser.0 = 125239172
307. ssCpuRawNice.0 = 0
308. ssCpuRawSystem.0 = 591821914
309. ssCpuRawIdle.0 = 1574032430
310. ssCpuRawWait.0 = 44745
311. ssCpuRawKernel.0 = 590996779
312. ssCpuRawInterrupt.0 = 295925
313. ssIORawSent.0 = 27986726
314. ssIORawReceived.0 = 129482
315. ssRawInterrupts.0 = 2447989166
316. ssRawContexts.0 = 3280946129
317. ssCpuRawSoftIRQ.0 = 529210
318. ssRawSwapIn.0 = 0
319. ssRawSwapOut.0 = 0  
320.  
321. 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]
322. laLoadInt.1 = 115
323. laLoadInt.2 = 129
324. laLoadInt.3 = 124  
325.  
326.  
327. >> Runtime for poller module 'ucd-mib': 0.0428 seconds with 4688 bytes
328. >> SNMP: [2/0.04s] MySQL: [0/0.00s]
329. #### Unload poller module ucd-mib ####
330.  
331. Modules status: Global+  
332. OS  
333. Device  
334.  
335. #### Load poller module ipSystemStats ####
336. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
337. ipSystemStatsTable = No Such Object available on this agent at this OID  
338.  
339. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
340.  
341.  
342. >> Runtime for poller module 'ipSystemStats': 0.4638 seconds with 1976 bytes
343. >> SNMP: [1/0.46s] MySQL: [0/0.00s]
344. #### Unload poller module ipSystemStats ####
345.  
346. Modules status: Global+  
347. OS  
348. Device  
349.  
350. #### Load poller module ports ####
351. 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[84][0m 0.87ms]
352.  
353. 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]
354. ifAlias.101 = Port 1
355. ifAlias.102 = Port 2
356. ifAlias.103 = Port 3
357. ifAlias.104 = Port 4
358. ifAlias.105 = Downlink (Port 5)
359. ifAlias.106 = Uplink (Port 6)  
360.  
361. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m]
362. ifIndex.101 = 101
363. ifIndex.102 = 102
364. ifIndex.103 = 103
365. ifIndex.104 = 104
366. ifIndex.105 = 105
367. ifIndex.106 = 106
368. ifDescr.101 = Port 1
369. ifDescr.102 = Port 2
370. ifDescr.103 = Port 3
371. ifDescr.104 = Port 4
372. ifDescr.105 = Downlink (Port 5)
373. ifDescr.106 = Uplink (Port 6)
374. ifType.101 = ethernetCsmacd
375. ifType.102 = ethernetCsmacd
376. ifType.103 = ethernetCsmacd
377. ifType.104 = ethernetCsmacd
378. ifType.105 = ethernetCsmacd
379. ifType.106 = ethernetCsmacd
380. ifMtu.101 = 10240
381. ifMtu.102 = 10240
382. ifMtu.103 = 10240
383. ifMtu.104 = 10240
384. ifMtu.105 = 10240
385. ifMtu.106 = 10240
386. ifSpeed.101 = 1000000000
387. ifSpeed.102 = 0
388. ifSpeed.103 = 100000000
389. ifSpeed.104 = 100000000
390. ifSpeed.105 = 1000000000
391. ifSpeed.106 = 0
392. ifPhysAddress.101 =
393. ifPhysAddress.102 =
394. ifPhysAddress.103 =
395. ifPhysAddress.104 =
396. ifPhysAddress.105 =
397. ifPhysAddress.106 =
398. ifAdminStatus.101 = up
399. ifAdminStatus.102 = up
400. ifAdminStatus.103 = up
401. ifAdminStatus.104 = up
402. ifAdminStatus.105 = up
403. ifAdminStatus.106 = up
404. ifOperStatus.101 = up
405. ifOperStatus.102 = down
406. ifOperStatus.103 = up
407. ifOperStatus.104 = up
408. ifOperStatus.105 = up
409. ifOperStatus.106 = down
410. ifLastChange.101 = 2233361008
411. ifLastChange.102 = 13514408
412. ifLastChange.103 = 2098141408
413. ifLastChange.104 = 2098141508
414. ifLastChange.105 = 2106415808
415. ifLastChange.106 = 1900
416. ifInOctets.101 = 1963883910
417. ifInOctets.102 = 1821648028
418. ifInOctets.103 = 3495314758
419. ifInOctets.104 = 3698532465
420. ifInOctets.105 = 1555748845
421. ifInOctets.106 = 0
422. ifInUcastPkts.101 = 172855918
423. ifInUcastPkts.102 = 10415362
424. ifInUcastPkts.103 = 9347666
425. ifInUcastPkts.104 = 3339920040
426. ifInUcastPkts.105 = 2341237490
427. ifInUcastPkts.106 = 0
428. ifInNUcastPkts.101 = 6282051
429. ifInNUcastPkts.102 = 106270
430. ifInNUcastPkts.103 = 263491
431. ifInNUcastPkts.104 = 6941508
432. ifInNUcastPkts.105 = 3869241846
433. ifInNUcastPkts.106 = 0
434. ifInDiscards.101 = 0
435. ifInDiscards.102 = 0
436. ifInDiscards.103 = 0
437. ifInDiscards.104 = 0
438. ifInDiscards.105 = 2
439. ifInDiscards.106 = 0
440. ifInErrors.101 = 0
441. ifInErrors.102 = 0
442. ifInErrors.103 = 0
443. ifInErrors.104 = 0
444. ifInErrors.105 = 0
445. ifInErrors.106 = 0
446. ifInUnknownProtos.101 = 0
447. ifInUnknownProtos.102 = 0
448. ifInUnknownProtos.103 = 0
449. ifInUnknownProtos.104 = 0
450. ifInUnknownProtos.105 = 0
451. ifInUnknownProtos.106 = 0
452. ifOutOctets.101 = 462797961
453. ifOutOctets.102 = 1071003252
454. ifOutOctets.103 = 1864893987
455. ifOutOctets.104 = 2827779130
456. ifOutOctets.105 = 2631265536
457. ifOutOctets.106 = 1047
458. ifOutUcastPkts.101 = 344900451
459. ifOutUcastPkts.102 = 37563177
460. ifOutUcastPkts.103 = 23871092
461. ifOutUcastPkts.104 = 1686992408
462. ifOutUcastPkts.105 = 3563424653
463. ifOutUcastPkts.106 = 3
464. ifOutNUcastPkts.101 = 2460027866
465. ifOutNUcastPkts.102 = 93770398
466. ifOutNUcastPkts.103 = 177100246
467. ifOutNUcastPkts.104 = 181376804
468. ifOutNUcastPkts.105 = 10167345
469. ifOutNUcastPkts.106 = 4
470. ifOutDiscards.101 = 0
471. ifOutDiscards.102 = 0
472. ifOutDiscards.103 = 0
473. ifOutDiscards.104 = 0
474. ifOutDiscards.105 = 0
475. ifOutDiscards.106 = 0
476. ifOutErrors.101 = 0
477. ifOutErrors.102 = 0
478. ifOutErrors.103 = 0
479. ifOutErrors.104 = 0
480. ifOutErrors.105 = 0
481. ifOutErrors.106 = 0
482. ifOutQLen.101 = 0
483. ifOutQLen.102 = 0
484. ifOutQLen.103 = 0
485. ifOutQLen.104 = 0
486. ifOutQLen.105 = 0
487. ifOutQLen.106 = 0
488. ifSpecific.101 = zeroDotZero
489. ifSpecific.102 = zeroDotZero
490. ifSpecific.103 = zeroDotZero
491. ifSpecific.104 = zeroDotZero
492. ifSpecific.105 = zeroDotZero
493. ifSpecific.106 = zeroDotZero  
494.  
495. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
496. dot3StatsDuplexStatus.101 = fullDuplex
497. dot3StatsDuplexStatus.102 = unknown
498. dot3StatsDuplexStatus.103 = fullDuplex
499. dot3StatsDuplexStatus.104 = fullDuplex
500. dot3StatsDuplexStatus.105 = fullDuplex
501. dot3StatsDuplexStatus.106 = unknown  
502.  
503. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
504. dot1qPvid.1 = 1
505. dot1qPvid.2 = 508
506. dot1qPvid.3 = 40
507. dot1qPvid.4 = 518
508. dot1qPvid.5 = 1
509. dot1qPvid.6 = 1  
510.  
511. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[84][0m 0.82ms]
512.  
513. array (
514.   101 =>
515.   array (
516.     'ifAlias' => 'Port 1',
517.     'ifIndex' => '101',
518.     'ifDescr' => 'Port 1',
519.     'ifType' => 'ethernetCsmacd',
520.     'ifMtu' => '10240',
521.     'ifSpeed' => '1000000000',
522.     'ifPhysAddress' => '',
523.     'ifAdminStatus' => 'up',
524.     'ifOperStatus' => 'up',
525.     'ifLastChange' => '2233361008',
526.     'ifInOctets' => '1963883910',
527.     'ifInUcastPkts' => '172855918',
528.     'ifInNUcastPkts' => '6282051',
529.     'ifInDiscards' => '0',
530.     'ifInErrors' => '0',
531.     'ifInUnknownProtos' => '0',
532.     'ifOutOctets' => '462797961',
533.     'ifOutUcastPkts' => '344900451',
534.     'ifOutNUcastPkts' => '2460027866',
535.     'ifOutDiscards' => '0',
536.     'ifOutErrors' => '0',
537.     'ifOutQLen' => '0',
538.     'ifSpecific' => 'zeroDotZero',
539.     'dot3StatsDuplexStatus' => 'fullDuplex',
540.   ),
541.   102 =>
542.   array (
543.     'ifAlias' => 'Port 2',
544.     'ifIndex' => '102',
545.     'ifDescr' => 'Port 2',
546.     'ifType' => 'ethernetCsmacd',
547.     'ifMtu' => '10240',
548.     'ifSpeed' => '0',
549.     'ifPhysAddress' => '',
550.     'ifAdminStatus' => 'up',
551.     'ifOperStatus' => 'down',
552.     'ifLastChange' => '13514408',
553.     'ifInOctets' => '1821648028',
554.     'ifInUcastPkts' => '10415362',
555.     'ifInNUcastPkts' => '106270',
556.     'ifInDiscards' => '0',
557.     'ifInErrors' => '0',
558.     'ifInUnknownProtos' => '0',
559.     'ifOutOctets' => '1071003252',
560.     'ifOutUcastPkts' => '37563177',
561.     'ifOutNUcastPkts' => '93770398',
562.     'ifOutDiscards' => '0',
563.     'ifOutErrors' => '0',
564.     'ifOutQLen' => '0',
565.     'ifSpecific' => 'zeroDotZero',
566.     'dot3StatsDuplexStatus' => 'unknown',
567.   ),
568.   103 =>
569.   array (
570.     'ifAlias' => 'Port 3',
571.     'ifIndex' => '103',
572.     'ifDescr' => 'Port 3',
573.     'ifType' => 'ethernetCsmacd',
574.     'ifMtu' => '10240',
575.     'ifSpeed' => '100000000',
576.     'ifPhysAddress' => '',
577.     'ifAdminStatus' => 'up',
578.     'ifOperStatus' => 'up',
579.     'ifLastChange' => '2098141408',
580.     'ifInOctets' => '3495314758',
581.     'ifInUcastPkts' => '9347666',
582.     'ifInNUcastPkts' => '263491',
583.     'ifInDiscards' => '0',
584.     'ifInErrors' => '0',
585.     'ifInUnknownProtos' => '0',
586.     'ifOutOctets' => '1864893987',
587.     'ifOutUcastPkts' => '23871092',
588.     'ifOutNUcastPkts' => '177100246',
589.     'ifOutDiscards' => '0',
590.     'ifOutErrors' => '0',
591.     'ifOutQLen' => '0',
592.     'ifSpecific' => 'zeroDotZero',
593.     'dot3StatsDuplexStatus' => 'fullDuplex',
594.   ),
595.   104 =>
596.   array (
597.     'ifAlias' => 'Port 4',
598.     'ifIndex' => '104',
599.     'ifDescr' => 'Port 4',
600.     'ifType' => 'ethernetCsmacd',
601.     'ifMtu' => '10240',
602.     'ifSpeed' => '100000000',
603.     'ifPhysAddress' => '',
604.     'ifAdminStatus' => 'up',
605.     'ifOperStatus' => 'up',
606.     'ifLastChange' => '2098141508',
607.     'ifInOctets' => '3698532465',
608.     'ifInUcastPkts' => '3339920040',
609.     'ifInNUcastPkts' => '6941508',
610.     'ifInDiscards' => '0',
611.     'ifInErrors' => '0',
612.     'ifInUnknownProtos' => '0',
613.     'ifOutOctets' => '2827779130',
614.     'ifOutUcastPkts' => '1686992408',
615.     'ifOutNUcastPkts' => '181376804',
616.     'ifOutDiscards' => '0',
617.     'ifOutErrors' => '0',
618.     'ifOutQLen' => '0',
619.     'ifSpecific' => 'zeroDotZero',
620.     'dot3StatsDuplexStatus' => 'fullDuplex',
621.   ),
622.   105 =>
623.   array (
624.     'ifAlias' => 'Downlink (Port 5)',
625.     'ifIndex' => '105',
626.     'ifDescr' => 'Downlink (Port 5)',
627.     'ifType' => 'ethernetCsmacd',
628.     'ifMtu' => '10240',
629.     'ifSpeed' => '1000000000',
630.     'ifPhysAddress' => '',
631.     'ifAdminStatus' => 'up',
632.     'ifOperStatus' => 'up',
633.     'ifLastChange' => '2106415808',
634.     'ifInOctets' => '1555748845',
635.     'ifInUcastPkts' => '2341237490',
636.     'ifInNUcastPkts' => '3869241846',
637.     'ifInDiscards' => '2',
638.     'ifInErrors' => '0',
639.     'ifInUnknownProtos' => '0',
640.     'ifOutOctets' => '2631265536',
641.     'ifOutUcastPkts' => '3563424653',
642.     'ifOutNUcastPkts' => '10167345',
643.     'ifOutDiscards' => '0',
644.     'ifOutErrors' => '0',
645.     'ifOutQLen' => '0',
646.     'ifSpecific' => 'zeroDotZero',
647.     'dot3StatsDuplexStatus' => 'fullDuplex',
648.   ),
649.   106 =>
650.   array (
651.     'ifAlias' => 'Uplink (Port 6)',
652.     'ifIndex' => '106',
653.     'ifDescr' => 'Uplink (Port 6)',
654.     'ifType' => 'ethernetCsmacd',
655.     'ifMtu' => '10240',
656.     'ifSpeed' => '0',
657.     'ifPhysAddress' => '',
658.     'ifAdminStatus' => 'up',
659.     'ifOperStatus' => 'down',
660.     'ifLastChange' => '1900',
661.     'ifInOctets' => '0',
662.     'ifInUcastPkts' => '0',
663.     'ifInNUcastPkts' => '0',
664.     'ifInDiscards' => '0',
665.     'ifInErrors' => '0',
666.     'ifInUnknownProtos' => '0',
667.     'ifOutOctets' => '1047',
668.     'ifOutUcastPkts' => '3',
669.     'ifOutNUcastPkts' => '4',
670.     'ifOutDiscards' => '0',
671.     'ifOutErrors' => '0',
672.     'ifOutQLen' => '0',
673.     'ifSpecific' => 'zeroDotZero',
674.     'dot3StatsDuplexStatus' => 'unknown',
675.   ),
676.   1 =>
677.   array (
678.     'dot1qPvid' => '1',
679.   ),
680.   2 =>
681.   array (
682.     'dot1qPvid' => '508',
683.   ),
684.   3 =>
685.   array (
686.     'dot1qPvid' => '40',
687.   ),
688.   4 =>
689.   array (
690.     'dot1qPvid' => '518',
691.   ),
692.   5 =>
693.   array (
694.     'dot1qPvid' => '1',
695.   ),
696.   6 =>
697.   array (
698.     'dot1qPvid' => '1',
699.   ),
700. )  
701.  valid  
702.  valid  
703.  valid  
704.  valid  
705.  valid  
706.  valid  
707. ignored: empty ifDescr, ifAlias and ifName  
708. SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `port_id` = ? [0;33m["1",null][0m 0.36ms]
709.  
710. ignored: empty ifDescr, ifAlias and ifName  
711. ignored: empty ifDescr, ifAlias and ifName  
712. ignored: empty ifDescr, ifAlias and ifName  
713. ignored: empty ifDescr, ifAlias and ifName  
714. ignored: empty ifDescr, ifAlias and ifName  
715.  
716. Port Port 1: Port 1 (101 / #4735) ifInOctets  
717. ifOutOctets  
718. ifInUcastPkts  
719. ifOutUcastPkts  
720. ifInBroadcastPkts  
721. ifOutBroadcastPkts  
722. ifInMulticastPkts  
723. ifOutMulticastPkts  
724. ifSpeed  
725. dot3Duplex VLAN =   Using ifDescr as ifName  
726. Port 1
727.  ifInOctets (2945 B) 210.35714285714 Bps 14 secs  
728.  
729.  ifOutOctets (45885 B) 3277.5 Bps 14 secs  
730.  
731.  ifInErrors (0 B) 0 Bps 14 secs  
732.  
733.  ifOutErrors (0 B) 0 Bps 14 secs  
734.  
735.  ifInUcastPkts (5 B) 0.35714285714286 Bps 14 secs  
736.  
737.  ifOutUcastPkts (24 B) 1.7142857142857 Bps 14 secs  
738.  
739.  ifInNUcastPkts (0 B) 0 Bps 14 secs  
740.  
741.  ifOutNUcastPkts (383 B) 27.357142857143 Bps 14 secs  
742.  
743.  ifInDiscards (0 B) 0 Bps 14 secs  
744.  
745.  ifOutDiscards (0 B) 0 Bps 14 secs  
746.  
747.  ifInUnknownProtos (0 B) 0 Bps 14 secs  
748.  
749.  ifInBroadcastPkts (0 B) 0 Bps 14 secs  
750.  
751.  ifOutBroadcastPkts (0 B) 0 Bps 14 secs  
752.  
753.  ifInMulticastPkts (0 B) 0 Bps 14 secs  
754.  
755.  ifOutMulticastPkts (0 B) 0 Bps 14 secs  
756. bps(1.68 Kbps/26.22 Kbps)bytes(2.88 KiB/44.81 KiB)pkts(0.36 pps/1.71 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1963883910",1963880965,210.35714285714286,2945,"462797961",462752076,3277.5,45885,"0",0,0,0,"0",0,0,0,"172855918",172855913,0.35714285714285715,5,"344900451",344900427,1.7142857142857142,24,1620740131,1620740117,14,4735][0m 6ms]
757.  
758. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["6282051",6282051,0,0,"2460027866",2460027483,27.357142857142858,383,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4735][0m 10.71ms]
759.  
760. 2 updated  
761.  
762. Port Port 2: Port 2 (102 / #4736) ifInOctets  
763. ifOutOctets  
764. ifInUcastPkts  
765. ifOutUcastPkts  
766. ifInBroadcastPkts  
767. ifOutBroadcastPkts  
768. ifInMulticastPkts  
769. ifOutMulticastPkts  
770. ifSpeed  
771. dot3Duplex VLAN =   Using ifDescr as ifName  
772. Port 24736 skipped because port is still down since last polling.  
773. SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0",1620740131,1620740117,14,4736][0m 13.45ms]
774.  
775. 1 updated  
776.  
777. Port Port 3: Port 3 (103 / #4737) ifInOctets  
778. ifOutOctets  
779. ifInUcastPkts  
780. ifOutUcastPkts  
781. ifInBroadcastPkts  
782. ifOutBroadcastPkts  
783. ifInMulticastPkts  
784. ifOutMulticastPkts  
785. ifSpeed  
786. dot3Duplex VLAN =   Using ifDescr as ifName  
787. Port 3
788.  ifInOctets (0 B) 0 Bps 14 secs  
789.  
790.  ifOutOctets (1556 B) 111.14285714286 Bps 14 secs  
791.  
792.  ifInErrors (0 B) 0 Bps 14 secs  
793.  
794.  ifOutErrors (0 B) 0 Bps 14 secs  
795.  
796.  ifInUcastPkts (0 B) 0 Bps 14 secs  
797.  
798.  ifOutUcastPkts (6 B) 0.42857142857143 Bps 14 secs  
799.  
800.  ifInNUcastPkts (0 B) 0 Bps 14 secs  
801.  
802.  ifOutNUcastPkts (14 B) 1 Bps 14 secs  
803.  
804.  ifInDiscards (0 B) 0 Bps 14 secs  
805.  
806.  ifOutDiscards (0 B) 0 Bps 14 secs  
807.  
808.  ifInUnknownProtos (0 B) 0 Bps 14 secs  
809.  
810.  ifInBroadcastPkts (0 B) 0 Bps 14 secs  
811.  
812.  ifOutBroadcastPkts (0 B) 0 Bps 14 secs  
813.  
814.  ifInMulticastPkts (0 B) 0 Bps 14 secs  
815.  
816.  ifOutMulticastPkts (0 B) 0 Bps 14 secs  
817. bps(0 bps/889 bps)bytes(0 B/1.52 KiB)pkts(0 pps/0.43 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["3495314758",3495314758,0,0,"1864893987",1864892431,111.14285714285714,1556,"0",0,0,0,"0",0,0,0,"9347666",9347666,0,0,"23871092",23871086,0.42857142857142855,6,1620740131,1620740117,14,4737][0m 11.6ms]
818.  
819. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["263491",263491,0,0,"177100246",177100232,1,14,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4737][0m 9.83ms]
820.  
821. 2 updated  
822.  
823. Port Port 4: Port 4 (104 / #4738) ifInOctets  
824. ifOutOctets  
825. ifInUcastPkts  
826. ifOutUcastPkts  
827. ifInBroadcastPkts  
828. ifOutBroadcastPkts  
829. ifInMulticastPkts  
830. ifOutMulticastPkts  
831. ifSpeed  
832. dot3Duplex VLAN =   Using ifDescr as ifName  
833. Port 4
834.  ifInOctets (39344 B) 2810.2857142857 Bps 14 secs  
835.  
836.  ifOutOctets (122971 B) 8783.6428571429 Bps 14 secs  
837.  
838.  ifInErrors (0 B) 0 Bps 14 secs  
839.  
840.  ifOutErrors (0 B) 0 Bps 14 secs  
841.  
842.  ifInUcastPkts (426 B) 30.428571428571 Bps 14 secs  
843.  
844.  ifOutUcastPkts (214 B) 15.285714285714 Bps 14 secs  
845.  
846.  ifInNUcastPkts (1 B) 0.071428571428571 Bps 14 secs  
847.  
848.  ifOutNUcastPkts (18 B) 1.2857142857143 Bps 14 secs  
849.  
850.  ifInDiscards (0 B) 0 Bps 14 secs  
851.  
852.  ifOutDiscards (0 B) 0 Bps 14 secs  
853.  
854.  ifInUnknownProtos (0 B) 0 Bps 14 secs  
855.  
856.  ifInBroadcastPkts (0 B) 0 Bps 14 secs  
857.  
858.  ifOutBroadcastPkts (0 B) 0 Bps 14 secs  
859.  
860.  ifInMulticastPkts (0 B) 0 Bps 14 secs  
861.  
862.  ifOutMulticastPkts (0 B) 0 Bps 14 secs  
863. bps(22.48 Kbps/70.27 Kbps)bytes(38.42 KiB/120.09 KiB)pkts(30.43 pps/15.29 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["3698532465",3698493121,2810.285714285714,39344,"2827779130",2827656159,8783.642857142857,122971,"0",0,0,0,"0",0,0,0,"3339920040",3339919614,30.428571428571427,426,"1686992408",1686992194,15.285714285714286,214,1620740131,1620740117,14,4738][0m 8.54ms]
864.  
865. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["6941508",6941507,0.07142857142857142,1,"181376804",181376786,1.2857142857142858,18,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4738][0m 11.27ms]
866.  
867. 2 updated  
868.  
869. Port Downlink (Port 5): Downlink (Port 5) (105 / #4739) ifInOctets  
870. ifOutOctets  
871. ifInUcastPkts  
872. ifOutUcastPkts  
873. ifInBroadcastPkts  
874. ifOutBroadcastPkts  
875. ifInMulticastPkts  
876. ifOutMulticastPkts  
877. ifSpeed  
878. dot3Duplex VLAN =   Using ifDescr as ifName  
879. Downlink (Port 5)array (
880.   'type' => 'downlink ',
881.   'descr' => 'Port 5',
882.   'circuit' => NULL,
883.   'speed' => '',
884.   'notes' => 'Port 5',
885. )  
886.  
887.  ifInOctets (188795 B) 13485.357142857 Bps 14 secs  
888.  
889.  ifOutOctets (51220 B) 3658.5714285714 Bps 14 secs  
890.  
891.  ifInErrors (0 B) 0 Bps 14 secs  
892.  
893.  ifOutErrors (0 B) 0 Bps 14 secs  
894.  
895.  ifInUcastPkts (281 B) 20.071428571429 Bps 14 secs  
896.  
897.  ifOutUcastPkts (471 B) 33.642857142857 Bps 14 secs  
898.  
899.  ifInNUcastPkts (535 B) 38.214285714286 Bps 14 secs  
900.  
901.  ifOutNUcastPkts (1 B) 0.071428571428571 Bps 14 secs  
902.  
903.  ifInDiscards (0 B) 0 Bps 14 secs  
904.  
905.  ifOutDiscards (0 B) 0 Bps 14 secs  
906.  
907.  ifInUnknownProtos (0 B) 0 Bps 14 secs  
908.  
909.  ifInBroadcastPkts (0 B) 0 Bps 14 secs  
910.  
911.  ifOutBroadcastPkts (0 B) 0 Bps 14 secs  
912.  
913.  ifInMulticastPkts (0 B) 0 Bps 14 secs  
914.  
915.  ifOutMulticastPkts (0 B) 0 Bps 14 secs  
916. bps(107.88 Kbps/29.27 Kbps)bytes(184.37 KiB/50.02 KiB)pkts(20.07 pps/33.64 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1555748845",1555560050,13485.357142857143,188795,"2631265536",2631214316,3658.5714285714284,51220,"0",0,0,0,"0",0,0,0,"2341237490",2341237209,20.071428571428573,281,"3563424653",3563424182,33.642857142857146,471,1620740131,1620740117,14,4739][0m 10.26ms]
917.  
918. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["3869241846",3869241311,38.214285714285715,535,"10167345",10167344,0.07142857142857142,1,"2",2,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4739][0m 12.38ms]
919.  
920. 2 updated  
921.  
922. Port Uplink (Port 6): Uplink (Port 6) (106 / #4740) ifInOctets  
923. ifOutOctets  
924. ifInUcastPkts  
925. ifOutUcastPkts  
926. ifInBroadcastPkts  
927. ifOutBroadcastPkts  
928. ifInMulticastPkts  
929. ifOutMulticastPkts  
930. ifSpeed  
931. dot3Duplex VLAN =   Using ifDescr as ifName  
932. Uplink (Port 6)array (
933.   'type' => 'uplink ',
934.   'descr' => 'Port 6',
935.   'circuit' => NULL,
936.   'speed' => '',
937.   'notes' => 'Port 6',
938. )  
939. 4740 skipped because port is still down since last polling.  
940. SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0",1620740131,1620740117,14,4740][0m 10.48ms]
941.  
942. 1 updated  
943.  
944. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1620740131,1620740117,null][0m 0.18ms]
945.  
946. 0 updated  
947.  
948. >> Runtime for poller module 'ports': 10.8491 seconds with 47488 bytes
949. >> SNMP: [4/10.73s] MySQL: [12/0.11s]
950. #### Unload poller module ports ####
951.  
952. Modules status: Global+  
953. OS  
954. Device  
955.  
956. #### Load poller module customoid ####
957. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[84][0m 0.18ms]
958.  
959.  
960. >> Runtime for poller module 'customoid': 0.0005 seconds with 2448 bytes
961. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
962. #### Unload poller module customoid ####
963.  
964. Modules status: Global+  
965. OS  
966. Device  
967.  
968. #### Load poller module bgp-peers ####
969. 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[84][0m 0.33ms]
970.  
971.  
972. >> Runtime for poller module 'bgp-peers': 0.0014 seconds with 15048 bytes
973. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
974. #### Unload poller module bgp-peers ####
975.  
976. Modules status: Global-  
977. OS  
978. Device  
979. Module [ junose-atm-vp ] disabled globally.
980.  
981. Modules status: Global-  
982. OS  
983. Device  
984. Module [ printer-supplies ] disabled globally.
985.  
986. Modules status: Global+  
987. OS  
988. Device  
989.  
990. #### Load poller module ucd-diskio ####
991. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[84][0m 0.15ms]
992.  
993.  
994. >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 1944 bytes
995. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
996. #### Unload poller module ucd-diskio ####
997.  
998. Modules status: Global-  
999. OS  
1000. Device  
1001. Module [ wifi ] disabled globally.
1002.  
1003. Modules status: Global+  
1004. OS  
1005. Device  
1006.  
1007. #### Load poller module wireless ####
1008. Attempting to initialize OS: generic  
1009. OS initialized: LibreNMS\OS\Generic  
1010. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[84][0m 0.18ms]
1011.  
1012.  
1013. >> Runtime for poller module 'wireless': 0.0016 seconds with 103144 bytes
1014. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
1015. #### Unload poller module wireless ####
1016.  
1017. Modules status: Global+  
1018. OS  
1019. Device  
1020.  
1021. #### Load poller module ospf ####
1022.  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]
1023. ospfGeneralGroup = No Such Object available on this agent at this OID  
1024.  
1025. Invalid snmp_walk() data = ospfGeneralGroup = No Such Object available on this agent at this OID  
1026. array (
1027. )  
1028. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[84][0m 0.34ms]
1029.  
1030. 0
1031. >> Runtime for poller module 'ospf': 0.4639 seconds with 31824 bytes
1032. >> SNMP: [1/0.46s] MySQL: [0/0.00s]
1033. #### Unload poller module ospf ####
1034.  
1035. Modules status: Global-  
1036. OS  
1037. Device  
1038. Module [ cisco-ipsec-flow-monitor ] disabled globally.
1039.  
1040. Modules status: Global-  
1041. OS  
1042. Device  
1043. Module [ cisco-remote-access-monitor ] disabled globally.
1044.  
1045. Modules status: Global-  
1046. OS  
1047. Device  
1048. Module [ cisco-cef ] disabled globally.
1049.  
1050. Modules status: Global-  
1051. OS  
1052. Device  
1053. Module [ cisco-sla ] disabled globally.
1054.  
1055. Modules status: Global-  
1056. OS  
1057. Device  
1058. Module [ cisco-mac-accounting ] disabled globally.
1059.  
1060. Modules status: Global-  
1061. OS  
1062. Device  
1063. Module [ cipsec-tunnels ] disabled globally.
1064.  
1065. Modules status: Global-  
1066. OS  
1067. Device  
1068. Module [ cisco-ace-loadbalancer ] disabled globally.
1069.  
1070. Modules status: Global-  
1071. OS  
1072. Device  
1073. Module [ cisco-ace-serverfarms ] disabled globally.
1074.  
1075. Modules status: Global-  
1076. OS  
1077. Device  
1078. Module [ cisco-asa-firewall ] disabled globally.
1079.  
1080. Modules status: Global-  
1081. OS  
1082. Device  
1083. Module [ cisco-voice ] disabled globally.
1084.  
1085. Modules status: Global-  
1086. OS  
1087. Device  
1088. Module [ cisco-cbqos ] disabled globally.
1089.  
1090. Modules status: Global-  
1091. OS  
1092. Device  
1093. Module [ cisco-otv ] disabled globally.
1094.  
1095. Modules status: Global-  
1096. OS  
1097. Device  
1098. Module [ cisco-qfp ] disabled globally.
1099.  
1100. Modules status: Global-  
1101. OS  
1102. Device  
1103. Module [ cisco-vpdn ] disabled globally.
1104.  
1105. Modules status: Global-  
1106. OS  
1107. Device  
1108. Module [ nac ] disabled globally.
1109.  
1110. Modules status: Global-  
1111. OS  
1112. Device  
1113. Module [ netscaler-vsvr ] disabled globally.
1114.  
1115. Modules status: Global-  
1116. OS  
1117. Device  
1118. Module [ aruba-controller ] disabled globally.
1119.  
1120. Modules status: Global+  
1121. OS  
1122. Device  
1123.  
1124. #### Load poller module entity-physical ####
1125. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[84][0m 0.34ms]
1126.  
1127.  
1128. >> Runtime for poller module 'entity-physical': 0.0007 seconds with 2152 bytes
1129. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
1130. #### Unload poller module entity-physical ####
1131.  
1132. Modules status: Global-  
1133. OS  
1134. Device  
1135. Module [ entity-state ] disabled globally.
1136.  
1137. Modules status: Global+  
1138. OS  
1139. Device  
1140.  
1141. #### Load poller module applications ####
1142. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[84][0m 0.51ms]
1143.  
1144.  
1145. >> Runtime for poller module 'applications': 0.0007 seconds with 1592 bytes
1146. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
1147. #### Unload poller module applications ####
1148.  
1149. Modules status: Global-  
1150. OS  
1151. Device  
1152. Module [ mib ] disabled globally.
1153.  
1154. Modules status: Global+  
1155. OS  
1156. Device  
1157.  
1158. #### Load poller module stp ####
1159. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[84][0m 0.3ms]
1160.  
1161. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
1162. 0  
1163.  
1164.  
1165.  
1166. >> Runtime for poller module 'stp': 0.0743 seconds with 5408 bytes
1167. >> SNMP: [1/0.07s] MySQL: [1/0.00s]
1168. #### Unload poller module stp ####
1169.  
1170. Modules status: Global+  
1171. OS  
1172. Device  
1173.  
1174. #### Load poller module ntp ####
1175.  
1176. >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes
1177. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
1178. #### Unload poller module ntp ####
1179.  
1180. Modules status: Global-  
1181. OS  
1182. Device  
1183. Module [ loadbalancers ] disabled globally.
1184.  
1185. Modules status: Global-  
1186. OS  
1187. Device  
1188. Module [ mef ] disabled globally.
1189.  
1190. Modules status: Global+  
1191. OS  
1192. Device  
1193.  
1194. #### Load poller module mpls ####
1195.  
1196. >> Runtime for poller module 'mpls': 0.0003 seconds with 23880 bytes
1197. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
1198. #### Unload poller module mpls ####
1199.  
1200. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[84][0m 0.45ms]
1201.  
1202.  
1203. SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m["108834877",3.25,20.046,84][0m 9.78ms]
1204.  
1205. Updating dsaw1917.infra.wobcom.de  
1206.  
1207. Polled in 20.046 seconds
1208. ### Start Device Groups ###
1209. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[84][0m 0.42ms]
1210.  
1211. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.14ms]
1212.  
1213. 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) [0;33m[][0m 0.43ms]
1214.  
1215. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["dsm%",84][0m 0.32ms]
1216.  
1217. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[84][0m 0.13ms]
1218.  
1219. Groups Added:  
1220. Groups Removed:  
1221. ### End Device Groups, runtime: 0.0047s ###
1222.  
1223. #### Start Alerts ####
1224. 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` = ?))) as `exists` [0;33m["2021-05-11T13:35:32.113970Z","2021-05-11T13:35:32.113970Z",0,1,"13:35:32","13:35:32","13:35:32","13:35:32","[42m%","device",84][0m 0.53ms]
1225.  
1226. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[84][0m 0.23ms]
1227.  
1228. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
1229.         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 = ?)
1230.         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 = ?))
1231.         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 = ?))
1232.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
1233.         WHERE a.disabled = 0 AND (
1234.             (d.device_id IS NULL AND g.group_id IS NULL)
1235.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
1236.             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))
1237.         ) [0;33m[84,84,84,84,84,84,84,84][0m 1.36ms]
1238.  
1239. Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m  
1240. 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[84][0m 0.31ms]
1241.  
1242. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,84][0m 0.21ms]
1243.  
1244. Status: [0;34mNOCHG[0m
1245. Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m  
1246. 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[84][0m 0.32ms]
1247.  
1248. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,84][0m 0.21ms]
1249.  
1250. Status: [0;34mNOCHG[0m
1251. Rule [0;35m#3 (Device rebooted):[0m  
1252. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed> 20 [0;33m[84][0m 0.27ms]
1253.  
1254. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,84][0m 0.13ms]
1255.  
1256. Status: [0;34mNOCHG[0m
1257. Rule [0;35m#6 (Port utilisation over threshold):[0m  
1258. 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[84][0m 1.11ms]
1259.  
1260. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,84][0m 0.22ms]
1261.  
1262. Status: [0;34mNOCHG[0m
1263. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
1264. SQL[[1;33mSELECT * FROM devices,sensors,ports WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND devices.device_id = ports.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 AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 0 [0;33m[84][0m 0.9ms]
1265.  
1266. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,84][0m 0.14ms]
1267.  
1268. Status: [0;34mNOCHG[0m
1269. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
1270. 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[84][0m 0.72ms]
1271.  
1272. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,84][0m 0.14ms]
1273.  
1274. Status: [0;34mNOCHG[0m
1275. Rule [0;35m#11 (Wireless Sensor under limit):[0m  
1276. 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[84][0m 0.39ms]
1277.  
1278. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,84][0m 0.13ms]
1279.  
1280. Status: [0;34mNOCHG[0m
1281. Rule [0;35m#12 (State Sensor Critical):[0m  
1282. 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[84][0m 0.47ms]
1283.  
1284. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,84][0m 0.13ms]
1285.  
1286. Status: [0;34mNOCHG[0m
1287. #### End Alerts ####
1288. ./poller.php dsaw1917.infra.wobcom.de 2021-05-11 15:35:32 - 1 devices polled in 20.25 secs  
1289. SNMP [22/18.82s]: Get[9/4.92s] Getnext[4/0.78s] Walk[9/13.12s]
1290. MySQL [44/0.15s]: Cell[13/0.00s] Row[-12/-0.00s] Rows[24/0.01s] Column[1/0.00s] Update[17/0.13s] Insert[1/0.01s] Delete[0/0.00s]
1291.