riello netman 204 output

From bobofly, 4 Years ago, written in Plain Text.
URL https://p.libren.ms/view/e60a862b
Embed
Download Paste or View Raw
  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


Reply to "riello netman 204 output"