1. librenms@librenms:~$ ./discovery.php -h 192.168.17.231 -d | ./pbin.sh
2. Paste endpoint: https://p.libren.ms/api/create
3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 6.06ms]
4.  
5. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.49ms]
6.  
7. SQL[SELECT version() [] 0.3ms]
8.  
9. Updating os_def.cache...
10. Done
11. SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE '192.168.17.231' ORDER BY device_id DESC [] 1.5ms]
12.  
13. ./discovery.php 192.168.17.231 2019-08-14 13:23:23 - 0 devices discovered in 0.588 secs
14. title:
15. name: librenms
16. private: 1
17. expire: 0
18. https://p.libren.ms/view/b87b6939
19. librenms@librenms:~$ ./discovery.php -h 192.168.17.232 -d | ./pbin.sh
20. Paste endpoint: https://p.libren.ms/api/create
21. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.73ms]
22.  
23. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.45ms]
24.  
25. SQL[SELECT version() [] 0.3ms]
26.  
27. Updating os_def.cache...
28. Done
29. SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE '192.168.17.232' ORDER BY device_id DESC [] 7.15ms]
30.  
31. ./discovery.php 192.168.17.232 2019-08-14 13:24:29 - 0 devices discovered in 0.409 secs
32. title:
33. name: librenms
34. private: 1
35. expire: 0
36. https://p.libren.ms/view/d1a456de
37. librenms@librenms:~$ ./discovery.php -h 192.168.17.232 -d
38. LibreNMS Discovery
39. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.59ms]
40.  
41. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.59ms]
42.  
43. SQL[SELECT version() [] 0.3ms]
44.  
45. ===================================
46. Version info:
47. Commit SHA: c14fd96bb473cd18ef696a870abf2b54f6e55bb7
48. Commit Date: 1564368454
49. DB Schema: 2019_07_03_132417_create_mpls_saps_table (139)
50. PHP: 7.2.15-0ubuntu0.18.04.2
51. MySQL: 10.1.38-MariaDB-0ubuntu0.18.04.1
52. RRDTool: 1.7.0
53. SNMP: NET-SNMP 5.7.3
54. ==================================DEBUG!
55. Updating os_def.cache...
56. Done
57. SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE '192.168.17.232' ORDER BY device_id DESC [] 1.36ms]
58.  
59. ./discovery.php 192.168.17.232 2019-08-14 13:24:38 - 0 devices discovered in 0.379 secs
60. MySQL [1/0.00s]: Cell[1/0.00s] Row[-1/-0.00s] Rows[1/0.00s] Column[0/0.00s] Update[0/0.00s] Insert[0/0.00s] Delete[0/0.00s]
61. librenms@librenms:~$ ./discovery.php -h 192.168.17.243 -d | ./pbin.sh
62. Paste endpoint: https://p.libren.ms/api/create
63. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 1.1ms]
64.  
65. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.75ms]
66.  
67. SQL[SELECT version() [] 0.64ms]
68.  
69. Updating os_def.cache...
70. Done
71. SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE '192.168.17.243' ORDER BY device_id DESC [] 3.6ms]
72.  
73. SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [54] 0.84ms]
74.  
75. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 192.168.17.243
76. array (
77.   'xmt' => '3',
78.   'rcv' => '3',
79.   'loss' => '0',
80.   'min' => '0.53',
81.   'max' => '0.64',
82.   'avg' => '0.59',
83.   'exitcode' => 0,
84. )
85. 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":"0.53","max":"0.64","avg":"0.59","device_id":54,"debug":"[]"} 79.44ms]
86.  
87. SNMP Check response code: 0
88. Netman 204
89.  
90. .*.4.1.5491.0
91.  
92. | Netman 204 | .1.3.6.1.4.1.5491.0 |
93. No Such Object available on this agent at this OID
94.  
95. No Such Object available on this agent at this OID
96.  
97. No Such Object available on this agent at this OID
98.  
99. No Such Object available on this agent at this OID
100.  
101. No Such Object available on this agent at this OID
102.  
103. No Such Object available on this agent at this OID
104.  
105. SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [54,"poll_mib"] 1.27ms]
106.  
107. Attempting to initialize OS: generic
108. OS initialized: LibreNMS\OS\Generic
109. Modules status: Global+
110. OS
111. Device
112. .*.*.0 = UPS 1
113. .*.*.0 = .*.4.1.5491.0
114. .*.*.0 = Netman 204
115.  
116. Modules status: Global+
117. OS+
118. Device
119. Netman 204
120.  
121. .*.4.1.5491.0
122.  
123. | Netman 204 | .1.3.6.1.4.1.5491.0 |
124. No Such Object available on this agent at this OID
125.  
126. No Such Object available on this agent at this OID
127.  
128. No Such Object available on this agent at this OID
129.  
130. No Such Object available on this agent at this OID
131.  
132. No Such Object available on this agent at this OID
133.  
134. No Such Object available on this agent at this OID
135.  
136. Modules status: Global+
137. OS+
138. Device
139. ifDescr.1 = Loopback Interface
140. ifDescr.2 = RPS Wired Network
141.  
142. ifName = No Such Object available on this agent at this OID
143.  
144. ifAlias = No Such Object available on this agent at this OID
145.  
146. ifType.1 = softwareLoopback
147. ifType.2 = ethernetCsmacd
148.  
149. array (
150.   1 =>
151.   array (
152.     'ifDescr' => 'Loopback Interface',
153.     'ifType' => 'softwareLoopback',
154.   ),
155.   2 =>
156.   array (
157.     'ifDescr' => 'RPS Wired Network',
158.     'ifType' => 'ethernetCsmacd',
159.   ),
160. )
161. SQL[SELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [54] 1.94ms]
162.  
163.  Using ifDescr as ifAlias
164.  Using ifDescr as ifName
165. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["Loopback Interface","softwareLoopback",1,"Loopback Interface","Loopback Interface",5999] 120.89ms]
166.  
167.  Using ifDescr as ifAlias
168.  Using ifDescr as ifName
169. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["RPS Wired Network","ethernetCsmacd",2,"RPS Wired Network","RPS Wired Network",6000] 107.72ms]
170.  
171. Modules status: Global+
172. OS+
173. Device
174. SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '54' [] 0.83ms]
175.  
176. ifStackStatus = No Such Object available on this agent at this OID
177.  
178. Modules status: Global+
179. OS+
180. Device
181. entPhysicalEntry = No Such Object available on this agent at this OID
182.  
183. SQL[SELECT * FROM `entPhysical` WHERE `device_id` = ? [54] 0.86ms]
184.  
185. Modules status: Global-
186. OS-
187. Device
188. Modules status: Global+
189. OS+
190. Device
191. No YAML Discovery data.
192. hrProcessorLoad = No Such Object available on this agent at this OID
193.  
194. SQL[SELECT `devices`.*, `location`, `lat`, `lng` FROM `devices` LEFT JOIN locations ON `devices`.location_id=`locations`.`id` WHERE `device_id` = ? [54] 1.15ms]
195.  
196. SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [54] 0.57ms]
197.  
198. SQL[SELECT * FROM `vrf_lite_cisco` WHERE `device_id` = ? [54] 0.55ms]
199.  
200. No Such Object available on this agent at this OID
201.  
202. SQL[SELECT * FROM `processors` WHERE `device_id`=? [54] 0.88ms]
203.  
204. SQL[DELETE T FROM `processors` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `devices`.`device_id` IS NULL [] 1.66ms]
205.  
206. Modules status: Global+
207. OS+
208. Device
209. SQL[SELECT COUNT(*) FROM `mempools` WHERE `device_id` = ? AND `mempool_type` = 'cemp' [54] 0.45ms]
210.  
211. dellNetCpuUtilTable = No Such Object available on this agent at this OID
212.  
213. dellNetProcessorEntry = No Such Object available on this agent at this OID
214.  
215. hpLocalMem = No Such Object available on this agent at this OID
216.  
217. hpGlobalMem = No Such Object available on this agent at this OID
218.  
219. hrStorageEntry = No Such Object available on this agent at this OID
220.  
221.  
222. SQL[SELECT * FROM `mempools` WHERE `device_id`  = '54' [] 4.14ms]
223.  
224. Modules status: Global+
225. OS+
226. Device
227. SQL[SELECT * FROM vrf_lite_cisco WHERE device_id = ?  [54] 0.45ms]
228.  
229. Modules status: Global-
230. OS-
231. Device
232. Modules status: Global-
233. OS-
234. Device
235. Modules status: Global-
236. OS-
237. Device
238. Modules status: Global-
239. OS-
240. Device
241. Modules status: Global-
242. OS-
243. Device
244. Modules status: Global-
245. OS-
246. Device
247. Modules status: Global-
248. OS-
249. Device
250. Modules status: Global+
251. OS+
252. Device
253. ipAdEntIfIndex.* 1
254. ipAdEntIfIndex.* 2
255.  
256. *
257.  
258. SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [54,"1"] 0.75ms]
259.  
260. SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [54,"1"] 0.41ms]
261.  
262. SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? ["127.0.0.0\/8"] 0.49ms]
263.  
264. SQL[UPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [null,"127.0.0.0\/8"] 1421.43ms]
265.  
266. SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? ["127.0.0.0\/8"] 0.68ms]
267.  
268. SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ?  ["127.0.0.1",8,5999] 0.76ms]
269.  
270. SQL[UPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [null,"127.0.0.1",8,5999] 1446.85ms]
271.  
272. *
273.  
274. SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [54,"2"] 5.22ms]
275.  
276. SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [54,"2"] 6.1ms]
277.  
278. SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? ["192.168.17.0\/24"] 0.55ms]
279.  
280. SQL[UPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [null,"192.168.17.0\/24"] 590.71ms]
281.  
282. SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? ["192.168.17.0\/24"] 0.95ms]
283.  
284. SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ?  ["192.168.17.243",24,6000] 0.96ms]
285.  
286. SQL[UPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [null,"192.168.17.243",24,6000] 222.3ms]
287.  
288. 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 [54] 2.26ms]
289.  
290. Modules status: Global+
291. OS+
292. Device
293. ipAddressIfIndex.ipv6 No Such Object available on this agent at this OID
294.  
295. .*.*.8.1.2 No Such Object available on this agent at this OID
296.  
297. 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 [54] 1.05ms]
298.  
299. Modules status: Global-
300. OS-
301. Device
302. Modules status: Global+
303. OS+
304. Device
305. entPhysicalDescr = No Such Object available on this agent at this OID
306.  
307. SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [54,"ipmi_hostname"] 0.77ms]
308.  
309. 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",54,"ipmi"] 1.11ms]
310.  
311. 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",54,"ipmi"] 0.98ms]
312.  
313. 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",54,"ipmi"] 0.97ms]
314.  
315. 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",54,"ipmi"] 0.94ms]
316.  
317.  
318. 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",54,"snmp"] 1.2ms]
319.  
320.  
321. 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",54,"snmp"] 0.93ms]
322.  
323.  
324. 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",54,"snmp"] 0.92ms]
325.  
326.  
327. 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",54,"snmp"] 0.93ms]
328.  
329.  
330. 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",54,"snmp"] 0.93ms]
331.  
332.  
333. 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",54,"snmp"] 0.94ms]
334.  
335.  
336. 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",54,"snmp"] 1.4ms]
337.  
338.  
339. 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",54,"snmp"] 2.21ms]
340.  
341.  
342. 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",54,"snmp"] 0.98ms]
343.  
344.  
345. 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",54,"snmp"] 0.95ms]
346.  
347.  
348. 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",54,"snmp"] 0.96ms]
349.  
350.  
351. 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",54,"snmp"] 0.94ms]
352.  
353.  
354. 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",54,"snmp"] 0.94ms]
355.  
356.  
357. 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",54,"snmp"] 0.92ms]
358.  
359.  
360. 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",54,"snmp"] 2.87ms]
361.  
362.  
363. 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",54,"snmp"] 0.97ms]
364.  
365.  
366. 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",54,"snmp"] 0.97ms]
367.  
368.  
369. 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",54,"snmp"] 0.96ms]
370.  
371.  
372. 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",54,"snmp"] 0.97ms]
373.  
374.  
375. 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",54,"snmp"] 1.14ms]
376.  
377.  
378. 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",54,"snmp"] 3.1ms]
379.  
380.  
381. 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",54,"snmp"] 0.96ms]
382.  
383.  
384. 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",54,"snmp"] 0.97ms]
385.  
386.  
387. 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",54,"snmp"] 0.95ms]
388.  
389.  
390. 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",54,"snmp"] 0.95ms]
391.  
392.  
393. 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",54,"snmp"] 6.48ms]
394.  
395. Modules status: Global+
396. OS+
397. Device
398. fileSystemSpaceTable = No Such Object available on this agent at this OID
399.  
400. hrStorageEntry = No Such Object available on this agent at this OID
401.  
402. dskTable = No Such Object available on this agent at this OID
403.  
404. SQL[SELECT `storage_descr` FROM `storage` WHERE `device_id`  = '54' AND `storage_type` != 'dsk' [] 0.77ms]
405.  
406.  
407. SQL[SELECT * FROM `storage` WHERE `device_id`  = '54' [] 4.22ms]
408.  
409. Modules status: Global+
410. OS+
411. Device
412.  
413. hrDeviceEntry = No Such Object available on this agent at this OID
414.  
415. hrProcessorEntry = No Such Object available on this agent at this OID
416.  
417. array (
418. )
419. SQL[SELECT * FROM `hrDevice` WHERE `device_id`  = '54' [] 0.71ms]
420.  
421. Modules status: Global+
422. OS+
423. Device
424. cdpCache = No Such Object available on this agent at this OID
425.  
426. lldpRemTable = No Such Object available on this agent at this OID
427.  
428. SQL[SELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`=? [54] 1.11ms]
429.  
430.  
431. SQL[SELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [54] 4.56ms]
432.  
433. SQL[DELETE T FROM `links` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`local_device_id` WHERE `devices`.`device_id` IS NULL [] 5.72ms]
434.  
435.  0 orphaned links deleted
436. Modules status: Global+
437. OS+
438. Device
439. ipNetToPhysicalPhysAddress = No Such Object available on this agent at this OID
440.  
441. ipNetToMediaPhysAddress[2][*] = 30:30:3a:30:32:3a:63:39:3a:30:66:3a:30:38:3a:31:61
442. ipNetToMediaPhysAddress[2][*] = 35:32:3a:35:34:3a:30:30:3a:63:63:3a:30:39:3a:62:66
443. ipNetToMediaPhysAddress[2][*] = 30:30:3a:31:30:3a:64:62:3a:63:32:3a:65:64:3a:38:37
444.  
445. SQL[SELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [54,""] 1.71ms]
446.  
447. SQL[SELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [54,2] 1.05ms]
448.  
449. Changed mac address for 192.168.17.60 from 30303a30323a63393a30663a30383a31 to 30303a30323a63393a30663a30383a3161
450. SQL[INSERT IGNORE INTO `eventlog` (`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES (:device_id,:reference,:type,:datetime,:severity,:message,:username) {"device_id":54,"reference":6000,"type":"interface","datetime":"2019-08-14 13:31:00","severity":4,"message":"MAC change: 192.168.17.60 : 30:30:3a:30:32:3a:63:39:3a:30:66:3a:30:38:3a:31 -> 30:30:3a:30:32:3a:63:39:3a:30:66:3a:30:38:3a:31:61","username":""} 116.99ms]
451.  
452. SQL[UPDATE `ipv4_mac` set `mac_address`=? WHERE port_id=? AND ipv4_address=? AND context_name=? ["30303a30323a63393a30663a30383a3161",6000,"192.168.17.60",""] 141.48ms]
453.  
454. 30:30:3a:30:32:3a:63:39:3a:30:66:3a:30:38:3a:31:61 => 192.168.17.60
455. Changed mac address for 192.168.17.90 from 35323a35343a30303a63633a30393a62 to 35323a35343a30303a63633a30393a6266
456. SQL[INSERT IGNORE INTO `eventlog` (`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES (:device_id,:reference,:type,:datetime,:severity,:message,:username) {"device_id":54,"reference":6000,"type":"interface","datetime":"2019-08-14 13:31:00","severity":4,"message":"MAC change: 192.168.17.90 : 35:32:3a:35:34:3a:30:30:3a:63:63:3a:30:39:3a:62 -> 35:32:3a:35:34:3a:30:30:3a:63:63:3a:30:39:3a:62:66","username":""} 115.89ms]
457.  
458. SQL[UPDATE `ipv4_mac` set `mac_address`=? WHERE port_id=? AND ipv4_address=? AND context_name=? ["35323a35343a30303a63633a30393a6266",6000,"192.168.17.90",""] 116.18ms]
459.  
460. 35:32:3a:35:34:3a:30:30:3a:63:63:3a:30:39:3a:62:66 => 192.168.17.90
461. Changed mac address for 192.168.17.254 from 30303a31303a64623a63323a65643a38 to 30303a31303a64623a63323a65643a3837
462. SQL[INSERT IGNORE INTO `eventlog` (`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES (:device_id,:reference,:type,:datetime,:severity,:message,:username) {"device_id":54,"reference":6000,"type":"interface","datetime":"2019-08-14 13:31:00","severity":4,"message":"MAC change: 192.168.17.254 : 30:30:3a:31:30:3a:64:62:3a:63:32:3a:65:64:3a:38 -> 30:30:3a:31:30:3a:64:62:3a:63:32:3a:65:64:3a:38:37","username":""} 116.52ms]
463.  
464. SQL[UPDATE `ipv4_mac` set `mac_address`=? WHERE port_id=? AND ipv4_address=? AND context_name=? ["30303a31303a64623a63323a65643a3837",6000,"192.168.17.254",""] 124.24ms]
465.  
466. 30:30:3a:31:30:3a:64:62:3a:63:32:3a:65:64:3a:38:37 => 192.168.17.254
467. SQL[DELETE FROM `ipv4_mac` WHERE `port_id` = ? AND `mac_address`=? AND `ipv4_address`=? AND `context_name`=? [6000,"30303a30323a63393a30663a30383a31","192.168.17.60",""] 233.3ms]
468.  
469.  
470. SQL[DELETE FROM `ipv4_mac` WHERE `port_id` = ? AND `mac_address`=? AND `ipv4_address`=? AND `context_name`=? [6000,"35323a35343a30303a63633a30393a62","192.168.17.90",""] 99.53ms]
471.  
472.  
473. SQL[DELETE FROM `ipv4_mac` WHERE `port_id` = ? AND `mac_address`=? AND `ipv4_address`=? AND `context_name`=? [6000,"30303a31303a64623a63323a65643a38","192.168.17.254",""] 100.27ms]
474.  
475.  
476. 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 [] 3.09ms]
477.  
478. Modules status: Global+
479. OS+
480. Device
481. SQL[
482.     SELECT *
483.     FROM ipv4_mac as m, ports as i
484.     WHERE m.port_id = i.port_id
485.     AND i.device_id = ?
486.     AND i.deleted = 0
487.     AND NOT EXISTS (
488.         SELECT * FROM ipv4_addresses a
489.         WHERE a.ipv4_address = m.ipv4_address
490.     )
491.     GROUP BY ipv4_address
492.     ORDER BY ipv4_address
493.      [54] 3.57ms]
494.  
495. Modules status: Global-
496. OS-
497. Device
498. Modules status: Global+
499. OS+
500. Device
501. "RPS SpA"
502.  
503. Peers :
504. SQL[DELETE FROM `bgpPeers` WHERE device_id=? AND context_name=? [54,""] 0.96ms]
505.  
506. SQL[DELETE FROM `bgpPeers_cbgp` WHERE device_id=? AND context_name=? [54,""] 0.59ms]
507.  
508. SQL[SELECT DISTINCT context_name FROM bgpPeers WHERE device_id=? [54] 9.33ms]
509.  
510. Modules status: Global+
511. OS+
512. Device
513. SQL[SELECT * FROM `vlans` WHERE `device_id` = ? [54] 0.68ms]
514.  
515. dot1dBasePortIfIndex = No Such Object available on this agent at this OID
516.  
517. No Such Object available on this agent at this OID
518.  
519. Modules status: Global-
520. OS-
521. Device
522. Modules status: Global-
523. OS-
524. Device
525. Modules status: Global-
526. OS-
527. Device
528. Modules status: Global+
529. OS+
530. Device
531. diskIOEntry = No Such Object available on this agent at this OID
532.  
533. array (
534. )
535. SQL[SELECT * FROM `ucd_diskio` where `device_id`  = '54' [] 0.97ms]
536.  
537. Modules status: Global-
538. OS-
539. Device
540. Modules status: Global+
541. OS+
542. Device
543. Modules status: Global+
544. OS+
545. Device
546. SQL[SELECT * FROM `stp` WHERE `device_id` = ? [54] 0.91ms]
547.  
548. No Such Object available on this agent at this OID
549.  
550. Modules status: Global+
551. OS+
552. Device
553. Modules status: Global-
554. OS-
555. Device
556. Modules status: Global-
557. OS-
558. Device
559. Modules status: Global+
560. OS+
561. Device
562. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"ap-count"] 5.94ms]
563.  
564. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"clients"] 7.04ms]
565.  
566. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"quality"] 0.67ms]
567.  
568. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"capacity"] 2.61ms]
569.  
570. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"utilization"] 1.32ms]
571.  
572. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"rate"] 5.91ms]
573.  
574. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"ccq"] 8.07ms]
575.  
576. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"snr"] 7.19ms]
577.  
578. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"ssr"] 2.78ms]
579.  
580. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"mse"] 4.03ms]
581.  
582. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"xpi"] 0.68ms]
583.  
584. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"rssi"] 5.59ms]
585.  
586. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"power"] 8.24ms]
587.  
588. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"noise-floor"] 0.67ms]
589.  
590. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"errors"] 6.47ms]
591.  
592. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"error-ratio"] 3.49ms]
593.  
594. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"error-rate"] 7.76ms]
595.  
596. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"frequency"] 7.64ms]
597.  
598. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [54,"distance"] 0.9ms]
599.  
600. Modules status: Global+
601. OS+
602. Device
603. SQL[SELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = ? [54] 11.71ms]
604.  
605. SQL[SELECT * FROM `ports_fdb` WHERE `device_id` = ? [54] 0.63ms]
606.  
607. dot1qTpFdbPort = No Such Object available on this agent at this OID
608.  
609. dot1dTpFdbPort = No Such Object available on this agent at this OID
610.  
611. Modules status: Global+
612. OS+
613. Device
614. SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [54,"poll_mib"] 4.59ms]
615.  
616. SQL[UPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [20.81,54] 68.34ms]
617.  
618. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"discover","doing":"192.168.17.243","start":1565789441.170568,"duration":"21.28","devices":1,"poller":"librenms"} 124.25ms]
619.  
620. ./discovery.php 192.168.17.243 2019-08-14 13:31:02 - 1 devices discovered in 21.28 secs
621. title:
622. name: librenms
623. private: 1
624. expire: 0
625. https://p.libren.ms/view/a0650f26