From ranchwifi1, 5 Years ago, written in Plain Text.
Embed
  1. LibreNMS Discovery
  2. SQL[[1;33mselect `version` from `dbSchema` order by `version` desc limit 1 [0;33m[][0m 0.37ms]
  3. SQL[[1;33mSELECT version() [0;33m[][0m 0.25ms]
  4. ===================================
  5. Version info:
  6. Commit SHA: 01e8a6e0896ce1916a8492e1a1219c09da10c700
  7. Commit Date: 1535060429
  8. DB Schema: 260
  9. PHP: 7.0.30-0ubuntu0.16.04.1
  10. MySQL: 10.0.34-MariaDB-0ubuntu0.16.04.1
  11. RRDTool: 1.5.5
  12. SNMP: NET-SNMP 5.7.3
  13. ==================================DEBUG!
  14. Updating os_def.cache... Done
  15. SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE '10.1.1.16' ORDER BY device_id DESC [0;33m[][0m 0.94ms]
  16. SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[150][0m 0.21ms]
  17. 10.1.1.16 150 generic [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 10.1.1.16
  18. Array
  19. (
  20.     [xmt] => 3
  21.     [rcv] => 3
  22.     [loss] => 0
  23.     [min] => 5.05
  24.     [max] => 8.71
  25.     [avg] => 6.71
  26.     [exitcode] => 0
  27. )
  28. SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW()) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"5.05","max":"8.71","avg":"6.71","device_id":150}[0m 38.38ms]
  29. SNMP Check response code: 0
  30. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0[0m]
  31. Morningstar Corporation TriStar MPPT Charge Controller SNMP Agent
  32.  
  33. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovqn -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0[0m]
  34. .*.4.1.33333
  35.  
  36. | Morningstar Corporation TriStar MPPT Charge Controller SNMP Agent | .1.3.6.1.4.1.33333 |
  37. 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]
  38.  
  39. SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [0;33m[150,"poll_mib"][0m 0.38ms]
  40. Attempting to initialize OS: generic
  41. OS initialized: LibreNMS\OS\Generic
  42.  
  43. Modules status: Global+ OS  Device  
  44. #### Load disco module core ####
  45. 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]
  46. .*.*.0 = PEMRIDGE
  47. .*.*.0 = .*.4.1.33333
  48. .*.*.0 = Morningstar Corporation TriStar MPPT Charge Controller SNMP Agent
  49.  
  50. SQL[[1;33mINSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) [0;33m{"host":150,"device_id":150,"reference":"NULL","type":"system","severity":3,"message":"sysObjectID -> .1.3.6.1.4.1.33333","username":""}[0m 53.37ms]
  51. SQL[[1;33mINSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) [0;33m{"host":150,"device_id":150,"reference":"NULL","type":"system","severity":3,"message":"sysName -> pemridge","username":""}[0m 41.99ms]
  52. SQL[[1;33mINSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) [0;33m{"host":150,"device_id":150,"reference":"NULL","type":"system","severity":3,"message":"sysDescr -> Morningstar Corporation TriStar MPPT Charge Controller SNMP Agent","username":""}[0m 36.26ms]
  53. SQL[[1;33mUPDATE `devices` set `sysObjectID`=?,`sysName`=?,`sysDescr`=? WHERE device_id=? [0;33m[".1.3.6.1.4.1.33333","pemridge","Morningstar Corporation TriStar MPPT Charge Controller SNMP Agent",150][0m 42.09ms]
  54.  
  55. >> Runtime for discovery module 'core': 0.2100 seconds with 3992 bytes
  56. >> SNMP: [5/0.12s] MySQL: [8/0.22s] RRD: [0/0.00s]
  57. #### Unload disco module core ####
  58.  
  59. Modules status: Global+ OS+ Device  
  60. #### Load disco module os ####
  61. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0[0m]
  62. Morningstar Corporation TriStar MPPT Charge Controller SNMP Agent
  63.  
  64. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovqn -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0[0m]
  65. .*.4.1.33333
  66.  
  67. | Morningstar Corporation TriStar MPPT Charge Controller SNMP Agent | .1.3.6.1.4.1.33333 |
  68. 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]
  69.  
  70. OS: Generic Device (generic)
  71.  
  72. >> Runtime for discovery module 'os': 0.0560 seconds with 1392 bytes
  73. >> SNMP: [3/0.05s] MySQL: [0/0.00s] RRD: [0/0.00s]
  74. #### Unload disco module os ####
  75.  
  76. Modules status: Global+ OS+ Device  
  77. #### Load disco module ports ####
  78. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifDescr[0m]
  79. End of MIB
  80.  
  81. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifName[0m]
  82. End of MIB
  83.  
  84. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifAlias[0m]
  85. End of MIB
  86.  
  87. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifType[0m]
  88. End of MIB
  89.  
  90. Array
  91. (
  92. )
  93. SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [0;33m[150][0m 0.95ms]
  94.  
  95.  
  96. >> Runtime for discovery module 'ports': 0.1440 seconds with 4000 bytes
  97. >> SNMP: [4/0.14s] MySQL: [1/0.00s] RRD: [0/0.00s]
  98. #### Unload disco module ports ####
  99.  
  100. Modules status: Global+ OS+ Device  
  101. #### Load disco module ports-stack ####
  102. SQL[[1;33mSELECT * FROM `ports_stack` WHERE `device_id` = '150' [0;33m[][0m 0.39ms]
  103. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY  -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifStackStatus[0m]
  104. End of MIB
  105.  
  106.  
  107.  
  108. >> Runtime for discovery module 'ports-stack': 0.0310 seconds with 1784 bytes
  109. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  110. #### Unload disco module ports-stack ####
  111.  
  112. Modules status: Global+ OS+ Device  
  113. #### Load disco module entity-physical ####
  114.  
  115. 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]
  116. End of MIB
  117.  
  118.  
  119. SQL[[1;33mSELECT * FROM `entPhysical` WHERE `device_id` = ? [0;33m[150][0m 0.99ms]
  120.  
  121. >> Runtime for discovery module 'entity-physical': 0.0550 seconds with 5216 bytes
  122. >> SNMP: [1/0.05s] MySQL: [1/0.00s] RRD: [0/0.00s]
  123. #### Unload disco module entity-physical ####
  124.  
  125. Modules status: Global- OS- Device  Module [ entity-state ] disabled on os.
  126.  
  127. Modules status: Global+ OS+ Device  
  128. #### Load disco module processors ####
  129. No YAML Discovery data.
  130. Host Resources: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 hrProcessorLoad[0m]
  131. End of MIB
  132.  
  133. UCD Resources: SQL[[1;33mSELECT `devices`.*, `lat`, `lng` FROM `devices` LEFT JOIN locations ON `devices`.`location`=`locations`.`location` WHERE `device_id` = ? [0;33m[150][0m 1.07ms]
  134. SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[150][0m 0.72ms]
  135. SQL[[1;33mSELECT * FROM `vrf_lite_cisco` WHERE `device_id` = ? [0;33m[150][0m 0.94ms]
  136. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.2021.11.11.0[0m]
  137.  
  138. SQL[[1;33mSELECT * FROM `processors` WHERE `device_id`=? [0;33m[150][0m 1.05ms]
  139. 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 3.07ms]
  140.  
  141.  
  142. >> Runtime for discovery module 'processors': 0.0610 seconds with 73408 bytes
  143. >> SNMP: [2/0.05s] MySQL: [5/0.01s] RRD: [0/0.00s]
  144. #### Unload disco module processors ####
  145.  
  146. Modules status: Global+ OS+ Device  
  147. #### Load disco module mempools ####
  148. SQL[[1;33mSELECT COUNT(*) FROM `mempools` WHERE `device_id` = ? AND `mempool_type` = 'cemp' [0;33m[150][0m 0.67ms]
  149. 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]
  150. End of MIB
  151.  
  152. 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]
  153. End of MIB
  154.  
  155. 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]
  156. End of MIB
  157.  
  158. SQL[[1;33mSELECT * FROM `mempools` WHERE `device_id`  = '150' [0;33m[][0m 0.5ms]
  159.  
  160.  
  161. >> Runtime for discovery module 'mempools': 0.1290 seconds with 28520 bytes
  162. >> SNMP: [3/0.12s] MySQL: [1/0.00s] RRD: [0/0.00s]
  163. #### Unload disco module mempools ####
  164.  
  165. Modules status: Global+ OS+ Device  
  166. #### Load disco module cisco-vrf-lite ####
  167. SQL[[1;33mSELECT * FROM vrf_lite_cisco WHERE device_id = ?  [0;33m[150][0m 0.29ms]
  168.  
  169. >> Runtime for discovery module 'cisco-vrf-lite': 0.0000 seconds with 2664 bytes
  170. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  171. #### Unload disco module cisco-vrf-lite ####
  172.  
  173. Modules status: Global- OS- Device  Module [ cisco-mac-accounting ] disabled on os.
  174.  
  175. Modules status: Global- OS- Device  Module [ cisco-pw ] disabled on os.
  176.  
  177. Modules status: Global- OS- Device  Module [ vrf ] disabled on os.
  178.  
  179. Modules status: Global- OS- Device  Module [ cisco-cef ] disabled on os.
  180.  
  181. Modules status: Global- OS- Device  Module [ cisco-sla ] disabled on os.
  182.  
  183. Modules status: Global- OS- Device  Module [ cisco-cbqos ] disabled on os.
  184.  
  185. Modules status: Global- OS- Device  Module [ cisco-otv ] disabled on os.
  186.  
  187. Modules status: Global+ OS+ Device  
  188. #### Load disco module ipv4-addresses ####
  189. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Osq -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntIfIndex[0m]
  190. End of MIB
  191.  
  192. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntNetMask.[0m]
  193.  
  194. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [0;33m[150,null][0m 0.39ms]
  195. !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[150][0m 1.23ms]
  196.  
  197.  
  198. >> Runtime for discovery module 'ipv4-addresses': 0.0560 seconds with 33504 bytes
  199. >> SNMP: [2/0.05s] MySQL: [1/0.00s] RRD: [0/0.00s]
  200. #### Unload disco module ipv4-addresses ####
  201.  
  202. Modules status: Global+ OS+ Device  
  203. #### Load disco module ipv6-addresses ####
  204. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Ln -Osq -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAddressIfIndex.ipv6[0m]
  205. End of MIB
  206.  
  207. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Ln -Osq -OnU -m IPV6-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipv6AddrPfxLength[0m]
  208. End of MIB
  209.  
  210. 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[150][0m 0.52ms]
  211.  
  212.  
  213. >> Runtime for discovery module 'ipv6-addresses': 0.0570 seconds with 3472 bytes
  214. >> SNMP: [2/0.06s] MySQL: [1/0.00s] RRD: [0/0.00s]
  215. #### Unload disco module ipv6-addresses ####
  216.  
  217. Modules status: Global- OS- Device  Module [ route ] disabled on os.
  218.  
  219. Modules status: Global+ OS+ Device  
  220. #### Load disco module sensors ####
  221.  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]
  222. End of MIB
  223.  
  224.  
  225. SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [0;33m[150,"ipmi_hostname"][0m 0.41ms]
  226. 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",150,"ipmi"][0m 0.64ms]
  227. 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",150,"ipmi"][0m 0.62ms]
  228. 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",150,"ipmi"][0m 0.66ms]
  229. 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",150,"ipmi"][0m 0.69ms]
  230. Airflow: 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",150,"snmp"][0m 0.72ms]
  231.  
  232. Current: 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",150,"snmp"][0m 0.7ms]
  233.  
  234. Charge: 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",150,"snmp"][0m 0.59ms]
  235.  
  236. Dbm: 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",150,"snmp"][0m 0.63ms]
  237.  
  238. Fanspeed: 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",150,"snmp"][0m 0.6ms]
  239.  
  240. Frequency: 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",150,"snmp"][0m 0.59ms]
  241.  
  242. Humidity: 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",150,"snmp"][0m 0.61ms]
  243.  
  244. Load: 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",150,"snmp"][0m 0.6ms]
  245.  
  246. Power: 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",150,"snmp"][0m 0.78ms]
  247.  
  248. Runtime: 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",150,"snmp"][0m 0.58ms]
  249.  
  250. Signal: 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",150,"snmp"][0m 0.61ms]
  251.  
  252. State: 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",150,"snmp"][0m 0.59ms]
  253.  
  254. Temperature: 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",150,"snmp"][0m 0.64ms]
  255.  
  256. Voltage: 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",150,"snmp"][0m 0.59ms]
  257.  
  258. Snr: 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",150,"snmp"][0m 0.59ms]
  259.  
  260. Pressure: 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",150,"snmp"][0m 0.59ms]
  261.  
  262. Cooling: 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",150,"snmp"][0m 0.6ms]
  263.  
  264. Delay: 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",150,"snmp"][0m 0.64ms]
  265.  
  266. Quality_factor: 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",150,"snmp"][0m 0.6ms]
  267.  
  268. Chromatic_dispersion: 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",150,"snmp"][0m 0.66ms]
  269.  
  270. Ber: 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",150,"snmp"][0m 0.62ms]
  271.  
  272. Eer: 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",150,"snmp"][0m 0.78ms]
  273.  
  274. Waterflow: 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",150,"snmp"][0m 0.59ms]
  275.  
  276.  
  277. >> Runtime for discovery module 'sensors': 0.0560 seconds with 39024 bytes
  278. >> SNMP: [1/0.03s] MySQL: [28/0.02s] RRD: [0/0.00s]
  279. #### Unload disco module sensors ####
  280.  
  281. Modules status: Global+ OS+ Device  
  282. #### Load disco module storage ####
  283. 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]
  284. End of MIB
  285.  
  286. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dskTable[0m]
  287. End of MIB
  288.  
  289. SQL[[1;33mSELECT `storage_descr` FROM `storage` WHERE `device_id`  = '150' AND `storage_type` != 'dsk' [0;33m[][0m 0.77ms]
  290. SQL[[1;33mSELECT * FROM `storage` WHERE `device_id`  = '150' [0;33m[][0m 0.37ms]
  291.  
  292.  
  293. >> Runtime for discovery module 'storage': 0.0730 seconds with 14256 bytes
  294. >> SNMP: [2/0.07s] MySQL: [1/0.00s] RRD: [0/0.00s]
  295. #### Unload disco module storage ####
  296.  
  297. Modules status: Global+ OS+ Device  
  298. #### Load disco module hr-device ####
  299. 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]
  300. End of MIB
  301.  
  302. 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]
  303. End of MIB
  304.  
  305. Array
  306. (
  307. )
  308. SQL[[1;33mSELECT * FROM `hrDevice` WHERE `device_id`  = '150' [0;33m[][0m 0.59ms]
  309.  
  310.  
  311. >> Runtime for discovery module 'hr-device': 0.0710 seconds with 3744 bytes
  312. >> SNMP: [2/0.07s] MySQL: [1/0.00s] RRD: [0/0.00s]
  313. #### Unload disco module hr-device ####
  314.  
  315. Modules status: Global+ OS+ Device  
  316. #### Load disco module discovery-protocols ####
  317.  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]
  318. End of MIB
  319.  
  320. SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[150,"End of MIB"][0m 3.31ms]
  321.  
  322. Warning: Invalid argument supplied for foreach() in /opt/librenms/includes/discovery/discovery-protocols.inc.php on line 49
  323.  
  324.  LLDP-MIB: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m LLDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 lldpRemTable[0m]
  325. End of MIB
  326.  
  327. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dBasePortIfIndex[0m]
  328. End of MIB
  329.  
  330. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m LLDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 lldpLocPortId[0m]
  331. End of MIB
  332.  
  333.  
  334. Warning: Invalid argument supplied for foreach() in /opt/librenms/includes/discovery/discovery-protocols.inc.php on line 166
  335.  
  336.  OSPF Discovery: SQL[[1;33mSELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`=? [0;33m[150][0m 0.81ms]
  337.  
  338. SQL[[1;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [0;33m[150][0m 0.68ms]
  339. 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 1.13ms]
  340.  0 orphaned links deleted
  341.  
  342. >> Runtime for discovery module 'discovery-protocols': 0.1450 seconds with 5112 bytes
  343. >> SNMP: [0/0.00s] MySQL: [4/0.01s] RRD: [0/0.00s]
  344. #### Unload disco module discovery-protocols ####
  345.  
  346. Modules status: Global+ OS+ Device  
  347. #### Load disco module arp-table ####
  348. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipNetToPhysicalPhysAddress[0m]
  349. End of MIB
  350.  
  351. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipNetToMediaPhysAddress[0m]
  352. End of MIB
  353.  
  354. SQL[[1;33mSELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [0;33m[150,""][0m 2.15ms]
  355. SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[150,"End of MIB"][0m 0.34ms]
  356.  
  357. Warning: Illegal string offset 'ipNetToMediaPhysAddress' in /opt/librenms/includes/discovery/arp-table.inc.php on line 59
  358.  
  359. Warning: Illegal string offset 'ipNetToPhysicalPhysAddress' in /opt/librenms/includes/discovery/arp-table.inc.php on line 60
  360.  
  361. Warning: Illegal string offset 'ipv4' in /opt/librenms/includes/discovery/arp-table.inc.php on line 60
  362. :
  363.  
  364. 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 3.35ms]
  365.  
  366.  
  367. >> Runtime for discovery module 'arp-table': 0.0820 seconds with 3440 bytes
  368. >> SNMP: [0/0.00s] MySQL: [3/0.01s] RRD: [0/0.00s]
  369. #### Unload disco module arp-table ####
  370.  
  371. Modules status: Global- OS- Device  Module [ discovery-arp ] disabled on os.
  372.  
  373. Modules status: Global- OS- Device  Module [ junose-atm-vp ] disabled on os.
  374.  
  375. Modules status: Global+ OS+ Device  
  376. #### Load disco module bgp-peers ####
  377. SNMP[[0;36m/usr/bin/snmpgetnext -v1 -c COMMUNITY -Oqvn -m BGP4-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 bgpLocalAs[0m]
  378.  
  379. No BGP on hostPeers :
  380. SQL[[1;33mDELETE FROM `bgpPeers` WHERE device_id=? AND context_name=? [0;33m[150,""][0m 0.45ms]
  381. SQL[[1;33mDELETE FROM `bgpPeers_cbgp` WHERE device_id=? AND context_name=? [0;33m[150,""][0m 0.22ms]
  382.  
  383. SQL[[1;33mSELECT DISTINCT context_name FROM bgpPeers WHERE device_id=? [0;33m[150][0m 0.3ms]
  384.  
  385. >> Runtime for discovery module 'bgp-peers': 0.0190 seconds with 5584 bytes
  386. >> SNMP: [1/0.02s] MySQL: [2/0.00s] RRD: [0/0.00s]
  387. #### Unload disco module bgp-peers ####
  388.  
  389. Modules status: Global+ OS+ Device  
  390. #### Load disco module vlans ####
  391. SQL[[1;33mSELECT * FROM `vlans` WHERE `device_id` = ? [0;33m[150][0m 0.3ms]
  392. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dBasePortIfIndex[0m]
  393. End of MIB
  394.  
  395. 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]
  396.  
  397.  
  398.  
  399. >> Runtime for discovery module 'vlans': 0.0660 seconds with 9304 bytes
  400. >> SNMP: [2/0.07s] MySQL: [1/0.00s] RRD: [0/0.00s]
  401. #### Unload disco module vlans ####
  402.  
  403. Modules status: Global- OS- Device  Module [ vmware-vminfo ] disabled on os.
  404.  
  405. Modules status: Global- OS- Device  Module [ libvirt-vminfo ] disabled on os.
  406.  
  407. Modules status: Global- OS- Device  Module [ toner ] disabled on os.
  408.  
  409. Modules status: Global+ OS+ Device  
  410. #### Load disco module ucd-diskio ####
  411. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-DISKIO-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 diskIOEntry[0m]
  412. End of MIB
  413.  
  414. Array
  415. (
  416. )
  417. SQL[[1;33mSELECT * FROM `ucd_diskio` where `device_id`  = '150' [0;33m[][0m 0.54ms]
  418.  
  419.  
  420. >> Runtime for discovery module 'ucd-diskio': 0.0320 seconds with 3160 bytes
  421. >> SNMP: [1/0.03s] MySQL: [1/0.00s] RRD: [0/0.00s]
  422. #### Unload disco module ucd-diskio ####
  423.  
  424. Modules status: Global- OS- Device  Module [ applications ] disabled on os.
  425.  
  426. Modules status: Global+ OS+ Device  
  427. #### Load disco module services ####
  428.  
  429. >> Runtime for discovery module 'services': 0.0000 seconds with 296 bytes
  430. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  431. #### Unload disco module services ####
  432.  
  433. Modules status: Global+ OS+ Device  
  434. #### Load disco module stp ####
  435. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[150][0m 0.35ms]
  436. SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dStpProtocolSpecification.0[0m]
  437.  
  438.  
  439.  
  440. >> Runtime for discovery module 'stp': 0.0180 seconds with 5824 bytes
  441. >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s]
  442. #### Unload disco module stp ####
  443.  
  444. Modules status: Global+ OS+ Device  
  445. #### Load disco module ntp ####
  446.  
  447. >> Runtime for discovery module 'ntp': 0.0000 seconds with 232 bytes
  448. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  449. #### Unload disco module ntp ####
  450.  
  451. Modules status: Global- OS- Device  Module [ loadbalancers ] disabled on os.
  452.  
  453. Modules status: Global- OS- Device  Module [ mef ] disabled on os.
  454.  
  455. Modules status: Global+ OS+ Device  
  456. #### Load disco module wireless ####
  457. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"ap-count"][0m 3.99ms]
  458. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"clients"][0m 0.77ms]
  459. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"quality"][0m 0.45ms]
  460. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"capacity"][0m 0.41ms]
  461. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"utilization"][0m 0.41ms]
  462. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"rate"][0m 0.44ms]
  463. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"ccq"][0m 0.44ms]
  464. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"snr"][0m 0.41ms]
  465. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"ssr"][0m 0.43ms]
  466. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"mse"][0m 0.41ms]
  467. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"rssi"][0m 0.4ms]
  468. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"power"][0m 0.41ms]
  469. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"noise-floor"][0m 0.47ms]
  470. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"errors"][0m 0.4ms]
  471. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"error-ratio"][0m 0.4ms]
  472. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"error-rate"][0m 0.41ms]
  473. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"frequency"][0m 0.41ms]
  474. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[150,"distance"][0m 0.42ms]
  475.  
  476. >> Runtime for discovery module 'wireless': 0.0160 seconds with 123072 bytes
  477. >> SNMP: [0/0.00s] MySQL: [18/0.01s] RRD: [0/0.00s]
  478. #### Unload disco module wireless ####
  479.  
  480. Modules status: Global+ OS+ Device  
  481. #### Load disco module fdb-table ####
  482. SQL[[1;33mSELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = ? [0;33m[150][0m 0.41ms]
  483. SQL[[1;33mSELECT * FROM `ports_fdb` WHERE `device_id` = ? [0;33m[150][0m 0.31ms]
  484. SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qTpFdbPort[0m]
  485. End of MIB
  486.  
  487. Q-BRIDGE-MIB:SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dBasePortIfIndex[0m]
  488. End of MIB
  489.  
  490.  
  491. Warning: Illegal string offset 'dot1dBasePortIfIndex' in /opt/librenms/includes/discovery/fdb-table/bridge.inc.php on line 48
  492. SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[150,""][0m 0.64ms]
  493.  
  494. Warning: Illegal string offset 'dot1qTpFdbPort' in /opt/librenms/includes/discovery/fdb-table/bridge.inc.php on line 54
  495.  
  496. Warning: Invalid argument supplied for foreach() in /opt/librenms/includes/discovery/fdb-table/bridge.inc.php on line 54
  497.  
  498.  
  499. >> Runtime for discovery module 'fdb-table': 0.0760 seconds with 3528 bytes
  500. >> SNMP: [0/0.00s] MySQL: [3/0.00s] RRD: [0/0.00s]
  501. #### Unload disco module fdb-table ####
  502.  
  503. SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [0;33m[150,"poll_mib"][0m 0.19ms]
  504. SQL[[1;33mUPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [0;33m[2.612,150][0m 18.97ms]
  505. Discovered in 2.612 seconds
  506.  
  507. SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"discover","doing":"10.1.1.16","start":1535131427.0317,"duration":"2.960","devices":1,"poller":"librenms"}[0m 35.98ms]
  508. ./discovery.php 10.1.1.16 2018-08-24 10:23:50 - 1 devices discovered in 2.960 secs
  509. SNMP [32/0.96s]: Get[12/0.27s] Getnext[1/0.02s] Walk[19/0.68s]
  510. MySQL [86/0.34s]: Cell[3/0.00s] Row[5/0.01s] Rows[64/0.05s] Column[2/0.00s] Update[2/0.06s] Insert[5/0.21s] Delete[5/0.01s]
  511. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  512.