1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.68ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.48ms]
5.  
6. SQL[[1;33mselect version() [0;33m[][0m 0.62ms]
7.  
8. ===========================================
9. Component | Version
10. --------- | -------
11. LibreNMS  | 22.10.0 (2022-10-18T06:47:05+02:00)
12. DB Schema | 2022_09_03_091314_update_ports_adsl_table_with_defaults (246)
13. PHP       | 8.1.11
14. Python    | 3.7.3
15. Database  | MariaDB 10.3.36-MariaDB-0+deb10u2
16. RRDTool   | 1.7.1
17. SNMP      | 5.7.3
18. ===========================================
19. DEBUG!
20. Updating os_def.cache  
21. Starting polling run:
22.  
23. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.0.201' ORDER BY `device_id` ASC [0;33m[][0m 1.85ms]
24.  
25. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[24][0m 1.55ms]
26.  
27. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[24][0m 0.65ms]
28.  
29. Attempting to initialize OS: linux  
30. Attempting to initialize Group OS: unix  
31. OS initialized: LibreNMS\OS\Shared\Unix  
32. Hostname:    192.168.0.201
33. Device ID:   24
34. OS:          linux
35.  (unix)
36.  
37. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '192.168.0.201'
38.  
39. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.34/0.38/0.43  
40. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
41. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.8*
42.  
43.  
44. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.34,0.43,0.38,3,3,0,24,"2022-11-05 13:16:26"][0m 6.28ms]
45.  
46. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.38,24][0m 3.45ms]
47.  
48. 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[24][0m 1.59ms]
49.  
50. Modules status: Global+  
51. OS  
52. Device  
53.  
54. #### Load poller module core ####
55. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m]  
56. .*.*.0 = Linux RPI41 5.15.76-v7l+ #1596 SMP Mon Oct 31 17:11:33 GMT 2022 armv7l
57. .*.*.0 = .*.4.1.8*
58. .*.*.0 = 9098526
59. .*.*.0 = RPI41
60.  
61.  
62. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
63. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID
64. HOST-RESOURCES-MIB::hrSystemUptime.0 = 9100029
65.  
66.  
67. Uptime seconds: 91000
68.  
69. Uptime:  1 day 1 hour 16 minutes 40 seconds
70. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[91000,24][0m 5.91ms]
71.  
72.  
73. >> Runtime for poller module 'core': 0.2182 seconds with 66232 bytes
74. >> [0;36mSNMP[0m: [2/0.20s] [1;33mMySQL[0m: [1/0.06s]  
75. #### Unload poller module core ####
76.  
77. Modules status: Global+  
78. OS  
79. Device  
80.  
81. #### Load poller module unix-agent ####
82. LibreNMS UNIX Agent: SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["192.168.0.201"][0m 1.15ms]
83.  
84. Reporting disabled by user setting  
85. Connection to UNIX agent failed on port 6556.
86.  
87. >> Runtime for poller module 'unix-agent': 10.0156 seconds with 5944 bytes
88. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
89. #### Unload poller module unix-agent ####
90.  
91. Modules status: Global+  
92. OS  
93. Device  
94.  
95. #### Load poller module os ####
96. Generic :(
97. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[7][0m 1.31ms]
98.  
99. Location: Rack
100. Hardware: Generic ARMv7
101. OS Version: 5.15.76-v7l+
102. OS Features:
103. Serial:
104.  
105. >> Runtime for poller module 'os': 0.0163 seconds with 94976 bytes
106. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
107. #### Unload poller module os ####
108.  
109. Modules status: Global+  
110. OS  
111. Device  
112.  
113. #### Load poller module availability ####
114. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[24][0m 2.24ms]
115.  
116. Availability:
117. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[24][0m 2.19ms]
118.  
119. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[24,1667564196][0m 3.14ms]
120.  
121. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,85][0m 1.56ms]
122.  
123. 1 day : 100%
124. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[24,1667045796][0m 3.22ms]
125.  
126. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[82.542,86][0m 1.61ms]
127.  
128. 7 days : 82.542%
129. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[24,1665058596][0m 3.23ms]
130.  
131. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[86.111,87][0m 1.59ms]
132.  
133. 30 days : 86.111%
134. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[24,1636114596][0m 3.63ms]
135.  
136. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[79.657,88][0m 1.62ms]
137.  
138. 365 days : 79.657%
139.  
140. >> Runtime for poller module 'availability': 0.0553 seconds with 16048 bytes
141. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.24s]  
142. #### Unload poller module availability ####
143.  
144. Modules status: Global+  
145. OS  
146. Device  
147.  
148. #### Load poller module ipmi ####
149. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[24][0m 2.79ms]
150.  
151. array (
152. )  
153.  
154. >> Runtime for poller module 'ipmi': 0.0063 seconds with 1624 bytes
155. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.03s]  
156. #### Unload poller module ipmi ####
157.  
158. Modules status: Global+  
159. OS  
160. Device  
161.  
162. #### Load poller module sensors ####
163. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[24][0m 2.24ms]
164.  
165.  
166. >> Runtime for poller module 'sensors': 0.0044 seconds with 808 bytes
167. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s]  
168. #### Unload poller module sensors ####
169.  
170. Modules status: Global+  
171. OS  
172. Device  
173.  
174. #### Load poller module processors ####
175. Attempting to initialize OS: linux  
176. Attempting to initialize Group OS: unix  
177. OS initialized: LibreNMS\OS\Shared\Unix  
178. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[24][0m 2.32ms]
179.  
180.  
181. >> Runtime for poller module 'processors': 0.0100 seconds with 48224 bytes
182. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s]  
183. #### Unload poller module processors ####
184.  
185. Modules status: Global+  
186. OS  
187. Device  
188.  
189. #### Load poller module mempools ####
190. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[24][0m 1.21ms]
191.  
192.  
193. >> Runtime for poller module 'mempools': 0.0047 seconds with 64808 bytes
194. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
195. #### Unload poller module mempools ####
196.  
197. Modules status: Global+  
198. OS  
199. Device  
200.  
201. #### Load poller module storage ####
202. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[24][0m 1.13ms]
203.  
204.  
205. >> Runtime for poller module 'storage': 0.0023 seconds with 1048 bytes
206. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
207. #### Unload poller module storage ####
208.  
209. Modules status: Global+  
210. OS  
211. Device  
212.  
213. #### Load poller module netstats ####
214. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-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]  
215. IP-MIB::icmpInMsgs.0 = No Such Object available on this agent at this OID
216. IP-MIB::icmpOutMsgs.0 = No Such Object available on this agent at this OID
217. IP-MIB::icmpInErrors.0 = No Such Object available on this agent at this OID
218. IP-MIB::icmpOutErrors.0 = No Such Object available on this agent at this OID
219. IP-MIB::icmpInEchos.0 = No Such Object available on this agent at this OID
220. IP-MIB::icmpOutEchos.0 = No Such Object available on this agent at this OID
221. IP-MIB::icmpInEchoReps.0 = No Such Object available on this agent at this OID
222. IP-MIB::icmpOutEchoReps.0 = No Such Object available on this agent at this OID
223. IP-MIB::icmpInDestUnreachs.0 = No Such Object available on this agent at this OID
224. IP-MIB::icmpOutDestUnreachs.0 = No Such Object available on this agent at this OID
225. IP-MIB::icmpInParmProbs.0 = No Such Object available on this agent at this OID
226. IP-MIB::icmpInTimeExcds.0 = No Such Object available on this agent at this OID
227. IP-MIB::icmpInSrcQuenchs.0 = No Such Object available on this agent at this OID
228. IP-MIB::icmpInRedirects.0 = No Such Object available on this agent at this OID
229. IP-MIB::icmpInTimestamps.0 = No Such Object available on this agent at this OID
230. IP-MIB::icmpInTimestampReps.0 = No Such Object available on this agent at this OID
231. IP-MIB::icmpInAddrMasks.0 = No Such Object available on this agent at this OID
232. IP-MIB::icmpInAddrMaskReps.0 = No Such Object available on this agent at this OID
233. IP-MIB::icmpOutTimeExcds.0 = No Such Object available on this agent at this OID
234. IP-MIB::icmpOutParmProbs.0 = No Such Object available on this agent at this OID
235. IP-MIB::icmpOutSrcQuenchs.0 = No Such Object available on this agent at this OID
236. IP-MIB::icmpOutRedirects.0 = No Such Object available on this agent at this OID
237. IP-MIB::icmpOutTimestamps.0 = No Such Object available on this agent at this OID
238. IP-MIB::icmpOutTimestampReps.0 = No Such Object available on this agent at this OID
239. IP-MIB::icmpOutAddrMasks.0 = No Such Object available on this agent at this OID
240. IP-MIB::icmpOutAddrMaskReps.0 = No Such Object available on this agent at this OID
241.  
242.  
243. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-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]  
244. IP-MIB::ipForwDatagrams.0 = No Such Object available on this agent at this OID
245. IP-MIB::ipInDelivers.0 = No Such Object available on this agent at this OID
246. IP-MIB::ipInReceives.0 = No Such Object available on this agent at this OID
247. IP-MIB::ipOutRequests.0 = No Such Object available on this agent at this OID
248. IP-MIB::ipInDiscards.0 = No Such Object available on this agent at this OID
249. IP-MIB::ipOutDiscards.0 = No Such Object available on this agent at this OID
250. IP-MIB::ipOutNoRoutes.0 = No Such Object available on this agent at this OID
251. IP-MIB::ipReasmReqds.0 = No Such Object available on this agent at this OID
252. IP-MIB::ipReasmOKs.0 = No Such Object available on this agent at this OID
253. IP-MIB::ipReasmFails.0 = No Such Object available on this agent at this OID
254. IP-MIB::ipFragOKs.0 = No Such Object available on this agent at this OID
255. IP-MIB::ipFragFails.0 = No Such Object available on this agent at this OID
256. IP-MIB::ipFragCreates.0 = No Such Object available on this agent at this OID
257. IP-MIB::ipInUnknownProtos.0 = No Such Object available on this agent at this OID
258. IP-MIB::ipInHdrErrors.0 = No Such Object available on this agent at this OID
259. IP-MIB::ipInAddrErrors.0 = No Such Object available on this agent at this OID
260.  
261.  
262. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
263. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
264.  
265.  
266. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-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]  
267. SNMPv2-MIB::snmpInPkts.0 = No Such Object available on this agent at this OID
268. SNMPv2-MIB::snmpOutPkts.0 = No Such Object available on this agent at this OID
269. SNMPv2-MIB::snmpInBadVersions.0 = No Such Object available on this agent at this OID
270. SNMPv2-MIB::snmpInBadCommunityNames.0 = No Such Object available on this agent at this OID
271. SNMPv2-MIB::snmpInBadCommunityUses.0 = No Such Object available on this agent at this OID
272. SNMPv2-MIB::snmpInASNParseErrs.0 = No Such Object available on this agent at this OID
273. SNMPv2-MIB::snmpInTooBigs.0 = No Such Object available on this agent at this OID
274. SNMPv2-MIB::snmpInNoSuchNames.0 = No Such Object available on this agent at this OID
275. SNMPv2-MIB::snmpInBadValues.0 = No Such Object available on this agent at this OID
276. SNMPv2-MIB::snmpInReadOnlys.0 = No Such Object available on this agent at this OID
277. SNMPv2-MIB::snmpInGenErrs.0 = No Such Object available on this agent at this OID
278. SNMPv2-MIB::snmpInTotalReqVars.0 = No Such Object available on this agent at this OID
279. SNMPv2-MIB::snmpInTotalSetVars.0 = No Such Object available on this agent at this OID
280. SNMPv2-MIB::snmpInGetRequests.0 = No Such Object available on this agent at this OID
281. SNMPv2-MIB::snmpInGetNexts.0 = No Such Object available on this agent at this OID
282. SNMPv2-MIB::snmpInSetRequests.0 = No Such Object available on this agent at this OID
283. SNMPv2-MIB::snmpInGetResponses.0 = No Such Object available on this agent at this OID
284. SNMPv2-MIB::snmpInTraps.0 = No Such Object available on this agent at this OID
285. SNMPv2-MIB::snmpOutTooBigs.0 = No Such Object available on this agent at this OID
286. SNMPv2-MIB::snmpOutNoSuchNames.0 = No Such Object available on this agent at this OID
287. SNMPv2-MIB::snmpOutBadValues.0 = No Such Object available on this agent at this OID
288. SNMPv2-MIB::snmpOutGenErrs.0 = No Such Object available on this agent at this OID
289. SNMPv2-MIB::snmpOutGetRequests.0 = No Such Object available on this agent at this OID
290. SNMPv2-MIB::snmpOutGetNexts.0 = No Such Object available on this agent at this OID
291. SNMPv2-MIB::snmpOutSetRequests.0 = No Such Object available on this agent at this OID
292. SNMPv2-MIB::snmpOutGetResponses.0 = No Such Object available on this agent at this OID
293. SNMPv2-MIB::snmpOutTraps.0 = No Such Object available on this agent at this OID
294. SNMPv2-MIB::snmpSilentDrops.0 = No Such Object available on this agent at this OID
295. SNMPv2-MIB::snmpProxyDrops.0 = No Such Object available on this agent at this OID
296.  
297.  
298. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
299. UDP-MIB::udpInDatagrams.0 = No Such Object available on this agent at this OID
300. UDP-MIB::udpOutDatagrams.0 = No Such Object available on this agent at this OID
301. UDP-MIB::udpInErrors.0 = No Such Object available on this agent at this OID
302. UDP-MIB::udpNoPorts.0 = No Such Object available on this agent at this OID
303.  
304.  
305. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-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]  
306. TCP-MIB::tcpActiveOpens.0 = No Such Object available on this agent at this OID
307. TCP-MIB::tcpPassiveOpens.0 = No Such Object available on this agent at this OID
308. TCP-MIB::tcpAttemptFails.0 = No Such Object available on this agent at this OID
309. TCP-MIB::tcpEstabResets.0 = No Such Object available on this agent at this OID
310. TCP-MIB::tcpCurrEstab.0 = No Such Object available on this agent at this OID
311. TCP-MIB::tcpInSegs.0 = No Such Object available on this agent at this OID
312. TCP-MIB::tcpOutSegs.0 = No Such Object available on this agent at this OID
313. TCP-MIB::tcpRetransSegs.0 = No Such Object available on this agent at this OID
314. TCP-MIB::tcpInErrs.0 = No Such Object available on this agent at this OID
315. TCP-MIB::tcpOutRsts.0 = No Such Object available on this agent at this OID
316.  
317.  
318.  
319.  
320. >> Runtime for poller module 'netstats': 0.6322 seconds with 19288 bytes
321. >> [0;36mSNMP[0m: [6/0.63s] [1;33mMySQL[0m: [0/0.00s]  
322. #### Unload poller module netstats ####
323.  
324. Modules status: Global+  
325. OS  
326. Device  
327.  
328. #### Load poller module hr-mib ####
329. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
330. hrSystemMaxProcesses.0 = 0
331. hrSystemProcesses.0 = 267
332. hrSystemNumUsers.0 = 2  
333.  
334.  ProcessesSQL[[1;33mselect * from `hrSystem` where (`device_id` = ?) limit 1 [0;33m[24][0m 1.6ms]
335.  
336.  Users
337.  
338. >> Runtime for poller module 'hr-mib': 0.2059 seconds with 23504 bytes
339. >> [0;36mSNMP[0m: [1/0.20s] [1;33mMySQL[0m: [1/0.02s]  
340. #### Unload poller module hr-mib ####
341.  
342. Modules status: Global+  
343. OS  
344. Device  
345.  
346. #### Load poller module ucd-mib ####
347. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
348. systemStats = No more variables left in this MIB View (It is past the end of the MIB tree)  
349.  
350. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
351. laLoadInt.1 = No Such Object available on this agent at this OID
352. laLoadInt.2 = No Such Object available on this agent at this OID
353. laLoadInt.3 = No Such Object available on this agent at this OID  
354.  
355.  
356. >> Runtime for poller module 'ucd-mib': 0.2301 seconds with 128 bytes
357. >> [0;36mSNMP[0m: [2/0.23s] [1;33mMySQL[0m: [0/0.00s]  
358. #### Unload poller module ucd-mib ####
359.  
360. Modules status: Global+  
361. OS  
362. Device  
363.  
364. #### Load poller module ipSystemStats ####
365. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
366. ipSystemStatsTable = No Such Object available on this agent at this OID  
367.  
368. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
369.  
370.  
371. >> Runtime for poller module 'ipSystemStats': 0.1168 seconds with 680 bytes
372. >> [0;36mSNMP[0m: [1/0.12s] [1;33mMySQL[0m: [0/0.00s]  
373. #### Unload poller module ipSystemStats ####
374.  
375. Modules status: Global+  
376. OS  
377. Device  
378.  
379. #### Load poller module ports ####
380. 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[24][0m 2.32ms]
381.  
382. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
383. ifXEntry = No more variables left in this MIB View (It is past the end of the MIB tree)  
384.  
385. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m]
386. ifEntry = No Such Object available on this agent at this OID  
387.  
388. Invalid snmp_walk() data = ifEntry = No Such Object available on this agent at this OID  
389. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
390. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
391.  
392. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
393. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
394. dot1qPvid = No Such Object available on this agent at this OID  
395.  
396. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
397. array (
398. )  
399.  
400. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1667650598,null,1667650598][0m 0.82ms]
401.  
402. 0 updated  
403.  
404. >> Runtime for poller module 'ports': 0.4596 seconds with 24864 bytes
405. >> [0;36mSNMP[0m: [4/0.45s] [1;33mMySQL[0m: [2/0.03s]  
406. #### Unload poller module ports ####
407.  
408. Modules status: Global-  
409. OS  
410. Device  
411. Module [ xdsl ] disabled globally.
412.  
413. Modules status: Global+  
414. OS  
415. Device  
416.  
417. #### Load poller module customoid ####
418. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[24][0m 0.97ms]
419.  
420.  
421. >> Runtime for poller module 'customoid': 0.0027 seconds with 1448 bytes
422. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
423. #### Unload poller module customoid ####
424.  
425. Modules status: Global-  
426. OS-  
427. Device  
428. Module [ bgp-peers ] disabled on os.
429.  
430. Modules status: Global-  
431. OS  
432. Device  
433. Module [ junose-atm-vp ] disabled globally.
434.  
435. Modules status: Global+  
436. OS  
437. Device  
438.  
439. #### Load poller module printer-supplies ####
440. SQL[[1;33mselect * from `printer_supplies` where `printer_supplies`.`device_id` = ? and `printer_supplies`.`device_id` is not null [0;33m[24][0m 0.84ms]
441.  
442.  
443. >> Runtime for poller module 'printer-supplies': 0.0057 seconds with 54576 bytes
444. >> [0;36mSNMP[0m: [1/0.00s] [1;33mMySQL[0m: [1/0.01s]  
445. #### Unload poller module printer-supplies ####
446.  
447. Modules status: Global+  
448. OS  
449. Device  
450.  
451. #### Load poller module ucd-diskio ####
452. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[24][0m 0.7ms]
453.  
454.  
455. >> Runtime for poller module 'ucd-diskio': 0.0021 seconds with 976 bytes
456. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
457. #### Unload poller module ucd-diskio ####
458.  
459. Modules status: Global+  
460. OS  
461. Device  
462.  
463. #### Load poller module wifi ####
464.  
465. >> Runtime for poller module 'wifi': 0.0003 seconds with 416 bytes
466. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
467. #### Unload poller module wifi ####
468.  
469. Modules status: Global+  
470. OS  
471. Device  
472.  
473. #### Load poller module wireless ####
474. Attempting to initialize OS: linux  
475. Attempting to initialize Group OS: unix  
476. OS initialized: LibreNMS\OS\Shared\Unix  
477. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[24][0m 0.91ms]
478.  
479.  
480. >> Runtime for poller module 'wireless': 0.0072 seconds with 83760 bytes
481. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
482. #### Unload poller module wireless ####
483.  
484. Modules status: Global+  
485. OS-  
486. Device  
487. Module [ ospf ] disabled on os.
488.  
489. Modules status: Global-  
490. OS  
491. Device  
492. Module [ isis ] disabled globally.
493.  
494. Modules status: Global-  
495. OS  
496. Device  
497. Module [ cisco-ipsec-flow-monitor ] disabled globally.
498.  
499. Modules status: Global-  
500. OS  
501. Device  
502. Module [ cisco-remote-access-monitor ] disabled globally.
503.  
504. Modules status: Global-  
505. OS  
506. Device  
507. Module [ cisco-cef ] disabled globally.
508.  
509. Modules status: Global-  
510. OS  
511. Device  
512. Module [ slas ] disabled globally.
513.  
514. Modules status: Global-  
515. OS  
516. Device  
517. Module [ cisco-mac-accounting ] disabled globally.
518.  
519. Modules status: Global-  
520. OS  
521. Device  
522. Module [ cipsec-tunnels ] disabled globally.
523.  
524. Modules status: Global-  
525. OS  
526. Device  
527. Module [ cisco-ace-loadbalancer ] disabled globally.
528.  
529. Modules status: Global-  
530. OS  
531. Device  
532. Module [ cisco-ace-serverfarms ] disabled globally.
533.  
534. Modules status: Global-  
535. OS  
536. Device  
537. Module [ cisco-asa-firewall ] disabled globally.
538.  
539. Modules status: Global-  
540. OS  
541. Device  
542. Module [ cisco-voice ] disabled globally.
543.  
544. Modules status: Global-  
545. OS  
546. Device  
547. Module [ cisco-cbqos ] disabled globally.
548.  
549. Modules status: Global-  
550. OS  
551. Device  
552. Module [ cisco-otv ] disabled globally.
553.  
554. Modules status: Global-  
555. OS  
556. Device  
557. Module [ cisco-qfp ] disabled globally.
558.  
559. Modules status: Global-  
560. OS  
561. Device  
562. Module [ cisco-vpdn ] disabled globally.
563.  
564. Modules status: Global-  
565. OS  
566. Device  
567. Module [ nac ] disabled globally.
568.  
569. Modules status: Global-  
570. OS  
571. Device  
572. Module [ netscaler-vsvr ] disabled globally.
573.  
574. Modules status: Global-  
575. OS  
576. Device  
577. Module [ aruba-controller ] disabled globally.
578.  
579. Modules status: Global+  
580. OS  
581. Device  
582.  
583. #### Load poller module entity-physical ####
584.  
585. >> Runtime for poller module 'entity-physical': 0.0004 seconds with 336 bytes
586. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
587. #### Unload poller module entity-physical ####
588.  
589. Modules status: Global+  
590. OS  
591. Device  
592.  
593. #### Load poller module entity-state ####
594. SQL[[1;33mSELECT S.entity_state_id, S.entStateLastChanged, P.entPhysicalIndex FROM entityState AS S LEFT JOIN entPhysical AS P USING (entPhysical_id) WHERE S.device_id=? [0;33m[24][0m 0.85ms]
595.  
596.  
597. >> Runtime for poller module 'entity-state': 0.0024 seconds with 1280 bytes
598. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
599. #### Unload poller module entity-state ####
600.  
601. Modules status: Global+  
602. OS  
603. Device  
604.  
605. #### Load poller module applications ####
606. SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[24][0m 1.56ms]
607.  
608. Application: apache, app_id=7SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Oqv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.8072.1.3.2.3.1.2.6.97.112.97.99.104.101'[0m]
609. No Such Object available on this agent at this OID  
610.  
611. SQL[[1;33mupdate `applications` set `timestamp` = NOW() where `app_id` = ? [0;33m[7][0m 6.08ms]
612.  
613. SQL[[1;33mSELECT * FROM `application_metrics` WHERE app_id=? [0;33m[7][0m 0.74ms]
614.  
615. : ....................
616.  
617. Application: nginx, app_id=6SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Ovq' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.8072.1.3.2.3.1.2.5.110.103.105.110.120'[0m]
618. No Such Object available on this agent at this OID  
619.  
620. active:  reading:  writing:  waiting:  Requests:  
621. SQL[[1;33mupdate `applications` set `timestamp` = NOW() where `app_id` = ? [0;33m[6][0m 5.86ms]
622.  
623. SQL[[1;33mSELECT * FROM `application_metrics` WHERE app_id=? [0;33m[6][0m 0.56ms]
624.  
625. : .....
626.  
627.  
628. >> Runtime for poller module 'applications': 0.2283 seconds with 41160 bytes
629. >> [0;36mSNMP[0m: [2/0.20s] [1;33mMySQL[0m: [5/0.15s]  
630. #### Unload poller module applications ####
631.  
632. Modules status: Global+  
633. OS-  
634. Device  
635. Module [ stp ] disabled on os.
636.  
637. Modules status: Global+  
638. OS  
639. Device  
640.  
641. #### Load poller module ntp ####
642.  
643. >> Runtime for poller module 'ntp': 0.0003 seconds with 264 bytes
644. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
645. #### Unload poller module ntp ####
646.  
647. Modules status: Global-  
648. OS  
649. Device  
650. Module [ loadbalancers ] disabled globally.
651.  
652. Modules status: Global-  
653. OS  
654. Device  
655. Module [ mef ] disabled globally.
656.  
657. Modules status: Global-  
658. OS  
659. Device  
660. Module [ mpls ] disabled globally.
661.  
662. Module mib does not exist, please remove it from your configurationEnabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[24][0m 0.6ms]
663.  
664.  
665. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[13.546,24][0m 3.16ms]
666.  
667. Updating 192.168.0.201  
668.  
669. Polled in 13.546 seconds
670. ### Start Device Groups ###
671. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.53ms]
672.  
673. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[24][0m 0.57ms]
674.  
675. Groups Added:  
676. Groups Removed:  
677. ### End Device Groups, runtime: 0.0116s ###
678.  
679. #### Start Alerts ####
680. 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[24][0m 0.7ms]
681.  
682. 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(`start`) &lt;= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `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-11-05T12:16:38.518308Z","2022-11-05T12:16:38.518308Z",0,1,"12:16:38","12:16:38","12:16:38","12:16:38","[46m%","device",24,"location",7][0m 1.99ms]
683.  
684. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[24][0m 1.49ms]
685.  
686. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
687.         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 = ?)
688.         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 = ?))
689.         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 = ?))
690.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
691.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
692.         WHERE a.disabled = 0 AND (
693.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
694.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
695.             OR (a.invert_map = 1  AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL))
696.         ) [0;33m[24,24,24,24,24,24,24,24,24,24,24][0m 4.74ms]
697.  
698. Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m  
699.  
700. 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[24][0m 1.45ms]
701.  
702. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,24][0m 0.53ms]
703.  
704. Status: [0;34mNOCHG[0m  
705. Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m  
706.  
707. 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[24][0m 1.41ms]
708.  
709. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,24][0m 0.54ms]
710.  
711. Status: [0;34mNOCHG[0m  
712. Rule [0;35m#3 (Device rebooted):[0m  
713.  
714. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed> 10 [0;33m[24][0m 1.28ms]
715.  
716. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,24][0m 0.52ms]
717.  
718. Status: [0;34mNOCHG[0m  
719. Rule [0;35m#6 (Port utilisation over threshold):[0m  
720.  
721. 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[24][0m 2.25ms]
722.  
723. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,24][0m 0.63ms]
724.  
725. Status: [0;34mNOCHG[0m  
726. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
727.  
728. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[24][0m 1.77ms]
729.  
730. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,24][0m 0.5ms]
731.  
732. Status: [0;34mNOCHG[0m  
733. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
734.  
735. 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[24][0m 1.74ms]
736.  
737. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,24][0m 0.53ms]
738.  
739. Status: [0;34mNOCHG[0m  
740. Rule [0;35m#14 (Wireless Sensor under limit):[0m  
741.  
742. 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[24][0m 1.75ms]
743.  
744. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[14,24][0m 0.53ms]
745.  
746. Status: [0;34mNOCHG[0m  
747. Rule [0;35m#17 (State Sensor Critical):[0m  
748.  
749. 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[24][0m 2.01ms]
750.  
751. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[17,24][0m 0.54ms]
752.  
753. Status: [0;34mNOCHG[0m  
754. Rule [0;35m#25 (Device added within the last 60 minutes):[0m  
755.  
756. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.inserted >= (DATE_SUB(NOW(),INTERVAL 60 MINUTE)) [0;33m[24][0m 1.29ms]
757.  
758. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[25,24][0m 0.53ms]
759.  
760. Status: [0;34mNOCHG[0m  
761. #### End Alerts ####
762. ./poller.php 192.168.0.201 2022-11-05 13:16:38 - 1 devices polled in 14.68 secs  
763.  
764. [0;36mSNMP[0m [20/2.20s]: Snmpget[14/1.51s] Snmpwalk[6/0.69s]  
765. [1;33mSQL[0m [75/1.27s]: Select[64/0.89s] Insert[1/0.06s] Update[10/0.32s]  
766.