1. -bash-4.2$ ./poller.php -h tlups1 -r -f -d | ./pbin.sh
2. Paste endpoint: https://p.libren.ms/api/create
3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.58ms]
4.  
5. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.46ms]
6.  
7. SQL[SELECT version() [] 0.31ms]
8.  
9. Updating os_def.cache...  
10. Done  
11. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'tlups1' ORDER BY `device_id` ASC [] 4.78ms]
12.  
13. SQL[select * from `devices` where `device_id` = ? limit 1 [30] 0.75ms]
14.  
15. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [30] 0.58ms]
16.  
17. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'tlups1'  
18. array (
19.   'xmt' => 3,
20.   'rcv' => 3,
21.   'loss' => 0,
22.   'min' => 1.39,
23.   'max' => 1.79,
24.   'avg' => 1.56,
25.   'dup' => 0,
26.   'exitcode' => 0,
27. )  
28. SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {"xmt":3,"rcv":3,"loss":0,"min":1.39,"max":1.79,"avg":1.56,"device_id":30,"debug":"[]"} 1.21ms]
29.  
30. SNMP Check response code: 0  
31. Modules status: Global+  
32. OS  
33. Device  
34. .*.*.0 = 54961
35. .*.*.0 = 1111 W. 35th St., Chicago IL, 60609
36. .*.*.0 = www.tripplite.com
37. .*.*.0 = tlup1.int.dittman.net
38. .*.*.0 = .*.4.1.850.1
39. .*.*.0 = POWERALERT 12  
40.  
41. snmpEngineTime.0 = No Such Object available on this agent at this OID
42. hrSystemUptime.0 = No Such Object available on this agent at this OID  
43.  
44. Uptime seconds: 550  
45. SQL[select * from `locations` where (`location` = ?) limit 1 ["1111 W. 35th St., Chicago IL, 60609"] 0.67ms]
46.  
47. Modules status: Global-  
48. OS  
49. Device  
50. Modules status: Global+  
51. OS  
52. Device  
53. SU1500RTXL2Ua  
54.  
55. "home"  
56.  
57. tlups1  
58.  
59. 9725AY0AC699600158  
60.  
61. 12.04.0047  
62.  
63. Modules status: Global+  
64. OS  
65. Device  
66. SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [30] 0.96ms]
67.  
68. array (
69. )  
70. Modules status: Global+  
71. OS  
72. Device  
73. SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [30] 0.75ms]
74.  
75. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["charge",30] 0.74ms]
76.  
77. .*.*.2.4.0 = 100  
78.  
79. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["frequency",30] 1.09ms]
80.  
81. .*.*.*.1 = 600
82. .*.*.4.2.0 = 600
83. .*.*.5.1.0 = 600  
84.  
85. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["load",30] 1.01ms]
86.  
87. .*.*.*.1 = 24  
88.  
89. SQL[UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [24,25,"Load",35] 1.34ms]
90.  
91. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["runtime",30] 0.91ms]
92.  
93. .*.*.2.2.0 = 0
94. .*.*.2.3.0 = 31  
95.  
96. SQL[UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [31,28,"Runtime",37] 1.36ms]
97.  
98. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["state",30] 0.87ms]
99.  
100. .*.*.2.1.0 = 2
101. .*.*.4.1.0 = 3  
102.  
103. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["temperature",30] 1.17ms]
104.  
105. .*.*.2.7.0 = 42  
106.  
107. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["voltage",30] 1.06ms]
108.  
109. .*.*.2.5.0 = 540
110. .*.*.*.1 = 120
111. .*.*.*.1 = 124
112. .*.*.*.1 = 124  
113.  
114. Modules status: Global+  
115. OS  
116. Device  
117. Attempting to initialize OS: poweralert  
118. OS initialized as Generic  
119. SQL[SELECT * FROM processors WHERE device_id=? [30] 0.71ms]
120.  
121. Modules status: Global+  
122. OS  
123. Device  
124. SQL[SELECT * FROM mempools WHERE device_id = ? [30] 0.55ms]
125.  
126. Modules status: Global+  
127. OS  
128. Device  
129. SQL[SELECT * FROM storage WHERE device_id = ? [30] 0.58ms]
130.  
131. Modules status: Global+  
132. OS  
133. Device  
134. icmpInMsgs.0 = 172
135. icmpInErrors.0 = 0
136. icmpInDestUnreachs.0 = 1
137. icmpInTimeExcds.0 = 0
138. icmpInParmProbs.0 = 0
139. icmpInSrcQuenchs.0 = 0
140. icmpInRedirects.0 = 0
141. icmpInEchos.0 = 171
142. icmpInEchoReps.0 = 0
143. icmpInTimestamps.0 = 0
144. icmpInTimestampReps.0 = 0
145. icmpInAddrMasks.0 = 0
146. icmpInAddrMaskReps.0 = 0
147. icmpOutMsgs.0 = 171
148. icmpOutErrors.0 = 0
149. icmpOutDestUnreachs.0 = 0
150. icmpOutTimeExcds.0 = 0
151. icmpOutParmProbs.0 = 0
152. icmpOutSrcQuenchs.0 = 0
153. icmpOutRedirects.0 = 0
154. icmpOutEchos.0 = 0
155. icmpOutEchoReps.0 = 171
156. icmpOutTimestamps.0 = 0
157. icmpOutTimestampReps.0 = 0
158. icmpOutAddrMasks.0 = 0
159. icmpOutAddrMaskReps.0 = 0  
160.  
161. ipForwDatagrams.0 = 0
162. ipInDelivers.0 = 42625
163. ipInReceives.0 = 42759
164. ipOutRequests.0 = 3567
165. ipInDiscards.0 = 0
166. ipOutDiscards.0 = 0
167. ipOutNoRoutes.0 = 0
168. ipReasmReqds.0 = 0
169. ipReasmOKs.0 = 0
170. ipReasmFails.0 = 0
171. ipFragOKs.0 = 0
172. ipFragFails.0 = 0
173. ipFragCreates.0 = 0
174. ipInUnknownProtos.0 = 0
175. ipInHdrErrors.0 = 0
176. ipInAddrErrors.0 = 134  
177.  
178. No Such Object available on this agent at this OID  
179.  
180. snmpInPkts.0 = 3394
181. snmpOutPkts.0 = 3393
182. snmpInBadVersions.0 = 0
183. snmpInBadCommunityNames.0 = 0
184. snmpInBadCommunityUses.0 = 0
185. snmpInASNParseErrs.0 = 0
186. snmpInTooBigs.0 = 0
187. snmpInNoSuchNames.0 = 0
188. snmpInBadValues.0 = 0
189. snmpInReadOnlys.0 = 0
190. snmpInGenErrs.0 = 0
191. snmpInTotalReqVars.0 = 9574
192. snmpInTotalSetVars.0 = 0
193. snmpInGetRequests.0 = 2274
194. snmpInGetNexts.0 = 636
195. snmpInSetRequests.0 = 0
196. snmpInGetResponses.0 = 0
197. snmpInTraps.0 = 0
198. snmpOutTooBigs.0 = 0
199. snmpOutNoSuchNames.0 = 503
200. snmpOutBadValues.0 = 0
201. snmpOutGenErrs.0 = 0
202. snmpOutGetRequests.0 = 0
203. snmpOutGetNexts.0 = 0
204. snmpOutSetRequests.0 = 0
205. snmpOutGetResponses.0 = 3395
206. snmpOutTraps.0 = 0
207. snmpEnableAuthenTraps.0 = enabled
208. snmpSilentDrops.0 = 0
209. snmpProxyDrops.0 = 0  
210.  
211. tcpActiveOpens.0 = 0
212. tcpPassiveOpens.0 = 0
213. tcpAttemptFails.0 = 0
214. tcpEstabResets.0 = 0
215. tcpCurrEstab.0 = 0
216. tcpInSegs.0 = 0
217. tcpOutSegs.0 = 0
218. tcpRetransSegs.0 = 0
219. tcpInErrs.0 = 0
220. tcpOutRsts.0 = 0  
221.  
222. mib-* = 42412
223. mib-* = 42412  
224.  
225. udpInDatagrams.0 = 42413
226. udpOutDatagrams.0 = 3404
227. udpInErrors.0 = 0
228. udpNoPorts.0 = 39011  
229.  
230. Modules status: Global+  
231. OS  
232. Device  
233. hrSystemProcesses.0 = No Such Object available on this agent at this OID
234. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
235.  
236. Modules status: Global+  
237. OS  
238. Device  
239. systemStats = No Such Object available on this agent at this OID  
240.  
241. memTotalSwap.0 = No Such Object available on this agent at this OID
242. memAvailSwap.0 = No Such Object available on this agent at this OID
243. memTotalReal.0 = No Such Object available on this agent at this OID
244. memAvailReal.0 = No Such Object available on this agent at this OID
245. memTotalFree.0 = No Such Object available on this agent at this OID
246. memShared.0 = No Such Object available on this agent at this OID
247. memBuffer.0 = No Such Object available on this agent at this OID
248. memCached.0 = No Such Object available on this agent at this OID  
249.  
250. laLoadInt.1 = No Such Object available on this agent at this OID
251. laLoadInt.2 = No Such Object available on this agent at this OID
252. laLoadInt.3 = No Such Object available on this agent at this OID  
253.  
254. Modules status: Global+  
255. OS  
256. Device  
257. ipSystemStatsTable = No Such Object available on this agent at this OID  
258.  
259. Modules status: Global+  
260. OS  
261. Device  
262. SQL[SELECT *, `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 [30] 1.98ms]
263.  
264. ifXEntry = No Such Object available on this agent at this OID  
265.  
266. ifIndex.1 = 1
267. ifIndex.2 = 2
268. ifIndex.3 = 3
269. ifIndex.4 = 4
270. ifDescr.1 = lo
271. ifDescr.2 = eth0
272. ifDescr.3 = ppp0
273. ifDescr.4 = ppp1
274. ifType.1 = other
275. ifType.2 = iso88023Csmacd
276. ifType.3 = ppp
277. ifType.4 = ppp
278. ifMtu.1 = 1500
279. ifMtu.2 = 1500
280. ifMtu.3 = 1500
281. ifMtu.4 = 1500
282. ifSpeed.1 = 0
283. ifSpeed.2 = 100000000
284. ifSpeed.3 = 9600
285. ifSpeed.4 = 9600
286. ifPhysAddress.1 = 0
287. ifPhysAddress.2 = 0:6:67:21:54:b1
288. ifPhysAddress.3 = 0
289. ifPhysAddress.4 = 0
290. ifAdminStatus.1 = up
291. ifAdminStatus.2 = up
292. ifAdminStatus.3 = down
293. ifAdminStatus.4 = down
294. ifOperStatus.1 = up
295. ifOperStatus.2 = up
296. ifOperStatus.3 = down
297. ifOperStatus.4 = down
298. ifLastChange.1 = 0
299. ifLastChange.2 = 0
300. ifLastChange.3 = 0
301. ifLastChange.4 = 0
302. ifInOctets.1 = 0
303. ifInOctets.2 = 6944560
304. ifInOctets.3 = 0
305. ifInOctets.4 = 0
306. ifInUcastPkts.1 = 0
307. ifInUcastPkts.2 = 3649
308. ifInUcastPkts.3 = 0
309. ifInUcastPkts.4 = 0
310. ifInNUcastPkts.1 = 0
311. ifInNUcastPkts.2 = 53419
312. ifInNUcastPkts.3 = 0
313. ifInNUcastPkts.4 = 0
314. ifInDiscards.1 = 0
315. ifInDiscards.2 = 0
316. ifInDiscards.3 = 0
317. ifInDiscards.4 = 0
318. ifInErrors.1 = 0
319. ifInErrors.2 = 8246
320. ifInErrors.3 = 0
321. ifInErrors.4 = 0
322. ifInUnknownProtos.1 = 0
323. ifInUnknownProtos.2 = 0
324. ifInUnknownProtos.3 = 0
325. ifInUnknownProtos.4 = 0
326. ifOutOctets.1 = 0
327. ifOutOctets.2 = 439251
328. ifOutOctets.3 = 0
329. ifOutOctets.4 = 0
330. ifOutUcastPkts.1 = 0
331. ifOutUcastPkts.2 = 3648
332. ifOutUcastPkts.3 = 0
333. ifOutUcastPkts.4 = 0
334. ifOutNUcastPkts.1 = 0
335. ifOutNUcastPkts.2 = 4
336. ifOutNUcastPkts.3 = 0
337. ifOutNUcastPkts.4 = 0
338. ifOutDiscards.1 = 0
339. ifOutDiscards.2 = 0
340. ifOutDiscards.3 = 0
341. ifOutDiscards.4 = 0
342. ifOutErrors.1 = 0
343. ifOutErrors.2 = 0
344. ifOutErrors.3 = 0
345. ifOutErrors.4 = 0
346. ifOutQLen.1 = 0
347. ifOutQLen.2 = 0
348. ifOutQLen.3 = 0
349. ifOutQLen.4 = 0
350. ifSpecific.1 = zeroDotZero
351. ifSpecific.2 = zeroDotZero
352. ifSpecific.3 = zeroDotZero
353. ifSpecific.4 = zeroDotZero  
354.  
355. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
356.  
357. dot1qPvid = No Such Object available on this agent at this OID  
358.  
359. SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [30] 0.87ms]
360.  
361. array (
362.   1 =>
363.   array (
364.     'ifIndex' => '1',
365.     'ifDescr' => 'lo',
366.     'ifType' => 'other',
367.     'ifMtu' => '1500',
368.     'ifSpeed' => '0',
369.     'ifPhysAddress' => '0',
370.     'ifAdminStatus' => 'up',
371.     'ifOperStatus' => 'up',
372.     'ifLastChange' => '0',
373.     'ifInOctets' => '0',
374.     'ifInUcastPkts' => '0',
375.     'ifInNUcastPkts' => '0',
376.     'ifInDiscards' => '0',
377.     'ifInErrors' => '0',
378.     'ifInUnknownProtos' => '0',
379.     'ifOutOctets' => '0',
380.     'ifOutUcastPkts' => '0',
381.     'ifOutNUcastPkts' => '0',
382.     'ifOutDiscards' => '0',
383.     'ifOutErrors' => '0',
384.     'ifOutQLen' => '0',
385.     'ifSpecific' => 'zeroDotZero',
386.   ),
387.   2 =>
388.   array (
389.     'ifIndex' => '2',
390.     'ifDescr' => 'eth0',
391.     'ifType' => 'iso88023Csmacd',
392.     'ifMtu' => '1500',
393.     'ifSpeed' => '100000000',
394.     'ifPhysAddress' => '0:6:67:21:54:b1',
395.     'ifAdminStatus' => 'up',
396.     'ifOperStatus' => 'up',
397.     'ifLastChange' => '0',
398.     'ifInOctets' => '6944560',
399.     'ifInUcastPkts' => '3649',
400.     'ifInNUcastPkts' => '53419',
401.     'ifInDiscards' => '0',
402.     'ifInErrors' => '8246',
403.     'ifInUnknownProtos' => '0',
404.     'ifOutOctets' => '439251',
405.     'ifOutUcastPkts' => '3648',
406.     'ifOutNUcastPkts' => '4',
407.     'ifOutDiscards' => '0',
408.     'ifOutErrors' => '0',
409.     'ifOutQLen' => '0',
410.     'ifSpecific' => 'zeroDotZero',
411.   ),
412.   3 =>
413.   array (
414.     'ifIndex' => '3',
415.     'ifDescr' => 'ppp0',
416.     'ifType' => 'ppp',
417.     'ifMtu' => '1500',
418.     'ifSpeed' => '9600',
419.     'ifPhysAddress' => '0',
420.     'ifAdminStatus' => 'down',
421.     'ifOperStatus' => 'down',
422.     'ifLastChange' => '0',
423.     'ifInOctets' => '0',
424.     'ifInUcastPkts' => '0',
425.     'ifInNUcastPkts' => '0',
426.     'ifInDiscards' => '0',
427.     'ifInErrors' => '0',
428.     'ifInUnknownProtos' => '0',
429.     'ifOutOctets' => '0',
430.     'ifOutUcastPkts' => '0',
431.     'ifOutNUcastPkts' => '0',
432.     'ifOutDiscards' => '0',
433.     'ifOutErrors' => '0',
434.     'ifOutQLen' => '0',
435.     'ifSpecific' => 'zeroDotZero',
436.   ),
437.   4 =>
438.   array (
439.     'ifIndex' => '4',
440.     'ifDescr' => 'ppp1',
441.     'ifType' => 'ppp',
442.     'ifMtu' => '1500',
443.     'ifSpeed' => '9600',
444.     'ifPhysAddress' => '0',
445.     'ifAdminStatus' => 'down',
446.     'ifOperStatus' => 'down',
447.     'ifLastChange' => '0',
448.     'ifInOctets' => '0',
449.     'ifInUcastPkts' => '0',
450.     'ifInNUcastPkts' => '0',
451.     'ifInDiscards' => '0',
452.     'ifInErrors' => '0',
453.     'ifInUnknownProtos' => '0',
454.     'ifOutOctets' => '0',
455.     'ifOutUcastPkts' => '0',
456.     'ifOutNUcastPkts' => '0',
457.     'ifOutDiscards' => '0',
458.     'ifOutErrors' => '0',
459.     'ifOutQLen' => '0',
460.     'ifSpecific' => 'zeroDotZero',
461.   ),
462. )  
463.  valid  
464.  valid  
465.  valid  
466.  valid  
467. ifInOctets  
468. ifOutOctets  
469. ifInUcastPkts  
470. ifOutUcastPkts  
471. ifInBroadcastPkts  
472. ifOutBroadcastPkts  
473. ifInMulticastPkts  
474. ifOutMulticastPkts  
475. ifSpeed  
476.  Using ifDescr as ifAlias  
477.  Using ifDescr as ifName  
478.  
479.  ifInOctets (0 B) 0 Bps 225 secs  
480.  
481.  ifOutOctets (0 B) 0 Bps 225 secs  
482.  
483.  ifInErrors (0 B) 0 Bps 225 secs  
484.  
485.  ifOutErrors (0 B) 0 Bps 225 secs  
486.  
487.  ifInUcastPkts (0 B) 0 Bps 225 secs  
488.  
489.  ifOutUcastPkts (0 B) 0 Bps 225 secs  
490.  
491.  ifInNUcastPkts (0 B) 0 Bps 225 secs  
492.  
493.  ifOutNUcastPkts (0 B) 0 Bps 225 secs  
494.  
495.  ifInDiscards (0 B) 0 Bps 225 secs  
496.  
497.  ifOutDiscards (0 B) 0 Bps 225 secs  
498.  
499.  ifInUnknownProtos (0 B) 0 Bps 225 secs  
500.  
501.  ifInBroadcastPkts (0 B) 0 Bps 225 secs  
502.  
503.  ifOutBroadcastPkts (0 B) 0 Bps 225 secs  
504.  
505.  ifInMulticastPkts (0 B) 0 Bps 225 secs  
506.  
507.  ifOutMulticastPkts (0 B) 0 Bps 225 secs  
508. SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,188] 1.26ms]
509.  
510. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,188] 1.15ms]
511.  
512. 1 updated  
513. ifInOctets  
514. ifOutOctets  
515. ifInUcastPkts  
516. ifOutUcastPkts  
517. ifInBroadcastPkts  
518. ifOutBroadcastPkts  
519. ifInMulticastPkts  
520. ifOutMulticastPkts  
521. ifSpeed  
522.  Using ifDescr as ifAlias  
523.  Using ifDescr as ifName  
524.  
525.  ifInOctets (324989 B) 1444.3955555556 Bps 225 secs  
526.  
527.  ifOutOctets (35777 B) 159.00888888889 Bps 225 secs  
528.  
529.  ifInErrors (231 B) 1.0266666666667 Bps 225 secs  
530.  
531.  ifOutErrors (0 B) 0 Bps 225 secs  
532.  
533.  ifInUcastPkts (257 B) 1.1422222222222 Bps 225 secs  
534.  
535.  ifOutUcastPkts (257 B) 1.1422222222222 Bps 225 secs  
536.  
537.  ifInNUcastPkts (2602 B) 11.564444444444 Bps 225 secs  
538.  
539.  ifOutNUcastPkts (0 B) 0 Bps 225 secs  
540.  
541.  ifInDiscards (0 B) 0 Bps 225 secs  
542.  
543.  ifOutDiscards (0 B) 0 Bps 225 secs  
544.  
545.  ifInUnknownProtos (0 B) 0 Bps 225 secs  
546.  
547.  ifInBroadcastPkts (0 B) 0 Bps 225 secs  
548.  
549.  ifOutBroadcastPkts (0 B) 0 Bps 225 secs  
550.  
551.  ifInMulticastPkts (0 B) 0 Bps 225 secs  
552.  
553.  ifOutMulticastPkts (0 B) 0 Bps 225 secs  
554. SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","6944560",6619571,1444.3955555555556,324989,"439251",403474,159.0088888888889,35777,"8246",8015,1.0266666666666666,231,"0",0,0,0,"3649",3392,1.1422222222222222,257,"3648",3391,1.1422222222222222,257,189] 1.12ms]
555.  
556. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["53419",50817,11.564444444444444,2602,"4",4,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,189] 1.03ms]
557.  
558. 2 updated  
559. ifInOctets  
560. ifOutOctets  
561. ifInUcastPkts  
562. ifOutUcastPkts  
563. ifInBroadcastPkts  
564. ifOutBroadcastPkts  
565. ifInMulticastPkts  
566. ifOutMulticastPkts  
567. ifSpeed  
568.  Using ifDescr as ifAlias  
569.  Using ifDescr as ifName  
570.  
571.  ifInOctets (0 B) 0 Bps 225 secs  
572.  
573.  ifOutOctets (0 B) 0 Bps 225 secs  
574.  
575.  ifInErrors (0 B) 0 Bps 225 secs  
576.  
577.  ifOutErrors (0 B) 0 Bps 225 secs  
578.  
579.  ifInUcastPkts (0 B) 0 Bps 225 secs  
580.  
581.  ifOutUcastPkts (0 B) 0 Bps 225 secs  
582.  
583.  ifInNUcastPkts (0 B) 0 Bps 225 secs  
584.  
585.  ifOutNUcastPkts (0 B) 0 Bps 225 secs  
586.  
587.  ifInDiscards (0 B) 0 Bps 225 secs  
588.  
589.  ifOutDiscards (0 B) 0 Bps 225 secs  
590.  
591.  ifInUnknownProtos (0 B) 0 Bps 225 secs  
592.  
593.  ifInBroadcastPkts (0 B) 0 Bps 225 secs  
594.  
595.  ifOutBroadcastPkts (0 B) 0 Bps 225 secs  
596.  
597.  ifInMulticastPkts (0 B) 0 Bps 225 secs  
598.  
599.  ifOutMulticastPkts (0 B) 0 Bps 225 secs  
600. SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,190] 1.12ms]
601.  
602. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,190] 1.01ms]
603.  
604. 1 updated  
605. ifInOctets  
606. ifOutOctets  
607. ifInUcastPkts  
608. ifOutUcastPkts  
609. ifInBroadcastPkts  
610. ifOutBroadcastPkts  
611. ifInMulticastPkts  
612. ifOutMulticastPkts  
613. ifSpeed  
614.  Using ifDescr as ifAlias  
615.  Using ifDescr as ifName  
616.  
617.  ifInOctets (0 B) 0 Bps 225 secs  
618.  
619.  ifOutOctets (0 B) 0 Bps 225 secs  
620.  
621.  ifInErrors (0 B) 0 Bps 225 secs  
622.  
623.  ifOutErrors (0 B) 0 Bps 225 secs  
624.  
625.  ifInUcastPkts (0 B) 0 Bps 225 secs  
626.  
627.  ifOutUcastPkts (0 B) 0 Bps 225 secs  
628.  
629.  ifInNUcastPkts (0 B) 0 Bps 225 secs  
630.  
631.  ifOutNUcastPkts (0 B) 0 Bps 225 secs  
632.  
633.  ifInDiscards (0 B) 0 Bps 225 secs  
634.  
635.  ifOutDiscards (0 B) 0 Bps 225 secs  
636.  
637.  ifInUnknownProtos (0 B) 0 Bps 225 secs  
638.  
639.  ifInBroadcastPkts (0 B) 0 Bps 225 secs  
640.  
641.  ifOutBroadcastPkts (0 B) 0 Bps 225 secs  
642.  
643.  ifInMulticastPkts (0 B) 0 Bps 225 secs  
644.  
645.  ifOutMulticastPkts (0 B) 0 Bps 225 secs  
646. SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,191] 1.17ms]
647.  
648. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,191] 1ms]
649.  
650. 1 updated  
651. Modules status: Global+  
652. OS  
653. Device  
654. SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [30] 0.67ms]
655.  
656. Modules status: Global+  
657. OS  
658. Device  
659. SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [30] 0.71ms]
660.  
661. Modules status: Global-  
662. OS  
663. Device  
664. Modules status: Global-  
665. OS  
666. Device  
667. Modules status: Global+  
668. OS  
669. Device  
670. SQL[SELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [30] 0.49ms]
671.  
672. Modules status: Global-  
673. OS  
674. Device  
675. Modules status: Global+  
676. OS  
677. Device  
678. Attempting to initialize OS: poweralert  
679. OS initialized as Generic  
680. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [30] 0.69ms]
681.  
682. Modules status: Global+  
683. OS  
684. Device  
685. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 0.7ms]
686.  
687. ospfGeneralGroup = No Such Object available on this agent at this OID  
688.  
689. array (
690. )  
691. SQL[delete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [30] 0.63ms]
692.  
693. Modules status: Global-  
694. OS  
695. Device  
696. Modules status: Global-  
697. OS  
698. Device  
699. Modules status: Global-  
700. OS  
701. Device  
702. Modules status: Global-  
703. OS  
704. Device  
705. Modules status: Global-  
706. OS  
707. Device  
708. Modules status: Global-  
709. OS  
710. Device  
711. Modules status: Global-  
712. OS  
713. Device  
714. Modules status: Global-  
715. OS  
716. Device  
717. Modules status: Global-  
718. OS  
719. Device  
720. Modules status: Global-  
721. OS  
722. Device  
723. Modules status: Global-  
724. OS  
725. Device  
726. Modules status: Global-  
727. OS  
728. Device  
729. Modules status: Global-  
730. OS  
731. Device  
732. Modules status: Global-  
733. OS  
734. Device  
735. Modules status: Global-  
736. OS  
737. Device  
738. Modules status: Global-  
739. OS  
740. Device  
741. Modules status: Global-  
742. OS  
743. Device  
744. Modules status: Global+  
745. OS  
746. Device  
747. SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [30] 0.61ms]
748.  
749. Modules status: Global-  
750. OS  
751. Device  
752. Modules status: Global+  
753. OS  
754. Device  
755. SQL[SELECT * FROM `applications` WHERE `device_id`  = ? [30] 0.63ms]
756.  
757. Modules status: Global-  
758. OS  
759. Device  
760. Modules status: Global+  
761. OS  
762. Device  
763. SQL[SELECT * FROM `stp` WHERE `device_id` = ? [30] 0.61ms]
764.  
765. No Such Object available on this agent at this OID  
766.  
767. Modules status: Global+  
768. OS  
769. Device  
770. Modules status: Global-  
771. OS  
772. Device  
773. Modules status: Global-  
774. OS  
775. Device  
776. Modules status: Global+  
777. OS  
778. Device  
779. Attempting to initialize OS: poweralert  
780. OS initialized as Generic  
781. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 1.01ms]
782.  
783. SQL[select * from `device_groups` [] 0.6ms]
784.  
785. SQL[select * from `device_group_device` where `device_id` = ? [30] 0.48ms]
786.  
787. Groups Added:  
788. Groups Removed:  
789. SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [30] 0.58ms]
790.  
791. SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [550,1.56,3.974,30] 1.3ms]
792.  
793. Updating tlups1  
794. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 0.71ms]
795.  
796. SQL[select `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` = ? [30] 0.61ms]
797.  
798. SQL[select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`start_recurring_dt` <= date_format(NOW(), '--%d') and (`end_recurring_dt` >= date_format(NOW(), '--%d') or `end_recurring_dt` is null or `end_recurring_dt` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), ''), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and 0 = 1))) as `exists` [0,1,"0000-00-00","","","device",30,"device_group"] 1.02ms]
799.  
800. SQL[SELECT DISTINCT a.* FROM alert_rules a
801.         LEFT JOIN alert_device_map d ON a.id=d.rule_id
802.         LEFT JOIN alert_group_map g ON a.id=g.rule_id
803.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
804.         WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [30,30] 2.12ms]
805.  
806. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"tlups1","start":1577149451.081733,"duration":"4.470","devices":1,"poller":null} 7.49ms]
807.  
808. ./poller.php tlups1 2019-12-23 19:04:15 - 1 devices polled in 4.470 secs  
809. title:
810. name: librenms
811. private: 1
812. expire: 0
813. https://p.libren.ms/view/f7f10dc0
814.