From librenms, 5 Months ago, written in Plain Text.
Embed
  1. LibreNMS Discovery
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 1.96ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 2.13ms]
  5.  
  6. SQL[[1;33mselect version() [0;33m[][0m 2.2ms]
  7.  
  8. ===========================================
  9. Component | Version
  10. --------- | -------
  11. LibreNMS  | 23.11.0-14-g13c934ab0 (2023-12-01T23:34:21+00:00)
  12. DB Schema | 2023_11_21_172239_increase_vminfo.vmwvmguestos_column_length (274)
  13. PHP       | 8.1.26
  14. Python    | 3.9.2
  15. Database  | MariaDB 10.11.5-MariaDB-log
  16. RRDTool   | 1.7.2
  17. SNMP      | 5.9
  18. ===========================================
  19. DEBUG!
  20. Updating os_def.cache  
  21. SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND `hostname` LIKE '192.168.2.1' ORDER BY device_id DESC [0;33m[][0m 4.4ms]
  22.  
  23. 192.168.2.1 62 draytek SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[62][0m 4.68ms]
  24.  
  25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[62][0m 2.33ms]
  26.  
  27. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '1000' '-O' '0' '192.168.2.1'
  28.  
  29. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.616/2.17/5.22  
  30. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '5' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
  31. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.7367
  32.  
  33.  
  34. Modules status: Global+  
  35. OS  
  36. Device  
  37.  
  38. #### Load disco module core ####
  39. Attempting to initialize OS: draytek  
  40. OS initialized as Generic (draytek)  
  41. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-On' '-t' '5' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysName.0'[0m]  
  42. .*.*.0 = .*.4.1.7367
  43. .*.*.0 = DrayTek Corporation, Router Model: Vigor167, Version: 5.2.3, Build Date/Time: Wed Oct 25 11:46:58 CST 2023
  44. .*.*.0 = Hercules
  45.  
  46.  
  47. | DrayTek Corporation, Router Model: Vigor167, Version: 5.2.3, Build Date/Time: Wed Oct 25 11:46:58 CST 2023 | .1.3.6.1.4.1.7367 |
  48.  
  49. OS: DrayTek (draytek)
  50.  
  51. Attempting to initialize OS: draytek  
  52. OS initialized as Generic (draytek)  
  53.  
  54. >> Runtime for discovery module 'core': 0.2590 seconds with 20632 bytes
  55. >> [0;36mSNMP[0m: [1/0.20s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s]  
  56. #### Unload disco module core ####
  57.  
  58. Modules status: Global+  
  59. OS  
  60. Device  
  61.  
  62. #### Load disco module os ####
  63. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[2][0m 2.28ms]
  64.  
  65. ::query() failed: DNS request failed: The domain name referenced in the query does not exist.  
  66. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Ovq' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'sysContact.0'[0m]
  67. https://www.draytek.com/about/contact-us  
  68.  
  69. Yaml OS data:  
  70. Location: Lounge
  71. Hardware: Vigor167
  72. OS Version: 5.2.3
  73. OS Features:
  74. Serial:
  75.  
  76. >> Runtime for discovery module 'os': 0.2080 seconds with 553224 bytes
  77. >> [0;36mSNMP[0m: [2/0.17s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s]  
  78. #### Unload disco module os ####
  79.  
  80. Modules status: Global+  
  81. OS  
  82. Device  
  83.  
  84. #### Load disco module ports ####
  85. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ifDescr'[0m]
  86. ifDescr.1 = lo
  87. ifDescr.2 = ip_vti0
  88. ifDescr.3 = sit0
  89. ifDescr.4 = ip6tnl0
  90. ifDescr.5 = lan_int2_if
  91. ifDescr.6 = eth0
  92. ifDescr.7 = eth0.1
  93. ifDescr.8 = eth0.2
  94. ifDescr.10 = br0
  95. ifDescr.11 = wan_int2_if
  96. ifDescr.12 = ptm0
  97. ifDescr.13 = ptm1  
  98.  
  99. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ifName'[0m]
  100. ifName.1 = lo
  101. ifName.2 = ip_vti0
  102. ifName.3 = sit0
  103. ifName.4 = ip6tnl0
  104. ifName.5 = lan_int2_if
  105. ifName.6 = eth0
  106. ifName.7 = eth0.1
  107. ifName.8 = eth0.2
  108. ifName.10 = br0
  109. ifName.11 = wan_int2_if
  110. ifName.12 = ptm0
  111. ifName.13 = ptm1  
  112.  
  113. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ifAlias'[0m]
  114. ifAlias.1 =
  115. ifAlias.2 =
  116. ifAlias.3 =
  117. ifAlias.4 =
  118. ifAlias.5 =
  119. ifAlias.6 =
  120. ifAlias.7 =
  121. ifAlias.8 =
  122. ifAlias.10 =
  123. ifAlias.11 =
  124. ifAlias.12 =
  125. ifAlias.13 =  
  126.  
  127. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ifType'[0m]
  128. ifType.1 = softwareLoopback
  129. ifType.2 = tunnel
  130. ifType.3 = tunnel
  131. ifType.4 = tunnel
  132. ifType.5 = ethernetCsmacd
  133. ifType.6 = ethernetCsmacd
  134. ifType.7 = ethernetCsmacd
  135. ifType.8 = ethernetCsmacd
  136. ifType.10 = ethernetCsmacd
  137. ifType.11 = ethernetCsmacd
  138. ifType.12 = ethernetCsmacd
  139. ifType.13 = ethernetCsmacd  
  140.  
  141. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ifOperStatus'[0m]
  142. ifOperStatus.1 = up
  143. ifOperStatus.2 = down
  144. ifOperStatus.3 = down
  145. ifOperStatus.4 = down
  146. ifOperStatus.5 = down
  147. ifOperStatus.6 = up
  148. ifOperStatus.7 = up
  149. ifOperStatus.8 = up
  150. ifOperStatus.10 = up
  151. ifOperStatus.11 = down
  152. ifOperStatus.12 = up
  153. ifOperStatus.13 = down  
  154.  
  155. array (
  156.   1 =>
  157.   array (
  158.     'ifDescr' => 'lo',
  159.     'ifName' => 'lo',
  160.     'ifAlias' => '',
  161.     'ifType' => 'softwareLoopback',
  162.     'ifOperStatus' => 'up',
  163.   ),
  164.   2 =>
  165.   array (
  166.     'ifDescr' => 'ip_vti0',
  167.     'ifName' => 'ip_vti0',
  168.     'ifAlias' => '',
  169.     'ifType' => 'tunnel',
  170.     'ifOperStatus' => 'down',
  171.   ),
  172.   3 =>
  173.   array (
  174.     'ifDescr' => 'sit0',
  175.     'ifName' => 'sit0',
  176.     'ifAlias' => '',
  177.     'ifType' => 'tunnel',
  178.     'ifOperStatus' => 'down',
  179.   ),
  180.   4 =>
  181.   array (
  182.     'ifDescr' => 'ip6tnl0',
  183.     'ifName' => 'ip6tnl0',
  184.     'ifAlias' => '',
  185.     'ifType' => 'tunnel',
  186.     'ifOperStatus' => 'down',
  187.   ),
  188.   5 =>
  189.   array (
  190.     'ifDescr' => 'lan_int2_if',
  191.     'ifName' => 'lan_int2_if',
  192.     'ifAlias' => '',
  193.     'ifType' => 'ethernetCsmacd',
  194.     'ifOperStatus' => 'down',
  195.   ),
  196.   6 =>
  197.   array (
  198.     'ifDescr' => 'eth0',
  199.     'ifName' => 'eth0',
  200.     'ifAlias' => '',
  201.     'ifType' => 'ethernetCsmacd',
  202.     'ifOperStatus' => 'up',
  203.   ),
  204.   7 =>
  205.   array (
  206.     'ifDescr' => 'eth0.1',
  207.     'ifName' => 'eth0.1',
  208.     'ifAlias' => '',
  209.     'ifType' => 'ethernetCsmacd',
  210.     'ifOperStatus' => 'up',
  211.   ),
  212.   8 =>
  213.   array (
  214.     'ifDescr' => 'eth0.2',
  215.     'ifName' => 'eth0.2',
  216.     'ifAlias' => '',
  217.     'ifType' => 'ethernetCsmacd',
  218.     'ifOperStatus' => 'up',
  219.   ),
  220.   10 =>
  221.   array (
  222.     'ifDescr' => 'br0',
  223.     'ifName' => 'br0',
  224.     'ifAlias' => '',
  225.     'ifType' => 'ethernetCsmacd',
  226.     'ifOperStatus' => 'up',
  227.   ),
  228.   11 =>
  229.   array (
  230.     'ifDescr' => 'wan_int2_if',
  231.     'ifName' => 'wan_int2_if',
  232.     'ifAlias' => '',
  233.     'ifType' => 'ethernetCsmacd',
  234.     'ifOperStatus' => 'down',
  235.   ),
  236.   12 =>
  237.   array (
  238.     'ifDescr' => 'ptm0',
  239.     'ifName' => 'ptm0',
  240.     'ifAlias' => '',
  241.     'ifType' => 'ethernetCsmacd',
  242.     'ifOperStatus' => 'up',
  243.   ),
  244.   13 =>
  245.   array (
  246.     'ifDescr' => 'ptm1',
  247.     'ifName' => 'ptm1',
  248.     'ifAlias' => '',
  249.     'ifType' => 'ethernetCsmacd',
  250.     'ifOperStatus' => 'down',
  251.   ),
  252. )  
  253. SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [0;33m[62][0m 4.35ms]
  254.  
  255.  Using ifDescr as ifAlias  
  256. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["lo","lo","lo","softwareLoopback","up",1,1611426][0m 2.41ms]
  257.  
  258. . Using ifDescr as ifAlias  
  259. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["ip_vti0","ip_vti0","ip_vti0","tunnel","down",2,1611427][0m 2.32ms]
  260.  
  261. . Using ifDescr as ifAlias  
  262. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["sit0","sit0","sit0","tunnel","down",3,1611428][0m 2.33ms]
  263.  
  264. . Using ifDescr as ifAlias  
  265. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["ip6tnl0","ip6tnl0","ip6tnl0","tunnel","down",4,1611429][0m 2.31ms]
  266.  
  267. . Using ifDescr as ifAlias  
  268. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["lan_int2_if","lan_int2_if","lan_int2_if","ethernetCsmacd","down",5,1611430][0m 2.45ms]
  269.  
  270. . Using ifDescr as ifAlias  
  271. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["eth0","eth0","eth0","ethernetCsmacd","up",6,1611431][0m 2.15ms]
  272.  
  273. . Using ifDescr as ifAlias  
  274. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["eth0.1","eth0.1","eth0.1","ethernetCsmacd","up",7,1611432][0m 2.34ms]
  275.  
  276. . Using ifDescr as ifAlias  
  277. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["eth0.2","eth0.2","eth0.2","ethernetCsmacd","up",8,1611433][0m 2.22ms]
  278.  
  279. . Using ifDescr as ifAlias  
  280. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["br0","br0","br0","ethernetCsmacd","up",10,1611434][0m 2.32ms]
  281.  
  282. . Using ifDescr as ifAlias  
  283. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["wan_int2_if","wan_int2_if","wan_int2_if","ethernetCsmacd","down",11,1611435][0m 2.42ms]
  284.  
  285. . Using ifDescr as ifAlias  
  286. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["ptm0","ptm0","ptm0","ethernetCsmacd","up",12,1611436][0m 2.57ms]
  287.  
  288. . Using ifDescr as ifAlias  
  289. SQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifName`=?,`ifAlias`=?,`ifType`=?,`ifOperStatus`=?,`ifIndex`=? WHERE `port_id` = ? [0;33m["ptm1","ptm1","ptm1","ethernetCsmacd","down",13,1611437][0m 2.35ms]
  290.  
  291. .
  292.  
  293. >> Runtime for discovery module 'ports': 1.0190 seconds with 44688 bytes
  294. >> [0;36mSNMP[0m: [5/0.96s] [1;33mMySQL[0m: [13/0.33s] [0;32mRRD[0m: [0/0.00s]  
  295. #### Unload disco module ports ####
  296.  
  297. Modules status: Global+  
  298. OS  
  299. Device  
  300.  
  301. #### Load disco module ports-stack ####
  302. SQL[[1;33mSELECT * FROM `ports_stack` WHERE `device_id` = '62' [0;33m[][0m 2.16ms]
  303.  
  304. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ifStackStatus'[0m]
  305. ifStackStatus = No Such Object available on this agent at this OID  
  306.  
  307.  
  308.  
  309. >> Runtime for discovery module 'ports-stack': 0.1880 seconds with 1648 bytes
  310. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s]  
  311. #### Unload disco module ports-stack ####
  312.  
  313. Modules status: Global-  
  314. OS+  
  315. Device  
  316.  
  317. #### Load disco module xdsl ####
  318. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-Os' '-t' '5' 'udp:HOSTNAME:161' 'ADSL-LINE-MIB::adslMibObjects'[0m]  
  319. adslLineCoding[0] = 2
  320. adslLineType[0] = 4
  321. adslLineSpecific[0] = zeroDotZero
  322. adslLineConfProfile[0] = VDSL2
  323. adslLineAlarmConfProfile[0] = DEFVAL
  324. adslAtucInvSerialNumber[0] = ................
  325. adslAtucInvVendorID[0] = b5004946 544eb206
  326. adslAtucInvVersionNumber[0] = ................
  327. adslAtucCurrSnrMgn[0] = 7
  328. adslAtucCurrAtn[0] = 17
  329. adslAtucCurrStatus[0] = "53 48 4F 57 54 49 4D 45 "
  330. adslAtucCurrOutputPwr[0] = 0
  331. adslAtucCurrAttainableRate[0] = 65199104
  332. adslAturInvSerialNumber[0] = 225004688011
  333. adslAturInvVendorID[0] = fe004452 41590000
  334. adslAturInvVersionNumber[0] = *_B_A60901
  335. adslAturCurrSnrMgn[0] = 8
  336. adslAturCurrAtn[0] = 0
  337. adslAturCurrStatus[0] = "53 48 4F 57 54 49 4D 45 "
  338. adslAturCurrOutputPwr[0] = 0
  339. adslAturCurrAttainableRate[0] = 14042112
  340. adslAtucChanInterleaveDelay[0] = 0
  341. adslAtucChanCurrTxRate[0] = 33170432
  342. adslAtucChanPrevTxRate[0] = 0
  343. adslAtucChanCrcBlockLength[0] = 7027
  344. adslAturChanInterleaveDelay[0] = 0
  345. adslAturChanCurrTxRate[0] = 10233856
  346. adslAturChanPrevTxRate[0] = 0
  347. adslAturChanCrcBlockLength[0] = 1
  348.  
  349.  
  350. SQL[[1;33mselect `port_id`, `ifIndex` from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null [0;33m[62][0m 2.69ms]
  351.  
  352. SQL[[1;33mselect `ports_adsl`.*, `ports`.`device_id` as `laravel_through_key` from `ports_adsl` inner join `ports` on `ports`.`port_id` = `ports_adsl`.`port_id` where `ports`.`device_id` = ? [0;33m[62][0m 3.22ms]
  353.  
  354. [0;31mError discovering xdsl module for 192.168.2.1.[0m PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'ports_adsl_port_id_unique' in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:580
  355. Stack trace:
  356. #0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): PDOStatement->execute()
  357. #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(788): Illuminate\Database\Connection->Illuminate\Database\{closure}()
  358. #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(755): Illuminate\Database\Connection->runQueryCallback()
  359. #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): Illuminate\Database\Connection->run()
  360. #4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(533): Illuminate\Database\Connection->statement()
  361. #5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert()
  362. #6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3383): Illuminate\Database\Query\Processors\Processor->processInsertGetId()
  363. #7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1925): Illuminate\Database\Query\Builder->insertGetId()
  364. #8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1333): Illuminate\Database\Eloquent\Builder->__call()
  365. #9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1298): Illuminate\Database\Eloquent\Model->insertAndSetId()
  366. #10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1137): Illuminate\Database\Eloquent\Model->performInsert()
  367. #11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Collections/HigherOrderCollectionProxy.php(60): Illuminate\Database\Eloquent\Model->save()
  368. #12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php(236): Illuminate\Support\HigherOrderCollectionProxy->Illuminate\Support\{closure}()
  369. #13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Collections/HigherOrderCollectionProxy.php(61): Illuminate\Support\Collection->each()
  370. #14 /opt/librenms/LibreNMS/DB/SyncsModels.php(70): Illuminate\Support\HigherOrderCollectionProxy->__call()
  371. #15 /opt/librenms/LibreNMS/Modules/Xdsl.php(163): LibreNMS\Modules\Xdsl->syncModels()
  372. #16 /opt/librenms/LibreNMS/Modules/Xdsl.php(74): LibreNMS\Modules\Xdsl->pollAdsl()
  373. #17 /opt/librenms/includes/discovery/xdsl.inc.php(8): LibreNMS\Modules\Xdsl->discover()
  374. #18 /opt/librenms/includes/discovery/functions.inc.php(164): include('...')
  375. #19 /opt/librenms/discovery.php(108): discover_device()
  376. #20 {main}
  377.  
  378. Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'ports_adsl_port_id_unique' (Connection: mysql, SQL: insert into `ports_adsl` (`adslLineCoding`, `adslLineType`, `adslAtucInvVendorID`, `adslAtucInvVersionNumber`, `adslAtucCurrSnrMgn`, `adslAtucCurrAtn`, `adslAtucCurrOutputPwr`, `adslAtucCurrAttainableRate`, `adslAturInvSerialNumber`, `adslAturInvVendorID`, `adslAturInvVersionNumber`, `adslAturCurrSnrMgn`, `adslAturCurrAtn`, `adslAturCurrOutputPwr`, `adslAturCurrAttainableRate`, `adslAtucChanCurrTxRate`, `adslAturChanCurrTxRate`, `port_id`) values (2, 4, b5004946 544eb206, , 0.7, 1.7, 0, 65199104, 225004688011, fe004452 41590000, 5.12.18.17_B_A60901, 0.8, 0, 0, 14042112, 33170432, 10233856, 0)) in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:795
  379. Stack trace:
  380. #0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(755): Illuminate\Database\Connection->runQueryCallback()
  381. #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): Illuminate\Database\Connection->run()
  382. #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(533): Illuminate\Database\Connection->statement()
  383. #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert()
  384. #4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3383): Illuminate\Database\Query\Processors\Processor->processInsertGetId()
  385. #5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1925): Illuminate\Database\Query\Builder->insertGetId()
  386. #6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1333): Illuminate\Database\Eloquent\Builder->__call()
  387. #7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1298): Illuminate\Database\Eloquent\Model->insertAndSetId()
  388. #8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1137): Illuminate\Database\Eloquent\Model->performInsert()
  389. #9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Collections/HigherOrderCollectionProxy.php(60): Illuminate\Database\Eloquent\Model->save()
  390. #10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php(236): Illuminate\Support\HigherOrderCollectionProxy->Illuminate\Support\{closure}()
  391. #11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Collections/HigherOrderCollectionProxy.php(61): Illuminate\Support\Collection->each()
  392. #12 /opt/librenms/LibreNMS/DB/SyncsModels.php(70): Illuminate\Support\HigherOrderCollectionProxy->__call()
  393. #13 /opt/librenms/LibreNMS/Modules/Xdsl.php(163): LibreNMS\Modules\Xdsl->syncModels()
  394. #14 /opt/librenms/LibreNMS/Modules/Xdsl.php(74): LibreNMS\Modules\Xdsl->pollAdsl()
  395. #15 /opt/librenms/includes/discovery/xdsl.inc.php(8): LibreNMS\Modules\Xdsl->discover()
  396. #16 /opt/librenms/includes/discovery/functions.inc.php(164): include('...')
  397. #17 /opt/librenms/discovery.php(108): discover_device()
  398. #18 {main}  
  399. SQL[[1;33minsert into `eventlog` (`reference`, `type`, `datetime`, `severity`, `message`, `username`, `device_id`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[null,"discovery","2023-12-02 13:33:41",5,"Error discovering xdsl module. Check log file for more details.","",62][0m 27.86ms]
  400.  
  401. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'ports_adsl_port_id_unique' (Connection: mysql, SQL: insert into `ports_adsl` (`adslLineCoding`, `adslLineType`, `adslAtucInvVendorID`, `adslAtucInvVersionNumber`, `adslAtucCurrSnrMgn`, `adslAtucCurrAtn`, `adslAtucCurrOutputPwr`, `adslAtucCurrAttainableRate`, `adslAturInvSerialNumber`, `adslAturInvVendorID`, `adslAturInvVersionNumber`, `adslAturCurrSnrMgn`, `adslAturCurrAtn`, `adslAturCurrOutputPwr`, `adslAturCurrAttainableRate`, `adslAtucChanCurrTxRate`, `adslAturChanCurrTxRate`, `port_id`) values (2, 4, b5004946 544eb206, , 0.7, 1.7, 0, 65199104, 225004688011, fe004452 41590000, 5.12.18.17_B_A60901, 0.8, 0, 0, 14042112, 33170432, 10233856, 0)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'ports_adsl_port_id_unique' (Connection: mysql, SQL: insert into `ports_adsl` (`adslLineCoding`, `adslLineType`, `adslAtucInvVendorID`, `adslAtucInvVersionNumber`, `adslAtucCurrSnrMgn`, `adslAtucCurrAtn`, `adslAtucCurrOutputPwr`, `adslAtucCurrAttainableRate`, `adslAturInvSerialNumber`, `adslAturInvVendorID`, `adslAturInvVersionNumber`, `adslAturCurrSnrMgn`, `adslAturCurrAtn`, `adslAturCurrOutputPwr`, `adslAturCurrAttainableRate`, `adslAtucChanCurrTxRate`, `adslAturChanCurrTxRate`, `port_id`) values (2, 4, b5004946 544eb206, , 0.7, 1.7, 0, 65199104, 225004688011, fe004452 41590000, 5.12.18.17_B_A60901, 0.8, 0, 0, 14042112, 33170432, 10233856, 0)) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:795)
  402. [previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'ports_adsl_port_id_unique' at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:580)"}
  403.  
  404. >> Runtime for discovery module 'xdsl': 0.3350 seconds with 636248 bytes
  405. >> [0;36mSNMP[0m: [1/0.26s] [1;33mMySQL[0m: [3/0.34s] [0;32mRRD[0m: [0/0.00s]  
  406. #### Unload disco module xdsl ####
  407.  
  408. Modules status: Global+  
  409. OS  
  410. Device  
  411.  
  412. #### Load disco module entity-physical ####
  413.  
  414. Caching OIDs: entPhysicalEntrySNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'entPhysicalEntry'[0m]
  415. entPhysicalEntry = No Such Object available on this agent at this OID  
  416. MIB search path: /opt/librenms/mibs
  417. Cannot find module (CISCO-ENTITY-VENDORTYPE-OID-MIB): At line 12 in (none)  
  418. Invalid snmp_walk() data = entPhysicalEntry = No Such Object available on this agent at this OID  
  419.  
  420. SQL[[1;33mSELECT * FROM `entPhysical` WHERE `device_id` = ? [0;33m[62][0m 2.5ms]
  421.  
  422.  
  423. >> Runtime for discovery module 'entity-physical': 0.2290 seconds with 7024 bytes
  424. >> [0;36mSNMP[0m: [1/0.22s] [1;33mMySQL[0m: [1/0.03s] [0;32mRRD[0m: [0/0.00s]  
  425. #### Unload disco module entity-physical ####
  426.  
  427. Modules status: Global-  
  428. OS  
  429. Device  
  430. Module [ entity-state ] disabled globally.
  431.  
  432. Modules status: Global-  
  433. OS  
  434. Device  
  435. Module [ isis ] disabled globally.
  436.  
  437. Modules status: Global+  
  438. OS  
  439. Device  
  440.  
  441. #### Load disco module processors ####
  442. No YAML Discovery data.  
  443. Host Resources: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'hrProcessorLoad'[0m]
  444. hrProcessorLoad.196608 = 1
  445. hrProcessorLoad.196609 = 1
  446. hrProcessorLoad.196610 = 0
  447. hrProcessorLoad.196611 = 3  
  448.  
  449. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'hrDeviceDescr'[0m]
  450. hrDeviceDescr.196608 =
  451. hrDeviceDescr.196609 =
  452. hrDeviceDescr.196610 =
  453. hrDeviceDescr.196611 =
  454. hrDeviceDescr.262145 = network interface lo
  455. hrDeviceDescr.262146 = network interface ip_vti0
  456. hrDeviceDescr.262147 = network interface sit0
  457. hrDeviceDescr.262148 = network interface ip6tnl0
  458. hrDeviceDescr.262149 = network interface lan_int2_if
  459. hrDeviceDescr.262150 = network interface eth0
  460. hrDeviceDescr.262151 = network interface eth0.1
  461. hrDeviceDescr.262152 = network interface eth0.2
  462. hrDeviceDescr.262154 = network interface br0
  463. hrDeviceDescr.262155 = network interface wan_int2_if
  464. hrDeviceDescr.262156 = network interface ptm0
  465. hrDeviceDescr.262157 = network interface ptm1
  466. hrDeviceDescr.327680 = such file or directory
  467.  
  468. hrDeviceDescr.786432 = Guessing that there's a floating point co-processor  
  469.  
  470. Discovered LibreNMS\Device\Processor Array
  471. (
  472.     [processor_id] =>
  473.     [entPhysicalIndex] => 0
  474.     [hrDeviceIndex] => 196608
  475.     [device_id] => 62
  476.     [processor_oid] => .1.3.6.1.2.1.25.3.3.1.2.196608
  477.     [processor_index] => 196608
  478.     [processor_type] => hr
  479.     [processor_usage] => 1
  480.     [processor_descr] => Processor
  481.     [processor_precision] => 1
  482.     [processor_perc_warn] => 75
  483. )  
  484. Discovered LibreNMS\Device\Processor Array
  485. (
  486.     [processor_id] =>
  487.     [entPhysicalIndex] => 0
  488.     [hrDeviceIndex] => 196609
  489.     [device_id] => 62
  490.     [processor_oid] => .1.3.6.1.2.1.25.3.3.1.2.196609
  491.     [processor_index] => 196609
  492.     [processor_type] => hr
  493.     [processor_usage] => 1
  494.     [processor_descr] => Processor
  495.     [processor_precision] => 1
  496.     [processor_perc_warn] => 75
  497. )  
  498. Discovered LibreNMS\Device\Processor Array
  499. (
  500.     [processor_id] =>
  501.     [entPhysicalIndex] => 0
  502.     [hrDeviceIndex] => 196610
  503.     [device_id] => 62
  504.     [processor_oid] => .1.3.6.1.2.1.25.3.3.1.2.196610
  505.     [processor_index] => 196610
  506.     [processor_type] => hr
  507.     [processor_usage] => 0
  508.     [processor_descr] => Processor
  509.     [processor_precision] => 1
  510.     [processor_perc_warn] => 75
  511. )  
  512. Discovered LibreNMS\Device\Processor Array
  513. (
  514.     [processor_id] =>
  515.     [entPhysicalIndex] => 0
  516.     [hrDeviceIndex] => 196611
  517.     [device_id] => 62
  518.     [processor_oid] => .1.3.6.1.2.1.25.3.3.1.2.196611
  519.     [processor_index] => 196611
  520.     [processor_type] => hr
  521.     [processor_usage] => 3
  522.     [processor_descr] => Processor
  523.     [processor_precision] => 1
  524.     [processor_perc_warn] => 75
  525. )  
  526. SQL[[1;33mSELECT * FROM `processors` WHERE  device_id=? AND processor_index=? AND processor_type=? [0;33m[62,"196608","hr"][0m 2.89ms]
  527.  
  528. .SQL[[1;33mSELECT * FROM `processors` WHERE  device_id=? AND processor_index=? AND processor_type=? [0;33m[62,"196609","hr"][0m 2.74ms]
  529.  
  530. .SQL[[1;33mSELECT * FROM `processors` WHERE  device_id=? AND processor_index=? AND processor_type=? [0;33m[62,"196610","hr"][0m 2.73ms]
  531.  
  532. .SQL[[1;33mSELECT * FROM `processors` WHERE  device_id=? AND processor_index=? AND processor_type=? [0;33m[62,"196611","hr"][0m 2.75ms]
  533.  
  534. .SQL[[1;33mSELECT * FROM `processors` WHERE  device_id=? AND processor_index=? AND processor_type=? [0;33m[62,"196608","hr"][0m 2.03ms]
  535.  
  536. .SQL[[1;33mSELECT * FROM `processors` WHERE  device_id=? AND processor_index=? AND processor_type=? [0;33m[62,"196609","hr"][0m 1.79ms]
  537.  
  538. .SQL[[1;33mSELECT * FROM `processors` WHERE  device_id=? AND processor_index=? AND processor_type=? [0;33m[62,"196610","hr"][0m 1.84ms]
  539.  
  540. .SQL[[1;33mSELECT * FROM `processors` WHERE  device_id=? AND processor_index=? AND processor_type=? [0;33m[62,"196611","hr"][0m 1.83ms]
  541.  
  542. .SQL[[1;33mSELECT * FROM `processors` WHERE `device_id`=? AND `processor_id` NOT IN (?,?,?,?,?,?,?,?) [0;33m[62,167,168,169,170,167,168,169,170][0m 2.3ms]
  543.  
  544. SQL[[1;33mDELETE T FROM `processors` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `devices`.`device_id` IS NULL [0;33m[][0m 2.73ms]
  545.  
  546.  
  547.  
  548. >> Runtime for discovery module 'processors': 0.4180 seconds with 60656 bytes
  549. >> [0;36mSNMP[0m: [2/0.38s] [1;33mMySQL[0m: [10/0.24s] [0;32mRRD[0m: [0/0.00s]  
  550. #### Unload disco module processors ####
  551.  
  552. Modules status: Global+  
  553. OS  
  554. Device  
  555.  
  556. #### Load disco module mempools ####
  557. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Oqv' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.7367.3.7.0'[0m]
  558. 92  
  559.  
  560. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[62][0m 3.15ms]
  561.  
  562. .
  563. draytek [system]: Memory: 92%
  564.  
  565. >> Runtime for discovery module 'mempools': 0.2310 seconds with 185560 bytes
  566. >> [0;36mSNMP[0m: [1/0.21s] [1;33mMySQL[0m: [1/0.03s] [0;32mRRD[0m: [0/0.00s]  
  567. #### Unload disco module mempools ####
  568.  
  569. Modules status: Global+  
  570. OS  
  571. Device  
  572.  
  573. #### Load disco module cisco-vrf-lite ####
  574. SQL[[1;33mSELECT * FROM vrf_lite_cisco WHERE device_id = ?  [0;33m[62][0m 2.35ms]
  575.  
  576.  
  577. >> Runtime for discovery module 'cisco-vrf-lite': 0.0040 seconds with 1368 bytes
  578. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s]  
  579. #### Unload disco module cisco-vrf-lite ####
  580.  
  581. Modules status: Global-  
  582. OS  
  583. Device  
  584. Module [ cisco-mac-accounting ] disabled globally.
  585.  
  586. Modules status: Global-  
  587. OS  
  588. Device  
  589. Module [ cisco-pw ] disabled globally.
  590.  
  591. Modules status: Global-  
  592. OS  
  593. Device  
  594. Module [ vrf ] disabled globally.
  595.  
  596. Modules status: Global-  
  597. OS  
  598. Device  
  599. Module [ cisco-cef ] disabled globally.
  600.  
  601. Modules status: Global-  
  602. OS  
  603. Device  
  604. Module [ slas ] disabled globally.
  605.  
  606. Modules status: Global-  
  607. OS  
  608. Device  
  609. Module [ cisco-cbqos ] disabled globally.
  610.  
  611. Modules status: Global-  
  612. OS  
  613. Device  
  614. Module [ cisco-otv ] disabled globally.
  615.  
  616. Modules status: Global-  
  617. OS  
  618. Device  
  619. Module [ cisco-qfp ] disabled globally.
  620.  
  621. Modules status: Global+  
  622. OS  
  623. Device  
  624.  
  625. #### Load disco module ipv4-addresses ####
  626. SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[62][0m 2.53ms]
  627.  
  628. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Osq' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ipAdEntIfIndex'[0m]
  629. ipAdEntIfIndex.* 1
  630. ipAdEntIfIndex.* 10  
  631.  
  632. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Oqv' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ipAdEntNetMask.127.0.0.1'[0m]
  633. *  
  634.  
  635. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [0;33m[62,"1"][0m 2.54ms]
  636.  
  637. SQL[[1;33mSELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[62,"1"][0m 2.48ms]
  638.  
  639. SQL[[1;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? [0;33m["127.0.0.0\/8"][0m 2.23ms]
  640.  
  641. SQL[[1;33mUPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [0;33m["","127.0.0.0\/8"][0m 1.9ms]
  642.  
  643. sSQL[[1;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? [0;33m["127.0.0.0\/8"][0m 1.73ms]
  644.  
  645. SQL[[1;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ?  [0;33m["127.0.0.1",8,1611426][0m 1.8ms]
  646.  
  647. SQL[[1;33mUPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [0;33m["","127.0.0.1",8,1611426][0m 1.77ms]
  648.  
  649. .SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Oqv' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'ipAdEntNetMask.192.168.2.1'[0m]
  650. *  
  651.  
  652. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [0;33m[62,"10"][0m 2.72ms]
  653.  
  654. SQL[[1;33mSELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[62,"10"][0m 2.56ms]
  655.  
  656. SQL[[1;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? [0;33m["192.168.2.0\/24"][0m 2.04ms]
  657.  
  658. SQL[[1;33mUPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [0;33m["","192.168.2.0\/24"][0m 2.19ms]
  659.  
  660. sSQL[[1;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? [0;33m["192.168.2.0\/24"][0m 2.09ms]
  661.  
  662. SQL[[1;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ?  [0;33m["192.168.2.1",24,1611434][0m 2.19ms]
  663.  
  664. SQL[[1;33mUPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [0;33m["","192.168.2.1",24,1611434][0m 2.25ms]
  665.  
  666. .SQL[[1;33mSELECT `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 [0;33m[62][0m 4.03ms]
  667.  
  668.  
  669.  
  670. >> Runtime for discovery module 'ipv4-addresses': 0.6710 seconds with 44768 bytes
  671. >> [0;36mSNMP[0m: [3/0.61s] [1;33mMySQL[0m: [16/0.37s] [0;32mRRD[0m: [0/0.00s]  
  672. #### Unload disco module ipv4-addresses ####
  673.  
  674. Modules status: Global+  
  675. OS  
  676. Device  
  677.  
  678. #### Load disco module ipv6-addresses ####
  679. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUt' '-t' '5' 'udp:HOSTNAME:161' 'IP-MIB::ipAddressIfIndex.ipv6'[0m]  
  680. IP-MIB::ipAddressIfIndex[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"] = 1
  681. IP-MIB::ipAddressIfIndex[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"] = 10
  682.  
  683.  
  684. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUt' '-t' '5' 'udp:HOSTNAME:161' 'IP-MIB::ipAddressOrigin.ipv6'[0m]  
  685. IP-MIB::ipAddressOrigin[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"] = manual
  686. IP-MIB::ipAddressOrigin[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"] = linklayer
  687.  
  688.  
  689. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUt' '-t' '5' 'udp:HOSTNAME:161' 'IP-MIB::ipAddressPrefix.ipv6'[0m]  
  690. IP-MIB::ipAddressPrefix[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"] = IP-MIB::ipAddressPrefixOrigin[1][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128]
  691. IP-MIB::ipAddressPrefix[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"] = IP-MIB::ipAddressPrefixOrigin[10][ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64]
  692.  
  693.  
  694. SQL[[1;33mSELECT `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 [0;33m[62][0m 3.18ms]
  695.  
  696.  
  697.  
  698. >> Runtime for discovery module 'ipv6-addresses': 0.5920 seconds with 8360 bytes
  699. >> [0;36mSNMP[0m: [3/0.59s] [1;33mMySQL[0m: [1/0.03s] [0;32mRRD[0m: [0/0.00s]  
  700. #### Unload disco module ipv6-addresses ####
  701.  
  702. Modules status: Global+  
  703. OS  
  704. Device  
  705.  
  706. #### Load disco module route ####
  707. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Osqn' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::inetCidrRouteNumber.0'[0m]
  708. .*.*.6.0 10  
  709.  
  710. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-FORWARD-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'inetCidrRouteNumber.0' 'ipCidrRouteNumber.0'[0m]
  711. inetCidrRouteNumber.0 = 10
  712. ipCidrRouteNumber.0 = No Such Object available on this agent at this OID  
  713.  
  714. SQL[[1;33mselect now() as now [0;33m[][0m 2.14ms]
  715.  
  716. SQL[[1;33mselect * from `route` where `device_id` = ? [0;33m[62][0m 6.56ms]
  717.  
  718. Reporting disabled by user setting  
  719. IP FORWARD MIB (with inetCidr support)  
  720. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUsetX' '-m' 'IP-FORWARD-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.4.24.7.1'[0m]
  721. inetCidrRouteIfIndex[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = 1
  722. inetCidrRouteIfIndex[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = 10
  723. inetCidrRouteIfIndex[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  724. inetCidrRouteIfIndex[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 10
  725. inetCidrRouteIfIndex[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  726. inetCidrRouteIfIndex[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  727. inetCidrRouteIfIndex[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 6
  728. inetCidrRouteIfIndex[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 7
  729. inetCidrRouteIfIndex[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 8
  730. inetCidrRouteIfIndex[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 10
  731. inetCidrRouteType[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = 3
  732. inetCidrRouteType[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = 3
  733. inetCidrRouteType[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 3
  734. inetCidrRouteType[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 3
  735. inetCidrRouteType[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 3
  736. inetCidrRouteType[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 3
  737. inetCidrRouteType[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 3
  738. inetCidrRouteType[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 3
  739. inetCidrRouteType[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 3
  740. inetCidrRouteType[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 3
  741. inetCidrRouteProto[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = 2
  742. inetCidrRouteProto[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = 2
  743. inetCidrRouteProto[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 2
  744. inetCidrRouteProto[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 2
  745. inetCidrRouteProto[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 2
  746. inetCidrRouteProto[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 2
  747. inetCidrRouteProto[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 2
  748. inetCidrRouteProto[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 2
  749. inetCidrRouteProto[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 2
  750. inetCidrRouteProto[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 2
  751. inetCidrRouteAge[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = 0
  752. inetCidrRouteAge[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = 0
  753. inetCidrRouteAge[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  754. inetCidrRouteAge[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  755. inetCidrRouteAge[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  756. inetCidrRouteAge[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  757. inetCidrRouteAge[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  758. inetCidrRouteAge[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  759. inetCidrRouteAge[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  760. inetCidrRouteAge[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  761. inetCidrRouteNextHopAS[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = 0
  762. inetCidrRouteNextHopAS[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = 0
  763. inetCidrRouteNextHopAS[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  764. inetCidrRouteNextHopAS[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  765. inetCidrRouteNextHopAS[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  766. inetCidrRouteNextHopAS[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  767. inetCidrRouteNextHopAS[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  768. inetCidrRouteNextHopAS[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  769. inetCidrRouteNextHopAS[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  770. inetCidrRouteNextHopAS[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  771. inetCidrRouteMetric1[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = 0
  772. inetCidrRouteMetric1[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = 0
  773. inetCidrRouteMetric1[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  774. inetCidrRouteMetric1[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 256
  775. inetCidrRouteMetric1[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  776. inetCidrRouteMetric1[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 0
  777. inetCidrRouteMetric1[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 256
  778. inetCidrRouteMetric1[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 256
  779. inetCidrRouteMetric1[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 256
  780. inetCidrRouteMetric1[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 256
  781. inetCidrRouteMetric2[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = -1
  782. inetCidrRouteMetric2[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = -1
  783. inetCidrRouteMetric2[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  784. inetCidrRouteMetric2[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  785. inetCidrRouteMetric2[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  786. inetCidrRouteMetric2[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  787. inetCidrRouteMetric2[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  788. inetCidrRouteMetric2[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  789. inetCidrRouteMetric2[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  790. inetCidrRouteMetric2[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  791. inetCidrRouteMetric3[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = -1
  792. inetCidrRouteMetric3[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = -1
  793. inetCidrRouteMetric3[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  794. inetCidrRouteMetric3[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  795. inetCidrRouteMetric3[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  796. inetCidrRouteMetric3[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  797. inetCidrRouteMetric3[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  798. inetCidrRouteMetric3[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  799. inetCidrRouteMetric3[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  800. inetCidrRouteMetric3[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  801. inetCidrRouteMetric4[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = -1
  802. inetCidrRouteMetric4[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = -1
  803. inetCidrRouteMetric4[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  804. inetCidrRouteMetric4[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  805. inetCidrRouteMetric4[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  806. inetCidrRouteMetric4[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  807. inetCidrRouteMetric4[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  808. inetCidrRouteMetric4[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  809. inetCidrRouteMetric4[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  810. inetCidrRouteMetric4[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  811. inetCidrRouteMetric5[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = -1
  812. inetCidrRouteMetric5[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = -1
  813. inetCidrRouteMetric5[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  814. inetCidrRouteMetric5[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  815. inetCidrRouteMetric5[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  816. inetCidrRouteMetric5[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  817. inetCidrRouteMetric5[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  818. inetCidrRouteMetric5[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  819. inetCidrRouteMetric5[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  820. inetCidrRouteMetric5[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = -1
  821. inetCidrRouteStatus[ipv4]["*"][16][zeroDotZero.1][ipv4]["*"] = 1
  822. inetCidrRouteStatus[ipv4]["*"][24][zeroDotZero.10][ipv4]["*"] = 1
  823. inetCidrRouteStatus[ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.5][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  824. inetCidrRouteStatus[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][64][zeroDotZero.3][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  825. inetCidrRouteStatus[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][128][zeroDotZero.6][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  826. inetCidrRouteStatus[ipv6]["fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:01"][128][zeroDotZero.7][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  827. inetCidrRouteStatus[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.8][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  828. inetCidrRouteStatus[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.9][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  829. inetCidrRouteStatus[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.10][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1
  830. inetCidrRouteStatus[ipv6]["ff:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"][8][zeroDotZero.11][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:00"] = 1  
  831.  
  832. inetCidrRoute SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[62][0m 3.42ms]
  833.  
  834. SQL[[1;33mselect * from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null and `ifIndex` = ? limit 1 [0;33m[62,"1"][0m 3.72ms]
  835.  
  836. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[62][0m 2.81ms]
  837.  
  838. SQL[[1;33mselect * from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null and `ifIndex` = ? limit 1 [0;33m[62,"10"][0m 3.48ms]
  839.  
  840. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[62][0m 2.82ms]
  841.  
  842. SQL[[1;33mselect * from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null and `ifIndex` = ? limit 1 [0;33m[62,"1"][0m 2.65ms]
  843.  
  844.  
  845.  
  846.  
  847.  
  848. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[62][0m 2.47ms]
  849.  
  850. SQL[[1;33mselect * from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null and `ifIndex` = ? limit 1 [0;33m[62,"10"][0m 2.64ms]
  851.  
  852.  
  853.  
  854.  
  855.  
  856. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[62][0m 2.48ms]
  857.  
  858. SQL[[1;33mselect * from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null and `ifIndex` = ? limit 1 [0;33m[62,"1"][0m 2.67ms]
  859.  
  860.  
  861.  
  862.  
  863.  
  864. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[62][0m 2.82ms]
  865.  
  866. SQL[[1;33mselect * from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null and `ifIndex` = ? limit 1 [0;33m[62,"6"][0m 3.55ms]
  867.  
  868.  
  869.  
  870.  
  871.  
  872. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUsetX' '-m' 'MPLS-L3VPN-STD-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'mplsL3VpnVrfPerfCurrNumRoutes'[0m]
  873. mplsL3VpnVrfPerfCurrNumRoutes = No Such Object available on this agent at this OID  
  874.  
  875. mplsL3VpnVrfRteTable SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUsetX' '-m' 'MPLS-L3VPN-STD-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'mplsL3VpnVrfRteTable'[0m]
  876. mplsL3VpnVrfRteTable = No Such Object available on this agent at this OID  
  877.  
  878.  
  879. Processing: SQL[[1;33mDELETE FROM `route` WHERE `route_id` = ? [0;33m[787226][0m 26.09ms]
  880.  
  881. -array (
  882.   'route_id' => 787226,
  883.   'created_at' => '2023-12-02 13:29:32',
  884.   'updated_at' => '2023-12-02 13:29:32',
  885.   'device_id' => 62,
  886.   'port_id' => 1611426,
  887.   'context_name' => '',
  888.   'inetCidrRouteIfIndex' => 1,
  889.   'inetCidrRouteType' => 3,
  890.   'inetCidrRouteProto' => 2,
  891.   'inetCidrRouteNextHopAS' => 0,
  892.   'inetCidrRouteMetric1' => 0,
  893.   'inetCidrRouteDestType' => 'ipv6',
  894.   'inetCidrRouteDest' => '0000:0000:0000:0000:0000:0000:0000:0001',
  895.   'inetCidrRouteNextHopType' => 'ipv6',
  896.   'inetCidrRouteNextHop' => '0000:0000:0000:0000:0000:0000:0000:0000',
  897.   'inetCidrRoutePolicy' => 'zeroDotZero.5',
  898.   'inetCidrRoutePfxLen' => 128,
  899. )  
  900. SQL[[1;33mDELETE FROM `route` WHERE `route_id` = ? [0;33m[787227][0m 3.63ms]
  901.  
  902. -array (
  903.   'route_id' => 787227,
  904.   'created_at' => '2023-12-02 13:29:32',
  905.   'updated_at' => '2023-12-02 13:29:32',
  906.   'device_id' => 62,
  907.   'port_id' => 1611434,
  908.   'context_name' => '',
  909.   'inetCidrRouteIfIndex' => 10,
  910.   'inetCidrRouteType' => 3,
  911.   'inetCidrRouteProto' => 2,
  912.   'inetCidrRouteNextHopAS' => 0,
  913.   'inetCidrRouteMetric1' => 256,
  914.   'inetCidrRouteDestType' => 'ipv6',
  915.   'inetCidrRouteDest' => 'fe80:0000:0000:0000:0000:0000:0000:0000',
  916.   'inetCidrRouteNextHopType' => 'ipv6',
  917.   'inetCidrRouteNextHop' => '0000:0000:0000:0000:0000:0000:0000:0000',
  918.   'inetCidrRoutePolicy' => 'zeroDotZero.3',
  919.   'inetCidrRoutePfxLen' => 64,
  920. )  
  921. SQL[[1;33mDELETE FROM `route` WHERE `route_id` = ? [0;33m[787228][0m 4.78ms]
  922.  
  923. -array (
  924.   'route_id' => 787228,
  925.   'created_at' => '2023-12-02 13:29:32',
  926.   'updated_at' => '2023-12-02 13:29:32',
  927.   'device_id' => 62,
  928.   'port_id' => 1611426,
  929.   'context_name' => '',
  930.   'inetCidrRouteIfIndex' => 1,
  931.   'inetCidrRouteType' => 3,
  932.   'inetCidrRouteProto' => 2,
  933.   'inetCidrRouteNextHopAS' => 0,
  934.   'inetCidrRouteMetric1' => 0,
  935.   'inetCidrRouteDestType' => 'ipv6',
  936.   'inetCidrRouteDest' => 'fe80:0000:0000:0000:0000:0000:0000:0001',
  937.   'inetCidrRouteNextHopType' => 'ipv6',
  938.   'inetCidrRouteNextHop' => '0000:0000:0000:0000:0000:0000:0000:0000',
  939.   'inetCidrRoutePolicy' => 'zeroDotZero.7',
  940.   'inetCidrRoutePfxLen' => 128,
  941. )  
  942. SQL[[1;33mDELETE FROM `route` WHERE `route_id` = ? [0;33m[787229][0m 3.67ms]
  943.  
  944. -array (
  945.   'route_id' => 787229,
  946.   'created_at' => '2023-12-02 13:29:32',
  947.   'updated_at' => '2023-12-02 13:29:32',
  948.   'device_id' => 62,
  949.   'port_id' => 1611431,
  950.   'context_name' => '',
  951.   'inetCidrRouteIfIndex' => 6,
  952.   'inetCidrRouteType' => 3,
  953.   'inetCidrRouteProto' => 2,
  954.   'inetCidrRouteNextHopAS' => 0,
  955.   'inetCidrRouteMetric1' => 256,
  956.   'inetCidrRouteDestType' => 'ipv6',
  957.   'inetCidrRouteDest' => 'ff00:0000:0000:0000:0000:0000:0000:0000',
  958.   'inetCidrRouteNextHopType' => 'ipv6',
  959.   'inetCidrRouteNextHop' => '0000:0000:0000:0000:0000:0000:0000:0000',
  960.   'inetCidrRoutePolicy' => 'zeroDotZero.8',
  961.   'inetCidrRoutePfxLen' => 8,
  962. )  
  963. SQL[[1;33mUPDATE `route` set `inetCidrRouteIfIndex`=?,`inetCidrRouteType`=?,`inetCidrRouteProto`=?,`inetCidrRouteNextHopAS`=?,`inetCidrRouteMetric1`=?,`inetCidrRouteDestType`=?,`inetCidrRouteDest`=?,`inetCidrRoutePfxLen`=?,`inetCidrRoutePolicy`=?,`inetCidrRouteNextHopType`=?,`inetCidrRouteNextHop`=?,`context_name`=?,`device_id`=?,`port_id`=?,`updated_at`=?,`route_id`=? WHERE `route_id` = ? [0;33m["1","3","2","0","0","ipv4","127.0.0.0",16,"zeroDotZero.1","ipv4","0.0.0.0","",62,1611426,"2023-12-02 13:33:44",786251,786251][0m 4.93ms]
  964.  
  965. .SQL[[1;33mUPDATE `route` set `inetCidrRouteIfIndex`=?,`inetCidrRouteType`=?,`inetCidrRouteProto`=?,`inetCidrRouteNextHopAS`=?,`inetCidrRouteMetric1`=?,`inetCidrRouteDestType`=?,`inetCidrRouteDest`=?,`inetCidrRoutePfxLen`=?,`inetCidrRoutePolicy`=?,`inetCidrRouteNextHopType`=?,`inetCidrRouteNextHop`=?,`context_name`=?,`device_id`=?,`port_id`=?,`updated_at`=?,`route_id`=? WHERE `route_id` = ? [0;33m["10","3","2","0","0","ipv4","192.168.2.0",24,"zeroDotZero.10","ipv4","0.0.0.0","",62,1611434,"2023-12-02 13:33:44",786252,786252][0m 3.83ms]
  966.  
  967. .SQL[[1;33mINSERT IGNORE INTO `route` (`inetCidrRouteIfIndex`,`inetCidrRouteType`,`inetCidrRouteProto`,`inetCidrRouteNextHopAS`,`inetCidrRouteMetric1`,`inetCidrRouteDestType`,`inetCidrRouteDest`,`inetCidrRoutePfxLen`,`inetCidrRoutePolicy`,`inetCidrRouteNextHopType`,`inetCidrRouteNextHop`,`context_name`,`device_id`,`port_id`,`updated_at`,`created_at`)  VALUES (:inetCidrRouteIfIndex,:inetCidrRouteType,:inetCidrRouteProto,:inetCidrRouteNextHopAS,:inetCidrRouteMetric1,:inetCidrRouteDestType,:inetCidrRouteDest,:inetCidrRoutePfxLen,:inetCidrRoutePolicy,:inetCidrRouteNextHopType,:inetCidrRouteNextHop,:context_name,:device_id,:port_id,:updated_at,:created_at) [0;33m{"inetCidrRouteIfIndex":"1","inetCidrRouteType":"3","inetCidrRouteProto":"2","inetCidrRouteNextHopAS":"0","inetCidrRouteMetric1":"0","inetCidrRouteDestType":"ipv6","inetCidrRouteDest":"0000:0000:0000:0000:0000:0000:0000:0001","inetCidrRoutePfxLen":128,"inetCidrRoutePolicy":"zeroDotZero.5","inetCidrRouteNextHopType":"ipv6","inetCidrRouteNextHop":"0000:0000:0000:0000:0000:0000:0000:0000","context_name":"","device_id":62,"port_id":1611426,"updated_at":"2023-12-02 13:33:44","created_at":"2023-12-02 13:33:44"}[0m 4.69ms]
  968.  
  969. +SQL[[1;33mINSERT IGNORE INTO `route` (`inetCidrRouteIfIndex`,`inetCidrRouteType`,`inetCidrRouteProto`,`inetCidrRouteNextHopAS`,`inetCidrRouteMetric1`,`inetCidrRouteDestType`,`inetCidrRouteDest`,`inetCidrRoutePfxLen`,`inetCidrRoutePolicy`,`inetCidrRouteNextHopType`,`inetCidrRouteNextHop`,`context_name`,`device_id`,`port_id`,`updated_at`,`created_at`)  VALUES (:inetCidrRouteIfIndex,:inetCidrRouteType,:inetCidrRouteProto,:inetCidrRouteNextHopAS,:inetCidrRouteMetric1,:inetCidrRouteDestType,:inetCidrRouteDest,:inetCidrRoutePfxLen,:inetCidrRoutePolicy,:inetCidrRouteNextHopType,:inetCidrRouteNextHop,:context_name,:device_id,:port_id,:updated_at,:created_at) [0;33m{"inetCidrRouteIfIndex":"10","inetCidrRouteType":"3","inetCidrRouteProto":"2","inetCidrRouteNextHopAS":"0","inetCidrRouteMetric1":"256","inetCidrRouteDestType":"ipv6","inetCidrRouteDest":"fe80:0000:0000:0000:0000:0000:0000:0000","inetCidrRoutePfxLen":64,"inetCidrRoutePolicy":"zeroDotZero.3","inetCidrRouteNextHopType":"ipv6","inetCidrRouteNextHop":"0000:0000:0000:0000:0000:0000:0000:0000","context_name":"","device_id":62,"port_id":1611434,"updated_at":"2023-12-02 13:33:44","created_at":"2023-12-02 13:33:44"}[0m 4.33ms]
  970.  
  971. +SQL[[1;33mINSERT IGNORE INTO `route` (`inetCidrRouteIfIndex`,`inetCidrRouteType`,`inetCidrRouteProto`,`inetCidrRouteNextHopAS`,`inetCidrRouteMetric1`,`inetCidrRouteDestType`,`inetCidrRouteDest`,`inetCidrRoutePfxLen`,`inetCidrRoutePolicy`,`inetCidrRouteNextHopType`,`inetCidrRouteNextHop`,`context_name`,`device_id`,`port_id`,`updated_at`,`created_at`)  VALUES (:inetCidrRouteIfIndex,:inetCidrRouteType,:inetCidrRouteProto,:inetCidrRouteNextHopAS,:inetCidrRouteMetric1,:inetCidrRouteDestType,:inetCidrRouteDest,:inetCidrRoutePfxLen,:inetCidrRoutePolicy,:inetCidrRouteNextHopType,:inetCidrRouteNextHop,:context_name,:device_id,:port_id,:updated_at,:created_at) [0;33m{"inetCidrRouteIfIndex":"1","inetCidrRouteType":"3","inetCidrRouteProto":"2","inetCidrRouteNextHopAS":"0","inetCidrRouteMetric1":"0","inetCidrRouteDestType":"ipv6","inetCidrRouteDest":"fe80:0000:0000:0000:0000:0000:0000:0001","inetCidrRoutePfxLen":128,"inetCidrRoutePolicy":"zeroDotZero.7","inetCidrRouteNextHopType":"ipv6","inetCidrRouteNextHop":"0000:0000:0000:0000:0000:0000:0000:0000","context_name":"","device_id":62,"port_id":1611426,"updated_at":"2023-12-02 13:33:44","created_at":"2023-12-02 13:33:44"}[0m 6.27ms]
  972.  
  973. +SQL[[1;33mINSERT IGNORE INTO `route` (`inetCidrRouteIfIndex`,`inetCidrRouteType`,`inetCidrRouteProto`,`inetCidrRouteNextHopAS`,`inetCidrRouteMetric1`,`inetCidrRouteDestType`,`inetCidrRouteDest`,`inetCidrRoutePfxLen`,`inetCidrRoutePolicy`,`inetCidrRouteNextHopType`,`inetCidrRouteNextHop`,`context_name`,`device_id`,`port_id`,`updated_at`,`created_at`)  VALUES (:inetCidrRouteIfIndex,:inetCidrRouteType,:inetCidrRouteProto,:inetCidrRouteNextHopAS,:inetCidrRouteMetric1,:inetCidrRouteDestType,:inetCidrRouteDest,:inetCidrRoutePfxLen,:inetCidrRoutePolicy,:inetCidrRouteNextHopType,:inetCidrRouteNextHop,:context_name,:device_id,:port_id,:updated_at,:created_at) [0;33m{"inetCidrRouteIfIndex":"6","inetCidrRouteType":"3","inetCidrRouteProto":"2","inetCidrRouteNextHopAS":"0","inetCidrRouteMetric1":"256","inetCidrRouteDestType":"ipv6","inetCidrRouteDest":"ff00:0000:0000:0000:0000:0000:0000:0000","inetCidrRoutePfxLen":8,"inetCidrRoutePolicy":"zeroDotZero.8","inetCidrRouteNextHopType":"ipv6","inetCidrRouteNextHop":"0000:0000:0000:0000:0000:0000:0000:0000","context_name":"","device_id":62,"port_id":1611431,"updated_at":"2023-12-02 13:33:44","created_at":"2023-12-02 13:33:44"}[0m 4.86ms]
  974.  
  975. +
  976. >> Runtime for discovery module 'route': 1.2330 seconds with 144376 bytes
  977. >> [0;36mSNMP[0m: [2/0.40s] [1;33mMySQL[0m: [24/1.11s] [0;32mRRD[0m: [0/0.00s]  
  978. #### Unload disco module route ####
  979.  
  980. Modules status: Global+  
  981. OS  
  982. Device  
  983.  
  984. #### Load disco module sensors ####
  985. Caching data: os mempools
  986.  ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'ENTITY-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'entPhysicalDescr'[0m]
  987. entPhysicalDescr = No Such Object available on this agent at this OID  
  988.  
  989. Invalid snmp_walk() data = entPhysicalDescr = No Such Object available on this agent at this OID  
  990.  
  991. SQL[[1;33mSELECT * 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 = ? [0;33m["voltage",62,"ipmi"][0m 3.99ms]
  992.  
  993. SQL[[1;33mSELECT * 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 = ? [0;33m["temperature",62,"ipmi"][0m 3.87ms]
  994.  
  995. SQL[[1;33mSELECT * 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 = ? [0;33m["fanspeed",62,"ipmi"][0m 4.05ms]
  996.  
  997. SQL[[1;33mSELECT * 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 = ? [0;33m["power",62,"ipmi"][0m 3.82ms]
  998.  
  999. Airflow: array (
  1000. )  
  1001. SQL[[1;33mSELECT * 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 = ? [0;33m["airflow",62,"snmp"][0m 3.77ms]
  1002.  
  1003.  
  1004. Current: array (
  1005. )  
  1006. SQL[[1;33mSELECT * 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 = ? [0;33m["current",62,"snmp"][0m 3.94ms]
  1007.  
  1008.  
  1009. Charge: array (
  1010. )  
  1011. SQL[[1;33mSELECT * 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 = ? [0;33m["charge",62,"snmp"][0m 3.91ms]
  1012.  
  1013.  
  1014. Dbm: array (
  1015. )  
  1016. SQL[[1;33mSELECT * 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 = ? [0;33m["dbm",62,"snmp"][0m 3.93ms]
  1017.  
  1018.  
  1019. Fanspeed: array (
  1020. )  
  1021. SQL[[1;33mSELECT * 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 = ? [0;33m["fanspeed",62,"snmp"][0m 3.85ms]
  1022.  
  1023.  
  1024. Frequency: array (
  1025. )  
  1026. SQL[[1;33mSELECT * 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 = ? [0;33m["frequency",62,"snmp"][0m 3.77ms]
  1027.  
  1028.  
  1029. Humidity: array (
  1030. )  
  1031. SQL[[1;33mSELECT * 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 = ? [0;33m["humidity",62,"snmp"][0m 3.91ms]
  1032.  
  1033.  
  1034. Load: array (
  1035. )  
  1036. SQL[[1;33mSELECT * 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 = ? [0;33m["load",62,"snmp"][0m 3.8ms]
  1037.  
  1038.  
  1039. Loss: array (
  1040. )  
  1041. SQL[[1;33mSELECT * 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 = ? [0;33m["loss",62,"snmp"][0m 3.91ms]
  1042.  
  1043.  
  1044. Power: array (
  1045. )  
  1046. SQL[[1;33mSELECT * 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 = ? [0;33m["power",62,"snmp"][0m 4.04ms]
  1047.  
  1048.  
  1049. Power_consumed: array (
  1050. )  
  1051. SQL[[1;33mSELECT * 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 = ? [0;33m["power_consumed",62,"snmp"][0m 3.87ms]
  1052.  
  1053.  
  1054. Power_factor: array (
  1055. )  
  1056. SQL[[1;33mSELECT * 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 = ? [0;33m["power_factor",62,"snmp"][0m 3.83ms]
  1057.  
  1058.  
  1059. Runtime: array (
  1060. )  
  1061. SQL[[1;33mSELECT * 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 = ? [0;33m["runtime",62,"snmp"][0m 3.96ms]
  1062.  
  1063.  
  1064. Signal: array (
  1065. )  
  1066. SQL[[1;33mSELECT * 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 = ? [0;33m["signal",62,"snmp"][0m 3.69ms]
  1067.  
  1068.  
  1069. State: array (
  1070. )  
  1071. SQL[[1;33mSELECT * 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 = ? [0;33m["state",62,"snmp"][0m 3.7ms]
  1072.  
  1073.  
  1074. Count: array (
  1075. )  
  1076. SQL[[1;33mSELECT * 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 = ? [0;33m["count",62,"snmp"][0m 3.84ms]
  1077.  
  1078.  
  1079. Temperature: array (
  1080. )  
  1081. SQL[[1;33mSELECT * 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 = ? [0;33m["temperature",62,"snmp"][0m 3.73ms]
  1082.  
  1083.  
  1084. Tv_signal: array (
  1085. )  
  1086. SQL[[1;33mSELECT * 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 = ? [0;33m["tv_signal",62,"snmp"][0m 3.86ms]
  1087.  
  1088.  
  1089. Bitrate: array (
  1090. )  
  1091. SQL[[1;33mSELECT * 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 = ? [0;33m["bitrate",62,"snmp"][0m 3.73ms]
  1092.  
  1093.  
  1094. Voltage: array (
  1095. )  
  1096. SQL[[1;33mSELECT * 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 = ? [0;33m["voltage",62,"snmp"][0m 3.6ms]
  1097.  
  1098.  
  1099. Snr: array (
  1100. )  
  1101. SQL[[1;33mSELECT * 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 = ? [0;33m["snr",62,"snmp"][0m 3.73ms]
  1102.  
  1103.  
  1104. Pressure: array (
  1105. )  
  1106. SQL[[1;33mSELECT * 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 = ? [0;33m["pressure",62,"snmp"][0m 3.78ms]
  1107.  
  1108.  
  1109. Cooling: array (
  1110. )  
  1111. SQL[[1;33mSELECT * 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 = ? [0;33m["cooling",62,"snmp"][0m 3.86ms]
  1112.  
  1113.  
  1114. Delay: array (
  1115. )  
  1116. SQL[[1;33mSELECT * 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 = ? [0;33m["delay",62,"snmp"][0m 3.73ms]
  1117.  
  1118.  
  1119. Quality_factor: array (
  1120. )  
  1121. SQL[[1;33mSELECT * 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 = ? [0;33m["quality_factor",62,"snmp"][0m 3.83ms]
  1122.  
  1123.  
  1124. Chromatic_dispersion: array (
  1125. )  
  1126. SQL[[1;33mSELECT * 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 = ? [0;33m["chromatic_dispersion",62,"snmp"][0m 3.75ms]
  1127.  
  1128.  
  1129. Ber: array (
  1130. )  
  1131. SQL[[1;33mSELECT * 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 = ? [0;33m["ber",62,"snmp"][0m 3.68ms]
  1132.  
  1133.  
  1134. Eer: array (
  1135. )  
  1136. SQL[[1;33mSELECT * 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 = ? [0;33m["eer",62,"snmp"][0m 3.74ms]
  1137.  
  1138.  
  1139. Waterflow: array (
  1140. )  
  1141. SQL[[1;33mSELECT * 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 = ? [0;33m["waterflow",62,"snmp"][0m 3.82ms]
  1142.  
  1143.  
  1144. Percent: array (
  1145. )  
  1146. SQL[[1;33mSELECT * 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 = ? [0;33m["percent",62,"snmp"][0m 3.9ms]
  1147.  
  1148.  
  1149.  
  1150. >> Runtime for discovery module 'sensors': 0.4100 seconds with 29016 bytes
  1151. >> [0;36mSNMP[0m: [1/0.23s] [1;33mMySQL[0m: [34/1.30s] [0;32mRRD[0m: [0/0.00s]  
  1152. #### Unload disco module sensors ####
  1153.  
  1154. Modules status: Global+  
  1155. OS  
  1156. Device  
  1157.  
  1158. #### Load disco module storage ####
  1159. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'DATA-DOMAIN-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/datadomain' '-t' '5' 'udp:HOSTNAME:161' 'fileSystemSpaceTable'[0m]
  1160. fileSystemSpaceTable = No Such Object available on this agent at this OID  
  1161.  
  1162. Invalid snmp_walk() data = fileSystemSpaceTable = No Such Object available on this agent at this OID  
  1163. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUsetX' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'hrStorageTable'[0m]
  1164. hrStorageIndex[1] = 1
  1165. hrStorageIndex[3] = 3
  1166. hrStorageIndex[6] = 6
  1167. hrStorageIndex[7] = 7
  1168. hrStorageIndex[8] = 8
  1169. hrStorageIndex[10] = 10
  1170. hrStorageType[1] = hrStorageRam
  1171. hrStorageType[3] = hrStorageVirtualMemory
  1172. hrStorageType[6] = hrStorageOther
  1173. hrStorageType[7] = hrStorageOther
  1174. hrStorageType[8] = hrStorageOther
  1175. hrStorageType[10] = hrStorageVirtualMemory
  1176. hrStorageDescr[1] = Physical memory
  1177. hrStorageDescr[3] = Virtual memory
  1178. hrStorageDescr[6] = Memory buffers
  1179. hrStorageDescr[7] = Cached memory
  1180. hrStorageDescr[8] = Shared memory
  1181. hrStorageDescr[10] = Swap space
  1182. hrStorageAllocationUnits[1] = 1024
  1183. hrStorageAllocationUnits[3] = 1024
  1184. hrStorageAllocationUnits[6] = 1024
  1185. hrStorageAllocationUnits[7] = 1024
  1186. hrStorageAllocationUnits[8] = 1024
  1187. hrStorageAllocationUnits[10] = 1024
  1188. hrStorageSize[1] = 105976
  1189. hrStorageSize[3] = 105976
  1190. hrStorageSize[6] = 105976
  1191. hrStorageSize[7] = 19964
  1192. hrStorageSize[8] = 6432
  1193. hrStorageSize[10] = 0
  1194. hrStorageUsed[1] = 97692
  1195. hrStorageUsed[3] = 97692
  1196. hrStorageUsed[6] = 7216
  1197. hrStorageUsed[7] = 19964
  1198. hrStorageUsed[8] = 6432
  1199. hrStorageUsed[10] = 0  
  1200.  
  1201. hrStorage : SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'dskTable'[0m]
  1202. dskTable = No Such Object available on this agent at this OID  
  1203.  
  1204. Invalid snmp_walk() data = dskTable = No Such Object available on this agent at this OID  
  1205. SQL[[1;33mSELECT `storage_descr` FROM `storage` WHERE `device_id`  = '62' AND `storage_type` != 'dsk' [0;33m[][0m 2.31ms]
  1206.  
  1207. array (
  1208. )  
  1209. SQL[[1;33mSELECT * FROM `storage` WHERE `device_id`  = '62' [0;33m[][0m 2.16ms]
  1210.  
  1211.  
  1212.  
  1213. >> Runtime for discovery module 'storage': 0.7080 seconds with 22880 bytes
  1214. >> [0;36mSNMP[0m: [2/0.49s] [1;33mMySQL[0m: [2/0.04s] [0;32mRRD[0m: [0/0.00s]  
  1215. #### Unload disco module storage ####
  1216.  
  1217. Modules status: Global+  
  1218. OS  
  1219. Device  
  1220.  
  1221. #### Load disco module hr-device ####
  1222. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'hrProcessorTable'[0m]
  1223. hrProcessorFrwID.196608 = zeroDotZero
  1224. hrProcessorFrwID.196609 = zeroDotZero
  1225. hrProcessorFrwID.196610 = zeroDotZero
  1226. hrProcessorFrwID.196611 = zeroDotZero
  1227. hrProcessorLoad.196608 = 1
  1228. hrProcessorLoad.196609 = 1
  1229. hrProcessorLoad.196610 = 0
  1230. hrProcessorLoad.196611 = 3  
  1231.  
  1232. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'hrDeviceTable'[0m]
  1233. hrDeviceIndex.196608 = 196608
  1234. hrDeviceIndex.196609 = 196609
  1235. hrDeviceIndex.196610 = 196610
  1236. hrDeviceIndex.196611 = 196611
  1237. hrDeviceIndex.262145 = 262145
  1238. hrDeviceIndex.262146 = 262146
  1239. hrDeviceIndex.262147 = 262147
  1240. hrDeviceIndex.262148 = 262148
  1241. hrDeviceIndex.262149 = 262149
  1242. hrDeviceIndex.262150 = 262150
  1243. hrDeviceIndex.262151 = 262151
  1244. hrDeviceIndex.262152 = 262152
  1245. hrDeviceIndex.262154 = 262154
  1246. hrDeviceIndex.262155 = 262155
  1247. hrDeviceIndex.262156 = 262156
  1248. hrDeviceIndex.262157 = 262157
  1249. hrDeviceIndex.327680 = 327680
  1250. hrDeviceIndex.786432 = 786432
  1251. hrDeviceType.196608 = hrDeviceProcessor
  1252. hrDeviceType.196609 = hrDeviceProcessor
  1253. hrDeviceType.196610 = hrDeviceProcessor
  1254. hrDeviceType.196611 = hrDeviceProcessor
  1255. hrDeviceType.262145 = hrDeviceNetwork
  1256. hrDeviceType.262146 = hrDeviceNetwork
  1257. hrDeviceType.262147 = hrDeviceNetwork
  1258. hrDeviceType.262148 = hrDeviceNetwork
  1259. hrDeviceType.262149 = hrDeviceNetwork
  1260. hrDeviceType.262150 = hrDeviceNetwork
  1261. hrDeviceType.262151 = hrDeviceNetwork
  1262. hrDeviceType.262152 = hrDeviceNetwork
  1263. hrDeviceType.262154 = hrDeviceNetwork
  1264. hrDeviceType.262155 = hrDeviceNetwork
  1265. hrDeviceType.262156 = hrDeviceNetwork
  1266. hrDeviceType.262157 = hrDeviceNetwork
  1267. hrDeviceType.327680 = hrDevicePrinter
  1268. hrDeviceType.786432 = hrDeviceCoprocessor
  1269. hrDeviceDescr.196608 =
  1270. hrDeviceDescr.196609 =
  1271. hrDeviceDescr.196610 =
  1272. hrDeviceDescr.196611 =
  1273. hrDeviceDescr.262145 = network interface lo
  1274. hrDeviceDescr.262146 = network interface ip_vti0
  1275. hrDeviceDescr.262147 = network interface sit0
  1276. hrDeviceDescr.262148 = network interface ip6tnl0
  1277. hrDeviceDescr.262149 = network interface lan_int2_if
  1278. hrDeviceDescr.262150 = network interface eth0
  1279. hrDeviceDescr.262151 = network interface eth0.1
  1280. hrDeviceDescr.262152 = network interface eth0.2
  1281. hrDeviceDescr.262154 = network interface br0
  1282. hrDeviceDescr.262155 = network interface wan_int2_if
  1283. hrDeviceDescr.262156 = network interface ptm0
  1284. hrDeviceDescr.262157 = network interface ptm1
  1285. hrDeviceDescr.327680 = such file or directory
  1286.  
  1287. hrDeviceDescr.786432 = Guessing that there's a floating point co-processor
  1288. hrDeviceID.196608 = zeroDotZero
  1289. hrDeviceID.196609 = zeroDotZero
  1290. hrDeviceID.196610 = zeroDotZero
  1291. hrDeviceID.196611 = zeroDotZero
  1292. hrDeviceID.262145 = zeroDotZero
  1293. hrDeviceID.262146 = zeroDotZero
  1294. hrDeviceID.262147 = zeroDotZero
  1295. hrDeviceID.262148 = zeroDotZero
  1296. hrDeviceID.262149 = zeroDotZero
  1297. hrDeviceID.262150 = zeroDotZero
  1298. hrDeviceID.262151 = zeroDotZero
  1299. hrDeviceID.262152 = zeroDotZero
  1300. hrDeviceID.262154 = zeroDotZero
  1301. hrDeviceID.262155 = zeroDotZero
  1302. hrDeviceID.262156 = zeroDotZero
  1303. hrDeviceID.262157 = zeroDotZero
  1304. hrDeviceID.327680 = zeroDotZero
  1305. hrDeviceID.786432 = zeroDotZero
  1306. hrDeviceStatus.196608 = running
  1307. hrDeviceStatus.196609 = running
  1308. hrDeviceStatus.196610 = running
  1309. hrDeviceStatus.196611 = running
  1310. hrDeviceStatus.262145 = running
  1311. hrDeviceStatus.262146 = down
  1312. hrDeviceStatus.262147 = down
  1313. hrDeviceStatus.262148 = down
  1314. hrDeviceStatus.262149 = down
  1315. hrDeviceStatus.262150 = running
  1316. hrDeviceStatus.262151 = running
  1317. hrDeviceStatus.262152 = running
  1318. hrDeviceStatus.262154 = running
  1319. hrDeviceStatus.262155 = down
  1320. hrDeviceStatus.262156 = running
  1321. hrDeviceStatus.262157 = down
  1322. hrDeviceStatus.327680 = unknown
  1323. hrDeviceErrors.262145 = 0
  1324. hrDeviceErrors.262146 = 0
  1325. hrDeviceErrors.262147 = 0
  1326. hrDeviceErrors.262148 = 0
  1327. hrDeviceErrors.262149 = 0
  1328. hrDeviceErrors.262150 = 0
  1329. hrDeviceErrors.262151 = 0
  1330. hrDeviceErrors.262152 = 0
  1331. hrDeviceErrors.262154 = 0
  1332. hrDeviceErrors.262155 = 0
  1333. hrDeviceErrors.262156 = 2048
  1334. hrDeviceErrors.262157 = 2048
  1335. hrDeviceErrors.327680 = 0  
  1336.  
  1337. array (
  1338.   196608 =>
  1339.   array (
  1340.     'hrProcessorFrwID' => 'zeroDotZero',
  1341.     'hrProcessorLoad' => '1',
  1342.     'hrDeviceIndex' => '196608',
  1343.     'hrDeviceType' => 'hrDeviceProcessor',
  1344.     'hrDeviceDescr' => '',
  1345.     'hrDeviceID' => 'zeroDotZero',
  1346.     'hrDeviceStatus' => 'running',
  1347.   ),
  1348.   196609 =>
  1349.   array (
  1350.     'hrProcessorFrwID' => 'zeroDotZero',
  1351.     'hrProcessorLoad' => '1',
  1352.     'hrDeviceIndex' => '196609',
  1353.     'hrDeviceType' => 'hrDeviceProcessor',
  1354.     'hrDeviceDescr' => '',
  1355.     'hrDeviceID' => 'zeroDotZero',
  1356.     'hrDeviceStatus' => 'running',
  1357.   ),
  1358.   196610 =>
  1359.   array (
  1360.     'hrProcessorFrwID' => 'zeroDotZero',
  1361.     'hrProcessorLoad' => '0',
  1362.     'hrDeviceIndex' => '196610',
  1363.     'hrDeviceType' => 'hrDeviceProcessor',
  1364.     'hrDeviceDescr' => '',
  1365.     'hrDeviceID' => 'zeroDotZero',
  1366.     'hrDeviceStatus' => 'running',
  1367.   ),
  1368.   196611 =>
  1369.   array (
  1370.     'hrProcessorFrwID' => 'zeroDotZero',
  1371.     'hrProcessorLoad' => '3',
  1372.     'hrDeviceIndex' => '196611',
  1373.     'hrDeviceType' => 'hrDeviceProcessor',
  1374.     'hrDeviceDescr' => '',
  1375.     'hrDeviceID' => 'zeroDotZero',
  1376.     'hrDeviceStatus' => 'running',
  1377.   ),
  1378.   262145 =>
  1379.   array (
  1380.     'hrDeviceIndex' => '262145',
  1381.     'hrDeviceType' => 'hrDeviceNetwork',
  1382.     'hrDeviceDescr' => 'network interface lo',
  1383.     'hrDeviceID' => 'zeroDotZero',
  1384.     'hrDeviceStatus' => 'running',
  1385.     'hrDeviceErrors' => '0',
  1386.   ),
  1387.   262146 =>
  1388.   array (
  1389.     'hrDeviceIndex' => '262146',
  1390.     'hrDeviceType' => 'hrDeviceNetwork',
  1391.     'hrDeviceDescr' => 'network interface ip_vti0',
  1392.     'hrDeviceID' => 'zeroDotZero',
  1393.     'hrDeviceStatus' => 'down',
  1394.     'hrDeviceErrors' => '0',
  1395.   ),
  1396.   262147 =>
  1397.   array (
  1398.     'hrDeviceIndex' => '262147',
  1399.     'hrDeviceType' => 'hrDeviceNetwork',
  1400.     'hrDeviceDescr' => 'network interface sit0',
  1401.     'hrDeviceID' => 'zeroDotZero',
  1402.     'hrDeviceStatus' => 'down',
  1403.     'hrDeviceErrors' => '0',
  1404.   ),
  1405.   262148 =>
  1406.   array (
  1407.     'hrDeviceIndex' => '262148',
  1408.     'hrDeviceType' => 'hrDeviceNetwork',
  1409.     'hrDeviceDescr' => 'network interface ip6tnl0',
  1410.     'hrDeviceID' => 'zeroDotZero',
  1411.     'hrDeviceStatus' => 'down',
  1412.     'hrDeviceErrors' => '0',
  1413.   ),
  1414.   262149 =>
  1415.   array (
  1416.     'hrDeviceIndex' => '262149',
  1417.     'hrDeviceType' => 'hrDeviceNetwork',
  1418.     'hrDeviceDescr' => 'network interface lan_int2_if',
  1419.     'hrDeviceID' => 'zeroDotZero',
  1420.     'hrDeviceStatus' => 'down',
  1421.     'hrDeviceErrors' => '0',
  1422.   ),
  1423.   262150 =>
  1424.   array (
  1425.     'hrDeviceIndex' => '262150',
  1426.     'hrDeviceType' => 'hrDeviceNetwork',
  1427.     'hrDeviceDescr' => 'network interface eth0',
  1428.     'hrDeviceID' => 'zeroDotZero',
  1429.     'hrDeviceStatus' => 'running',
  1430.     'hrDeviceErrors' => '0',
  1431.   ),
  1432.   262151 =>
  1433.   array (
  1434.     'hrDeviceIndex' => '262151',
  1435.     'hrDeviceType' => 'hrDeviceNetwork',
  1436.     'hrDeviceDescr' => 'network interface eth0.1',
  1437.     'hrDeviceID' => 'zeroDotZero',
  1438.     'hrDeviceStatus' => 'running',
  1439.     'hrDeviceErrors' => '0',
  1440.   ),
  1441.   262152 =>
  1442.   array (
  1443.     'hrDeviceIndex' => '262152',
  1444.     'hrDeviceType' => 'hrDeviceNetwork',
  1445.     'hrDeviceDescr' => 'network interface eth0.2',
  1446.     'hrDeviceID' => 'zeroDotZero',
  1447.     'hrDeviceStatus' => 'running',
  1448.     'hrDeviceErrors' => '0',
  1449.   ),
  1450.   262154 =>
  1451.   array (
  1452.     'hrDeviceIndex' => '262154',
  1453.     'hrDeviceType' => 'hrDeviceNetwork',
  1454.     'hrDeviceDescr' => 'network interface br0',
  1455.     'hrDeviceID' => 'zeroDotZero',
  1456.     'hrDeviceStatus' => 'running',
  1457.     'hrDeviceErrors' => '0',
  1458.   ),
  1459.   262155 =>
  1460.   array (
  1461.     'hrDeviceIndex' => '262155',
  1462.     'hrDeviceType' => 'hrDeviceNetwork',
  1463.     'hrDeviceDescr' => 'network interface wan_int2_if',
  1464.     'hrDeviceID' => 'zeroDotZero',
  1465.     'hrDeviceStatus' => 'down',
  1466.     'hrDeviceErrors' => '0',
  1467.   ),
  1468.   262156 =>
  1469.   array (
  1470.     'hrDeviceIndex' => '262156',
  1471.     'hrDeviceType' => 'hrDeviceNetwork',
  1472.     'hrDeviceDescr' => 'network interface ptm0',
  1473.     'hrDeviceID' => 'zeroDotZero',
  1474.     'hrDeviceStatus' => 'running',
  1475.     'hrDeviceErrors' => '2048',
  1476.   ),
  1477.   262157 =>
  1478.   array (
  1479.     'hrDeviceIndex' => '262157',
  1480.     'hrDeviceType' => 'hrDeviceNetwork',
  1481.     'hrDeviceDescr' => 'network interface ptm1',
  1482.     'hrDeviceID' => 'zeroDotZero',
  1483.     'hrDeviceStatus' => 'down',
  1484.     'hrDeviceErrors' => '2048',
  1485.   ),
  1486.   327680 =>
  1487.   array (
  1488.     'hrDeviceIndex' => '327680',
  1489.     'hrDeviceType' => 'hrDevicePrinter',
  1490.     'hrDeviceDescr' => 'such file or directory',
  1491.     'hrDeviceID' => 'zeroDotZero',
  1492.     'hrDeviceStatus' => 'unknown',
  1493.     'hrDeviceErrors' => '0',
  1494.   ),
  1495.   786432 =>
  1496.   array (
  1497.     'hrDeviceIndex' => '786432',
  1498.     'hrDeviceType' => 'hrDeviceCoprocessor',
  1499.     'hrDeviceDescr' => 'Guessing that there\'s a floating point co-processor',
  1500.     'hrDeviceID' => 'zeroDotZero',
  1501.   ),
  1502. )  
  1503. SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"196608"][0m 2.27ms]
  1504.  
  1505. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=?,`hrProcessorLoad`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceProcessor","","running",0,"1",62,"196608"][0m 2.53ms]
  1506.  
  1507. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"196609"][0m 2.09ms]
  1508.  
  1509. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=?,`hrProcessorLoad`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceProcessor","","running",0,"1",62,"196609"][0m 2.51ms]
  1510.  
  1511. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"196610"][0m 2.12ms]
  1512.  
  1513. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=?,`hrProcessorLoad`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceProcessor","","running",0,"0",62,"196610"][0m 2.43ms]
  1514.  
  1515. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"196611"][0m 2.04ms]
  1516.  
  1517. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=?,`hrProcessorLoad`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceProcessor","","running",0,"3",62,"196611"][0m 2.06ms]
  1518.  
  1519. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262145"][0m 1.98ms]
  1520.  
  1521. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface lo","running","0",62,"262145"][0m 2.4ms]
  1522.  
  1523. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262146"][0m 1.99ms]
  1524.  
  1525. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface ip_vti0","down","0",62,"262146"][0m 2.43ms]
  1526.  
  1527. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262147"][0m 2.07ms]
  1528.  
  1529. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface sit0","down","0",62,"262147"][0m 2.39ms]
  1530.  
  1531. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262148"][0m 1.95ms]
  1532.  
  1533. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface ip6tnl0","down","0",62,"262148"][0m 2.38ms]
  1534.  
  1535. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262149"][0m 1.9ms]
  1536.  
  1537. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface lan_int2_if","down","0",62,"262149"][0m 2.48ms]
  1538.  
  1539. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262150"][0m 2.09ms]
  1540.  
  1541. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface eth0","running","0",62,"262150"][0m 2.48ms]
  1542.  
  1543. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262151"][0m 2.05ms]
  1544.  
  1545. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface eth0.1","running","0",62,"262151"][0m 2.5ms]
  1546.  
  1547. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262152"][0m 2.03ms]
  1548.  
  1549. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface eth0.2","running","0",62,"262152"][0m 2.59ms]
  1550.  
  1551. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262154"][0m 2.09ms]
  1552.  
  1553. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface br0","running","0",62,"262154"][0m 2.35ms]
  1554.  
  1555. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262155"][0m 2.09ms]
  1556.  
  1557. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface wan_int2_if","down","0",62,"262155"][0m 2.54ms]
  1558.  
  1559. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262156"][0m 2.09ms]
  1560.  
  1561. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface ptm0","running","2048",62,"262156"][0m 2.45ms]
  1562.  
  1563. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"262157"][0m 2.07ms]
  1564.  
  1565. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceNetwork","network interface ptm1","down","2048",62,"262157"][0m 2.58ms]
  1566.  
  1567. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"327680"][0m 2.18ms]
  1568.  
  1569. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDevicePrinter","such file or directory","unknown","0",62,"327680"][0m 2.46ms]
  1570.  
  1571. .SQL[[1;33mSELECT COUNT(*) FROM `hrDevice` WHERE device_id = ? AND hrDeviceIndex = ? [0;33m[62,"786432"][0m 2.18ms]
  1572.  
  1573. SQL[[1;33mUPDATE `hrDevice` set `hrDeviceType`=?,`hrDeviceDescr`=?,`hrDeviceStatus`=?,`hrDeviceErrors`=? WHERE device_id=? AND hrDeviceIndex=? [0;33m["hrDeviceCoprocessor","Guessing that there's a floating point co-processor","unknown",0,62,"786432"][0m 2.39ms]
  1574.  
  1575. .SQL[[1;33mSELECT * FROM `hrDevice` WHERE `device_id`  = '62' [0;33m[][0m 2.25ms]
  1576.  
  1577.  
  1578.  
  1579. >> Runtime for discovery module 'hr-device': 0.5410 seconds with 44360 bytes
  1580. >> [0;36mSNMP[0m: [2/0.42s] [1;33mMySQL[0m: [37/0.83s] [0;32mRRD[0m: [0/0.00s]  
  1581. #### Unload disco module hr-device ####
  1582.  
  1583. Modules status: Global+  
  1584. OS  
  1585. Device  
  1586.  
  1587. #### Load disco module discovery-protocols ####
  1588.  LLDP-MIB: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-Os' '-t' '5' 'udp:HOSTNAME:161' 'LLDP-MIB::lldpRemTable'[0m]  
  1589. lldpRemTable = No Such Object available on this agent at this OID
  1590.  
  1591.  
  1592.  
  1593.  OSPF Discovery: SQL[[1;33mSELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`=? [0;33m[62][0m 2.2ms]
  1594.  
  1595.  
  1596.  
  1597. SQL[[1;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [0;33m[62][0m 3.92ms]
  1598.  
  1599. SQL[[1;33mDELETE T FROM `links` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`local_device_id` WHERE `devices`.`device_id` IS NULL [0;33m[][0m 2.37ms]
  1600.  
  1601.  0 orphaned links deleted  
  1602.  
  1603. >> Runtime for discovery module 'discovery-protocols': 0.3080 seconds with 9784 bytes
  1604. >> [0;36mSNMP[0m: [1/0.29s] [1;33mMySQL[0m: [3/0.08s] [0;32mRRD[0m: [0/0.00s]  
  1605. #### Unload disco module discovery-protocols ####
  1606.  
  1607. Modules status: Global+  
  1608. OS  
  1609. Device  
  1610.  
  1611. #### Load disco module arp-table ####
  1612. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '5' 'udp:HOSTNAME:161' 'IP-MIB::ipNetToPhysicalPhysAddress'[0m]  
  1613. IP-MIB::ipNetToPhysicalPhysAddress[10][ipv4]["*"] = 14:49:bc:22:e9:e8
  1614.  
  1615.  
  1616. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '5' 'udp:HOSTNAME:161' 'IP-MIB::ipNetToMediaPhysAddress'[0m]  
  1617. IP-MIB::ipNetToMediaPhysAddress[10][*] = 14:49:bc:22:e9:e8
  1618.  
  1619.  
  1620. SQL[[1;33mSELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [0;33m[62,""][0m 2.23ms]
  1621.  
  1622. SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[62,10][0m 3.36ms]
  1623.  
  1624. br0:
  1625. 14:49:bc:22:e9:e8 => 192.168.2.100  
  1626.  
  1627. SQL[[1;33mDELETE 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 [0;33m[][0m 5.07ms]
  1628.  
  1629.  
  1630.  
  1631. >> Runtime for discovery module 'arp-table': 0.4080 seconds with 24064 bytes
  1632. >> [0;36mSNMP[0m: [2/0.39s] [1;33mMySQL[0m: [3/0.11s] [0;32mRRD[0m: [0/0.00s]  
  1633. #### Unload disco module arp-table ####
  1634.  
  1635. Modules status: Global-  
  1636. OS  
  1637. Device  
  1638. Module [ discovery-arp ] disabled globally.
  1639.  
  1640. Modules status: Global-  
  1641. OS  
  1642. Device  
  1643. Module [ junose-atm-vp ] disabled globally.
  1644.  
  1645. Modules status: Global-  
  1646. OS  
  1647. Device  
  1648. Module [ bgp-peers ] disabled globally.
  1649.  
  1650. Modules status: Global+  
  1651. OS  
  1652. Device  
  1653.  
  1654. #### Load disco module vlans ####
  1655. SQL[[1;33mSELECT * FROM `vlans` WHERE `device_id` = ? [0;33m[62][0m 2.18ms]
  1656.  
  1657. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'BRIDGE-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'dot1dBasePortIfIndex'[0m]
  1658. dot1dBasePortIfIndex = No Such Object available on this agent at this OID  
  1659.  
  1660. Invalid snmp_walk() data = dot1dBasePortIfIndex = No Such Object available on this agent at this OID  
  1661. IEEE8021-Q-BRIDGE-MIB VLANs: SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Oqv' '-m' 'IEEE8021-Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'dot1qVlanVersionNumber.0'[0m]
  1662. No Such Object available on this agent at this OID  
  1663.  
  1664.  
  1665.  
  1666. >> Runtime for discovery module 'vlans': 0.5040 seconds with 5112 bytes
  1667. >> [0;36mSNMP[0m: [2/0.50s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s]  
  1668. #### Unload disco module vlans ####
  1669.  
  1670. Modules status: Global-  
  1671. OS  
  1672. Device  
  1673. Module [ vminfo ] disabled globally.
  1674.  
  1675. Modules status: Global-  
  1676. OS  
  1677. Device  
  1678. Module [ printer-supplies ] disabled globally.
  1679.  
  1680. Modules status: Global+  
  1681. OS  
  1682. Device  
  1683.  
  1684. #### Load disco module ucd-diskio ####
  1685. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-DISKIO-MIB' '-M' '/opt/librenms/mibs' '-t' '5' 'udp:HOSTNAME:161' 'diskIOEntry'[0m]
  1686. diskIOEntry = No Such Object available on this agent at this OID  
  1687.  
  1688. Invalid snmp_walk() data = diskIOEntry = No Such Object available on this agent at this OID  
  1689. array (
  1690. )  
  1691. SQL[[1;33mSELECT * FROM `ucd_diskio` where `device_id`  = '62' [0;33m[][0m 2.21ms]
  1692.  
  1693.  
  1694.  
  1695. >> Runtime for discovery module 'ucd-diskio': 0.1850 seconds with 1872 bytes
  1696. >> [0;36mSNMP[0m: [1/0.18s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s]  
  1697. #### Unload disco module ucd-diskio ####
  1698.  
  1699. Modules status: Global-  
  1700. OS  
  1701. Device  
  1702. Module [ applications ] disabled globally.
  1703.  
  1704. Modules status: Global+  
  1705. OS  
  1706. Device  
  1707.  
  1708. #### Load disco module services ####
  1709.  
  1710. >> Runtime for discovery module 'services': 0.0000 seconds with 576 bytes
  1711. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s]  
  1712. #### Unload disco module services ####
  1713.  
  1714. Modules status: Global+  
  1715. OS  
  1716. Device  
  1717.  
  1718. #### Load disco module stp ####
  1719. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '5' 'udp:HOSTNAME:161' 'BRIDGE-MIB::dot1dStpProtocolSpecification.0'[0m]  
  1720. BRIDGE-MIB::dot1dStpProtocolSpecification.0 = No Such Object available on this agent at this OID
  1721.  
  1722.  
  1723. Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[62][0m 2.67ms]
  1724.  
  1725.  
  1726. Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[62][0m 2.3ms]
  1727.  
  1728.  
  1729.  
  1730. >> Runtime for discovery module 'stp': 0.2080 seconds with 38640 bytes
  1731. >> [0;36mSNMP[0m: [1/0.20s] [1;33mMySQL[0m: [2/0.05s] [0;32mRRD[0m: [0/0.00s]  
  1732. #### Unload disco module stp ####
  1733.  
  1734. Modules status: Global+  
  1735. OS  
  1736. Device  
  1737.  
  1738. #### Load disco module ntp ####
  1739.  
  1740. >> Runtime for discovery module 'ntp': 0.0000 seconds with 192 bytes
  1741. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s]  
  1742. #### Unload disco module ntp ####
  1743.  
  1744. Modules status: Global-  
  1745. OS  
  1746. Device  
  1747. Module [ loadbalancers ] disabled globally.
  1748.  
  1749. Modules status: Global-  
  1750. OS  
  1751. Device  
  1752. Module [ mef ] disabled globally.
  1753.  
  1754. Modules status: Global+  
  1755. OS  
  1756. Device  
  1757.  
  1758. #### Load disco module wireless ####
  1759. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"ap-count"][0m 3.04ms]
  1760.  
  1761. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"clients"][0m 2.87ms]
  1762.  
  1763. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"quality"][0m 2.79ms]
  1764.  
  1765. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"capacity"][0m 3.07ms]
  1766.  
  1767. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"utilization"][0m 3.09ms]
  1768.  
  1769. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"rate"][0m 3.01ms]
  1770.  
  1771. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"ccq"][0m 3.05ms]
  1772.  
  1773. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"snr"][0m 3.07ms]
  1774.  
  1775. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"sinr"][0m 3.07ms]
  1776.  
  1777. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"rsrp"][0m 3ms]
  1778.  
  1779. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"rsrq"][0m 3.06ms]
  1780.  
  1781. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"ssr"][0m 3.12ms]
  1782.  
  1783. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"mse"][0m 3.11ms]
  1784.  
  1785. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"xpi"][0m 3.01ms]
  1786.  
  1787. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"rssi"][0m 3.17ms]
  1788.  
  1789. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"power"][0m 3.13ms]
  1790.  
  1791. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"noise-floor"][0m 3.03ms]
  1792.  
  1793. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"errors"][0m 3.07ms]
  1794.  
  1795. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"error-ratio"][0m 3.01ms]
  1796.  
  1797. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"error-rate"][0m 3.01ms]
  1798.  
  1799. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"frequency"][0m 3.23ms]
  1800.  
  1801. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"distance"][0m 3.15ms]
  1802.  
  1803. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"cell"][0m 3.1ms]
  1804.  
  1805. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[62,"channel"][0m 2.98ms]
  1806.  
  1807.  
  1808. >> Runtime for discovery module 'wireless': 0.1090 seconds with 114720 bytes
  1809. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [24/0.73s] [0;32mRRD[0m: [0/0.00s]  
  1810. #### Unload disco module wireless ####
  1811.  
  1812. Modules status: Global-  
  1813. OS  
  1814. Device  
  1815. Module [ fdb-table ] disabled globally.
  1816.  
  1817. Modules status: Global+  
  1818. OS  
  1819. Device  
  1820.  
  1821. #### Load disco module mpls ####
  1822.  
  1823. >> Runtime for discovery module 'mpls': 0.0010 seconds with 33720 bytes
  1824. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s]  
  1825. #### Unload disco module mpls ####
  1826.  
  1827. SQL[[1;33mupdate `devices` set `last_discovered_timetaken` = ?, `last_discovered` = NOW() where `device_id` = ? [0;33m[10.153,62][0m 26.7ms]
  1828.  
  1829. Discovered in 10.153 seconds
  1830.  
  1831. ./discovery.php 192.168.2.1 2023-12-02 13:33:48 - 1 devices discovered in 11.57 secs  
  1832.  
  1833. [0;36mSNMP[0m [34/6.93s]: Snmpget[11/2.08s] Snmpwalk[23/4.85s]  
  1834. [1;33mSQL[0m [187/6.21s]: Select[138/4.09s] Update[37/1.16s] Insert[5/0.48s] Delete[7/0.48s]  
  1835. [0;32mRRD[0m [0/0.00s]:  
  1836.