1. -bash-4.2$ ./discovery.php -h tlups1 -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.92ms]
4.  
5. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.51ms]
6.  
7. SQL[SELECT version() [] 0.4ms]
8.  
9. Updating os_def.cache...  
10. Done  
11. SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE 'tlups1' ORDER BY device_id DESC [] 4.36ms]
12.  
13. SQL[select * from `devices` where `device_id` = ? limit 1 [30] 3.22ms]
14.  
15. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [30] 1.95ms]
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.31,
23.   'max' => 10.8,
24.   'avg' => 4.59,
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.31,"max":10.8,"avg":4.59,"device_id":30,"debug":"[]"} 1.53ms]
29.  
30. SNMP Check response code: 0  
31. Attempting to initialize OS: poweralert  
32. OS initialized as Generic  
33. Modules status: Global+  
34. OS  
35. Device  
36. .*.*.0 = tlup1.int.dittman.net
37. .*.*.0 = .*.4.1.850.1
38. .*.*.0 = POWERALERT 12  
39.  
40. Modules status: Global+  
41. OS+  
42. Device  
43. POWERALERT 12  
44.  
45. .*.4.1.850.1  
46.  
47. | POWERALERT 12 | .1.3.6.1.4.1.850.1 |  
48. No Such Object available on this agent at this OID  
49.  
50. No Such Object available on this agent at this OID  
51.  
52. No Such Object available on this agent at this OID  
53.  
54. No Such Object available on this agent at this OID  
55.  
56. No Such Instance currently exists at this OID  
57.  
58. Modules status: Global+  
59. OS+  
60. Device  
61. ifDescr.1 = lo
62. ifDescr.2 = eth0
63. ifDescr.3 = ppp0
64. ifDescr.4 = ppp1  
65.  
66. ifName = No Such Object available on this agent at this OID  
67.  
68. ifAlias = No Such Object available on this agent at this OID  
69.  
70. ifType.1 = other
71. ifType.2 = iso88023Csmacd
72. ifType.3 = ppp
73. ifType.4 = ppp  
74.  
75. array (
76.   1 =>
77.   array (
78.     'ifDescr' => 'lo',
79.     'ifType' => 'other',
80.   ),
81.   2 =>
82.   array (
83.     'ifDescr' => 'eth0',
84.     'ifType' => 'iso88023Csmacd',
85.   ),
86.   3 =>
87.   array (
88.     'ifDescr' => 'ppp0',
89.     'ifType' => 'ppp',
90.   ),
91.   4 =>
92.   array (
93.     'ifDescr' => 'ppp1',
94.     'ifType' => 'ppp',
95.   ),
96. )  
97. SQL[SELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [30] 1.38ms]
98.  
99.  Using ifDescr as ifAlias  
100.  Using ifDescr as ifName  
101. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["lo","other",1,"lo","lo",188] 9.14ms]
102.  
103.  Using ifDescr as ifAlias  
104.  Using ifDescr as ifName  
105. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["eth0","iso88023Csmacd",2,"eth0","eth0",189] 7.39ms]
106.  
107.  Using ifDescr as ifAlias  
108.  Using ifDescr as ifName  
109. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["ppp0","ppp",3,"ppp0","ppp0",190] 1.01ms]
110.  
111.  Using ifDescr as ifAlias  
112.  Using ifDescr as ifName  
113. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["ppp1","ppp",4,"ppp1","ppp1",191] 0.96ms]
114.  
115. Modules status: Global+  
116. OS+  
117. Device  
118. SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '30' [] 0.5ms]
119.  
120. ifStackStatus = No Such Object available on this agent at this OID  
121.  
122. Modules status: Global+  
123. OS+  
124. Device  
125. entPhysicalEntry = No Such Object available on this agent at this OID  
126.  
127. SQL[SELECT * FROM `entPhysical` WHERE `device_id` = ? [30] 0.91ms]
128.  
129. Modules status: Global-  
130. OS-  
131. Device  
132. Modules status: Global+  
133. OS+  
134. Device  
135. No YAML Discovery data.  
136. hrProcessorLoad = No Such Object available on this agent at this OID  
137.  
138. SQL[select * from `locations` where `locations`.`id` = ? limit 1 [5] 0.62ms]
139.  
140. SQL[select * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [30] 0.78ms]
141.  
142. No Such Object available on this agent at this OID  
143.  
144. SQL[SELECT * FROM `processors` WHERE `device_id`=? [30] 0.87ms]
145.  
146. SQL[DELETE T FROM `processors` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `devices`.`device_id` IS NULL [] 0.7ms]
147.  
148. Modules status: Global+  
149. OS+  
150. Device  
151. SQL[SELECT COUNT(*) FROM `mempools` WHERE `device_id` = ? AND `mempool_type` = 'cemp' [30] 0.52ms]
152.  
153. dellNetCpuUtilTable = No Such Object available on this agent at this OID  
154.  
155. dellNetProcessorEntry = No Such Object available on this agent at this OID  
156.  
157. hpLocalMem = No Such Object available on this agent at this OID  
158.  
159. hpGlobalMem = No Such Object available on this agent at this OID  
160.  
161. hrStorageEntry = No Such Object available on this agent at this OID  
162.  
163. memoryUsageTable = No Such Object available on this agent at this OID  
164.  
165. memStatsTable = No Such Object available on this agent at this OID  
166.  
167.  
168. SQL[SELECT * FROM `mempools` WHERE `device_id`  = '30' [] 0.97ms]
169.  
170. Modules status: Global+  
171. OS+  
172. Device  
173. SQL[SELECT * FROM vrf_lite_cisco WHERE device_id = ?  [30] 0.47ms]
174.  
175. Modules status: Global-  
176. OS-  
177. Device  
178. Modules status: Global-  
179. OS-  
180. Device  
181. Modules status: Global-  
182. OS-  
183. Device  
184. Modules status: Global-  
185. OS-  
186. Device  
187. Modules status: Global-  
188. OS-  
189. Device  
190. Modules status: Global-  
191. OS-  
192. Device  
193. Modules status: Global-  
194. OS-  
195. Device  
196. Modules status: Global-  
197. OS-  
198. Device  
199. Modules status: Global+  
200. OS+  
201. Device  
202. ipAdEntIfIndex.* 1
203. ipAdEntIfIndex.* 2  
204.  
205. *  
206.  
207. SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [30,"1"] 0.88ms]
208.  
209. SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [30,"1"] 0.62ms]
210.  
211. SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? ["127.0.0.0\/8"] 0.59ms]
212.  
213. SQL[UPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [null,"127.0.0.0\/8"] 11.43ms]
214.  
215. SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? ["127.0.0.0\/8"] 0.55ms]
216.  
217. SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ?  ["127.0.0.1",8,188] 0.56ms]
218.  
219. SQL[UPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [null,"127.0.0.1",8,188] 6.21ms]
220.  
221. *  
222.  
223. SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [30,"2"] 0.77ms]
224.  
225. SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [30,"2"] 0.56ms]
226.  
227. SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? ["192.94.152.0\/24"] 0.53ms]
228.  
229. SQL[UPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [null,"192.94.152.0\/24"] 1.12ms]
230.  
231. SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? ["192.94.152.0\/24"] 0.55ms]
232.  
233. SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ?  ["192.94.152.251",24,189] 0.62ms]
234.  
235. SQL[UPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [null,"192.94.152.251",24,189] 0.97ms]
236.  
237. SQL[SELECT `ipv4_addresses`.*, `ports`.`device_id`, `ports`.`ifIndex` FROM `ipv4_addresses` LEFT JOIN `ports` ON `ipv4_addresses`.`port_id` = `ports`.`port_id` WHERE `ports`.device_id = ? OR `ports`.`device_id` IS NULL [30] 0.93ms]
238.  
239. Modules status: Global+  
240. OS+  
241. Device  
242. ipAddressIfIndex.ipv6 No Such Object available on this agent at this OID  
243.  
244. .*.*.8.1.2 No Such Object available on this agent at this OID  
245.  
246. SQL[SELECT `ipv6_addresses`.*, `ports`.`device_id`, `ports`.`ifIndex` FROM `ipv6_addresses` LEFT JOIN `ports` ON `ipv6_addresses`.`port_id` = `ports`.`port_id` WHERE `ports`.device_id = ? OR `ports`.`device_id` IS NULL [30] 0.96ms]
247.  
248. Modules status: Global-  
249. OS-  
250. Device  
251. Modules status: Global+  
252. OS+  
253. Device  
254. 9725AY0AC699600158  
255.  
256. array (
257.   'poweralert_serial' => '9725AY0AC699600158',
258. )  
259. entPhysicalDescr = No Such Instance currently exists at this OID  
260.  
261. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["voltage",30,"ipmi"] 1.98ms]
262.  
263. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["temperature",30,"ipmi"] 1.15ms]
264.  
265. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["fanspeed",30,"ipmi"] 1.01ms]
266.  
267. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["power",30,"ipmi"] 1.02ms]
268.  
269.  
270. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["airflow",30,"snmp"] 0.98ms]
271.  
272. No Such Instance currently exists at this OID  
273.  
274. upsOutputCurrent[1] = No Such Instance currently exists at this OID  
275.  
276. upsInputCurrent[1] = No Such Instance currently exists at this OID  
277.  
278. upsBypassCurrent[1] = No Such Instance currently exists at this OID  
279.  
280.  
281. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["current",30,"snmp"] 1.42ms]
282.  
283. 100  
284.  
285. Discover sensor: .1.3.6.1.2.1.33.1.2.4.0, 500, rfc1628, Battery charge remaining, snmp, 1, 1, , 100, (limits: LL: 15, LW: 50, W: , H: 101)  
286. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","charge",30,"rfc1628","500"] 0.93ms]
287.  
288. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["charge",30,"rfc1628","500"] 0.77ms]
289.  
290. array (
291.   'rfc1628' =>
292.   array (
293.     500 => 1,
294.   ),
295. )  
296. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["charge",30,"snmp"] 1.09ms]
297.  
298. 500 -> rfc1628  
299.  
300. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["dbm",30,"snmp"] 0.96ms]
301.  
302.  
303. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["fanspeed",30,"snmp"] 0.97ms]
304.  
305. upsInputFrequency[1] = 600  
306.  
307. Discover sensor: .1.3.6.1.2.1.33.1.3.3.1.2.1, 3.2.0.1, rfc1628, Input, snmp, 10, 1, , 60, (limits: LL: , LW: , W: , H: )  
308. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","frequency",30,"rfc1628","3.2.0.1"] 1.17ms]
309.  
310. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","3.2.0.1"] 1ms]
311.  
312. 600  
313.  
314. Discover sensor: .1.3.6.1.2.1.33.1.4.2.0, 4.2.0, rfc1628, Output, snmp, 10, 1, , 60, (limits: LL: , LW: , W: , H: )  
315. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","frequency",30,"rfc1628","4.2.0"] 1.07ms]
316.  
317. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","4.2.0"] 0.93ms]
318.  
319. 600  
320.  
321. Discover sensor: .1.3.6.1.2.1.33.1.5.1.0, 5.1.0, rfc1628, Bypass, snmp, 10, 1, , 60, (limits: LL: , LW: , W: , H: )  
322. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","frequency",30,"rfc1628","5.1.0"] 1.1ms]
323.  
324. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","5.1.0"] 0.92ms]
325.  
326. array (
327.   'rfc1628' =>
328.   array (
329.     '3.2.0.1' => 1,
330.     '4.2.0' => 1,
331.     '5.1.0' => 1,
332.   ),
333. )  
334. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["frequency",30,"snmp"] 1.31ms]
335.  
336. 3.2.0.1 -> rfc1628  
337. 4.2.0 -> rfc1628  
338. 5.1.0 -> rfc1628  
339.  
340. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["humidity",30,"snmp"] 1.1ms]
341.  
342. upsOutputPercentLoad[1] = 25  
343.  
344. Discover sensor: .1.3.6.1.2.1.33.1.4.4.1.5.1, 501, rfc1628, Percentage load, snmp, 1, 1, , 25, (limits: LL: , LW: , W: , H: )  
345. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","load",30,"rfc1628","501"] 0.89ms]
346.  
347. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["load",30,"rfc1628","501"] 0.81ms]
348.  
349. array (
350.   'rfc1628' =>
351.   array (
352.     501 => 1,
353.   ),
354. )  
355. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["load",30,"snmp"] 1.11ms]
356.  
357. 501 -> rfc1628  
358. upsOutputPower[1] = No Such Instance currently exists at this OID  
359.  
360. upsInputTruePower[1] = No Such Instance currently exists at this OID  
361.  
362. upsBypassPower[1] = No Such Instance currently exists at this OID  
363.  
364.  
365. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["power",30,"snmp"] 1.36ms]
366.  
367.  
368. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["power_consumed",30,"snmp"] 1.05ms]
369.  
370.  
371. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["power_factor",30,"snmp"] 1.06ms]
372.  
373. 0  
374.  
375. Discover sensor: .1.3.6.1.2.1.33.1.2.2.0, 100, rfc1628, Time on battery, snmp, 60, 1, , 0, (limits: LL: 0, LW: 0, W: 1, H: 2)  
376. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","runtime",30,"rfc1628","100"] 0.92ms]
377.  
378. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["runtime",30,"rfc1628","100"] 0.82ms]
379.  
380. 30  
381.  
382. Discover sensor: .1.3.6.1.2.1.33.1.2.3.0, 200, rfc1628, Estimated battery time remaining, snmp, 1, 1, , 30, (limits: LL: 5, LW: 10, W: , H: 10000)  
383. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","runtime",30,"rfc1628","200"] 1.02ms]
384.  
385. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["runtime",30,"rfc1628","200"] 0.87ms]
386.  
387. array (
388.   'rfc1628' =>
389.   array (
390.     100 => 1,
391.     200 => 1,
392.   ),
393. )  
394. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["runtime",30,"snmp"] 1.2ms]
395.  
396. 100 -> rfc1628  
397. 200 -> rfc1628  
398.  
399. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["signal",30,"snmp"] 0.95ms]
400.  
401. 2  
402.  
403. SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["upsBatteryStatusState"] 0.79ms]
404.  
405. SQL[SELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [43] 0.72ms]
406.  
407. Discover sensor: .1.3.6.1.2.1.33.1.2.1.0, 0, upsBatteryStatusState, Battery Status, snmp, 1, 1, 0, 2, (limits: LL: , LW: , W: , H: )  
408. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","state",30,"upsBatteryStatusState","0"] 0.76ms]
409.  
410. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsBatteryStatusState","0"] 0.86ms]
411.  
412. SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsBatteryStatusState",0] 0.75ms]
413.  
414. SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["upsBatteryStatusState"] 0.6ms]
415.  
416. SQL[INSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`)  VALUES (:sensor_id,:state_index_id) {"sensor_id":38,"state_index_id":43} 1.28ms]
417.  
418. 3  
419.  
420. SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["upsOutputSourceState"] 0.77ms]
421.  
422. SQL[SELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [44] 0.71ms]
423.  
424. Discover sensor: .1.3.6.1.2.1.33.1.4.1.0, 0, upsOutputSourceState, Output Source, snmp, 1, 1, 0, 3, (limits: LL: , LW: , W: , H: )  
425. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","state",30,"upsOutputSourceState","0"] 0.77ms]
426.  
427. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsOutputSourceState","0"] 0.86ms]
428.  
429. SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsOutputSourceState",0] 0.74ms]
430.  
431. SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["upsOutputSourceState"] 0.58ms]
432.  
433. SQL[INSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`)  VALUES (:sensor_id,:state_index_id) {"sensor_id":39,"state_index_id":44} 1.24ms]
434.  
435. array (
436.   'upsBatteryStatusState' =>
437.   array (
438.     0 => 1,
439.   ),
440.   'upsOutputSourceState' =>
441.   array (
442.     0 => 1,
443.   ),
444. )  
445. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["state",30,"snmp"] 1.23ms]
446.  
447. 0 -> upsBatteryStatusState  
448. 0 -> upsOutputSourceState  
449.  
450. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["count",30,"snmp"] 0.95ms]
451.  
452. 42  
453.  
454. Discover sensor: .1.3.6.1.2.1.33.1.2.7.0, 0, rfc1628, Battery, snmp, 1, 1, , 42, (limits: LL: , LW: , W: , H: )  
455. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","temperature",30,"rfc1628","0"] 1.03ms]
456.  
457. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["temperature",30,"rfc1628","0"] 0.94ms]
458.  
459. array (
460.   'rfc1628' =>
461.   array (
462.     0 => 1,
463.   ),
464. )  
465. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["temperature",30,"snmp"] 1.18ms]
466.  
467. 0 -> rfc1628  
468. 540  
469.  
470. Discover sensor: .1.3.6.1.2.1.33.1.2.5.0, 1.2.5.0, rfc1628, Battery, snmp, 10, 1, , 54, (limits: LL: , LW: , W: , H: )  
471. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",30,"rfc1628","1.2.5.0"] 1.01ms]
472.  
473. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","1.2.5.0"] 0.93ms]
474.  
475. upsOutputVoltage[1] = 119  
476.  
477. Discover sensor: .1.3.6.1.2.1.33.1.4.4.1.2.1, 1, rfc1628, Output, snmp, 1, 1, , 119, (limits: LL: , LW: , W: , H: )  
478. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",30,"rfc1628","1"] 1.08ms]
479.  
480. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","1"] 0.93ms]
481.  
482. upsInputVoltage[1] = 124  
483.  
484. Discover sensor: .1.3.6.1.2.1.33.1.3.3.1.3.1, 101, rfc1628, Input, snmp, 1, 1, , 124, (limits: LL: , LW: , W: , H: )  
485. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",30,"rfc1628","101"] 1.06ms]
486.  
487. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","101"] 0.89ms]
488.  
489. upsBypassVoltage[1] = 124  
490.  
491. Discover sensor: .1.3.6.1.2.1.33.1.5.3.1.2.1, 201, rfc1628, Bypass, snmp, 1, 1, , 124, (limits: LL: , LW: , W: , H: )  
492. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",30,"rfc1628","201"] 0.97ms]
493.  
494. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","201"] 0.83ms]
495.  
496. array (
497.   'rfc1628' =>
498.   array (
499.     '1.2.5.0' => 1,
500.     1 => 1,
501.     101 => 1,
502.     201 => 1,
503.   ),
504. )  
505. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["voltage",30,"snmp"] 1.2ms]
506.  
507. 1.2.5.0 -> rfc1628  
508. 1 -> rfc1628  
509. 101 -> rfc1628  
510. 201 -> rfc1628  
511.  
512. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["snr",30,"snmp"] 0.97ms]
513.  
514.  
515. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["pressure",30,"snmp"] 0.99ms]
516.  
517.  
518. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["cooling",30,"snmp"] 0.95ms]
519.  
520.  
521. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["delay",30,"snmp"] 0.9ms]
522.  
523.  
524. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["quality_factor",30,"snmp"] 0.91ms]
525.  
526.  
527. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["chromatic_dispersion",30,"snmp"] 0.9ms]
528.  
529.  
530. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["ber",30,"snmp"] 0.9ms]
531.  
532.  
533. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["eer",30,"snmp"] 0.9ms]
534.  
535.  
536. SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["waterflow",30,"snmp"] 1ms]
537.  
538. Modules status: Global+  
539. OS+  
540. Device  
541.  
542. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/poweralert
543. Cannot find module (IBM-AIX-MIB): At line 1 in (none)
544. aixFsTableEntry: Unknown Object Identifier (Sub-id not found: (top) -> aixFsTableEntry)  
545. SQL[SELECT `storage_descr` FROM `storage` WHERE `device_id`  = '30' AND `storage_type` != 'aixFileSystem' [] 0.73ms]
546.  
547. fileSystemSpaceTable = No Such Object available on this agent at this OID  
548.  
549. hrStorageEntry = No Such Object available on this agent at this OID  
550.  
551. dskTable = No Such Object available on this agent at this OID  
552.  
553. SQL[SELECT `storage_descr` FROM `storage` WHERE `device_id`  = '30' AND `storage_type` != 'dsk' [] 0.74ms]
554.  
555.  
556. SQL[SELECT * FROM `storage` WHERE `device_id`  = '30' [] 0.55ms]
557.  
558. Modules status: Global+  
559. OS+  
560. Device  
561.  
562. hrDeviceEntry = No Such Object available on this agent at this OID  
563.  
564. hrProcessorEntry = No Such Object available on this agent at this OID  
565.  
566. array (
567. )  
568. SQL[SELECT * FROM `hrDevice` WHERE `device_id`  = '30' [] 0.82ms]
569.  
570. Modules status: Global+  
571. OS+  
572. Device  
573. cdpCache = No Such Object available on this agent at this OID  
574.  
575. lldpRemTable = No Such Object available on this agent at this OID  
576.  
577. SQL[SELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`=? [30] 0.81ms]
578.  
579.  
580. SQL[SELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [30] 1.11ms]
581.  
582. SQL[DELETE T FROM `links` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`local_device_id` WHERE `devices`.`device_id` IS NULL [] 0.52ms]
583.  
584.  0 orphaned links deleted  
585. Modules status: Global+  
586. OS+  
587. Device  
588. ipNetToPhysicalPhysAddress = No Such Object available on this agent at this OID  
589.  
590. ipNetToMediaPhysAddress = No Such Instance currently exists at this OID  
591.  
592. SQL[SELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [30,""] 1.35ms]
593.  
594. SQL[DELETE T FROM `ipv4_mac` T LEFT JOIN `ports` ON `ports`.`port_id` = T.`port_id` LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `ports`.`port_id` IS NULL AND `devices`.`device_id` IS NULL [] 1.44ms]
595.  
596. Modules status: Global-  
597. OS-  
598. Device  
599. Modules status: Global-  
600. OS-  
601. Device  
602. Modules status: Global+  
603. OS+  
604. Device  
605. "Tripp Lite"  
606.  
607. Peers :  
608. SQL[DELETE FROM `bgpPeers` WHERE device_id=? AND context_name=? [30,""] 0.57ms]
609.  
610. SQL[DELETE FROM `bgpPeers_cbgp` WHERE device_id=? AND context_name=? [30,""] 0.44ms]
611.  
612. SQL[SELECT DISTINCT context_name FROM bgpPeers WHERE device_id=? [30] 0.61ms]
613.  
614. Modules status: Global+  
615. OS+  
616. Device  
617. SQL[SELECT * FROM `vlans` WHERE `device_id` = ? [30] 0.55ms]
618.  
619. dot1dBasePortIfIndex = No Such Object available on this agent at this OID  
620.  
621. No Such Object available on this agent at this OID  
622.  
623. Modules status: Global-  
624. OS-  
625. Device  
626. Modules status: Global-  
627. OS-  
628. Device  
629. Modules status: Global-  
630. OS-  
631. Device  
632. Modules status: Global+  
633. OS+  
634. Device  
635. diskIOEntry = No Such Object available on this agent at this OID  
636.  
637. array (
638. )  
639. SQL[SELECT * FROM `ucd_diskio` where `device_id`  = '30' [] 0.65ms]
640.  
641. Modules status: Global-  
642. OS-  
643. Device  
644. Modules status: Global+  
645. OS+  
646. Device  
647. Modules status: Global+  
648. OS+  
649. Device  
650. SQL[SELECT * FROM `stp` WHERE `device_id` = ? [30] 0.53ms]
651.  
652. No Such Object available on this agent at this OID  
653.  
654. Modules status: Global+  
655. OS+  
656. Device  
657. Modules status: Global-  
658. OS-  
659. Device  
660. Modules status: Global-  
661. OS-  
662. Device  
663. Modules status: Global+  
664. OS+  
665. Device  
666. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ap-count"] 0.95ms]
667.  
668. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"clients"] 0.64ms]
669.  
670. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"quality"] 0.67ms]
671.  
672. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"capacity"] 0.65ms]
673.  
674. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"utilization"] 0.65ms]
675.  
676. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rate"] 0.65ms]
677.  
678. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ccq"] 0.78ms]
679.  
680. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"snr"] 0.72ms]
681.  
682. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"sinr"] 0.7ms]
683.  
684. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rsrp"] 0.73ms]
685.  
686. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rsrq"] 0.7ms]
687.  
688. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ssr"] 0.7ms]
689.  
690. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"mse"] 0.7ms]
691.  
692. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"xpi"] 0.69ms]
693.  
694. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rssi"] 0.75ms]
695.  
696. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"power"] 0.68ms]
697.  
698. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"noise-floor"] 0.66ms]
699.  
700. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"errors"] 0.66ms]
701.  
702. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"error-ratio"] 0.59ms]
703.  
704. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"error-rate"] 0.67ms]
705.  
706. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"frequency"] 0.67ms]
707.  
708. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"distance"] 0.7ms]
709.  
710. Modules status: Global+  
711. OS+  
712. Device  
713. SQL[SELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = ? [30] 0.49ms]
714.  
715. SQL[SELECT * FROM `ports_fdb` WHERE `device_id` = ? [30] 0.53ms]
716.  
717. dot1qTpFdbPort = No Such Object available on this agent at this OID  
718.  
719. dot1dTpFdbPort = No Such Object available on this agent at this OID  
720.  
721. Modules status: Global+  
722. OS+  
723. Device  
724. SQL[UPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [7.143,30] 1.43ms]
725.  
726. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"discover","doing":"tlups1","start":1577149261.115333,"duration":"7.682","devices":1,"poller":"librenms.int.dittman.net"} 0.92ms]
727.  
728. ./discovery.php tlups1 2019-12-23 19:01:08 - 1 devices discovered in 7.682 secs  
729. title:
730. name: librenms
731. private: 1
732. expire: 0
733. https://p.libren.ms/view/8265e217
734.