1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.22ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.18ms]
5.  
6. SQL[[1;33mselect version() [0;33m[][0m 0.19ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA:
11. Commit Date:
12. DB Schema: 2021_10_20_224207_increase_length_of_attrib_type_column (224)
13. PHP: 7.4.25
14. MySQL: 10.4.22-MariaDB-1:10.4.22+maria~focal
15. RRDTool: 1.7.2
16. SNMP: NET-SNMP 5.9
17. ==================================DEBUG!
18. Updating os_def.cache  
19. Starting polling run:
20.  
21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'ap-1.weil-st.net' ORDER BY `device_id` ASC [0;33m[][0m 0.55ms]
22.  
23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[12][0m 0.38ms]
24.  
25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[12][0m 0.26ms]
26.  
27. Attempting to initialize OS: tplink  
28. OS initialized as Generic  
29. Hostname:    ap-1.weil-st.net
30. Device ID:   12
31. OS:          tplink
32. Resolved IP: 192.168.10.245
33.  
34.  
35. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' 'ap-1.weil-st.net'
36.  
37. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.423/0.493/0.531  
38. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
39. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.118*
40.  
41.  
42. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.423,0.531,0.493,3,3,0,12,"2021-12-03 16:01:57"][0m 4.24ms]
43.  
44. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.493,12][0m 0.29ms]
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[12][0m 0.25ms]
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/tplink' '-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 = Linux EAP660 HD 4.4.60 #1 SMP PREEMPT Thu Jul 29 17:20:23 CST 2021 aarch64
55. .*.*.0 = .*.4.1.118*
56. .*.*.0 = 473723
57. .*.*.0 = EAP660 HD
58.  
59.  
60. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
61. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 4737
62. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
63.  
64.  
65. Uptime seconds: 4737
66.  
67. Uptime:  1 hour 18 minutes 57 seconds
68. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[4737,12][0m 3.92ms]
69.  
70.  
71. >> Runtime for poller module 'core': 0.0434 seconds with 4552 bytes
72. >> [0;36mSNMP[0m: [2/0.04s] [1;33mMySQL[0m: [1/0.04s]
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[8][0m 0.27ms]
87.  
88. Location: Minneapolis, MN, USA
89. Hardware:
90. OS Version:
91. OS Features:
92. Serial:
93.  
94. >> Runtime for poller module 'os': 0.0025 seconds with 34768 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[12][0m 0.34ms]
104.  
105. Availability:
106. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[12][0m 0.24ms]
107.  
108. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[12,1638482517][0m 0.26ms]
109.  
110. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[5.696,5][0m 3.84ms]
111.  
112. 1 day : 5.696%
113. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[12,1637964117][0m 0.64ms]
114.  
115. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[54.583,6][0m 0.43ms]
116.  
117. 7 days : 54.583%
118. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[12,1635976917][0m 0.58ms]
119.  
120. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[89.384,7][0m 0.42ms]
121.  
122. 30 days : 89.384%
123. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[12,1607032917][0m 0.53ms]
124.  
125. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.056,8][0m 0.34ms]
126.  
127. 365 days : 99.056%
128.  
129. >> Runtime for poller module 'availability': 0.0111 seconds with 3320 bytes
130. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.08s]
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[12][0m 0.54ms]
139.  
140. array (
141. )  
142.  
143. >> Runtime for poller module 'ipmi': 0.0015 seconds with 88 bytes
144. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]
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[12][0m 0.41ms]
153.  
154.  
155. >> Runtime for poller module 'sensors': 0.0008 seconds with 80 bytes
156. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]
157. #### Unload poller module sensors ####
158.  
159. Modules status: Global+  
160. OS  
161. Device  
162.  
163. #### Load poller module processors ####
164. Attempting to initialize OS: tplink  
165. OS initialized as Generic  
166. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[12][0m 0.46ms]
167.  
168.  
169. >> Runtime for poller module 'processors': 0.0033 seconds with 2744 bytes
170. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]
171. #### Unload poller module processors ####
172.  
173. Modules status: Global+  
174. OS  
175. Device  
176.  
177. #### Load poller module mempools ####
178. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[12][0m 0.51ms]
179.  
180.  
181. >> Runtime for poller module 'mempools': 0.0032 seconds with 25424 bytes
182. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]
183. #### Unload poller module mempools ####
184.  
185. Modules status: Global+  
186. OS  
187. Device  
188.  
189. #### Load poller module storage ####
190. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[12][0m 0.42ms]
191.  
192.  
193. >> Runtime for poller module 'storage': 0.0009 seconds with 80 bytes
194. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]
195. #### Unload poller module storage ####
196.  
197. Modules status: Global+  
198. OS  
199. Device  
200.  
201. #### Load poller module netstats ####
202. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' '-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]  
203. IP-MIB::icmpInMsgs.0 = 65
204. IP-MIB::icmpOutMsgs.0 = 0
205. IP-MIB::icmpInErrors.0 = 0
206. IP-MIB::icmpOutErrors.0 = 65
207. IP-MIB::icmpInEchos.0 = 0
208. IP-MIB::icmpOutEchos.0 = 0
209. IP-MIB::icmpInEchoReps.0 = 63
210. IP-MIB::icmpOutEchoReps.0 = 0
211. IP-MIB::icmpInDestUnreachs.0 = 0
212. IP-MIB::icmpOutDestUnreachs.0 = 0
213. IP-MIB::icmpInParmProbs.0 = 0
214. IP-MIB::icmpInTimeExcds.0 = 2
215. IP-MIB::icmpInSrcQuenchs.0 = 0
216. IP-MIB::icmpInRedirects.0 = 0
217. IP-MIB::icmpInTimestamps.0 = 0
218. IP-MIB::icmpInTimestampReps.0 = 0
219. IP-MIB::icmpInAddrMasks.0 = 0
220. IP-MIB::icmpInAddrMaskReps.0 = 0
221. IP-MIB::icmpOutTimeExcds.0 = 2
222. IP-MIB::icmpOutParmProbs.0 = 0
223. IP-MIB::icmpOutSrcQuenchs.0 = 0
224. IP-MIB::icmpOutRedirects.0 = 0
225. IP-MIB::icmpOutTimestamps.0 = 63
226. IP-MIB::icmpOutTimestampReps.0 = 0
227. IP-MIB::icmpOutAddrMasks.0 = 0
228. IP-MIB::icmpOutAddrMaskReps.0 = 0
229.  
230.  
231. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' '-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]  
232. IP-MIB::ipForwDatagrams.0 = 0
233. IP-MIB::ipInDelivers.0 = 3640
234. IP-MIB::ipInReceives.0 = 29112
235. IP-MIB::ipOutRequests.0 = 2574
236. IP-MIB::ipInDiscards.0 = 0
237. IP-MIB::ipOutDiscards.0 = 0
238. IP-MIB::ipOutNoRoutes.0 = 0
239. IP-MIB::ipReasmReqds.0 = 0
240. IP-MIB::ipReasmOKs.0 = 0
241. IP-MIB::ipReasmFails.0 = 0
242. IP-MIB::ipFragOKs.0 = 0
243. IP-MIB::ipFragFails.0 = 0
244. IP-MIB::ipFragCreates.0 = 0
245. IP-MIB::ipInUnknownProtos.0 = 0
246. IP-MIB::ipInHdrErrors.0 = 0
247. IP-MIB::ipInAddrErrors.0 = 0
248.  
249.  
250. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
251. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
252.  
253.  
254. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' '-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]  
255. SNMPv2-MIB::snmpInPkts.0 = 1087
256. SNMPv2-MIB::snmpOutPkts.0 = 1086
257. SNMPv2-MIB::snmpInBadVersions.0 = 0
258. SNMPv2-MIB::snmpInBadCommunityNames.0 = 0
259. SNMPv2-MIB::snmpInBadCommunityUses.0 = 0
260. SNMPv2-MIB::snmpInASNParseErrs.0 = 0
261. SNMPv2-MIB::snmpInTooBigs.0 = 0
262. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
263. SNMPv2-MIB::snmpInBadValues.0 = 0
264. SNMPv2-MIB::snmpInReadOnlys.0 = 0
265. SNMPv2-MIB::snmpInGenErrs.0 = 0
266. SNMPv2-MIB::snmpInTotalReqVars.0 = 8442
267. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
268. SNMPv2-MIB::snmpInGetRequests.0 = 431
269. SNMPv2-MIB::snmpInGetNexts.0 = 4
270. SNMPv2-MIB::snmpInSetRequests.0 = 0
271. SNMPv2-MIB::snmpInGetResponses.0 = 0
272. SNMPv2-MIB::snmpInTraps.0 = 0
273. SNMPv2-MIB::snmpOutTooBigs.0 = 0
274. SNMPv2-MIB::snmpOutNoSuchNames.0 = 0
275. SNMPv2-MIB::snmpOutBadValues.0 = 0
276. SNMPv2-MIB::snmpOutGenErrs.0 = 0
277. SNMPv2-MIB::snmpOutGetRequests.0 = 0
278. SNMPv2-MIB::snmpOutGetNexts.0 = 0
279. SNMPv2-MIB::snmpOutSetRequests.0 = 0
280. SNMPv2-MIB::snmpOutGetResponses.0 = 1086
281. SNMPv2-MIB::snmpOutTraps.0 = 0
282. SNMPv2-MIB::snmpSilentDrops.0 = 0
283. SNMPv2-MIB::snmpProxyDrops.0 = 0
284.  
285.  
286. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
287. UDP-MIB::udpInDatagrams.0 = 1104
288. UDP-MIB::udpOutDatagrams.0 = 1102
289. UDP-MIB::udpInErrors.0 = 0
290. UDP-MIB::udpNoPorts.0 = 0
291.  
292.  
293. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' '-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]  
294. TCP-MIB::tcpActiveOpens.0 = 2
295. TCP-MIB::tcpPassiveOpens.0 = 0
296. TCP-MIB::tcpAttemptFails.0 = 0
297. TCP-MIB::tcpEstabResets.0 = 0
298. TCP-MIB::tcpCurrEstab.0 = 1
299. TCP-MIB::tcpInSegs.0 = 792
300. TCP-MIB::tcpOutSegs.0 = 1412
301. TCP-MIB::tcpRetransSegs.0 = 0
302. TCP-MIB::tcpInErrs.0 = 0
303. TCP-MIB::tcpOutRsts.0 = 0
304.  
305.  
306.  
307.  
308. >> Runtime for poller module 'netstats': 0.1310 seconds with 1696 bytes
309. >> [0;36mSNMP[0m: [6/0.13s] [1;33mMySQL[0m: [0/0.00s]
310. #### Unload poller module netstats ####
311.  
312. Modules status: Global+  
313. OS  
314. Device  
315.  
316. #### Load poller module hr-mib ####
317. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
318. hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID
319. hrSystemProcesses.0 = No Such Object available on this agent at this OID
320. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
321.  
322.  
323.  
324. >> Runtime for poller module 'hr-mib': 0.0083 seconds with 90192 bytes
325. >> [0;36mSNMP[0m: [1/0.01s] [1;33mMySQL[0m: [0/0.00s]
326. #### Unload poller module hr-mib ####
327.  
328. Modules status: Global+  
329. OS  
330. Device  
331.  
332. #### Load poller module ucd-mib ####
333. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'systemStats'[0m]
334. systemStats = No Such Object available on this agent at this OID  
335.  
336. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
337. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
338. laLoadInt.1 = No Such Object available on this agent at this OID
339. laLoadInt.2 = No Such Object available on this agent at this OID
340. laLoadInt.3 = No Such Object available on this agent at this OID  
341.  
342.  
343. >> Runtime for poller module 'ucd-mib': 0.0195 seconds with -968 bytes
344. >> [0;36mSNMP[0m: [2/0.02s] [1;33mMySQL[0m: [0/0.00s]
345. #### Unload poller module ucd-mib ####
346.  
347. Modules status: Global+  
348. OS  
349. Device  
350.  
351. #### Load poller module ipSystemStats ####
352. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
353. ipSystemStatsTable = No Such Object available on this agent at this OID  
354.  
355. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
356.  
357.  
358. >> Runtime for poller module 'ipSystemStats': 0.0263 seconds with 80 bytes
359. >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [0/0.00s]
360. #### Unload poller module ipSystemStats ####
361.  
362. Modules status: Global+  
363. OS  
364. Device  
365.  
366. #### Load poller module ports ####
367. 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[12][0m 0.86ms]
368.  
369. 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/tplink' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
370. ifXEntry = No Such Object available on this agent at this OID  
371.  
372. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
373. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'ifEntry'[0m]
374. ifIndex.1 = 1
375. ifIndex.2 = 2
376. ifIndex.3 = 3
377. ifIndex.4 = 4
378. ifIndex.5 = 5
379. ifIndex.6 = 6
380. ifIndex.7 = 7
381. ifIndex.14 = 14
382. ifIndex.15 = 15
383. ifIndex.16 = 16
384. ifDescr.1 = lo
385. ifDescr.2 = miireg
386. ifDescr.3 = eth0
387. ifDescr.4 = br0
388. ifDescr.5 = wifi0
389. ifDescr.6 = wifi1
390. ifDescr.7 = soc0
391. ifDescr.14 = ath0
392. ifDescr.15 = ath10
393. ifDescr.16 = ath1
394. ifType.1 = softwareLoopback
395. ifType.2 = other
396. ifType.3 = ethernetCsmacd
397. ifType.4 = ethernetCsmacd
398. ifType.5 = other
399. ifType.6 = other
400. ifType.7 = other
401. ifType.14 = ethernetCsmacd
402. ifType.15 = ethernetCsmacd
403. ifType.16 = ethernetCsmacd
404. ifMtu.1 = 65536
405. ifMtu.2 = 0
406. ifMtu.3 = 1500
407. ifMtu.4 = 1500
408. ifMtu.5 = 1500
409. ifMtu.6 = 1500
410. ifMtu.7 = 0
411. ifMtu.14 = 1500
412. ifMtu.15 = 1500
413. ifMtu.16 = 1500
414. ifSpeed.1 = 10000000
415. ifSpeed.2 = 0
416. ifSpeed.3 = 1000000000
417. ifSpeed.4 = 0
418. ifSpeed.5 = 0
419. ifSpeed.6 = 0
420. ifSpeed.7 = 0
421. ifSpeed.14 = 0
422. ifSpeed.15 = 0
423. ifSpeed.16 = 0
424. ifPhysAddress.1 =
425. ifPhysAddress.2 =
426. ifPhysAddress.3 = 10:27:f5:97:de:fc
427. ifPhysAddress.4 = 10:27:f5:97:de:fc
428. ifPhysAddress.5 = 10:27:f5:97:de:fd
429. ifPhysAddress.6 = 10:27:f5:97:de:fc
430. ifPhysAddress.7 =
431. ifPhysAddress.14 = 10:27:f5:97:de:fc
432. ifPhysAddress.15 = 10:27:f5:97:de:fd
433. ifPhysAddress.16 = 16:27:f5:97:de:fc
434. ifAdminStatus.1 = up
435. ifAdminStatus.2 = down
436. ifAdminStatus.3 = up
437. ifAdminStatus.4 = up
438. ifAdminStatus.5 = up
439. ifAdminStatus.6 = up
440. ifAdminStatus.7 = down
441. ifAdminStatus.14 = up
442. ifAdminStatus.15 = up
443. ifAdminStatus.16 = up
444. ifOperStatus.1 = up
445. ifOperStatus.2 = down
446. ifOperStatus.3 = up
447. ifOperStatus.4 = up
448. ifOperStatus.5 = up
449. ifOperStatus.6 = up
450. ifOperStatus.7 = down
451. ifOperStatus.14 = up
452. ifOperStatus.15 = up
453. ifOperStatus.16 = up
454. ifLastChange.1 = 0
455. ifLastChange.2 = 0
456. ifLastChange.3 = 300
457. ifLastChange.4 = 0
458. ifLastChange.5 = 9009
459. ifLastChange.6 = 8708
460. ifLastChange.7 = 1201
461. ifLastChange.14 = 424594
462. ifLastChange.15 = 424894
463. ifLastChange.16 = 425795
464. ifInOctets.1 = 174
465. ifInOctets.2 = 0
466. ifInOctets.3 = 581721350
467. ifInOctets.4 = 18871736
468. ifInOctets.5 = 284813607
469. ifInOctets.6 = 685072818
470. ifInOctets.7 = 0
471. ifInOctets.14 = 5294104
472. ifInOctets.15 = 2727909
473. ifInOctets.16 = 67349901
474. ifInUcastPkts.1 = 2
475. ifInUcastPkts.2 = 0
476. ifInUcastPkts.3 = 1060004
477. ifInUcastPkts.4 = 44765
478. ifInUcastPkts.5 = 460604
479. ifInUcastPkts.6 = 639351
480. ifInUcastPkts.7 = 0
481. ifInUcastPkts.14 = 69149
482. ifInUcastPkts.15 = 15401
483. ifInUcastPkts.16 = 56095
484. ifInNUcastPkts.1 = 0
485. ifInNUcastPkts.2 = 0
486. ifInNUcastPkts.3 = 41947
487. ifInNUcastPkts.4 = 0
488. ifInNUcastPkts.5 = 0
489. ifInNUcastPkts.6 = 0
490. ifInNUcastPkts.7 = 0
491. ifInNUcastPkts.14 = 0
492. ifInNUcastPkts.15 = 0
493. ifInNUcastPkts.16 = 0
494. ifInDiscards.1 = 0
495. ifInDiscards.2 = 0
496. ifInDiscards.3 = 157
497. ifInDiscards.4 = 10477
498. ifInDiscards.5 = 17391
499. ifInDiscards.6 = 46103
500. ifInDiscards.7 = 0
501. ifInDiscards.14 = 2
502. ifInDiscards.15 = 3
503. ifInDiscards.16 = 0
504. ifInErrors.1 = 0
505. ifInErrors.2 = 0
506. ifInErrors.3 = 0
507. ifInErrors.4 = 0
508. ifInErrors.5 = 17391
509. ifInErrors.6 = 46103
510. ifInErrors.7 = 0
511. ifInErrors.14 = 2
512. ifInErrors.15 = 3
513. ifInErrors.16 = 0
514. ifInUnknownProtos.1 = 0
515. ifInUnknownProtos.2 = 0
516. ifInUnknownProtos.3 = 0
517. ifInUnknownProtos.4 = 0
518. ifInUnknownProtos.5 = 0
519. ifInUnknownProtos.6 = 0
520. ifInUnknownProtos.7 = 0
521. ifInUnknownProtos.14 = 0
522. ifInUnknownProtos.15 = 0
523. ifInUnknownProtos.16 = 0
524. ifOutOctets.1 = 174
525. ifOutOctets.2 = 0
526. ifOutOctets.3 = 975401041
527. ifOutOctets.4 = 894535
528. ifOutOctets.5 = 562218674
529. ifOutOctets.6 = 68747523
530. ifOutOctets.7 = 0
531. ifOutOctets.14 = 14875973
532. ifOutOctets.15 = 13542458
533. ifOutOctets.16 = 3936340
534. ifOutUcastPkts.1 = 2
535. ifOutUcastPkts.2 = 0
536. ifOutUcastPkts.3 = 1102144
537. ifOutUcastPkts.4 = 2683
538. ifOutUcastPkts.5 = 760290
539. ifOutUcastPkts.6 = 511704
540. ifOutUcastPkts.7 = 0
541. ifOutUcastPkts.14 = 85971
542. ifOutUcastPkts.15 = 44717
543. ifOutUcastPkts.16 = 38963
544. ifOutNUcastPkts.1 = 0
545. ifOutNUcastPkts.2 = 0
546. ifOutNUcastPkts.3 = 0
547. ifOutNUcastPkts.4 = 0
548. ifOutNUcastPkts.5 = 0
549. ifOutNUcastPkts.6 = 0
550. ifOutNUcastPkts.7 = 0
551. ifOutNUcastPkts.14 = 0
552. ifOutNUcastPkts.15 = 0
553. ifOutNUcastPkts.16 = 0
554. ifOutDiscards.1 = 0
555. ifOutDiscards.2 = 0
556. ifOutDiscards.3 = 0
557. ifOutDiscards.4 = 0
558. ifOutDiscards.5 = 211908
559. ifOutDiscards.6 = 33192
560. ifOutDiscards.7 = 0
561. ifOutDiscards.14 = 0
562. ifOutDiscards.15 = 0
563. ifOutDiscards.16 = 0
564. ifOutErrors.1 = 0
565. ifOutErrors.2 = 0
566. ifOutErrors.3 = 0
567. ifOutErrors.4 = 0
568. ifOutErrors.5 = 211908
569. ifOutErrors.6 = 33192
570. ifOutErrors.7 = 0
571. ifOutErrors.14 = 0
572. ifOutErrors.15 = 0
573. ifOutErrors.16 = 0
574. ifOutQLen.1 = 0
575. ifOutQLen.2 = 0
576. ifOutQLen.3 = 0
577. ifOutQLen.4 = 0
578. ifOutQLen.5 = 0
579. ifOutQLen.6 = 0
580. ifOutQLen.7 = 0
581. ifOutQLen.14 = 0
582. ifOutQLen.15 = 0
583. ifOutQLen.16 = 0
584. ifSpecific.1 = zeroDotZero
585. ifSpecific.2 = zeroDotZero
586. ifSpecific.3 = zeroDotZero
587. ifSpecific.4 = zeroDotZero
588. ifSpecific.5 = zeroDotZero
589. ifSpecific.6 = zeroDotZero
590. ifSpecific.7 = zeroDotZero
591. ifSpecific.14 = zeroDotZero
592. ifSpecific.15 = zeroDotZero
593. ifSpecific.16 = zeroDotZero  
594.  
595. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'dot3StatsIndex'[0m]
596. dot3StatsIndex = No Such Object available on this agent at this OID  
597.  
598. Invalid snmp_walk() data = dot3StatsIndex = No Such Object available on this agent at this OID  
599. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
600. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
601.  
602. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
603. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
604. dot1qPvid = No Such Object available on this agent at this OID  
605.  
606. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
607. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [0;33m[12][0m 0.68ms]
608.  
609. array (
610.   1 =>
611.   array (
612.     'ifIndex' => '1',
613.     'ifDescr' => 'lo',
614.     'ifType' => 'softwareLoopback',
615.     'ifMtu' => '65536',
616.     'ifSpeed' => '10000000',
617.     'ifPhysAddress' => '',
618.     'ifAdminStatus' => 'up',
619.     'ifOperStatus' => 'up',
620.     'ifLastChange' => '0',
621.     'ifInOctets' => '174',
622.     'ifInUcastPkts' => '2',
623.     'ifInNUcastPkts' => '0',
624.     'ifInDiscards' => '0',
625.     'ifInErrors' => '0',
626.     'ifInUnknownProtos' => '0',
627.     'ifOutOctets' => '174',
628.     'ifOutUcastPkts' => '2',
629.     'ifOutNUcastPkts' => '0',
630.     'ifOutDiscards' => '0',
631.     'ifOutErrors' => '0',
632.     'ifOutQLen' => '0',
633.     'ifSpecific' => 'zeroDotZero',
634.   ),
635.   2 =>
636.   array (
637.     'ifIndex' => '2',
638.     'ifDescr' => 'miireg',
639.     'ifType' => 'other',
640.     'ifMtu' => '0',
641.     'ifSpeed' => '0',
642.     'ifPhysAddress' => '',
643.     'ifAdminStatus' => 'down',
644.     'ifOperStatus' => 'down',
645.     'ifLastChange' => '0',
646.     'ifInOctets' => '0',
647.     'ifInUcastPkts' => '0',
648.     'ifInNUcastPkts' => '0',
649.     'ifInDiscards' => '0',
650.     'ifInErrors' => '0',
651.     'ifInUnknownProtos' => '0',
652.     'ifOutOctets' => '0',
653.     'ifOutUcastPkts' => '0',
654.     'ifOutNUcastPkts' => '0',
655.     'ifOutDiscards' => '0',
656.     'ifOutErrors' => '0',
657.     'ifOutQLen' => '0',
658.     'ifSpecific' => 'zeroDotZero',
659.   ),
660.   3 =>
661.   array (
662.     'ifIndex' => '3',
663.     'ifDescr' => 'eth0',
664.     'ifType' => 'ethernetCsmacd',
665.     'ifMtu' => '1500',
666.     'ifSpeed' => '1000000000',
667.     'ifPhysAddress' => '10:27:f5:97:de:fc',
668.     'ifAdminStatus' => 'up',
669.     'ifOperStatus' => 'up',
670.     'ifLastChange' => '300',
671.     'ifInOctets' => '581721350',
672.     'ifInUcastPkts' => '1060004',
673.     'ifInNUcastPkts' => '41947',
674.     'ifInDiscards' => '157',
675.     'ifInErrors' => '0',
676.     'ifInUnknownProtos' => '0',
677.     'ifOutOctets' => '975401041',
678.     'ifOutUcastPkts' => '1102144',
679.     'ifOutNUcastPkts' => '0',
680.     'ifOutDiscards' => '0',
681.     'ifOutErrors' => '0',
682.     'ifOutQLen' => '0',
683.     'ifSpecific' => 'zeroDotZero',
684.   ),
685.   4 =>
686.   array (
687.     'ifIndex' => '4',
688.     'ifDescr' => 'br0',
689.     'ifType' => 'ethernetCsmacd',
690.     'ifMtu' => '1500',
691.     'ifSpeed' => '0',
692.     'ifPhysAddress' => '10:27:f5:97:de:fc',
693.     'ifAdminStatus' => 'up',
694.     'ifOperStatus' => 'up',
695.     'ifLastChange' => '0',
696.     'ifInOctets' => '18871736',
697.     'ifInUcastPkts' => '44765',
698.     'ifInNUcastPkts' => '0',
699.     'ifInDiscards' => '10477',
700.     'ifInErrors' => '0',
701.     'ifInUnknownProtos' => '0',
702.     'ifOutOctets' => '894535',
703.     'ifOutUcastPkts' => '2683',
704.     'ifOutNUcastPkts' => '0',
705.     'ifOutDiscards' => '0',
706.     'ifOutErrors' => '0',
707.     'ifOutQLen' => '0',
708.     'ifSpecific' => 'zeroDotZero',
709.   ),
710.   5 =>
711.   array (
712.     'ifIndex' => '5',
713.     'ifDescr' => 'wifi0',
714.     'ifType' => 'other',
715.     'ifMtu' => '1500',
716.     'ifSpeed' => '0',
717.     'ifPhysAddress' => '10:27:f5:97:de:fd',
718.     'ifAdminStatus' => 'up',
719.     'ifOperStatus' => 'up',
720.     'ifLastChange' => '9009',
721.     'ifInOctets' => '284813607',
722.     'ifInUcastPkts' => '460604',
723.     'ifInNUcastPkts' => '0',
724.     'ifInDiscards' => '17391',
725.     'ifInErrors' => '17391',
726.     'ifInUnknownProtos' => '0',
727.     'ifOutOctets' => '562218674',
728.     'ifOutUcastPkts' => '760290',
729.     'ifOutNUcastPkts' => '0',
730.     'ifOutDiscards' => '211908',
731.     'ifOutErrors' => '211908',
732.     'ifOutQLen' => '0',
733.     'ifSpecific' => 'zeroDotZero',
734.   ),
735.   6 =>
736.   array (
737.     'ifIndex' => '6',
738.     'ifDescr' => 'wifi1',
739.     'ifType' => 'other',
740.     'ifMtu' => '1500',
741.     'ifSpeed' => '0',
742.     'ifPhysAddress' => '10:27:f5:97:de:fc',
743.     'ifAdminStatus' => 'up',
744.     'ifOperStatus' => 'up',
745.     'ifLastChange' => '8708',
746.     'ifInOctets' => '685072818',
747.     'ifInUcastPkts' => '639351',
748.     'ifInNUcastPkts' => '0',
749.     'ifInDiscards' => '46103',
750.     'ifInErrors' => '46103',
751.     'ifInUnknownProtos' => '0',
752.     'ifOutOctets' => '68747523',
753.     'ifOutUcastPkts' => '511704',
754.     'ifOutNUcastPkts' => '0',
755.     'ifOutDiscards' => '33192',
756.     'ifOutErrors' => '33192',
757.     'ifOutQLen' => '0',
758.     'ifSpecific' => 'zeroDotZero',
759.   ),
760.   7 =>
761.   array (
762.     'ifIndex' => '7',
763.     'ifDescr' => 'soc0',
764.     'ifType' => 'other',
765.     'ifMtu' => '0',
766.     'ifSpeed' => '0',
767.     'ifPhysAddress' => '',
768.     'ifAdminStatus' => 'down',
769.     'ifOperStatus' => 'down',
770.     'ifLastChange' => '1201',
771.     'ifInOctets' => '0',
772.     'ifInUcastPkts' => '0',
773.     'ifInNUcastPkts' => '0',
774.     'ifInDiscards' => '0',
775.     'ifInErrors' => '0',
776.     'ifInUnknownProtos' => '0',
777.     'ifOutOctets' => '0',
778.     'ifOutUcastPkts' => '0',
779.     'ifOutNUcastPkts' => '0',
780.     'ifOutDiscards' => '0',
781.     'ifOutErrors' => '0',
782.     'ifOutQLen' => '0',
783.     'ifSpecific' => 'zeroDotZero',
784.   ),
785.   14 =>
786.   array (
787.     'ifIndex' => '14',
788.     'ifDescr' => 'ath0',
789.     'ifType' => 'ethernetCsmacd',
790.     'ifMtu' => '1500',
791.     'ifSpeed' => '0',
792.     'ifPhysAddress' => '10:27:f5:97:de:fc',
793.     'ifAdminStatus' => 'up',
794.     'ifOperStatus' => 'up',
795.     'ifLastChange' => '424594',
796.     'ifInOctets' => '5294104',
797.     'ifInUcastPkts' => '69149',
798.     'ifInNUcastPkts' => '0',
799.     'ifInDiscards' => '2',
800.     'ifInErrors' => '2',
801.     'ifInUnknownProtos' => '0',
802.     'ifOutOctets' => '14875973',
803.     'ifOutUcastPkts' => '85971',
804.     'ifOutNUcastPkts' => '0',
805.     'ifOutDiscards' => '0',
806.     'ifOutErrors' => '0',
807.     'ifOutQLen' => '0',
808.     'ifSpecific' => 'zeroDotZero',
809.   ),
810.   15 =>
811.   array (
812.     'ifIndex' => '15',
813.     'ifDescr' => 'ath10',
814.     'ifType' => 'ethernetCsmacd',
815.     'ifMtu' => '1500',
816.     'ifSpeed' => '0',
817.     'ifPhysAddress' => '10:27:f5:97:de:fd',
818.     'ifAdminStatus' => 'up',
819.     'ifOperStatus' => 'up',
820.     'ifLastChange' => '424894',
821.     'ifInOctets' => '2727909',
822.     'ifInUcastPkts' => '15401',
823.     'ifInNUcastPkts' => '0',
824.     'ifInDiscards' => '3',
825.     'ifInErrors' => '3',
826.     'ifInUnknownProtos' => '0',
827.     'ifOutOctets' => '13542458',
828.     'ifOutUcastPkts' => '44717',
829.     'ifOutNUcastPkts' => '0',
830.     'ifOutDiscards' => '0',
831.     'ifOutErrors' => '0',
832.     'ifOutQLen' => '0',
833.     'ifSpecific' => 'zeroDotZero',
834.   ),
835.   16 =>
836.   array (
837.     'ifIndex' => '16',
838.     'ifDescr' => 'ath1',
839.     'ifType' => 'ethernetCsmacd',
840.     'ifMtu' => '1500',
841.     'ifSpeed' => '0',
842.     'ifPhysAddress' => '16:27:f5:97:de:fc',
843.     'ifAdminStatus' => 'up',
844.     'ifOperStatus' => 'up',
845.     'ifLastChange' => '425795',
846.     'ifInOctets' => '67349901',
847.     'ifInUcastPkts' => '56095',
848.     'ifInNUcastPkts' => '0',
849.     'ifInDiscards' => '0',
850.     'ifInErrors' => '0',
851.     'ifInUnknownProtos' => '0',
852.     'ifOutOctets' => '3936340',
853.     'ifOutUcastPkts' => '38963',
854.     'ifOutNUcastPkts' => '0',
855.     'ifOutDiscards' => '0',
856.     'ifOutErrors' => '0',
857.     'ifOutQLen' => '0',
858.     'ifSpecific' => 'zeroDotZero',
859.   ),
860. )  
861.  valid  
862. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":1,"ifName":null}[0m 3.95ms]
863.  
864. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.32ms]
865.  
866. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 7.49ms]
867.  
868. Adding: (1)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.61ms]
869.  
870.  valid  
871. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":2,"ifName":null}[0m 4.23ms]
872.  
873. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.49ms]
874.  
875. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.45ms]
876.  
877. Adding: (2)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.25ms]
878.  
879.  valid  
880. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":3,"ifName":null}[0m 3.78ms]
881.  
882. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.28ms]
883.  
884. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.45ms]
885.  
886. Adding: (3)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.22ms]
887.  
888.  valid  
889. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":4,"ifName":null}[0m 4.05ms]
890.  
891. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.28ms]
892.  
893. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.44ms]
894.  
895. Adding: (4)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.24ms]
896.  
897.  valid  
898. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":5,"ifName":null}[0m 3.96ms]
899.  
900. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.38ms]
901.  
902. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.65ms]
903.  
904. Adding: (5)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.31ms]
905.  
906.  valid  
907. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":6,"ifName":null}[0m 3.95ms]
908.  
909. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.25ms]
910.  
911. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.44ms]
912.  
913. Adding: (6)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.25ms]
914.  
915.  valid  
916. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":7,"ifName":null}[0m 3.79ms]
917.  
918. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.26ms]
919.  
920. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.5ms]
921.  
922. Adding: (7)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.29ms]
923.  
924.  valid  
925. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":14,"ifName":null}[0m 4ms]
926.  
927. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.29ms]
928.  
929. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.48ms]
930.  
931. Adding: (14)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.33ms]
932.  
933.  valid  
934. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":15,"ifName":null}[0m 4.04ms]
935.  
936. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.35ms]
937.  
938. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.54ms]
939.  
940. Adding: (15)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.32ms]
941.  
942.  valid  
943. SQL[[1;33mINSERT IGNORE INTO `ports` (`device_id`,`ifIndex`,`ifName`)  VALUES (:device_id,:ifIndex,:ifName) [0;33m{"device_id":12,"ifIndex":16,"ifName":null}[0m 3.79ms]
944.  
945. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.28ms]
946.  
947. SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m["0"][0m 0.46ms]
948.  
949. Adding: (16)(0)SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":"0"}[0m 0.26ms]
950.  
951.  
952. SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `device_id` = ? AND `port_id` = ? [0;33m["1",12,null][0m 0.29ms]
953.  
954. Port :  (16 / #) deleted.
955. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1638568917,1638568492,null][0m 0.2ms]
956.  
957. 0 updated  
958.  
959. >> Runtime for poller module 'ports': 0.1648 seconds with 11808 bytes
960. >> [0;36mSNMP[0m: [5/0.09s] [1;33mMySQL[0m: [44/0.60s]
961. #### Unload poller module ports ####
962.  
963. Modules status: Global+  
964. OS  
965. Device  
966.  
967. #### Load poller module customoid ####
968. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[12][0m 0.27ms]
969.  
970.  
971. >> Runtime for poller module 'customoid': 0.0007 seconds with 80 bytes
972. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]
973. #### Unload poller module customoid ####
974.  
975. Modules status: Global+  
976. OS  
977. Device  
978.  
979. #### Load poller module bgp-peers ####
980. 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[12][0m 0.3ms]
981.  
982.  
983. >> Runtime for poller module 'bgp-peers': 0.0030 seconds with 80 bytes
984. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]
985. #### Unload poller module bgp-peers ####
986.  
987. Modules status: Global-  
988. OS  
989. Device  
990. Module [ junose-atm-vp ] disabled globally.
991.  
992. Modules status: Global-  
993. OS  
994. Device  
995. Module [ printer-supplies ] disabled globally.
996.  
997. Modules status: Global+  
998. OS  
999. Device  
1000.  
1001. #### Load poller module ucd-diskio ####
1002. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[12][0m 0.22ms]
1003.  
1004.  
1005. >> Runtime for poller module 'ucd-diskio': 0.0006 seconds with 80 bytes
1006. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]
1007. #### Unload poller module ucd-diskio ####
1008.  
1009. Modules status: Global-  
1010. OS  
1011. Device+  
1012.  
1013. #### Load poller module wifi ####
1014.  
1015. >> Runtime for poller module 'wifi': 0.0001 seconds with 80 bytes
1016. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]
1017. #### Unload poller module wifi ####
1018.  
1019. Modules status: Global+  
1020. OS  
1021. Device  
1022.  
1023. #### Load poller module wireless ####
1024. Attempting to initialize OS: tplink  
1025. OS initialized as Generic  
1026. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[12][0m 0.29ms]
1027.  
1028.  
1029. >> Runtime for poller module 'wireless': 0.0034 seconds with 7504 bytes
1030. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]
1031. #### Unload poller module wireless ####
1032.  
1033. Modules status: Global+  
1034. OS  
1035. Device  
1036.  
1037. #### Load poller module ospf ####
1038. SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[12][0m 0.25ms]
1039.  
1040.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
1041. ospfGeneralGroup = No Such Object available on this agent at this OID  
1042.  
1043. Invalid snmp_walk() data = ospfGeneralGroup = No Such Object available on this agent at this OID  
1044. array (
1045. )  
1046. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` = ?) and 1 = 1 [0;33m[12,""][0m 0.35ms]
1047.  
1048. 0
1049. >> Runtime for poller module 'ospf': 0.0208 seconds with 50616 bytes
1050. >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [2/0.01s]
1051. #### Unload poller module ospf ####
1052.  
1053. Modules status: Global-  
1054. OS  
1055. Device  
1056. Module [ isis ] disabled globally.
1057.  
1058. Modules status: Global-  
1059. OS  
1060. Device  
1061. Module [ cisco-ipsec-flow-monitor ] disabled globally.
1062.  
1063. Modules status: Global-  
1064. OS  
1065. Device  
1066. Module [ cisco-remote-access-monitor ] disabled globally.
1067.  
1068. Modules status: Global-  
1069. OS  
1070. Device  
1071. Module [ cisco-cef ] disabled globally.
1072.  
1073. Modules status: Global-  
1074. OS  
1075. Device  
1076. Module [ slas ] disabled globally.
1077.  
1078. Modules status: Global-  
1079. OS  
1080. Device  
1081. Module [ cisco-mac-accounting ] disabled globally.
1082.  
1083. Modules status: Global-  
1084. OS  
1085. Device  
1086. Module [ cipsec-tunnels ] disabled globally.
1087.  
1088. Modules status: Global-  
1089. OS  
1090. Device  
1091. Module [ cisco-ace-loadbalancer ] disabled globally.
1092.  
1093. Modules status: Global-  
1094. OS  
1095. Device  
1096. Module [ cisco-ace-serverfarms ] disabled globally.
1097.  
1098. Modules status: Global-  
1099. OS  
1100. Device  
1101. Module [ cisco-asa-firewall ] disabled globally.
1102.  
1103. Modules status: Global-  
1104. OS  
1105. Device  
1106. Module [ cisco-voice ] disabled globally.
1107.  
1108. Modules status: Global-  
1109. OS  
1110. Device  
1111. Module [ cisco-cbqos ] disabled globally.
1112.  
1113. Modules status: Global-  
1114. OS  
1115. Device  
1116. Module [ cisco-otv ] disabled globally.
1117.  
1118. Modules status: Global-  
1119. OS  
1120. Device  
1121. Module [ cisco-qfp ] disabled globally.
1122.  
1123. Modules status: Global-  
1124. OS  
1125. Device  
1126. Module [ cisco-vpdn ] disabled globally.
1127.  
1128. Modules status: Global-  
1129. OS  
1130. Device  
1131. Module [ nac ] disabled globally.
1132.  
1133. Modules status: Global-  
1134. OS  
1135. Device  
1136. Module [ netscaler-vsvr ] disabled globally.
1137.  
1138. Modules status: Global-  
1139. OS  
1140. Device  
1141. Module [ aruba-controller ] disabled globally.
1142.  
1143. Modules status: Global+  
1144. OS  
1145. Device  
1146.  
1147. #### Load poller module entity-physical ####
1148.  
1149. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 80 bytes
1150. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]
1151. #### Unload poller module entity-physical ####
1152.  
1153. Modules status: Global-  
1154. OS  
1155. Device  
1156. Module [ entity-state ] disabled globally.
1157.  
1158. Modules status: Global+  
1159. OS  
1160. Device  
1161.  
1162. #### Load poller module applications ####
1163. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[12][0m 0.38ms]
1164.  
1165.  
1166. >> Runtime for poller module 'applications': 0.0006 seconds with 80 bytes
1167. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]
1168. #### Unload poller module applications ####
1169.  
1170. Modules status: Global-  
1171. OS  
1172. Device  
1173. Module [ mib ] disabled globally.
1174.  
1175. Modules status: Global+  
1176. OS  
1177. Device  
1178.  
1179. #### Load poller module stp ####
1180. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[12][0m 0.28ms]
1181.  
1182. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/tplink' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
1183. No Such Object available on this agent at this OID  
1184.  
1185.  
1186.  
1187. >> Runtime for poller module 'stp': 0.0171 seconds with -264 bytes
1188. >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [1/0.00s]
1189. #### Unload poller module stp ####
1190.  
1191. Modules status: Global+  
1192. OS  
1193. Device  
1194.  
1195. #### Load poller module ntp ####
1196.  
1197. >> Runtime for poller module 'ntp': 0.0001 seconds with 80 bytes
1198. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]
1199. #### Unload poller module ntp ####
1200.  
1201. Modules status: Global-  
1202. OS  
1203. Device  
1204. Module [ loadbalancers ] disabled globally.
1205.  
1206. Modules status: Global-  
1207. OS  
1208. Device  
1209. Module [ mef ] disabled globally.
1210.  
1211. Modules status: Global+  
1212. OS  
1213. Device  
1214.  
1215. #### Load poller module mpls ####
1216.  
1217. >> Runtime for poller module 'mpls': 0.0004 seconds with 488 bytes
1218. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]
1219. #### Unload poller module mpls ####
1220.  
1221. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[12][0m 0.31ms]
1222.  
1223.  
1224. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[1.511,12][0m 3.79ms]
1225.  
1226. Updating ap-1.weil-st.net  
1227.  
1228. Polled in 1.511 seconds
1229. ### Start Device Groups ###
1230. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[12][0m 0.42ms]
1231.  
1232. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.12ms]
1233.  
1234. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[12][0m 0.21ms]
1235.  
1236. Groups Added:  
1237. Groups Removed:  
1238. ### End Device Groups, runtime: 0.005s ###
1239.  
1240. #### Start Alerts ####
1241. 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[12][0m 0.56ms]
1242.  
1243. SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) &lt;= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-12-03T22:01:57.628092Z","2021-12-03T22:01:57.628092Z",0,1,"22:01:57","22:01:57","22:01:57","22:01:57","[45m%","device",12,"location",8][0m 0.79ms]
1244.  
1245. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[12][0m 0.32ms]
1246.  
1247. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
1248.         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 = ?)
1249.         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 = ?))
1250.         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 = ?))
1251.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
1252.         WHERE a.disabled = 0 AND (
1253.             (d.device_id IS NULL AND g.group_id IS NULL)
1254.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
1255.             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))
1256.         ) [0;33m[12,12,12,12,12,12,12,12][0m 0.99ms]
1257.  
1258. #### End Alerts ####
1259. ./poller.php ap-1.weil-st.net 2021-12-03 16:01:57 - 1 devices polled in 1.668 secs  
1260.  
1261. [0;36mSNMP[0m [20/0.37s]: Snmpget[12/0.22s] Snmpwalk[8/0.15s]
1262. [1;33mSQL[0m [90/0.94s]: Select[49/0.30s] Insert[31/0.50s] Update[9/0.14s] Delete[1/0.00s]
1263.