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.16ms]
5.  
6. SQL[[1;33mselect version() [0;33m[][0m 0.17ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA:
11. Commit Date:
12. DB Schema: 2022_07_19_081224_plugins_unique_index (243)
13. PHP: 7.4.30
14. MySQL: 10.5.16-MariaDB-1:10.5.16+maria~bionic
15. RRDTool: 1.7.0
16. 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` = 'ups-vr1k2-b.myhz.nl' ORDER BY `device_id` ASC [0;33m[][0m 0.64ms]
22.  
23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[21][0m 0.33ms]
24.  
25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[21][0m 0.14ms]
26.  
27. Attempting to initialize OS: apc  
28. OS initialized: LibreNMS\OS\Apc  
29. Hostname:    ups-vr1k2-b.myhz.nl
30. Device ID:   21
31. OS:          apc
32. Resolved IP: 145.19.127.73
33.  
34.  
35. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' 'ups-vr1k2-b.myhz.nl'
36.  
37. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.49/0.55/0.6  
38. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
39. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.3*
40.  
41.  
42. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.49,0.6,0.55,3,3,0,21,"2022-08-19 11:44:48"][0m 0.9ms]
43.  
44. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.55,21][0m 0.69ms]
45.  
46. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[21][0m 0.21ms]
47.  
48. Modules status: Global+  
49. OS  
50. Device  
51.  
52. #### Load poller module core ####
53. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m]  
54. .*.*.0 = APC Web/SNMP Management Card (MB:v4.2.9 PF:v* PN:apc_hw21_aos_*.bin AF1:v* AN1:apc_hw21_su_*.bin MN:AP9641 HR:5 SN: 5A2111T33391 MD:03/17/2021) (Embedded PowerNet SNMP Agent SW v2.2 compatible)
55. .*.*.0 = .*.4.1.3*
56. .*.*.0 = 8829100
57. .*.*.0 = ups-vr1k2-b
58.  
59.  
60. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
61. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 88291
62. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
63.  
64.  
65. Uptime seconds: 88291
66.  
67. Uptime:  1 day 31 minutes 31 seconds
68. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[88291,21][0m 0.82ms]
69.  
70.  
71. >> Runtime for poller module 'core': 0.0212 seconds with 70544 bytes
72. >> [0;36mSNMP[0m: [2/0.02s] [1;33mMySQL[0m: [1/0.01s]  
73. #### Unload poller module core ####
74.  
75. Modules status: Global-  
76. OS  
77. Device  
78. Module [ unix-agent ] disabled globally.
79.  
80. Modules status: Global+  
81. OS  
82. Device  
83.  
84. #### Load poller module os ####
85. Generic :(
86. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[30][0m 0.21ms]
87.  
88. Location: VR1K2, V110, Vlissingen
89. Hardware: Smart-UPS 3000 UPS 09.3 (ID18)
90. OS Version: AOS v2.2.0.1 / App v2.2.1.1
91. OS Features:
92. Serial: AS2111164239
93.  
94. >> Runtime for poller module 'os': 0.0027 seconds with 183304 bytes
95. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
96. #### Unload poller module os ####
97.  
98. Modules status: Global+  
99. OS  
100. Device  
101.  
102. #### Load poller module availability ####
103. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[21][0m 0.13ms]
104.  
105. Availability:
106. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[21][0m 0.11ms]
107.  
108. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[21,1660815888][0m 0.35ms]
109.  
110. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,273][0m 0.15ms]
111.  
112. 1 day : 100%
113. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[21,1660297488][0m 0.25ms]
114.  
115. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,274][0m 0.14ms]
116.  
117. 7 days : 100%
118. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[21,1658310288][0m 0.24ms]
119.  
120. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.988,275][0m 0.13ms]
121.  
122. 30 days : 99.988%
123. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[21,1629366288][0m 0.26ms]
124.  
125. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[95.481,276][0m 0.14ms]
126.  
127. 365 days : 95.481%
128.  
129. >> Runtime for poller module 'availability': 0.0041 seconds with 13264 bytes
130. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.02s]  
131. #### Unload poller module availability ####
132.  
133. Modules status: Global+  
134. OS  
135. Device  
136.  
137. #### Load poller module ipmi ####
138. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[21][0m 0.35ms]
139.  
140. array (
141. )  
142.  
143. >> Runtime for poller module 'ipmi': 0.0007 seconds with 1592 bytes
144. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
145. #### Unload poller module ipmi ####
146.  
147. Modules status: Global+  
148. OS  
149. Device  
150.  
151. #### Load poller module sensors ####
152. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[21][0m 0.29ms]
153.  
154. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["charge",21][0m 0.32ms]
155.  
156. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.3.1.0'[0m]
157. .*.4.1.3*.* = 1000  
158.  
159. Checking (snmp) charge Battery Charge...
160. 100 %
161. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["current",21][0m 0.47ms]
162.  
163. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.4.3.4.0'[0m]
164. .*.4.1.3*.* = 30  
165.  
166. Checking (snmp) current Phase 0 Output...
167. 3 A
168. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["frequency",21][0m 0.57ms]
169.  
170. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.3.3.4.0' '.1.3.6.1.4.1.318.1.1.1.4.3.2.0'[0m]
171. .*.4.1.3*.* = 500
172. .*.4.1.3*.* = 500  
173.  
174. Checking (snmp) frequency Input...
175. Checking (snmp) frequency Output...
176. 50 Hz
177. 50 Hz
178. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["load",21][0m 0.52ms]
179.  
180. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.4.3.3.0'[0m]
181. .*.4.1.3*.* = 234  
182.  
183. Checking (snmp) load Load(VA)...
184. 23.4 %
185. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["runtime",21][0m 0.5ms]
186.  
187. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.2.3.0'[0m]
188. .*.4.1.3*.* = 324000  
189.  
190. Checking (snmp) runtime Runtime...
191. 54 Min
192. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[54,52,"runtime",273][0m 0.96ms]
193.  
194. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["state",21][0m 0.48ms]
195.  
196. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.2.4.0' '.1.3.6.1.4.1.318.1.1.1.4.1.1.0'[0m]
197. .*.4.1.3*.* = 1
198. .*.4.1.3*.* = 2  
199.  
200. Checking (snmp) state UPS Battery Replacement Status...
201. Checking (snmp) state Output Status...
202. 1 #
203. 2 #
204. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["temperature",21][0m 0.58ms]
205.  
206. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.3.2.0'[0m]
207. .*.4.1.3*.* = 266  
208.  
209. Checking (snmp) temperature Internal Temperature...
210. 26.6 C
211. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["voltage",21][0m 0.65ms]
212.  
213. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.3.4.0' '.1.3.6.1.4.1.318.1.1.1.3.3.1.0' '.1.3.6.1.4.1.318.1.1.1.4.3.1.0'[0m]
214. .*.4.1.3*.* = 542
215. .*.4.1.3*.* = 2289
216. .*.4.1.3*.* = 2289  
217.  
218. Checking (snmp) voltage Battery Bus...
219. Checking (snmp) voltage Input...
220. Checking (snmp) voltage Output...
221. 54.2 V
222. 228.9 V
223. 228.9 V
224.  
225. >> Runtime for poller module 'sensors': 0.0819 seconds with 520 bytes
226. >> [0;36mSNMP[0m: [8/0.07s] [1;33mMySQL[0m: [10/0.05s]  
227. #### Unload poller module sensors ####
228.  
229. Modules status: Global+  
230. OS  
231. Device  
232.  
233. #### Load poller module processors ####
234. Attempting to initialize OS: apc  
235. OS initialized: LibreNMS\OS\Apc  
236. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[21][0m 0.41ms]
237.  
238.  
239. >> Runtime for poller module 'processors': 0.0027 seconds with 59056 bytes
240. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
241. #### Unload poller module processors ####
242.  
243. Modules status: Global+  
244. OS  
245. Device  
246.  
247. #### Load poller module mempools ####
248. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[21][0m 0.31ms]
249.  
250.  
251. >> Runtime for poller module 'mempools': 0.0024 seconds with 76976 bytes
252. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
253. #### Unload poller module mempools ####
254.  
255. Modules status: Global+  
256. OS  
257. Device  
258.  
259. #### Load poller module storage ####
260. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[21][0m 0.26ms]
261.  
262.  
263. >> Runtime for poller module 'storage': 0.0008 seconds with 904 bytes
264. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
265. #### Unload poller module storage ####
266.  
267. Modules status: Global+  
268. OS  
269. Device  
270.  
271. #### Load poller module netstats ####
272. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m]  
273. IP-MIB::icmpInMsgs.0 = 1226
274. IP-MIB::icmpOutMsgs.0 = 1226
275. IP-MIB::icmpInErrors.0 = 0
276. IP-MIB::icmpOutErrors.0 = 0
277. IP-MIB::icmpInEchos.0 = 900
278. IP-MIB::icmpOutEchos.0 = 326
279. IP-MIB::icmpInEchoReps.0 = 326
280. IP-MIB::icmpOutEchoReps.0 = 900
281. IP-MIB::icmpInDestUnreachs.0 = 0
282. IP-MIB::icmpOutDestUnreachs.0 = 0
283. IP-MIB::icmpInParmProbs.0 = 0
284. IP-MIB::icmpInTimeExcds.0 = 0
285. IP-MIB::icmpInSrcQuenchs.0 = 0
286. IP-MIB::icmpInRedirects.0 = 0
287. IP-MIB::icmpInTimestamps.0 = 0
288. IP-MIB::icmpInTimestampReps.0 = 0
289. IP-MIB::icmpInAddrMasks.0 = 0
290. IP-MIB::icmpInAddrMaskReps.0 = 0
291. IP-MIB::icmpOutTimeExcds.0 = 0
292. IP-MIB::icmpOutParmProbs.0 = 0
293. IP-MIB::icmpOutSrcQuenchs.0 = 0
294. IP-MIB::icmpOutRedirects.0 = 0
295. IP-MIB::icmpOutTimestamps.0 = 0
296. IP-MIB::icmpOutTimestampReps.0 = 0
297. IP-MIB::icmpOutAddrMasks.0 = 0
298. IP-MIB::icmpOutAddrMaskReps.0 = 0
299.  
300.  
301. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m]  
302. IP-MIB::ipForwDatagrams.0 = 0
303. IP-MIB::ipInDelivers.0 = 20812
304. IP-MIB::ipInReceives.0 = 20812
305. IP-MIB::ipOutRequests.0 = 18381
306. IP-MIB::ipInDiscards.0 = 0
307. IP-MIB::ipOutDiscards.0 = 0
308. IP-MIB::ipOutNoRoutes.0 = 0
309. IP-MIB::ipReasmReqds.0 = 0
310. IP-MIB::ipReasmOKs.0 = 0
311. IP-MIB::ipReasmFails.0 = 0
312. IP-MIB::ipFragOKs.0 = 0
313. IP-MIB::ipFragFails.0 = 0
314. IP-MIB::ipFragCreates.0 = 0
315. IP-MIB::ipInUnknownProtos.0 = 0
316. IP-MIB::ipInHdrErrors.0 = 0
317. IP-MIB::ipInAddrErrors.0 = 0
318.  
319.  
320. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
321. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
322.  
323.  
324. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m]  
325. SNMPv2-MIB::snmpInPkts.0 = 15492
326. SNMPv2-MIB::snmpOutPkts.0 = 15491
327. SNMPv2-MIB::snmpInBadVersions.0 = 0
328. SNMPv2-MIB::snmpInBadCommunityNames.0 = 0
329. SNMPv2-MIB::snmpInBadCommunityUses.0 = 269
330. SNMPv2-MIB::snmpInASNParseErrs.0 = 0
331. SNMPv2-MIB::snmpInTooBigs.0 = 0
332. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
333. SNMPv2-MIB::snmpInBadValues.0 = 0
334. SNMPv2-MIB::snmpInReadOnlys.0 = 0
335. SNMPv2-MIB::snmpInGenErrs.0 = 0
336. SNMPv2-MIB::snmpInTotalReqVars.0 = 36710
337. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
338. SNMPv2-MIB::snmpInGetRequests.0 = 8653
339. SNMPv2-MIB::snmpInGetNexts.0 = 114
340. SNMPv2-MIB::snmpInSetRequests.0 = 0
341. SNMPv2-MIB::snmpInGetResponses.0 = 0
342. SNMPv2-MIB::snmpInTraps.0 = 0
343. SNMPv2-MIB::snmpOutTooBigs.0 = 0
344. SNMPv2-MIB::snmpOutNoSuchNames.0 = 264
345. SNMPv2-MIB::snmpOutBadValues.0 = 0
346. SNMPv2-MIB::snmpOutGenErrs.0 = 0
347. SNMPv2-MIB::snmpOutGetRequests.0 = 0
348. SNMPv2-MIB::snmpOutGetNexts.0 = 0
349. SNMPv2-MIB::snmpOutSetRequests.0 = 0
350. SNMPv2-MIB::snmpOutGetResponses.0 = 15491
351. SNMPv2-MIB::snmpOutTraps.0 = 0
352. SNMPv2-MIB::snmpSilentDrops.0 = 0
353. SNMPv2-MIB::snmpProxyDrops.0 = 0
354.  
355.  
356. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
357. UDP-MIB::udpInDatagrams.0 = 15500
358. UDP-MIB::udpOutDatagrams.0 = 15512
359. UDP-MIB::udpInErrors.0 = 0
360. UDP-MIB::udpNoPorts.0 = 1866
361.  
362.  
363. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m]  
364. TCP-MIB::tcpActiveOpens.0 = 4
365. TCP-MIB::tcpPassiveOpens.0 = 299
366. TCP-MIB::tcpAttemptFails.0 = 0
367. TCP-MIB::tcpEstabResets.0 = 1
368. TCP-MIB::tcpCurrEstab.0 = 0
369. TCP-MIB::tcpInSegs.0 = 2223
370. TCP-MIB::tcpOutSegs.0 = 1033
371. TCP-MIB::tcpRetransSegs.0 = 0
372. TCP-MIB::tcpInErrs.0 = 0
373. TCP-MIB::tcpOutRsts.0 = 1
374.  
375.  
376.  
377.  
378. >> Runtime for poller module 'netstats': 0.0542 seconds with 22920 bytes
379. >> [0;36mSNMP[0m: [6/0.05s] [1;33mMySQL[0m: [0/0.00s]  
380. #### Unload poller module netstats ####
381.  
382. Modules status: Global+  
383. OS  
384. Device  
385.  
386. #### Load poller module hr-mib ####
387. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
388. hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID
389. hrSystemProcesses.0 = No Such Object available on this agent at this OID
390. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
391.  
392.  
393.  
394. >> Runtime for poller module 'hr-mib': 0.0090 seconds with 576 bytes
395. >> [0;36mSNMP[0m: [1/0.01s] [1;33mMySQL[0m: [0/0.00s]  
396. #### Unload poller module hr-mib ####
397.  
398. Modules status: Global+  
399. OS  
400. Device  
401.  
402. #### Load poller module ucd-mib ####
403. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'systemStats'[0m]
404. systemStats = No Such Object available on this agent at this OID  
405.  
406. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
407. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
408. laLoadInt.1 = No Such Object available on this agent at this OID
409. laLoadInt.2 = No Such Object available on this agent at this OID
410. laLoadInt.3 = No Such Object available on this agent at this OID  
411.  
412.  
413. >> Runtime for poller module 'ucd-mib': 0.0160 seconds with 136 bytes
414. >> [0;36mSNMP[0m: [2/0.02s] [1;33mMySQL[0m: [0/0.00s]  
415. #### Unload poller module ucd-mib ####
416.  
417. Modules status: Global+  
418. OS  
419. Device  
420.  
421. #### Load poller module ipSystemStats ####
422. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
423. ipSystemStatsInReceives.ipv4 = 0
424. ipSystemStatsInReceives.ipv6 = 1241
425. ipSystemStatsHCInReceives.ipv4 = 0
426. ipSystemStatsHCInReceives.ipv6 = 1241
427. ipSystemStatsInOctets.ipv4 = 3042018
428. ipSystemStatsInOctets.ipv6 = 0
429. ipSystemStatsHCInOctets.ipv4 = 3042018
430. ipSystemStatsHCInOctets.ipv6 = 0
431. ipSystemStatsInHdrErrors.ipv4 = 0
432. ipSystemStatsInHdrErrors.ipv6 = 0
433. ipSystemStatsInNoRoutes.ipv4 = 0
434. ipSystemStatsInNoRoutes.ipv6 = 0
435. ipSystemStatsInAddrErrors.ipv4 = 0
436. ipSystemStatsInAddrErrors.ipv6 = 0
437. ipSystemStatsInUnknownProtos.ipv4 = 0
438. ipSystemStatsInUnknownProtos.ipv6 = 0
439. ipSystemStatsInTruncatedPkts.ipv4 = 0
440. ipSystemStatsInTruncatedPkts.ipv6 = 0
441. ipSystemStatsInForwDatagrams.ipv4 = 0
442. ipSystemStatsInForwDatagrams.ipv6 = 0
443. ipSystemStatsHCInForwDatagrams.ipv4 = 0
444. ipSystemStatsHCInForwDatagrams.ipv6 = 0
445. ipSystemStatsReasmReqds.ipv4 = 0
446. ipSystemStatsReasmReqds.ipv6 = 0
447. ipSystemStatsReasmOKs.ipv4 = 0
448. ipSystemStatsReasmOKs.ipv6 = 0
449. ipSystemStatsReasmFails.ipv4 = 0
450. ipSystemStatsReasmFails.ipv6 = 0
451. ipSystemStatsInDiscards.ipv4 = 0
452. ipSystemStatsInDiscards.ipv6 = 0
453. ipSystemStatsInDelivers.ipv4 = 20824
454. ipSystemStatsInDelivers.ipv6 = 1241
455. ipSystemStatsHCInDelivers.ipv4 = 0
456. ipSystemStatsHCInDelivers.ipv6 = 1241
457. ipSystemStatsOutRequests.ipv4 = 18393
458. ipSystemStatsOutRequests.ipv6 = 717
459. ipSystemStatsHCOutRequests.ipv4 = 18393
460. ipSystemStatsHCOutRequests.ipv6 = 717
461. ipSystemStatsOutNoRoutes.ipv4 = 0
462. ipSystemStatsOutNoRoutes.ipv6 = 0
463. ipSystemStatsOutForwDatagrams.ipv4 = 0
464. ipSystemStatsOutForwDatagrams.ipv6 = 0
465. ipSystemStatsHCOutForwDatagrams.ipv4 = 0
466. ipSystemStatsHCOutForwDatagrams.ipv6 = 0
467. ipSystemStatsOutDiscards.ipv4 = 0
468. ipSystemStatsOutDiscards.ipv6 = 0
469. ipSystemStatsOutFragReqds.ipv4 = 0
470. ipSystemStatsOutFragReqds.ipv6 = 0
471. ipSystemStatsOutFragOKs.ipv4 = 0
472. ipSystemStatsOutFragOKs.ipv6 = 0
473. ipSystemStatsOutFragFails.ipv4 = 0
474. ipSystemStatsOutFragFails.ipv6 = 0
475. ipSystemStatsOutFragCreates.ipv4 = 0
476. ipSystemStatsOutFragCreates.ipv6 = 0
477. ipSystemStatsOutTransmits.ipv4 = 0
478. ipSystemStatsOutTransmits.ipv6 = 0
479. ipSystemStatsHCOutTransmits.ipv4 = 0
480. ipSystemStatsHCOutTransmits.ipv6 = 0
481. ipSystemStatsOutOctets.ipv4 = 3862798
482. ipSystemStatsOutOctets.ipv6 = 0
483. ipSystemStatsHCOutOctets.ipv4 = 3863054
484. ipSystemStatsHCOutOctets.ipv6 = 0
485. ipSystemStatsInMcastPkts.ipv4 = 0
486. ipSystemStatsInMcastPkts.ipv6 = 1241
487. ipSystemStatsHCInMcastPkts.ipv4 = 0
488. ipSystemStatsHCInMcastPkts.ipv6 = 1241
489. ipSystemStatsInMcastOctets.ipv4 = 0
490. ipSystemStatsInMcastOctets.ipv6 = 0
491. ipSystemStatsHCInMcastOctets.ipv4 = 0
492. ipSystemStatsHCInMcastOctets.ipv6 = 0
493. ipSystemStatsOutMcastPkts.ipv4 = 0
494. ipSystemStatsOutMcastPkts.ipv6 = 717
495. ipSystemStatsHCOutMcastPkts.ipv4 = 0
496. ipSystemStatsHCOutMcastPkts.ipv6 = 717
497. ipSystemStatsOutMcastOctets.ipv4 = 0
498. ipSystemStatsOutMcastOctets.ipv6 = 0
499. ipSystemStatsHCOutMcastOctets.ipv4 = 0
500. ipSystemStatsHCOutMcastOctets.ipv6 = 0
501. ipSystemStatsInBcastPkts.ipv4 = 1866
502. ipSystemStatsInBcastPkts.ipv6 = 0
503. ipSystemStatsHCInBcastPkts.ipv4 = 1866
504. ipSystemStatsHCInBcastPkts.ipv6 = 0
505. ipSystemStatsOutBcastPkts.ipv4 = 4
506. ipSystemStatsOutBcastPkts.ipv6 = 0
507. ipSystemStatsHCOutBcastPkts.ipv4 = 4
508. ipSystemStatsHCOutBcastPkts.ipv6 = 0
509. ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00
510. ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
511. ipSystemStatsRefreshRate.ipv4 = 0
512. ipSystemStatsRefreshRate.ipv6 = 0  
513.  
514. ipv4 ipv6
515.  
516. >> Runtime for poller module 'ipSystemStats': 0.0205 seconds with 16448 bytes
517. >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [0/0.00s]  
518. #### Unload poller module ipSystemStats ####
519.  
520. Modules status: Global+  
521. OS  
522. Device  
523.  
524. #### Load poller module ports ####
525. 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[21][0m 1.11ms]
526.  
527. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
528. ifXEntry = No Such Object available on this agent at this OID  
529.  
530. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
531. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'ifEntry'[0m]
532. ifIndex.1 = 1
533. ifIndex.2 = 2
534. ifDescr.1 = LOOPBACK
535. ifDescr.2 = vmac0
536. ifType.1 = softwareLoopback
537. ifType.2 = ethernetCsmacd
538. ifMtu.1 = 1500
539. ifMtu.2 = 1500
540. ifSpeed.1 = 0
541. ifSpeed.2 = 0
542. ifPhysAddress.1 =
543. ifPhysAddress.2 = 28:29:86:4d:a1:57
544. ifAdminStatus.1 = up
545. ifAdminStatus.2 = up
546. ifOperStatus.1 = up
547. ifOperStatus.2 = up
548. ifLastChange.1 = 0
549. ifLastChange.2 = 105
550. ifInOctets.1 = 0
551. ifInOctets.2 = 3043206
552. ifInUcastPkts.1 = 0
553. ifInUcastPkts.2 = 18975
554. ifInNUcastPkts.1 = 0
555. ifInNUcastPkts.2 = 1866
556. ifInDiscards.1 = 0
557. ifInDiscards.2 = 0
558. ifInErrors.1 = 0
559. ifInErrors.2 = 0
560. ifInUnknownProtos.1 = 0
561. ifInUnknownProtos.2 = 0
562. ifOutOctets.1 = 0
563. ifOutOctets.2 = 3865207
564. ifOutUcastPkts.1 = 0
565. ifOutUcastPkts.2 = 19127
566. ifOutNUcastPkts.1 = 0
567. ifOutNUcastPkts.2 = 4
568. ifOutDiscards.1 = 0
569. ifOutDiscards.2 = 0
570. ifOutErrors.1 = 0
571. ifOutErrors.2 = 0
572. ifOutQLen.1 = 0
573. ifOutQLen.2 = 0
574. ifSpecific.1 = zeroDotZero
575. ifSpecific.2 = zeroDotZero  
576.  
577. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
578. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
579.  
580. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
581. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
582. dot1qPvid = No Such Object available on this agent at this OID  
583.  
584. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
585. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [0;33m[21][0m 0.88ms]
586.  
587. array (
588.   1 =>
589.   array (
590.     'ifIndex' => '1',
591.     'ifDescr' => 'LOOPBACK',
592.     'ifType' => 'softwareLoopback',
593.     'ifMtu' => '1500',
594.     'ifSpeed' => '0',
595.     'ifPhysAddress' => '',
596.     'ifAdminStatus' => 'up',
597.     'ifOperStatus' => 'up',
598.     'ifLastChange' => '0',
599.     'ifInOctets' => '0',
600.     'ifInUcastPkts' => '0',
601.     'ifInNUcastPkts' => '0',
602.     'ifInDiscards' => '0',
603.     'ifInErrors' => '0',
604.     'ifInUnknownProtos' => '0',
605.     'ifOutOctets' => '0',
606.     'ifOutUcastPkts' => '0',
607.     'ifOutNUcastPkts' => '0',
608.     'ifOutDiscards' => '0',
609.     'ifOutErrors' => '0',
610.     'ifOutQLen' => '0',
611.     'ifSpecific' => 'zeroDotZero',
612.   ),
613.   2 =>
614.   array (
615.     'ifIndex' => '2',
616.     'ifDescr' => 'vmac0',
617.     'ifType' => 'ethernetCsmacd',
618.     'ifMtu' => '1500',
619.     'ifSpeed' => '0',
620.     'ifPhysAddress' => '28:29:86:4d:a1:57',
621.     'ifAdminStatus' => 'up',
622.     'ifOperStatus' => 'up',
623.     'ifLastChange' => '105',
624.     'ifInOctets' => '3043206',
625.     'ifInUcastPkts' => '18975',
626.     'ifInNUcastPkts' => '1866',
627.     'ifInDiscards' => '0',
628.     'ifInErrors' => '0',
629.     'ifInUnknownProtos' => '0',
630.     'ifOutOctets' => '3865207',
631.     'ifOutUcastPkts' => '19127',
632.     'ifOutNUcastPkts' => '4',
633.     'ifOutDiscards' => '0',
634.     'ifOutErrors' => '0',
635.     'ifOutQLen' => '0',
636.     'ifSpecific' => 'zeroDotZero',
637.   ),
638. )  
639.  valid  
640.  valid  
641.  
642. Port LOOPBACK: LOOPBACK (1 / #137) ifInOctets  
643. ifOutOctets  
644. ifInUcastPkts  
645. ifOutUcastPkts  
646. ifInBroadcastPkts  
647. ifOutBroadcastPkts  
648. ifInMulticastPkts  
649. ifOutMulticastPkts  
650. ifSpeed (0)  
651. VLAN =   Using ifDescr as ifAlias  
652.  Using ifDescr as ifName  
653. LOOPBACK
654.  ifInOctets (0 B) 0 Bps 187 secs  
655.  
656.  ifOutOctets (0 B) 0 Bps 187 secs  
657.  
658.  ifInErrors (0 B) 0 Bps 187 secs  
659.  
660.  ifOutErrors (0 B) 0 Bps 187 secs  
661.  
662.  ifInUcastPkts (0 B) 0 Bps 187 secs  
663.  
664.  ifOutUcastPkts (0 B) 0 Bps 187 secs  
665.  
666.  ifInNUcastPkts (0 B) 0 Bps 187 secs  
667.  
668.  ifOutNUcastPkts (0 B) 0 Bps 187 secs  
669.  
670.  ifInDiscards (0 B) 0 Bps 187 secs  
671.  
672.  ifOutDiscards (0 B) 0 Bps 187 secs  
673.  
674.  ifInUnknownProtos (0 B) 0 Bps 187 secs  
675.  
676.  ifInBroadcastPkts (0 B) 0 Bps 187 secs  
677.  
678.  ifOutBroadcastPkts (0 B) 0 Bps 187 secs  
679.  
680.  ifInMulticastPkts (0 B) 0 Bps 187 secs  
681.  
682.  ifOutMulticastPkts (0 B) 0 Bps 187 secs  
683. bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`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["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,1660902289,1660902102,187,137][0m 1.57ms]
684.  
685. 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["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,0,0,0,0,0,0,0,0,137][0m 0.54ms]
686.  
687. 1 updated  
688.  
689. Port vmac0: vmac0 (2 / #138) ifInOctets  
690. ifOutOctets  
691. ifInUcastPkts  
692. ifOutUcastPkts  
693. ifInBroadcastPkts  
694. ifOutBroadcastPkts  
695. ifInMulticastPkts  
696. ifOutMulticastPkts  
697. ifSpeed (0)  
698. VLAN =   Using ifDescr as ifAlias  
699.  Using ifDescr as ifName  
700. vmac0
701.  ifInOctets (42269 B) 226.03743315508 Bps 187 secs  
702.  
703.  ifOutOctets (82408 B) 440.68449197861 Bps 187 secs  
704.  
705.  ifInErrors (0 B) 0 Bps 187 secs  
706.  
707.  ifOutErrors (0 B) 0 Bps 187 secs  
708.  
709.  ifInUcastPkts (418 B) 2.2352941176471 Bps 187 secs  
710.  
711.  ifOutUcastPkts (419 B) 2.2406417112299 Bps 187 secs  
712.  
713.  ifInNUcastPkts (3 B) 0.016042780748663 Bps 187 secs  
714.  
715.  ifOutNUcastPkts (0 B) 0 Bps 187 secs  
716.  
717.  ifInDiscards (0 B) 0 Bps 187 secs  
718.  
719.  ifOutDiscards (0 B) 0 Bps 187 secs  
720.  
721.  ifInUnknownProtos (0 B) 0 Bps 187 secs  
722.  
723.  ifInBroadcastPkts (0 B) 0 Bps 187 secs  
724.  
725.  ifOutBroadcastPkts (0 B) 0 Bps 187 secs  
726.  
727.  ifInMulticastPkts (0 B) 0 Bps 187 secs  
728.  
729.  ifOutMulticastPkts (0 B) 0 Bps 187 secs  
730. bps(1.81 kbps/3.53 kbps)bytes(41.28 KiB/80.48 KiB)pkts(2.24 pps/2.24 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["3043206",3000937,226.0374331550802,42269,"3865207",3782799,440.6844919786096,82408,"0",0,0,0,"0",0,0,0,"18975",18557,2.235294117647059,418,"19127",18708,2.2406417112299466,419,1660902289,1660902102,187,138][0m 0.56ms]
731.  
732. 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["1866",1863,0.016042780748663103,3,"4",4,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,0,0,138][0m 0.44ms]
733.  
734. 2 updated  
735.  
736. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1660902289,1660902102,null][0m 0.12ms]
737.  
738. 0 updated  
739.  
740. >> Runtime for poller module 'ports': 0.0602 seconds with 41352 bytes
741. >> [0;36mSNMP[0m: [4/0.04s] [1;33mMySQL[0m: [7/0.05s]  
742. #### Unload poller module ports ####
743.  
744. Modules status: Global+  
745. OS  
746. Device  
747.  
748. #### Load poller module customoid ####
749. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[21][0m 0.22ms]
750.  
751.  
752. >> Runtime for poller module 'customoid': 0.0005 seconds with 1320 bytes
753. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
754. #### Unload poller module customoid ####
755.  
756. Modules status: Global+  
757. OS  
758. Device  
759.  
760. #### Load poller module bgp-peers ####
761. 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[21][0m 0.22ms]
762.  
763.  
764. >> Runtime for poller module 'bgp-peers': 0.0015 seconds with 14328 bytes
765. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
766. #### Unload poller module bgp-peers ####
767.  
768. Modules status: Global-  
769. OS  
770. Device  
771. Module [ junose-atm-vp ] disabled globally.
772.  
773. Modules status: Global-  
774. OS  
775. Device  
776. Module [ printer-supplies ] disabled globally.
777.  
778. Modules status: Global+  
779. OS  
780. Device  
781.  
782. #### Load poller module ucd-diskio ####
783. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[21][0m 0.13ms]
784.  
785.  
786. >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 784 bytes
787. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
788. #### Unload poller module ucd-diskio ####
789.  
790. Modules status: Global-  
791. OS  
792. Device  
793. Module [ wifi ] disabled globally.
794.  
795. Modules status: Global+  
796. OS  
797. Device  
798.  
799. #### Load poller module wireless ####
800. Attempting to initialize OS: apc  
801. OS initialized: LibreNMS\OS\Apc  
802. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[21][0m 0.15ms]
803.  
804.  
805. >> Runtime for poller module 'wireless': 0.0012 seconds with 103192 bytes
806. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
807. #### Unload poller module wireless ####
808.  
809. Modules status: Global+  
810. OS  
811. Device  
812.  
813. #### Load poller module ospf ####
814. SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[21][0m 0.14ms]
815.  
816.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]  
817. ospfGeneralGroup = No Such Object available on this agent at this OID
818.  
819.  
820. SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[21,""][0m 0.31ms]
821.  
822. 0
823. >> Runtime for poller module 'ospf': 0.0119 seconds with 93856 bytes
824. >> [0;36mSNMP[0m: [1/0.01s] [1;33mMySQL[0m: [2/0.00s]  
825. #### Unload poller module ospf ####
826.  
827. Modules status: Global-  
828. OS  
829. Device  
830. Module [ isis ] disabled globally.
831.  
832. Modules status: Global-  
833. OS  
834. Device  
835. Module [ cisco-ipsec-flow-monitor ] disabled globally.
836.  
837. Modules status: Global-  
838. OS  
839. Device  
840. Module [ cisco-remote-access-monitor ] disabled globally.
841.  
842. Modules status: Global-  
843. OS  
844. Device  
845. Module [ cisco-cef ] disabled globally.
846.  
847. Modules status: Global-  
848. OS  
849. Device  
850. Module [ slas ] disabled globally.
851.  
852. Modules status: Global-  
853. OS  
854. Device  
855. Module [ cisco-mac-accounting ] disabled globally.
856.  
857. Modules status: Global-  
858. OS  
859. Device  
860. Module [ cipsec-tunnels ] disabled globally.
861.  
862. Modules status: Global-  
863. OS  
864. Device  
865. Module [ cisco-ace-loadbalancer ] disabled globally.
866.  
867. Modules status: Global-  
868. OS  
869. Device  
870. Module [ cisco-ace-serverfarms ] disabled globally.
871.  
872. Modules status: Global-  
873. OS  
874. Device  
875. Module [ cisco-asa-firewall ] disabled globally.
876.  
877. Modules status: Global-  
878. OS  
879. Device  
880. Module [ cisco-voice ] disabled globally.
881.  
882. Modules status: Global-  
883. OS  
884. Device  
885. Module [ cisco-cbqos ] disabled globally.
886.  
887. Modules status: Global-  
888. OS  
889. Device  
890. Module [ cisco-otv ] disabled globally.
891.  
892. Modules status: Global-  
893. OS  
894. Device  
895. Module [ cisco-qfp ] disabled globally.
896.  
897. Modules status: Global-  
898. OS  
899. Device  
900. Module [ cisco-vpdn ] disabled globally.
901.  
902. Modules status: Global-  
903. OS  
904. Device  
905. Module [ nac ] disabled globally.
906.  
907. Modules status: Global-  
908. OS  
909. Device  
910. Module [ netscaler-vsvr ] disabled globally.
911.  
912. Modules status: Global-  
913. OS  
914. Device  
915. Module [ aruba-controller ] disabled globally.
916.  
917. Modules status: Global+  
918. OS  
919. Device  
920.  
921. #### Load poller module entity-physical ####
922.  
923. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 472 bytes
924. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
925. #### Unload poller module entity-physical ####
926.  
927. Modules status: Global-  
928. OS  
929. Device  
930. Module [ entity-state ] disabled globally.
931.  
932. Modules status: Global+  
933. OS  
934. Device  
935.  
936. #### Load poller module applications ####
937. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[21][0m 0.17ms]
938.  
939.  
940. >> Runtime for poller module 'applications': 0.0004 seconds with 576 bytes
941. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
942. #### Unload poller module applications ####
943.  
944. Modules status: Global+  
945. OS  
946. Device  
947.  
948. #### Load poller module stp ####
949. Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[21][0m 0.17ms]
950.  
951.  
952. Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[21][0m 0.17ms]
953.  
954.  
955. >> Runtime for poller module 'stp': 0.0015 seconds with 73088 bytes
956. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.00s]  
957. #### Unload poller module stp ####
958.  
959. Modules status: Global+  
960. OS  
961. Device  
962.  
963. #### Load poller module ntp ####
964.  
965. >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes
966. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
967. #### Unload poller module ntp ####
968.  
969. Modules status: Global-  
970. OS  
971. Device  
972. Module [ loadbalancers ] disabled globally.
973.  
974. Modules status: Global-  
975. OS  
976. Device  
977. Module [ mef ] disabled globally.
978.  
979. Modules status: Global+  
980. OS  
981. Device  
982.  
983. #### Load poller module mpls ####
984.  
985. >> Runtime for poller module 'mpls': 0.0002 seconds with 23656 bytes
986. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
987. #### Unload poller module mpls ####
988.  
989. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[21][0m 0.16ms]
990.  
991.  
992. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[1.343,21][0m 0.66ms]
993.  
994. Updating ups-vr1k2-b.myhz.nl  
995.  
996. Polled in 1.343 seconds
997. ### Start Device Groups ###
998. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.15ms]
999.  
1000. 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, 5, 6, 7, 8, 9, 10, 11, 12) [0;33m[][0m 0.72ms]
1001.  
1002. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%QNAP%",21][0m 0.23ms]
1003.  
1004. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%hpe-ilo%",21][0m 0.17ms]
1005.  
1006. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%Smart-UPS%",21][0m 0.17ms]
1007.  
1008. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%AP7851%","%apc-epdu%","%AP8858%",21][0m 0.19ms]
1009.  
1010. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0mxos%","%ios%",21][0m 0.16ms]
1011.  
1012. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;34morderrouter%",21][0m 0.16ms]
1013.  
1014. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;31mouter%","[0;36more%",21][0m 0.16ms]
1015.  
1016. SQL[[1;33mselect exists(select * from `devices` left join `sensors` on `devices`.`device_id` = `sensors`.`device_id` where (`sensors`.`sensor_class` = ? AND `devices`.`type` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["humidity","power",21][0m 0.29ms]
1017.  
1018. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` where (`devices`.`type` = ? AND (`ports`.`ifAlias` LIKE ? OR `ports`.`ifAlias` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["server","%VPN%","[1;35mUBLIC%",21][0m 0.21ms]
1019.  
1020. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[21][0m 0.14ms]
1021.  
1022. Groups Added:  
1023. Groups Removed:  
1024. ### End Device Groups, runtime: 0.0128s ###
1025.  
1026. #### Start Alerts ####
1027. 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[21][0m 0.17ms]
1028.  
1029. 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 `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` in (6)) 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["2022-08-19T09:44:49.191004Z","2022-08-19T09:44:49.191004Z",0,1,"09:44:49","09:44:49","09:44:49","09:44:49","[45m%","device",21,"device_group","location",30][0m 0.71ms]
1030.  
1031. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[21][0m 0.32ms]
1032.  
1033. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
1034.         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 = ?)
1035.         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 = ?))
1036.         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 = ?))
1037.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
1038.         WHERE a.disabled = 0 AND (
1039.             (d.device_id IS NULL AND g.group_id IS NULL)
1040.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
1041.             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))
1042.         ) [0;33m[21,21,21,21,21,21,21,21][0m 1.01ms]
1043.  
1044. Rule [0;35m#15 (APC UPS Battery Needs Replacement):[0m  
1045.  
1046. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "upsAdvBatteryReplaceIndicator" AND sensors.sensor_current = 2 [0;33m[21][0m 0.44ms]
1047.  
1048. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,21][0m 0.18ms]
1049.  
1050. Status: [0;34mNOCHG[0m  
1051. Rule [0;35m#16 (APC UPS Switched to Battery Power):[0m  
1052.  
1053. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 3 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[21][0m 0.44ms]
1054.  
1055. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[16,21][0m 0.16ms]
1056.  
1057. Status: [0;34mNOCHG[0m  
1058. Rule [0;35m#17 (APC UPS in Hardware Failure Bypass Mode):[0m  
1059.  
1060. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 10 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[21][0m 0.38ms]
1061.  
1062. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[17,21][0m 0.15ms]
1063.  
1064. Status: [0;34mNOCHG[0m  
1065. Rule [0;35m#18 (APC UPS in Emergency Static Bypass Mode):[0m  
1066.  
1067. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 16 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[21][0m 0.38ms]
1068.  
1069. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,21][0m 0.15ms]
1070.  
1071. Status: [0;34mNOCHG[0m  
1072. Rule [0;35m#19 (APC UPS in Smart Trim Mode):[0m  
1073.  
1074. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 12 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[21][0m 0.38ms]
1075.  
1076. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[19,21][0m 0.15ms]
1077.  
1078. Status: [0;34mNOCHG[0m  
1079. Rule [0;35m#26 (Devices up/down):[0m  
1080.  
1081. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[21][0m 0.25ms]
1082.  
1083. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[26,21][0m 0.15ms]
1084.  
1085. Status: [0;34mNOCHG[0m  
1086. Rule [0;35m#45 (Network devices up/down):[0m  
1087.  
1088. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND (devices.type = "network" OR devices.type = "firewall" OR devices.type = "loadbalancer" OR devices.type = "wireless") [0;33m[21][0m 0.28ms]
1089.  
1090. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[45,21][0m 0.14ms]
1091.  
1092. Status: [0;34mNOCHG[0m  
1093. #### End Alerts ####
1094. ./poller.php ups-vr1k2-b.myhz.nl 2022-08-19 11:44:49 - 1 devices polled in 1.513 secs  
1095.  
1096. [0;36mSNMP[0m [26/0.25s]: Snmpget[19/0.17s] Snmpwalk[7/0.08s]  
1097. [1;33mSQL[0m [86/0.31s]: Select[71/0.23s] Insert[1/0.01s] Update[13/0.07s] Delete[1/0.00s]  
1098.