1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 1.39ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.85ms]
5.  
6. SQL[[1;33mselect version() [0;33m[][0m 0.85ms]
7.  
8. ===========================================
9. Component | Version
10. --------- | -------
11. LibreNMS  | 23.8.2-3-g723600751 (2023-08-21T20:28:07-03:00)
12. DB Schema | 2023_08_02_120455_vendor_ouis_unique_index (255)
13. PHP       | 8.1.2-1ubuntu2.14
14. Python    | 3.10.12
15. Database  | MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1
16. RRDTool   | 1.7.2
17. SNMP      | 5.9.1
18. ===========================================
19. DEBUG!
20. Updating os_def.cache  
21. Starting polling run:
22.  
23. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'snmp.meraki.com' ORDER BY `device_id` ASC [0;33m[][0m 1.75ms]
24.  
25. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[78][0m 1.06ms]
26.  
27. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[78][0m 1.19ms]
28.  
29. Attempting to initialize OS: meraki  
30. OS initialized as Generic (meraki)  
31. Hostname:    snmp.meraki.com
32. Device ID:   78
33. OS:          meraki
34. Resolved IP: 209.206.48.34
35.  
36.  
37. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '5' '-p' '500' '-t' '500' '-O' '0' 'snmp.meraki.com'
38.  
39. response: xmt/rcv/%loss = 5/5/0%, min/avg/max = 167/167/167  
40. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:16100' 'SNMPv2-MIB::sysObjectID.0'[0m]  
41. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.29671.1
42.  
43. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/meraki
44. Cannot find module (SNMP-VACM-MIB): At line 5 in (none)
45.  
46. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [0;33m[167,167,167,5,5,0,"{\"poller_name\":\"vmlibrenms\"}",78,"2023-08-24 12:39:01"][0m 2.83ms]
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[78][0m 1.24ms]
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:/opt/librenms/mibs/meraki' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:16100' 'SNMPv2-MIB::sysUpTime.0'[0m]  
56. .*.*.0 = 2041794100
57.  
58. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/meraki
59. Cannot find module (SNMP-VACM-MIB): At line 5 in (none)
60.  
61.  
62. >> Runtime for poller module 'core': 0.2667 seconds with 52648 bytes
63. >> [0;36mSNMP[0m: [1/0.26s] [1;33mMySQL[0m: [0/0.00s]  
64. #### Unload poller module core ####
65.  
66. Modules status: Global+  
67. OS  
68. Device  
69.  
70. #### Load poller module unix-agent ####
71.  
72. >> Runtime for poller module 'unix-agent': 0.0019 seconds with 9288 bytes
73. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
74. #### Unload poller module unix-agent ####
75.  
76. Modules status: Global+  
77. OS  
78. Device  
79.  
80. #### Load poller module os ####
81. Generic :(
82. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[4][0m 1.9ms]
83.  
84. Location: 500 Terry A Francois Blvd, San Francisco, CA 94158, USA
85. Hardware:
86. OS Version:
87. OS Features:
88. Serial:
89.  
90. >> Runtime for poller module 'os': 0.0085 seconds with 122408 bytes
91. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s]  
92. #### Unload poller module os ####
93.  
94. Modules status: Global+  
95. OS  
96. Device  
97.  
98. #### Load poller module availability ####
99. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[78][0m 0.97ms]
100.  
101. Availability:
102. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[78][0m 0.98ms]
103.  
104. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[78,1692805141][0m 1.01ms]
105.  
106. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,297][0m 0.72ms]
107.  
108. 1 day : 100%
109. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[78,1692286741][0m 0.89ms]
110.  
111. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.809,298][0m 0.69ms]
112.  
113. 1 week : 99.809%
114. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[78,1690299541][0m 0.86ms]
115.  
116. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.933,299][0m 0.66ms]
117.  
118. 1 month : 99.933%
119. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[78,1661355541][0m 0.93ms]
120.  
121. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.994,300][0m 0.59ms]
122.  
123. 1 year : 99.994%
124.  
125. >> Runtime for poller module 'availability': 0.0194 seconds with 154832 bytes
126. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.08s]  
127. #### Unload poller module availability ####
128.  
129. Modules status: Global+  
130. OS  
131. Device  
132.  
133. #### Load poller module ipmi ####
134. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[78][0m 1.01ms]
135.  
136. array (
137. )  
138.  
139. >> Runtime for poller module 'ipmi': 0.0022 seconds with 2944 bytes
140. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
141. #### Unload poller module ipmi ####
142.  
143. Modules status: Global+  
144. OS  
145. Device  
146.  
147. #### Load poller module sensors ####
148. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[78][0m 0.87ms]
149.  
150.  
151. >> Runtime for poller module 'sensors': 0.0016 seconds with 1504 bytes
152. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
153. #### Unload poller module sensors ####
154.  
155. Modules status: Global+  
156. OS  
157. Device  
158.  
159. #### Load poller module processors ####
160. Attempting to initialize OS: meraki  
161. OS initialized as Generic (meraki)  
162. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[78][0m 1.1ms]
163.  
164.  
165. >> Runtime for poller module 'processors': 0.0042 seconds with 60896 bytes
166. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
167. #### Unload poller module processors ####
168.  
169. Modules status: Global+  
170. OS  
171. Device  
172.  
173. #### Load poller module mempools ####
174. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[78][0m 0.96ms]
175.  
176.  
177. >> Runtime for poller module 'mempools': 0.0038 seconds with 80576 bytes
178. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
179. #### Unload poller module mempools ####
180.  
181. Modules status: Global+  
182. OS  
183. Device  
184.  
185. #### Load poller module storage ####
186. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[78][0m 0.9ms]
187.  
188.  
189. >> Runtime for poller module 'storage': 0.0017 seconds with 1360 bytes
190. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
191. #### Unload poller module storage ####
192.  
193. Modules status: Global+  
194. OS  
195. Device  
196.  
197. #### Load poller module netstats ####
198. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:16100' '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]  
199. IP-MIB::icmpInMsgs.0 = No Such Object available on this agent at this OID
200. IP-MIB::icmpOutMsgs.0 = No Such Object available on this agent at this OID
201. IP-MIB::icmpInErrors.0 = No Such Object available on this agent at this OID
202. IP-MIB::icmpOutErrors.0 = No Such Object available on this agent at this OID
203. IP-MIB::icmpInEchos.0 = No Such Object available on this agent at this OID
204. IP-MIB::icmpOutEchos.0 = No Such Object available on this agent at this OID
205. IP-MIB::icmpInEchoReps.0 = No Such Object available on this agent at this OID
206. IP-MIB::icmpOutEchoReps.0 = No Such Object available on this agent at this OID
207. IP-MIB::icmpInDestUnreachs.0 = No Such Object available on this agent at this OID
208. IP-MIB::icmpOutDestUnreachs.0 = No Such Object available on this agent at this OID
209. IP-MIB::icmpInParmProbs.0 = No Such Object available on this agent at this OID
210. IP-MIB::icmpInTimeExcds.0 = No Such Object available on this agent at this OID
211. IP-MIB::icmpInSrcQuenchs.0 = No Such Object available on this agent at this OID
212. IP-MIB::icmpInRedirects.0 = No Such Object available on this agent at this OID
213. IP-MIB::icmpInTimestamps.0 = No Such Object available on this agent at this OID
214. IP-MIB::icmpInTimestampReps.0 = No Such Object available on this agent at this OID
215. IP-MIB::icmpInAddrMasks.0 = No Such Object available on this agent at this OID
216. IP-MIB::icmpInAddrMaskReps.0 = No Such Object available on this agent at this OID
217. IP-MIB::icmpOutTimeExcds.0 = No Such Object available on this agent at this OID
218. IP-MIB::icmpOutParmProbs.0 = No Such Object available on this agent at this OID
219. IP-MIB::icmpOutSrcQuenchs.0 = No Such Object available on this agent at this OID
220. IP-MIB::icmpOutRedirects.0 = No Such Object available on this agent at this OID
221. IP-MIB::icmpOutTimestamps.0 = No Such Object available on this agent at this OID
222. IP-MIB::icmpOutTimestampReps.0 = No Such Object available on this agent at this OID
223. IP-MIB::icmpOutAddrMasks.0 = No Such Object available on this agent at this OID
224. IP-MIB::icmpOutAddrMaskReps.0 = No Such Object available on this agent at this OID
225.  
226. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/meraki
227. Cannot find module (SNMP-VACM-MIB): At line 5 in (none)
228.  
229. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:16100' '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]  
230. IP-MIB::ipForwDatagrams.0 = No Such Object available on this agent at this OID
231. IP-MIB::ipInDelivers.0 = No Such Object available on this agent at this OID
232. IP-MIB::ipInReceives.0 = No Such Object available on this agent at this OID
233. IP-MIB::ipOutRequests.0 = No Such Object available on this agent at this OID
234. IP-MIB::ipInDiscards.0 = No Such Object available on this agent at this OID
235. IP-MIB::ipOutDiscards.0 = No Such Object available on this agent at this OID
236. IP-MIB::ipOutNoRoutes.0 = No Such Object available on this agent at this OID
237. IP-MIB::ipReasmReqds.0 = No Such Object available on this agent at this OID
238. IP-MIB::ipReasmOKs.0 = No Such Object available on this agent at this OID
239. IP-MIB::ipReasmFails.0 = No Such Object available on this agent at this OID
240. IP-MIB::ipFragOKs.0 = No Such Object available on this agent at this OID
241. IP-MIB::ipFragFails.0 = No Such Object available on this agent at this OID
242. IP-MIB::ipFragCreates.0 = No Such Object available on this agent at this OID
243. IP-MIB::ipInUnknownProtos.0 = No Such Object available on this agent at this OID
244. IP-MIB::ipInHdrErrors.0 = No Such Object available on this agent at this OID
245. IP-MIB::ipInAddrErrors.0 = No Such Object available on this agent at this OID
246.  
247. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/meraki
248. Cannot find module (SNMP-VACM-MIB): At line 5 in (none)
249.  
250. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:16100' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
251. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
252.  
253. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/meraki
254. Cannot find module (SNMP-VACM-MIB): At line 5 in (none)
255.  
256. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:16100' '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]  
257. SNMPv2-MIB::snmpInPkts.0 = No Such Object available on this agent at this OID
258. SNMPv2-MIB::snmpOutPkts.0 = No Such Object available on this agent at this OID
259. SNMPv2-MIB::snmpInBadVersions.0 = No Such Object available on this agent at this OID
260. SNMPv2-MIB::snmpInBadCommunityNames.0 = No Such Object available on this agent at this OID
261. SNMPv2-MIB::snmpInBadCommunityUses.0 = No Such Object available on this agent at this OID
262. SNMPv2-MIB::snmpInASNParseErrs.0 = No Such Object available on this agent at this OID
263. SNMPv2-MIB::snmpInTooBigs.0 = No Such Object available on this agent at this OID
264. SNMPv2-MIB::snmpInNoSuchNames.0 = No Such Object available on this agent at this OID
265. SNMPv2-MIB::snmpInBadValues.0 = No Such Object available on this agent at this OID
266. SNMPv2-MIB::snmpInReadOnlys.0 = No Such Object available on this agent at this OID
267. SNMPv2-MIB::snmpInGenErrs.0 = No Such Object available on this agent at this OID
268. SNMPv2-MIB::snmpInTotalReqVars.0 = No Such Object available on this agent at this OID
269. SNMPv2-MIB::snmpInTotalSetVars.0 = No Such Object available on this agent at this OID
270. SNMPv2-MIB::snmpInGetRequests.0 = No Such Object available on this agent at this OID
271. SNMPv2-MIB::snmpInGetNexts.0 = No Such Object available on this agent at this OID
272. SNMPv2-MIB::snmpInSetRequests.0 = No Such Object available on this agent at this OID
273. SNMPv2-MIB::snmpInGetResponses.0 = No Such Object available on this agent at this OID
274. SNMPv2-MIB::snmpInTraps.0 = No Such Object available on this agent at this OID
275. SNMPv2-MIB::snmpOutTooBigs.0 = No Such Object available on this agent at this OID
276. SNMPv2-MIB::snmpOutNoSuchNames.0 = No Such Object available on this agent at this OID
277. SNMPv2-MIB::snmpOutBadValues.0 = No Such Object available on this agent at this OID
278. SNMPv2-MIB::snmpOutGenErrs.0 = No Such Object available on this agent at this OID
279. SNMPv2-MIB::snmpOutGetRequests.0 = No Such Object available on this agent at this OID
280. SNMPv2-MIB::snmpOutGetNexts.0 = No Such Object available on this agent at this OID
281. SNMPv2-MIB::snmpOutSetRequests.0 = No Such Object available on this agent at this OID
282. SNMPv2-MIB::snmpOutGetResponses.0 = No Such Object available on this agent at this OID
283. SNMPv2-MIB::snmpOutTraps.0 = No Such Object available on this agent at this OID
284. SNMPv2-MIB::snmpSilentDrops.0 = No Such Object available on this agent at this OID
285. SNMPv2-MIB::snmpProxyDrops.0 = No Such Object available on this agent at this OID
286.  
287. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/meraki
288. Cannot find module (SNMP-VACM-MIB): At line 5 in (none)
289.  
290. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:16100' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
291. UDP-MIB::udpInDatagrams.0 = No Such Object available on this agent at this OID
292. UDP-MIB::udpOutDatagrams.0 = No Such Object available on this agent at this OID
293. UDP-MIB::udpInErrors.0 = No Such Object available on this agent at this OID
294. UDP-MIB::udpNoPorts.0 = No Such Object available on this agent at this OID
295.  
296. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/meraki
297. Cannot find module (SNMP-VACM-MIB): At line 5 in (none)
298.  
299. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:16100' '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]  
300. TCP-MIB::tcpActiveOpens.0 = No Such Object available on this agent at this OID
301. TCP-MIB::tcpPassiveOpens.0 = No Such Object available on this agent at this OID
302. TCP-MIB::tcpAttemptFails.0 = No Such Object available on this agent at this OID
303. TCP-MIB::tcpEstabResets.0 = No Such Object available on this agent at this OID
304. TCP-MIB::tcpCurrEstab.0 = No Such Object available on this agent at this OID
305. TCP-MIB::tcpInSegs.0 = No Such Object available on this agent at this OID
306. TCP-MIB::tcpOutSegs.0 = No Such Object available on this agent at this OID
307. TCP-MIB::tcpRetransSegs.0 = No Such Object available on this agent at this OID
308. TCP-MIB::tcpInErrs.0 = No Such Object available on this agent at this OID
309. TCP-MIB::tcpOutRsts.0 = No Such Object available on this agent at this OID
310.  
311. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/meraki
312. Cannot find module (SNMP-VACM-MIB): At line 5 in (none)
313.  
314.  
315.  
316. >> Runtime for poller module 'netstats': 2.6065 seconds with 40144 bytes
317. >> [0;36mSNMP[0m: [6/2.60s] [1;33mMySQL[0m: [0/0.00s]  
318. #### Unload poller module netstats ####
319.  
320. Modules status: Global+  
321. OS  
322. Device  
323.  
324. #### Load poller module hr-mib ####
325. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' 'udp:HOSTNAME:16100' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
326. hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID
327. hrSystemProcesses.0 = No Such Object available on this agent at this OID
328. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
329.  
330.  
331.  
332. >> Runtime for poller module 'hr-mib': 0.2697 seconds with 1248 bytes
333. >> [0;36mSNMP[0m: [1/0.27s] [1;33mMySQL[0m: [0/0.00s]  
334. #### Unload poller module hr-mib ####
335.  
336. Modules status: Global+  
337. OS  
338. Device  
339.  
340. #### Load poller module ucd-mib ####
341. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' 'udp:HOSTNAME:16100' 'systemStats'[0m]
342. systemStats = No Such Object available on this agent at this OID  
343.  
344. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
345. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' 'udp:HOSTNAME:16100' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
346. laLoadInt.1 = No Such Object available on this agent at this OID
347. laLoadInt.2 = No Such Object available on this agent at this OID
348. laLoadInt.3 = No Such Object available on this agent at this OID  
349.  
350.  
351. >> Runtime for poller module 'ucd-mib': 0.7029 seconds with 1600 bytes
352. >> [0;36mSNMP[0m: [2/0.70s] [1;33mMySQL[0m: [0/0.00s]  
353. #### Unload poller module ucd-mib ####
354.  
355. Modules status: Global+  
356. OS  
357. Device  
358.  
359. #### Load poller module ipSystemStats ####
360. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' 'udp:HOSTNAME:16100' 'ipSystemStats'[0m]
361. ipSystemStatsTable = No Such Object available on this agent at this OID  
362.  
363. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
364.  
365.  
366. >> Runtime for poller module 'ipSystemStats': 0.4608 seconds with 1736 bytes
367. >> [0;36mSNMP[0m: [1/0.46s] [1;33mMySQL[0m: [0/0.00s]  
368. #### Unload poller module ipSystemStats ####
369.  
370. Modules status: Global+  
371. OS  
372. Device  
373.  
374. #### Load poller module ports ####
375. 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[78][0m 2.22ms]
376.  
377. 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/meraki' 'udp:HOSTNAME:16100' 'ifXEntry'[0m]
378. ifXEntry = No Such Object available on this agent at this OID  
379.  
380. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
381. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' 'udp:HOSTNAME:16100' 'ifEntry'[0m]
382. ifEntry = No Such Object available on this agent at this OID  
383.  
384. Invalid snmp_walk() data = ifEntry = No Such Object available on this agent at this OID  
385. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' 'udp:HOSTNAME:16100' 'dot3StatsDuplexStatus'[0m]
386. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
387.  
388. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
389. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' 'udp:HOSTNAME:16100' 'dot1qPvid'[0m]
390. dot1qPvid = No Such Object available on this agent at this OID  
391.  
392. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
393. array (
394. )  
395.  
396. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1692891547,null,1692891547][0m 0.96ms]
397.  
398. 0 updated  
399.  
400. >> Runtime for poller module 'ports': 1.8860 seconds with 42440 bytes
401. >> [0;36mSNMP[0m: [4/1.87s] [1;33mMySQL[0m: [2/0.03s]  
402. #### Unload poller module ports ####
403.  
404. Modules status: Global-  
405. OS  
406. Device+  
407.  
408. #### Load poller module xdsl ####
409. SQL[[1;33mselect exists(select * from `ports_adsl` inner join `ports` on `ports`.`port_id` = `ports_adsl`.`port_id` where `ports`.`device_id` = ?) as `exists` [0;33m[78][0m 1.17ms]
410.  
411. SQL[[1;33mselect exists(select * from `ports_vdsl` inner join `ports` on `ports`.`port_id` = `ports_vdsl`.`port_id` where `ports`.`device_id` = ?) as `exists` [0;33m[78][0m 1.01ms]
412.  
413.  
414. >> Runtime for poller module 'xdsl': 0.0113 seconds with 382856 bytes
415. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.02s]  
416. #### Unload poller module xdsl ####
417.  
418. Modules status: Global+  
419. OS  
420. Device  
421.  
422. #### Load poller module customoid ####
423. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[78][0m 0.96ms]
424.  
425.  
426. >> Runtime for poller module 'customoid': 0.0021 seconds with 2008 bytes
427. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
428. #### Unload poller module customoid ####
429.  
430. Modules status: Global+  
431. OS  
432. Device  
433.  
434. #### Load poller module bgp-peers ####
435. 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[78][0m 1.15ms]
436.  
437.  
438. >> Runtime for poller module 'bgp-peers': 0.0057 seconds with 13304 bytes
439. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
440. #### Unload poller module bgp-peers ####
441.  
442. Modules status: Global-  
443. OS  
444. Device+  
445.  
446. #### Load poller module junose-atm-vp ####
447. SQL[[1;33mSELECT * FROM `ports` AS P, `juniAtmVp` AS J WHERE P.`device_id` = ? AND J.port_id = P.port_id [0;33m[78][0m 1.34ms]
448.  
449.  
450. >> Runtime for poller module 'junose-atm-vp': 0.0024 seconds with 1624 bytes
451. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
452. #### Unload poller module junose-atm-vp ####
453.  
454. Modules status: Global-  
455. OS  
456. Device+  
457.  
458. #### Load poller module printer-supplies ####
459. SQL[[1;33mselect * from `printer_supplies` where `printer_supplies`.`device_id` = ? and `printer_supplies`.`device_id` is not null [0;33m[78][0m 0.92ms]
460.  
461.  
462. >> Runtime for poller module 'printer-supplies': 0.0036 seconds with 61432 bytes
463. >> [0;36mSNMP[0m: [1/0.00s] [1;33mMySQL[0m: [1/0.01s]  
464. #### Unload poller module printer-supplies ####
465.  
466. Modules status: Global+  
467. OS  
468. Device  
469.  
470. #### Load poller module ucd-diskio ####
471. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[78][0m 0.9ms]
472.  
473.  
474. >> Runtime for poller module 'ucd-diskio': 0.0018 seconds with 816 bytes
475. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
476. #### Unload poller module ucd-diskio ####
477.  
478. Modules status: Global+  
479. OS  
480. Device  
481.  
482. #### Load poller module wifi ####
483.  
484. >> Runtime for poller module 'wifi': 0.0002 seconds with 512 bytes
485. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
486. #### Unload poller module wifi ####
487.  
488. Modules status: Global+  
489. OS  
490. Device  
491.  
492. #### Load poller module wireless ####
493. Attempting to initialize OS: meraki  
494. OS initialized as Generic (meraki)  
495. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[78][0m 0.98ms]
496.  
497.  
498. >> Runtime for poller module 'wireless': 0.0048 seconds with 104616 bytes
499. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
500. #### Unload poller module wireless ####
501.  
502. Modules status: Global-  
503. OS  
504. Device  
505. Module [ ospf ] disabled globally.
506.  
507. Modules status: Global-  
508. OS  
509. Device  
510. Module [ isis ] disabled globally.
511.  
512. Modules status: Global+  
513. OS  
514. Device+  
515.  
516. #### Load poller module cisco-ipsec-flow-monitor ####
517.  
518. >> Runtime for poller module 'cisco-ipsec-flow-monitor': 0.0005 seconds with 2560 bytes
519. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
520. #### Unload poller module cisco-ipsec-flow-monitor ####
521.  
522. Modules status: Global+  
523. OS  
524. Device  
525.  
526. #### Load poller module cisco-remote-access-monitor ####
527.  
528. >> Runtime for poller module 'cisco-remote-access-monitor': 0.0004 seconds with 640 bytes
529. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
530. #### Unload poller module cisco-remote-access-monitor ####
531.  
532. Modules status: Global+  
533. OS  
534. Device+  
535.  
536. #### Load poller module cisco-cef ####
537.  
538. >> Runtime for poller module 'cisco-cef': 0.0006 seconds with 2160 bytes
539. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
540. #### Unload poller module cisco-cef ####
541.  
542. Modules status: Global-  
543. OS  
544. Device+  
545.  
546. #### Load poller module slas ####
547.  
548. >> Runtime for poller module 'slas': 0.0005 seconds with 6512 bytes
549. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
550. #### Unload poller module slas ####
551.  
552. Modules status: Global-  
553. OS  
554. Device  
555. Module [ cisco-mac-accounting ] disabled globally.
556.  
557. Modules status: Global-  
558. OS  
559. Device+  
560.  
561. #### Load poller module cipsec-tunnels ####
562.  
563. >> Runtime for poller module 'cipsec-tunnels': 0.0009 seconds with 2464 bytes
564. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
565. #### Unload poller module cipsec-tunnels ####
566.  
567. Modules status: Global-  
568. OS  
569. Device+  
570.  
571. #### Load poller module cisco-ace-loadbalancer ####
572.  
573. >> Runtime for poller module 'cisco-ace-loadbalancer': 0.0004 seconds with 896 bytes
574. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
575. #### Unload poller module cisco-ace-loadbalancer ####
576.  
577. Modules status: Global-  
578. OS  
579. Device+  
580.  
581. #### Load poller module cisco-ace-serverfarms ####
582.  
583. >> Runtime for poller module 'cisco-ace-serverfarms': 0.0004 seconds with 896 bytes
584. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
585. #### Unload poller module cisco-ace-serverfarms ####
586.  
587. Modules status: Global+  
588. OS  
589. Device  
590.  
591. #### Load poller module cisco-asa-firewall ####
592.  
593. >> Runtime for poller module 'cisco-asa-firewall': 0.0004 seconds with 744 bytes
594. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
595. #### Unload poller module cisco-asa-firewall ####
596.  
597. Modules status: Global-  
598. OS  
599. Device+  
600.  
601. #### Load poller module cisco-voice ####
602.  
603. >> Runtime for poller module 'cisco-voice': 0.0002 seconds with 392 bytes
604. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
605. #### Unload poller module cisco-voice ####
606.  
607. Modules status: Global-  
608. OS  
609. Device+  
610.  
611. #### Load poller module cisco-cbqos ####
612.  
613. >> Runtime for poller module 'cisco-cbqos': 0.0006 seconds with 1856 bytes
614. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
615. #### Unload poller module cisco-cbqos ####
616.  
617. Modules status: Global-  
618. OS  
619. Device+  
620.  
621. #### Load poller module cisco-otv ####
622.  
623. >> Runtime for poller module 'cisco-otv': 0.0008 seconds with 4248 bytes
624. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
625. #### Unload poller module cisco-otv ####
626.  
627. Modules status: Global-  
628. OS  
629. Device+  
630.  
631. #### Load poller module cisco-qfp ####
632. SQL[[1;33mselect * from `component` where `type` = ? and `disabled` = ? and `ignore` = ? and `device_id` = ? [0;33m["cisco-qfp",0,0,78][0m 1.06ms]
633.  
634. Reporting disabled by user setting  
635.  
636. >> Runtime for poller module 'cisco-qfp': 0.0045 seconds with 90912 bytes
637. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
638. #### Unload poller module cisco-qfp ####
639.  
640. Modules status: Global-  
641. OS  
642. Device  
643. Module [ cisco-vpdn ] disabled globally.
644.  
645. Modules status: Global-  
646. OS  
647. Device  
648. Module [ nac ] disabled globally.
649.  
650. Modules status: Global-  
651. OS  
652. Device+  
653.  
654. #### Load poller module netscaler-vsvr ####
655.  
656. >> Runtime for poller module 'netscaler-vsvr': 0.0006 seconds with 1552 bytes
657. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
658. #### Unload poller module netscaler-vsvr ####
659.  
660. Modules status: Global-  
661. OS  
662. Device-  
663. Module [ aruba-controller ] disabled on host.
664.  
665. Modules status: Global+  
666. OS  
667. Device  
668.  
669. #### Load poller module entity-physical ####
670.  
671. >> Runtime for poller module 'entity-physical': 0.0003 seconds with 392 bytes
672. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
673. #### Unload poller module entity-physical ####
674.  
675. Modules status: Global-  
676. OS  
677. Device+  
678.  
679. #### Load poller module entity-state ####
680. 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[78][0m 1ms]
681.  
682.  
683. >> Runtime for poller module 'entity-state': 0.0021 seconds with 1472 bytes
684. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
685. #### Unload poller module entity-state ####
686.  
687. Modules status: Global-  
688. OS  
689. Device  
690. Module [ applications ] disabled globally.
691.  
692. Modules status: Global+  
693. OS  
694. Device  
695.  
696. #### Load poller module stp ####
697. Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[78][0m 1ms]
698.  
699.  
700. Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[78][0m 1.03ms]
701.  
702.  
703. >> Runtime for poller module 'stp': 0.0059 seconds with 50696 bytes
704. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.02s]  
705. #### Unload poller module stp ####
706.  
707. Modules status: Global-  
708. OS  
709. Device  
710. Module [ ntp ] disabled globally.
711.  
712. Modules status: Global-  
713. OS  
714. Device+  
715.  
716. #### Load poller module loadbalancers ####
717.  
718. >> Runtime for poller module 'loadbalancers': 0.0003 seconds with 320 bytes
719. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
720. #### Unload poller module loadbalancers ####
721.  
722. Modules status: Global-  
723. OS  
724. Device+  
725.  
726. #### Load poller module mef ####
727. MEF Links: SQL[[1;33mSELECT id, mefID, mefType, mefIdent, mefMTU, mefAdmState, mefRowState FROM mefinfo WHERE device_id = ? [0;33m[78][0m 0.87ms]
728.  
729.  
730.  
731. >> Runtime for poller module 'mef': 0.0019 seconds with 1408 bytes
732. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
733. #### Unload poller module mef ####
734.  
735. Modules status: Global+  
736. OS  
737. Device  
738.  
739. #### Load poller module mpls ####
740.  
741. >> Runtime for poller module 'mpls': 0.0010 seconds with 36712 bytes
742. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
743. #### Unload poller module mpls ####
744.  
745. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[78][0m 1.08ms]
746.  
747.  
748. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[8.85,78][0m 1.81ms]
749.  
750. Updating snmp.meraki.com  
751.  
752. Polled in 8.85 seconds
753. ### Start Device Groups ###
754. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.77ms]
755.  
756. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[78][0m 0.89ms]
757.  
758. Groups Added:  
759. Groups Removed:  
760. ### End Device Groups, runtime: 0.0106s ###
761.  
762. #### Start Alerts ####
763. 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[78][0m 1.02ms]
764.  
765. 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["2023-08-24T15:39:07.609176Z","2023-08-24T15:39:07.609176Z",0,1,"15:39:07","15:39:07","15:39:07","15:39:07","[44m%","device",78,"location",4][0m 1.9ms]
766.  
767. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[78][0m 1.29ms]
768.  
769. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
770.         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 = ?)
771.         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 = ?))
772.         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 = ?))
773.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
774.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
775.         WHERE a.disabled = 0 AND (
776.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
777.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
778.             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))
779.         ) [0;33m[78,78,78,78,78,78,78,78,78,78,78][0m 4.53ms]
780.  
781. Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m  
782.  
783. 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[78][0m 1.27ms]
784.  
785. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,78][0m 0.84ms]
786.  
787. Status: [0;34mNOCHG[0m  
788. Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m  
789.  
790. 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[78][0m 1.17ms]
791.  
792. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,78][0m 0.79ms]
793.  
794. Status: [0;34mNOCHG[0m  
795. Rule [0;35m#3 (Device rebooted):[0m  
796.  
797. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed> 30 AND devices.last_ping_timetaken &lt;= 50 [0;33m[78][0m 1.12ms]
798.  
799. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,78][0m 0.78ms]
800.  
801. Status: [0;34mNOCHG[0m  
802. Rule [0;35m#6 (Port utilisation over threshold):[0m  
803.  
804. 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[78][0m 1.95ms]
805.  
806. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,78][0m 0.79ms]
807.  
808. Status: [0;34mNOCHG[0m  
809. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
810.  
811. 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[78][0m 1.48ms]
812.  
813. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,78][0m 0.79ms]
814.  
815. Status: [0;34mNOCHG[0m  
816. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
817.  
818. 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[78][0m 1.42ms]
819.  
820. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,78][0m 0.79ms]
821.  
822. Status: [0;34mNOCHG[0m  
823. Rule [0;35m#11 (Wireless Sensor under limit):[0m  
824.  
825. 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[78][0m 1.41ms]
826.  
827. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,78][0m 0.79ms]
828.  
829. Status: [0;34mNOCHG[0m  
830. Rule [0;35m#12 (State Sensor Critical):[0m  
831.  
832. 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[78][0m 1.69ms]
833.  
834. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,78][0m 0.81ms]
835.  
836. Status: [0;34mNOCHG[0m  
837. Rule [0;35m#13 (Devices up/down):[0m  
838.  
839. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[78][0m 1.14ms]
840.  
841. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,78][0m 0.78ms]
842.  
843. Status: [0;34mNOCHG[0m  
844. Rule [0;35m#15 (Ping Latency Critical):[0m  
845.  
846. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.last_ping_timetaken > 50 [0;33m[78][0m 1.14ms]
847.  
848. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,78][0m 0.79ms]
849.  
850. Status: [0;33mSKIP[0m  
851. #### End Alerts ####
852. ./poller.php snmp.meraki.com 2023-08-24 12:39:07 - 1 devices polled in 9.718 secs  
853.  
854. [0;36mSNMP[0m [17/6.44s]: Snmpget[11/3.66s] Snmpwalk[6/2.78s]  
855. [1;33mSQL[0m [74/0.86s]: Select[67/0.77s] Insert[1/0.03s] Update[6/0.05s]  
856.