From stephen, 6 Years ago, written in Plain Text.
Embed
  1. LibreNMS Discovery
  2. ===================================
  3. Version info:
  4. Commit SHA: fbca432296d93ca3d0ff094acabdb0d216e58cf3
  5. Commit Date: 1516607148
  6. DB Schema: 230
  7. PHP: 7.0.25
  8. MySQL: 10.1.30-MariaDB
  9. RRDTool: 1.7.0
  10. SNMP: NET-SNMP 5.7.2
  11. ==================================DEBUG!
  12. Updating os_def.cache... Done
  13. SQL[[0;33mSELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE 'nvr.secureconsult.com.au' ORDER BY device_id DESC[0m]
  14. SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '10'[0m]
  15. nvr.secureconsult.com.au 10 generic SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','7.82','9.22','8.60','10',NOW())[0m]
  16. SNMP Check response code: 0
  17. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0[0m]
  18. DH-NVR4108HS-8P-4KS2
  19.  
  20. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovqn -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0[0m]
  21. .*.4.1.10048*
  22.  
  23. | DH-NVR4108HS-8P-4KS2 | .1.3.6.1.4.1.1004849.3.2.10 |
  24. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.12148.10.2.6.0[0m]
  25.  
  26. SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '10' AND `attrib_type` = 'poll_mib' [0m]
  27.  
  28. Modules status: Global+ OS  Device  
  29. #### Load disco module core ####
  30. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OUQn -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysName.0 sysObjectID.0 sysDescr.0[0m]
  31. .*.*.0 = (none)
  32. .*.*.0 = .*.4.1.10048*
  33. .*.*.0 = DH-NVR4108HS-8P-4KS2
  34.  
  35.  
  36. >> Runtime for discovery module 'core': 0.0170 seconds with 1040 bytes
  37. >> SNMP: [5/0.11s] MySQL: [8/0.04s] RRD: [0/0.00s]
  38. #### Unload disco module core ####
  39.  
  40. Modules status: Global+ OS+ Device  
  41. #### Load disco module os ####
  42. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0[0m]
  43. DH-NVR4108HS-8P-4KS2
  44.  
  45. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovqn -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0[0m]
  46. .*.4.1.10048*
  47.  
  48. | DH-NVR4108HS-8P-4KS2 | .1.3.6.1.4.1.1004849.3.2.10 |
  49. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.12148.10.2.6.0[0m]
  50.  
  51. OS: Generic Device (generic)
  52.  
  53. >> Runtime for discovery module 'os': 0.0770 seconds with 1336 bytes
  54. >> SNMP: [3/0.08s] MySQL: [0/0.00s] RRD: [0/0.00s]
  55. #### Unload disco module os ####
  56.  
  57. Modules status: Global+ OS+ Device  
  58. #### Load disco module ports ####
  59. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifDescr[0m]
  60. ifDescr.1 = lo
  61. ifDescr.2 = eth0
  62.  
  63. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifName[0m]
  64.  
  65. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifAlias[0m]
  66.  
  67. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifType[0m]
  68. ifType.1 = softwareLoopback
  69. ifType.2 = ethernetCsmacd
  70.  
  71. Array
  72. (
  73.     [1] => Array
  74.         (
  75.             [ifDescr] => lo
  76.             [ifType] => softwareLoopback
  77.         )
  78.  
  79.     [2] => Array
  80.         (
  81.             [ifDescr] => eth0
  82.             [ifType] => ethernetCsmacd
  83.         )
  84.  
  85. )
  86. SQL[[0;33mSELECT `name` FROM `port_association_mode` WHERE pom_id = '1'[0m]
  87. SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '10' ORDER BY port_id[0m]
  88. ..
  89.  
  90. >> Runtime for discovery module 'ports': 0.0980 seconds with 4288 bytes
  91. >> SNMP: [4/0.10s] MySQL: [2/0.00s] RRD: [0/0.00s]
  92. #### Unload disco module ports ####
  93.  
  94. Modules status: Global+ OS+ Device  
  95. #### Load disco module ports-stack ####
  96. SQL[[0;33mSELECT * FROM `ports_stack` WHERE `device_id` = '10'[0m]
  97. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY  -OQUs -M /opt/librenms/mibs udp:HOSTNAME:161 ifStackStatus[0m]
  98.  
  99.  
  100.  
  101. >> Runtime for discovery module 'ports-stack': 0.0290 seconds with 1768 bytes
  102. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  103. #### Unload disco module ports-stack ####
  104.  
  105. Modules status: Global+ OS+ Device  
  106. #### Load disco module entity-physical ####
  107.  
  108. Caching OIDs: entPhysicalEntrySNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 entPhysicalEntry[0m]
  109.  
  110.  
  111. SQL[[0;33mSELECT * FROM `entPhysical` WHERE `device_id` = '10'[0m]
  112.  
  113. >> Runtime for discovery module 'entity-physical': 0.1100 seconds with 5184 bytes
  114. >> SNMP: [1/0.11s] MySQL: [1/0.00s] RRD: [0/0.00s]
  115. #### Unload disco module entity-physical ####
  116.  
  117. Modules status: Global- OS- Device  Module [ entity-state ] disabled on os.
  118.  
  119. Modules status: Global+ OS+ Device  
  120. #### Load disco module processors ####
  121.  hrDevice: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs udp:HOSTNAME:161 hrDevice[0m]
  122.  
  123. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs udp:HOSTNAME:161 hrProcessorLoad[0m]
  124.  
  125. SQL[[0;33mSELECT COUNT(*) FROM `processors` WHERE `device_id` = '10' AND `processor_type` != 'ucd-old'[0m]
  126. SQL[[0;33mSELECT * FROM `processors` WHERE `device_id`  = '10'[0m]
  127.  
  128.  
  129. >> Runtime for discovery module 'processors': 0.0430 seconds with 50256 bytes
  130. >> SNMP: [2/0.04s] MySQL: [2/0.00s] RRD: [0/0.00s]
  131. #### Unload disco module processors ####
  132.  
  133. Modules status: Global+ OS+ Device  
  134. #### Load disco module mempools ####
  135. SQL[[0;33mSELECT COUNT(*) FROM `mempools` WHERE `device_id` = '10' AND `mempool_type` = 'cemp'[0m]
  136. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETSWITCH-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/hp udp:HOSTNAME:161 hpLocal[0m]
  137.  
  138. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETSWITCH-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/hp udp:HOSTNAME:161 hpGlobal[0m]
  139.  
  140. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES:NetWare-Host-Ext-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 hrStorageEntry[0m]
  141.  
  142. SQL[[0;33mSELECT * FROM `mempools` WHERE `device_id`  = '10'[0m]
  143.  
  144.  
  145. >> Runtime for discovery module 'mempools': 0.2920 seconds with 21088 bytes
  146. >> SNMP: [3/0.29s] MySQL: [2/0.00s] RRD: [0/0.00s]
  147. #### Unload disco module mempools ####
  148.  
  149. Modules status: Global+ OS+ Device  
  150. #### Load disco module cisco-vrf-lite ####
  151. SQL[[0;33mSELECT * FROM vrf_lite_cisco WHERE device_id = '10' [0m]
  152.  
  153. >> Runtime for discovery module 'cisco-vrf-lite': 0.0000 seconds with 2696 bytes
  154. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  155. #### Unload disco module cisco-vrf-lite ####
  156.  
  157. Modules status: Global- OS- Device  Module [ cisco-mac-accounting ] disabled on os.
  158.  
  159. Modules status: Global- OS- Device  Module [ cisco-pw ] disabled on os.
  160.  
  161. Modules status: Global- OS- Device  Module [ vrf ] disabled on os.
  162.  
  163. Modules status: Global- OS- Device  Module [ cisco-cef ] disabled on os.
  164.  
  165. Modules status: Global- OS- Device  Module [ cisco-sla ] disabled on os.
  166.  
  167. Modules status: Global- OS- Device  Module [ cisco-cbqos ] disabled on os.
  168.  
  169. Modules status: Global- OS- Device  Module [ cisco-otv ] disabled on os.
  170.  
  171. Modules status: Global+ OS+ Device  
  172. #### Load disco module ipv4-addresses ####
  173. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Osq -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntIfIndex[0m]
  174. ipAdEntIfIndex.* 2
  175. ipAdEntIfIndex.* 1
  176. ipAdEntIfIndex.* 2
  177.  
  178. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntNetMask.10.1.1.1[0m]
  179. *
  180.  
  181. SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE device_id = '10' AND `ifIndex` = '2'[0m]
  182. SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '10' AND `ifIndex` = '2'[0m]
  183. SQL[[0;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = '10.1.1.1/24'[0m]
  184. SQL[[0;33mUPDATE `ipv4_networks` set `context_name` ='' WHERE `ipv4_network` = '10.1.1.1/24'[0m]
  185. sSQL[[0;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.1.1.1/24'[0m]
  186. SQL[[0;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = '10.1.1.1' AND `ipv4_prefixlen` = '24' AND `port_id` = '2' [0m]
  187. SQL[[0;33mUPDATE `ipv4_addresses` set `context_name` ='' WHERE `ipv4_address` = '10.1.1.1' AND `ipv4_prefixlen` = '24' AND `port_id` = '2'[0m]
  188. .SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntNetMask.127.0.0.1[0m]
  189. *
  190.  
  191. SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE device_id = '10' AND `ifIndex` = '1'[0m]
  192. SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '10' AND `ifIndex` = '1'[0m]
  193. SQL[[0;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = '127.0.0.1/8'[0m]
  194. SQL[[0;33mUPDATE `ipv4_networks` set `context_name` ='' WHERE `ipv4_network` = '127.0.0.1/8'[0m]
  195. sSQL[[0;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '127.0.0.1/8'[0m]
  196. SQL[[0;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = '127.0.0.1' AND `ipv4_prefixlen` = '8' AND `port_id` = '1' [0m]
  197. SQL[[0;33mUPDATE `ipv4_addresses` set `context_name` ='' WHERE `ipv4_address` = '127.0.0.1' AND `ipv4_prefixlen` = '8' AND `port_id` = '1'[0m]
  198. .SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntNetMask.192.168.1.2[0m]
  199. *
  200.  
  201. SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE device_id = '10' AND `ifIndex` = '2'[0m]
  202. SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '10' AND `ifIndex` = '2'[0m]
  203. SQL[[0;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = '192.168.1.2/24'[0m]
  204. SQL[[0;33mUPDATE `ipv4_networks` set `context_name` ='' WHERE `ipv4_network` = '192.168.1.2/24'[0m]
  205. sSQL[[0;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '192.168.1.2/24'[0m]
  206. SQL[[0;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = '192.168.1.2' AND `ipv4_prefixlen` = '24' AND `port_id` = '2' [0m]
  207. SQL[[0;33mUPDATE `ipv4_addresses` set `context_name` ='' WHERE `ipv4_address` = '192.168.1.2' AND `ipv4_prefixlen` = '24' AND `port_id` = '2'[0m]
  208. .SQL[[0;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 = '10' OR `ports`.`device_id` IS NULL[0m]
  209.  
  210.  
  211. >> Runtime for discovery module 'ipv4-addresses': 0.3340 seconds with 34928 bytes
  212. >> SNMP: [4/0.09s] MySQL: [22/0.24s] RRD: [0/0.00s]
  213. #### Unload disco module ipv4-addresses ####
  214.  
  215. Modules status: Global+ OS+ Device  
  216. #### Load disco module ipv6-addresses ####
  217. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Ln -Osq -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAddressIfIndex.ipv6[0m]
  218.  
  219. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Ln -Osq -OnU -m IPV6-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipv6AddrPfxLength[0m]
  220.  
  221. SQL[[0;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 = '10' OR `ports`.`device_id` IS NULL[0m]
  222.  
  223.  
  224. >> Runtime for discovery module 'ipv6-addresses': 0.1380 seconds with 3368 bytes
  225. >> SNMP: [2/0.14s] MySQL: [1/0.00s] RRD: [0/0.00s]
  226. #### Unload disco module ipv6-addresses ####
  227.  
  228. Modules status: Global- OS- Device  Module [ route ] disabled on os.
  229.  
  230. Modules status: Global+ OS+ Device  
  231. #### Load disco module sensors ####
  232.  ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m CISCO-ENTITY-SENSOR-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 entPhysicalDescr[0m]
  233.  
  234.  
  235. SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '10' AND `attrib_type` = 'ipmi_hostname' [0m]
  236. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'ipmi'[0m]
  237. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'ipmi'[0m]
  238. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'ipmi'[0m]
  239. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'ipmi'[0m]
  240. Airflow: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='airflow' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  241.  
  242. Current: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='current' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  243.  
  244. Charge: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='charge' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  245.  
  246. Dbm: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='dbm' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  247.  
  248. Fanspeed: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  249.  
  250. Frequency: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='frequency' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  251.  
  252. Humidity: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='humidity' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  253.  
  254. Load: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='load' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  255.  
  256. Power: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  257.  
  258. Runtime: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='runtime' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  259.  
  260. Signal: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='signal' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  261.  
  262. State: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='state' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  263.  
  264. Temperature: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  265.  
  266. Voltage: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  267.  
  268. Snr: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='snr' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  269.  
  270. Pressure: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='pressure' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  271.  
  272. Cooling: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='cooling' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  273.  
  274. Delay: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='delay' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  275.  
  276. Quality_factor: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='quality_factor' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  277.  
  278. Chromatic_dispersion: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='chromatic_dispersion' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  279.  
  280. Ber: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='ber' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  281.  
  282. Eer: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='eer' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  283.  
  284. Waterflow: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='waterflow' AND S.device_id = D.device_id AND D.device_id = '10' AND S.poller_type = 'snmp'[0m]
  285.  
  286.  
  287. >> Runtime for discovery module 'sensors': 0.1140 seconds with 16520 bytes
  288. >> SNMP: [1/0.10s] MySQL: [28/0.01s] RRD: [0/0.00s]
  289. #### Unload disco module sensors ####
  290.  
  291. Modules status: Global+ OS+ Device  
  292. #### Load disco module storage ####
  293. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m EQLVOLUME-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/equallogic udp:HOSTNAME:161 EqliscsiVolumeEntry[0m]
  294.  
  295. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m CPQHOST-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/hp udp:HOSTNAME:161 cpqHoFileSysEntry[0m]
  296.  
  297. HPE ILO4 SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES:NetWare-Host-Ext-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 hrStorageEntry[0m]
  298.  
  299. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETAPP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dfEntry[0m]
  300.  
  301. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dskTable[0m]
  302.  
  303. SQL[[0;33mSELECT `storage_descr` FROM `storage` WHERE `device_id`  = '10' AND `storage_type` != 'dsk'[0m]
  304. SQL[[0;33mSELECT * FROM `storage` WHERE `device_id`  = '10'[0m]
  305.  
  306.  
  307. >> Runtime for discovery module 'storage': 0.5570 seconds with 6608 bytes
  308. >> SNMP: [4/0.44s] MySQL: [2/0.00s] RRD: [0/0.00s]
  309. #### Unload disco module storage ####
  310.  
  311. Modules status: Global+ OS+ Device  
  312. #### Load disco module hr-device ####
  313. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs udp:HOSTNAME:161 hrDeviceEntry[0m]
  314.  
  315. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs udp:HOSTNAME:161 hrProcessorEntry[0m]
  316.  
  317. Array
  318. (
  319. )
  320. SQL[[0;33mSELECT * FROM `hrDevice` WHERE `device_id`  = '10'[0m]
  321.  
  322.  
  323. >> Runtime for discovery module 'hr-device': 0.0500 seconds with 3056 bytes
  324. >> SNMP: [2/0.05s] MySQL: [1/0.00s] RRD: [0/0.00s]
  325. #### Unload disco module hr-device ####
  326.  
  327. Modules status: Global+ OS+ Device  
  328. #### Load disco module discovery-protocols ####
  329.  CISCO-CDP-MIB: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m CISCO-CDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 cdpCache[0m]
  330.  
  331.  
  332.  LLDP-MIB: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m LLDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 lldpRemTable[0m]
  333.  
  334.  
  335.  OSPF Discovery: SQL[[0;33mSELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`='10'[0m]
  336.  
  337. SQL[[0;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = '10'[0m]
  338. SQL[[0;33mDELETE T FROM `links` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`local_device_id` WHERE `devices`.`device_id` IS NULL[0m]
  339.  0 orphaned links deleted
  340.  
  341. >> Runtime for discovery module 'discovery-protocols': 0.1550 seconds with 4720 bytes
  342. >> SNMP: [0/0.00s] MySQL: [3/0.00s] RRD: [0/0.00s]
  343. #### Unload disco module discovery-protocols ####
  344.  
  345. Modules status: Global+ OS+ Device  
  346. #### Load disco module arp-table ####
  347. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipNetToPhysicalPhysAddress[0m]
  348.  
  349. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipNetToMediaPhysAddress[0m]
  350. ipNetToMediaPhysAddress[2][*] = e0:50:8b:14:9:f3
  351. ipNetToMediaPhysAddress[2][*] = e0:50:8b:14:c:2c
  352. ipNetToMediaPhysAddress[2][*] = e0:50:8b:14:b:c5
  353. ipNetToMediaPhysAddress[2][*] = e0:50:8b:14:8:ec
  354. ipNetToMediaPhysAddress[2][*] = e0:50:8b:14:c:29
  355. ipNetToMediaPhysAddress[2][*] = e0:50:8b:14:a:d6
  356. ipNetToMediaPhysAddress[2][*] = e0:50:8b:14:c:a2
  357. ipNetToMediaPhysAddress[2][*] = e0:50:8b:14:e:36
  358. ipNetToMediaPhysAddress[2][*] = 44:d9:e7:7:55:cc
  359.  
  360. SQL[[0;33mSELECT * from `ipv4_mac` WHERE `device_id`='10' AND `context_name`=''[0m]
  361. SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '10' AND `ifIndex` = '2'[0m]
  362. eth0:
  363. e0:50:8b:14:9:f3 => 10.1.1.65
  364. e0:50:8b:14:c:2c => 10.1.1.66
  365. e0:50:8b:14:b:c5 => 10.1.1.67
  366. e0:50:8b:14:8:ec => 10.1.1.68
  367. e0:50:8b:14:c:29 => 10.1.1.69
  368. e0:50:8b:14:a:d6 => 10.1.1.70
  369. e0:50:8b:14:c:a2 => 10.1.1.71
  370. e0:50:8b:14:e:36 => 10.1.1.72
  371. 44:d9:e7:7:55:cc => 192.168.1.1
  372.  
  373. SQL[[0;33mINSERT INTO `ipv4_mac` (`port_id`,`device_id`,`mac_address`,`ipv4_address`,`context_name`)  VALUES ('2','10','e0508b1409f3','10.1.1.65',NULL),('2','10','e0508b140c2c','10.1.1.66',NULL),('2','10','e0508b140bc5','10.1.1.67',NULL),('2','10','e0508b1408ec','10.1.1.68',NULL),('2','10','e0508b140c29','10.1.1.69',NULL),('2','10','e0508b140ad6','10.1.1.70',NULL),('2','10','e0508b140ca2','10.1.1.71',NULL),('2','10','e0508b140e36','10.1.1.72',NULL),('2','10','44d9e70755cc','192.168.1.1',NULL)[0m]
  374. SQL[[0;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[0m]
  375.  
  376.  
  377. >> Runtime for discovery module 'arp-table': 0.1770 seconds with 18080 bytes
  378. >> SNMP: [0/0.00s] MySQL: [4/0.06s] RRD: [0/0.00s]
  379. #### Unload disco module arp-table ####
  380.  
  381. Modules status: Global- OS- Device  Module [ discovery-arp ] disabled on os.
  382.  
  383. Modules status: Global- OS- Device  Module [ junose-atm-vp ] disabled on os.
  384.  
  385. Modules status: Global+ OS+ Device  
  386. #### Load disco module bgp-peers ####
  387. SNMP[[0;36m/usr/bin/snmpgetnext -v1 -c COMMUNITY -Oqvn -m BGP4-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 bgpLocalAs[0m]
  388. 0:0:00:00.00
  389.  
  390. No BGP on hostPeers :
  391. SQL[[0;33mSELECT * FROM bgpPeers WHERE device_id = '10' AND (context_name = '' OR context_name IS NULL)[0m]
  392.  
  393.  
  394. >> Runtime for discovery module 'bgp-peers': 0.0210 seconds with 5032 bytes
  395. >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s]
  396. #### Unload disco module bgp-peers ####
  397.  
  398. Modules status: Global+ OS+ Device  
  399. #### Load disco module vlans ####
  400. SQL[[0;33mSELECT * FROM `vlans` WHERE `device_id` = '10'[0m]
  401. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dBasePortIfIndex[0m]
  402.  
  403. IEEE8021-Q-BRIDGE-MIB VLANs: SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IEEE8021-Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qVlanVersionNumber.0[0m]
  404.  
  405.  
  406.  
  407. >> Runtime for discovery module 'vlans': 0.0490 seconds with 6864 bytes
  408. >> SNMP: [2/0.05s] MySQL: [1/0.00s] RRD: [0/0.00s]
  409. #### Unload disco module vlans ####
  410.  
  411. Modules status: Global- OS- Device  Module [ vmware-vminfo ] disabled on os.
  412.  
  413. Modules status: Global- OS- Device  Module [ libvirt-vminfo ] disabled on os.
  414.  
  415. Modules status: Global- OS- Device  Module [ toner ] disabled on os.
  416.  
  417. Modules status: Global+ OS+ Device  
  418. #### Load disco module ucd-diskio ####
  419. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-DISKIO-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 diskIOEntry[0m]
  420.  
  421. Array
  422. (
  423. )
  424. SQL[[0;33mSELECT * FROM `ucd_diskio` where `device_id`  = '10'[0m]
  425.  
  426.  
  427. >> Runtime for discovery module 'ucd-diskio': 0.1260 seconds with 2992 bytes
  428. >> SNMP: [1/0.13s] MySQL: [1/0.00s] RRD: [0/0.00s]
  429. #### Unload disco module ucd-diskio ####
  430.  
  431. Modules status: Global- OS- Device  Module [ applications ] disabled on os.
  432.  
  433. Modules status: Global+ OS+ Device  
  434. #### Load disco module services ####
  435.  
  436. >> Runtime for discovery module 'services': 0.0000 seconds with 328 bytes
  437. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  438. #### Unload disco module services ####
  439.  
  440. Modules status: Global+ OS+ Device  
  441. #### Load disco module stp ####
  442. SQL[[0;33mSELECT * FROM `stp` WHERE `device_id` = '10'[0m]
  443. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dStpProtocolSpecification.0[0m]
  444.  
  445.  
  446.  
  447. >> Runtime for discovery module 'stp': 0.0210 seconds with 5904 bytes
  448. >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s]
  449. #### Unload disco module stp ####
  450.  
  451. Modules status: Global+ OS+ Device  
  452. #### Load disco module ntp ####
  453.  
  454. >> Runtime for discovery module 'ntp': 8.7020 seconds with 144 bytes
  455. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  456. #### Unload disco module ntp ####
  457.  
  458. Modules status: Global- OS- Device  Module [ loadbalancers ] disabled on os.
  459.  
  460. Modules status: Global- OS- Device  Module [ mef ] disabled on os.
  461.  
  462. Modules status: Global+ OS+ Device  
  463. #### Load disco module wireless ####
  464. Attempting to initialize OS: generic
  465. OS initialized: LibreNMS\OS\Generic
  466. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='ap-count'[0m]
  467. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='clients'[0m]
  468. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='quality'[0m]
  469. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='capacity'[0m]
  470. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='utilization'[0m]
  471. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='rate'[0m]
  472. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='ccq'[0m]
  473. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='snr'[0m]
  474. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='ssr'[0m]
  475. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='mse'[0m]
  476. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='rssi'[0m]
  477. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='power'[0m]
  478. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='noise-floor'[0m]
  479. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='error-ratio'[0m]
  480. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='error-rate'[0m]
  481. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='frequency'[0m]
  482. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='10' AND `sensor_class`='distance'[0m]
  483.  
  484. >> Runtime for discovery module 'wireless': 0.0050 seconds with 202632 bytes
  485. >> SNMP: [0/0.00s] MySQL: [17/0.00s] RRD: [0/0.00s]
  486. #### Unload disco module wireless ####
  487.  
  488. Modules status: Global+ OS+ Device  
  489. #### Load disco module fdb-table ####
  490. SQL[[0;33mSELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = '10'[0m]
  491. SQL[[0;33mSELECT * FROM `ports_fdb` WHERE `device_id` = '10'[0m]
  492. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qTpFdbPort[0m]
  493.  
  494. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dTpFdbPort[0m]
  495.  
  496.  
  497.  
  498. >> Runtime for discovery module 'fdb-table': 0.0540 seconds with 2464 bytes
  499. >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s]
  500. #### Unload disco module fdb-table ####
  501.  
  502. SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '10' AND `attrib_type` = 'poll_mib' [0m]
  503. SQL[[0;33mUPDATE `devices` set `last_discovered` =NOW(),`last_discovered_timetaken` ='3.626' WHERE `device_id` = '10'[0m]
  504. Discovered in 3.626 seconds
  505.  
  506. SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('discover','nvr.secureconsult.com.au','1516695752.357','3.775','1','family.secureconsult.com.au')[0m]
  507. ./discovery.php nvr.secureconsult.com.au 2018-01-23 19:22:36 - 1 devices discovered in 3.775 secs
  508. SNMP [36/1.76s]: Get[13/0.28s] Getnext[1/0.02s] Walk[22/1.45s]
  509. MySQL [104/0.43s]: Cell[20/0.00s] Row[5/0.00s] Rows[66/0.02s] Column[1/0.00s] Update[7/0.28s] Insert[3/0.12s] Delete[2/0.01s]
  510. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  511.