LibreNMS Discovery SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.83ms] SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.53ms] SQL[[1;33mselect version() [0;33m[][0m 0.52ms] =========================================== Component | Version --------- | ------- LibreNMS | 24.8.1 (2024-08-22T02:50:00+00:00) DB Schema | 2024_07_19_120719_update_ports_stack_table (296) PHP | 8.1.2-1ubuntu2.18 Python | 3.10.12 Database | MariaDB 10.6.18-MariaDB-0ubuntu0.22.04.1 RRDTool | 1.7.2 SNMP | 5.9.1 =========================================== DEBUG! Updating os_def.cache SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND `hostname` LIKE '10.16.19.70' ORDER BY device_id DESC [0;33m[][0m 1.45ms] 10.16.19.70 13 esphome SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[13][0m 0.76ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[13][0m 0.65ms] [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.16.19.70' response: 10.16.19.70 : xmt/rcv/%loss = 3/3/0%, min/avg/max = 24.1/58.1/112 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' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::org.9999.32 Modules status: Global+ OS Device #### Load disco module core #### Attempting to initialize OS: esphome OS initialized as Generic (esphome) 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' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = .1.3.9999.32 .*.*.0 = ESPHome version 2024.9.1 compiled Sep 25 2024, 21:19:22, Board esp32dev .*.*.0 = projector-living-room | ESPHome version 2024.9.1 compiled Sep 25 2024, 21:19:22, Board esp32dev | .1.3.9999.32 | OS: ESP-Home (esphome) Attempting to initialize OS: esphome OS initialized as Generic (esphome) >> Runtime for discovery module 'core': 0.4750 seconds with -97576 bytes >> [0;36mSNMP[0m: [1/0.28s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module core #### Modules status: Global+ OS Device #### Load disco module os #### Yaml location data: SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysLocation.0'[0m] Living Room SQL[[1;33mselect * from `locations` where (`location` = ?) limit 1 [0;33m["Living Room"][0m 0.82ms] ::query() failed: DNS request failed: The domain name referenced in the query does not exist. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovq' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'sysContact.0'[0m] Jacob Ernst Yaml OS data: Location: Living Room Hardware: OS Version: OS Features: Serial: >> Runtime for discovery module 'os': 0.5870 seconds with 732616 bytes >> [0;36mSNMP[0m: [4/0.48s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module os #### Modules status: Global+ OS Device- Module [ ports ] disabled on host. Modules status: Global+ OS Device- Module [ ports-stack ] disabled on host. Modules status: Global- OS Device Module [ xdsl ] disabled globally. Modules status: Global+ OS Device- Module [ entity-physical ] disabled on host. Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global- OS Device Module [ isis ] disabled globally. Modules status: Global+ OS Device- Module [ processors ] disabled on host. Modules status: Global+ OS Device- Module [ mempools ] disabled on host. Modules status: Global+ OS Device- Module [ cisco-vrf-lite ] disabled on host. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cisco-pw ] disabled globally. Modules status: Global- OS Device Module [ vrf ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ slas ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global+ OS Device- Module [ ipv4-addresses ] disabled on host. Modules status: Global+ OS Device- Module [ ipv6-addresses ] disabled on host. Modules status: Global+ OS Device- Module [ route ] disabled on host. Modules status: Global+ OS+ Device #### Load disco module sensors #### Caching data: sensors SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQn' '-Ih' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.9999.4.1.0'[0m] .1.3.99* = -54 ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'entPhysicalDescr'[0m] entPhysicalDescr = No more variables left in this MIB View (It is past the end of the MIB tree) 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",13,"ipmi"][0m 1.43ms] 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",13,"ipmi"][0m 0.92ms] 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",13,"ipmi"][0m 0.82ms] 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",13,"ipmi"][0m 0.79ms] Airflow: array ( ) 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",13,"snmp"][0m 0.79ms] Current: array ( ) 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",13,"snmp"][0m 0.78ms] Charge: array ( ) 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",13,"snmp"][0m 0.95ms] Dbm: Dynamic Discovery (dbm): array ( 'data' => array ( 0 => array ( 'oid' => '.1.3.9999.4.1.0', 'descr' => 'RSSI', 'snmp_flags' => array ( 0 => '-OQn', ), 'num_oid' => '.1.3.9999.4.1.0', 'index' => 0, 'value' => '.1.3.9999.4.1.0', ), ), ) Data .1.3.9999.4.1.0: array ( ) array ( ) 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",13,"snmp"][0m 0.84ms] Fanspeed: array ( ) 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",13,"snmp"][0m 0.79ms] Frequency: array ( ) 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",13,"snmp"][0m 0.79ms] Humidity: array ( ) 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",13,"snmp"][0m 0.83ms] Load: array ( ) 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",13,"snmp"][0m 0.81ms] Loss: array ( ) 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",13,"snmp"][0m 0.78ms] Power: array ( ) 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",13,"snmp"][0m 0.87ms] Power_consumed: array ( ) 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",13,"snmp"][0m 0.8ms] Power_factor: array ( ) 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",13,"snmp"][0m 0.78ms] Runtime: array ( ) 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",13,"snmp"][0m 0.8ms] Signal: array ( ) 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",13,"snmp"][0m 0.8ms] State: array ( ) 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",13,"snmp"][0m 0.8ms] Count: array ( ) 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",13,"snmp"][0m 1.2ms] Temperature: array ( ) 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",13,"snmp"][0m 0.81ms] Tv_signal: array ( ) 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",13,"snmp"][0m 0.79ms] Bitrate: array ( ) 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",13,"snmp"][0m 0.78ms] Voltage: array ( ) 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",13,"snmp"][0m 0.89ms] Snr: array ( ) 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",13,"snmp"][0m 0.8ms] Pressure: array ( ) 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",13,"snmp"][0m 0.78ms] Cooling: array ( ) 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",13,"snmp"][0m 0.78ms] Delay: array ( ) 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",13,"snmp"][0m 0.86ms] Quality_factor: array ( ) 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",13,"snmp"][0m 0.81ms] Chromatic_dispersion: array ( ) 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",13,"snmp"][0m 0.78ms] Ber: array ( ) 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",13,"snmp"][0m 0.94ms] Eer: array ( ) 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",13,"snmp"][0m 0.79ms] Waterflow: array ( ) 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",13,"snmp"][0m 0.78ms] Percent: array ( ) 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",13,"snmp"][0m 0.8ms] >> Runtime for discovery module 'sensors': 1.0390 seconds with 141640 bytes >> [0;36mSNMP[0m: [2/0.98s] [1;33mMySQL[0m: [34/0.29s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module sensors #### Modules status: Global+ OS Device #### Load disco module storage #### SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'DATA-DOMAIN-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/datadomain' 'udp:HOSTNAME:161' 'fileSystemSpaceTable'[0m] fileSystemSpaceTable = No more variables left in this MIB View (It is past the end of the MIB tree) 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' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-Os' 'udp:HOSTNAME:161' 'ARICENT-ISS-MIB::issSwitchCurrentFlashUsage.0'[0m] Exitcode: 1 ["MIB search path: /opt/librenms/mibs Cannot find module (ARICENT-ISS-MIB): At line 12 in (none) ARICENT-ISS-MIB::issSwitchCurrentFlashUsage.0: Unknown Object Identifier "] MIB search path: /opt/librenms/mibs Cannot find module (ARICENT-ISS-MIB): At line 12 in (none) ARICENT-ISS-MIB::issSwitchCurrentFlashUsage.0: Unknown Object Identifier SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageTable'[0m] hrStorageIndex[1] = 1 hrStorageIndex[2] = 2 hrStorageDescr[1] = FLASH hrStorageDescr[2] = SPI RAM hrStorageAllocationUnits[1] = 1 hrStorageAllocationUnits[2] = 1 hrStorageSize[1] = 4194304 hrStorageSize[2] = 0 hrStorageUsed[1] = 922048 hrStorageUsed[2] = 0 hrStorage : Discover Storage: 1, , hrstorage, FLASH, 4194304, 1, 922048 SQL[[1;33mSELECT * FROM `storage` WHERE `storage_index` = ? AND `device_id` = ? AND `storage_mib` = ? [0;33m[1,13,"hrstorage"][0m 1.07ms] SQL[[1;33mUPDATE `storage` set `storage_descr`=?,`storage_type`=?,`storage_units`=?,`storage_size`=? WHERE `device_id` = ? AND `storage_index` = ? AND `storage_mib` = ? [0;33m["FLASH",null,"1",4194304,13,1,"hrstorage"][0m 0.47ms] .Discover Storage: 2, , hrstorage, SPI RAM, 0, 1, 0 SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dskTable'[0m] dskTable = No more variables left in this MIB View (It is past the end of the MIB tree) SQL[[1;33mSELECT `storage_descr` FROM `storage` WHERE `device_id` = '13' AND `storage_type` != 'dsk' [0;33m[][0m 0.9ms] array ( 'hrstorage' => array ( 1 => 1, ), ) SQL[[1;33mSELECT * FROM `storage` WHERE `device_id` = '13' [0;33m[][0m 0.52ms] 1 -> hrstorage >> Runtime for discovery module 'storage': 1.2100 seconds with 26448 bytes >> [0;36mSNMP[0m: [3/0.40s] [1;33mMySQL[0m: [4/0.03s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module storage #### Modules status: Global+ OS Device- Module [ hr-device ] disabled on host. Modules status: Global+ OS Device- Module [ discovery-protocols ] disabled on host. Modules status: Global+ OS Device- Module [ arp-table ] disabled on host. Modules status: Global- OS Device Module [ discovery-arp ] disabled globally. Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global+ OS Device- Module [ bgp-peers ] disabled on host. Modules status: Global+ OS Device- Module [ vlans ] disabled on host. Modules status: Global+ OS Device- Module [ vminfo ] disabled on host. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device- Module [ ucd-diskio ] disabled on host. Modules status: Global+ OS Device- Module [ applications ] disabled on host. Modules status: Global+ OS Device- Module [ services ] disabled on host. Modules status: Global+ OS Device- Module [ stp ] disabled on host. Modules status: Global+ OS Device- Module [ ntp ] disabled on host. Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device- Module [ wireless ] disabled on host. Modules status: Global+ OS Device- Module [ fdb-table ] disabled on host. Modules status: Global+ OS Device- Module [ mpls ] disabled on host. SQL[[1;33mupdate `devices` set `last_discovered_timetaken` = ?, `last_discovered` = NOW() where `device_id` = ? [0;33m[4.909,13][0m 0.66ms] Discovered in 4.909 seconds ./discovery.php 10.16.19.70 2024-09-27 23:00:04 - 1 devices discovered in 5.387 secs [0;36mSNMP[0m [11/2.49s]: Snmpget[7/1.15s] Snmpwalk[4/1.34s] [1;33mSQL[0m [47/0.39s]: Select[45/0.38s] Update[2/0.01s] [0;32mRRD[0m [0/0.00s]: