LibreNMS Discovery =================================== Version info: Commit SHA: a391e6270345a29f7983ad6a64e62587c9f28e16 Commit Date: 1514352969 DB Schema: 226 PHP: 7.1.11 MySQL: 5.5.56-MariaDB RRDTool: 1.4.8 SNMP: NET-SNMP 5.7.2 ==================================DEBUG! SQL[[0;33mSELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE '192.168.6.102' ORDER BY device_id DESC[0m] SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '5'[0m] 192.168.6.102 5 unifi SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','0.35','0.37','0.36','5',NOW())[0m] SNMP Check response code: 0 SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '5' AND `attrib_type` = 'poll_mib' [0m] Modules status: Global+ OS+ Device #### Load disco module os #### SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0[0m] Linux 2.6.22 #1 PREEMPT Fri Sep 15 22:34:14 PDT 2017 mips SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovqn -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0[0m] .*.4.1.10002.1 | Linux 2.6.22 #1 PREEMPT Fri Sep 15 22:34:14 PDT 2017 mips | .1.3.6.1.4.1.10002.1 | SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m SYNOLOGY-SYSTEM-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt:/opt/librenms/mibs/synology udp:HOSTNAME:161 systemStatus.0[0m] SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 HOST-RESOURCES-MIB::hrSystemInitialLoadParameters.0[0m] SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 .1.3.6.1.4.1.12148.10.2.6.0[0m] SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 GANDI-MIB::rxCounter.0[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Osqnv -m IEEE802dot11-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 dot11manufacturerProductName[0m] UAP-ACv2 UAP-ACv2 UAP-ACv2 UAP-ACv2 OS: Ubiquiti UniFi (unifi) >> Runtime for discovery module 'os': 0.2310 seconds with 1800 bytes >> SNMP: [8/0.26s] MySQL: [8/0.00s] RRD: [0/0.00s] #### Unload disco module os #### Modules status: Global+ OS+ Device #### Load disco module ports #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ifDescr[0m] ifDescr.1 = lo ifDescr.2 = eth0 ifDescr.3 = eth1 ifDescr.4 = eth2 ifDescr.5 = wl0.1 ifDescr.6 = wl0.2 ifDescr.7 = wl0.3 ifDescr.8 = wl0.4 ifDescr.9 = wl0.5 ifDescr.10 = wl0.6 ifDescr.11 = wl0.7 ifDescr.12 = wl0.8 ifDescr.13 = wl0.9 ifDescr.14 = wl0.10 ifDescr.15 = wl0.11 ifDescr.16 = wl0.12 ifDescr.17 = wl0.13 ifDescr.18 = wl0.14 ifDescr.19 = wl0.15 ifDescr.20 = wl1.1 ifDescr.21 = wl1.2 ifDescr.22 = wl1.3 ifDescr.23 = wl1.4 ifDescr.24 = wl1.5 ifDescr.25 = wl1.6 ifDescr.26 = wl1.7 ifDescr.27 = wl1.8 ifDescr.28 = wl1.9 ifDescr.29 = wl1.10 ifDescr.30 = wl1.11 ifDescr.31 = wl1.12 ifDescr.32 = wl1.13 ifDescr.33 = wl1.14 ifDescr.34 = wl1.15 ifDescr.35 = eth0.10 ifDescr.36 = br0 ifDescr.37 = br0.10 SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ifName[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ifAlias[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ifType[0m] ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = ethernetCsmacd ifType.6 = ethernetCsmacd ifType.7 = ethernetCsmacd ifType.8 = ethernetCsmacd ifType.9 = ethernetCsmacd ifType.10 = ethernetCsmacd ifType.11 = ethernetCsmacd ifType.12 = ethernetCsmacd ifType.13 = ethernetCsmacd ifType.14 = ethernetCsmacd ifType.15 = ethernetCsmacd ifType.16 = ethernetCsmacd ifType.17 = ethernetCsmacd ifType.18 = ethernetCsmacd ifType.19 = ethernetCsmacd ifType.20 = ethernetCsmacd ifType.21 = ethernetCsmacd ifType.22 = ethernetCsmacd ifType.23 = ethernetCsmacd ifType.24 = ethernetCsmacd ifType.25 = ethernetCsmacd ifType.26 = ethernetCsmacd ifType.27 = ethernetCsmacd ifType.28 = ethernetCsmacd ifType.29 = ethernetCsmacd ifType.30 = ethernetCsmacd ifType.31 = ethernetCsmacd ifType.32 = ethernetCsmacd ifType.33 = ethernetCsmacd ifType.34 = ethernetCsmacd ifType.35 = ethernetCsmacd ifType.36 = ethernetCsmacd ifType.37 = ethernetCsmacd Array ( [1] => Array ( [ifDescr] => lo [ifType] => softwareLoopback ) [2] => Array ( [ifDescr] => eth0 [ifType] => ethernetCsmacd ) [3] => Array ( [ifDescr] => eth1 [ifType] => ethernetCsmacd ) [4] => Array ( [ifDescr] => eth2 [ifType] => ethernetCsmacd ) [5] => Array ( [ifDescr] => wl0.1 [ifType] => ethernetCsmacd ) [6] => Array ( [ifDescr] => wl0.2 [ifType] => ethernetCsmacd ) [7] => Array ( [ifDescr] => wl0.3 [ifType] => ethernetCsmacd ) [8] => Array ( [ifDescr] => wl0.4 [ifType] => ethernetCsmacd ) [9] => Array ( [ifDescr] => wl0.5 [ifType] => ethernetCsmacd ) [10] => Array ( [ifDescr] => wl0.6 [ifType] => ethernetCsmacd ) [11] => Array ( [ifDescr] => wl0.7 [ifType] => ethernetCsmacd ) [12] => Array ( [ifDescr] => wl0.8 [ifType] => ethernetCsmacd ) [13] => Array ( [ifDescr] => wl0.9 [ifType] => ethernetCsmacd ) [14] => Array ( [ifDescr] => wl0.10 [ifType] => ethernetCsmacd ) [15] => Array ( [ifDescr] => wl0.11 [ifType] => ethernetCsmacd ) [16] => Array ( [ifDescr] => wl0.12 [ifType] => ethernetCsmacd ) [17] => Array ( [ifDescr] => wl0.13 [ifType] => ethernetCsmacd ) [18] => Array ( [ifDescr] => wl0.14 [ifType] => ethernetCsmacd ) [19] => Array ( [ifDescr] => wl0.15 [ifType] => ethernetCsmacd ) [20] => Array ( [ifDescr] => wl1.1 [ifType] => ethernetCsmacd ) [21] => Array ( [ifDescr] => wl1.2 [ifType] => ethernetCsmacd ) [22] => Array ( [ifDescr] => wl1.3 [ifType] => ethernetCsmacd ) [23] => Array ( [ifDescr] => wl1.4 [ifType] => ethernetCsmacd ) [24] => Array ( [ifDescr] => wl1.5 [ifType] => ethernetCsmacd ) [25] => Array ( [ifDescr] => wl1.6 [ifType] => ethernetCsmacd ) [26] => Array ( [ifDescr] => wl1.7 [ifType] => ethernetCsmacd ) [27] => Array ( [ifDescr] => wl1.8 [ifType] => ethernetCsmacd ) [28] => Array ( [ifDescr] => wl1.9 [ifType] => ethernetCsmacd ) [29] => Array ( [ifDescr] => wl1.10 [ifType] => ethernetCsmacd ) [30] => Array ( [ifDescr] => wl1.11 [ifType] => ethernetCsmacd ) [31] => Array ( [ifDescr] => wl1.12 [ifType] => ethernetCsmacd ) [32] => Array ( [ifDescr] => wl1.13 [ifType] => ethernetCsmacd ) [33] => Array ( [ifDescr] => wl1.14 [ifType] => ethernetCsmacd ) [34] => Array ( [ifDescr] => wl1.15 [ifType] => ethernetCsmacd ) [35] => Array ( [ifDescr] => eth0.10 [ifType] => ethernetCsmacd ) [36] => Array ( [ifDescr] => br0 [ifType] => ethernetCsmacd ) [37] => Array ( [ifDescr] => br0.10 [ifType] => ethernetCsmacd ) ) SQL[[0;33mSELECT `name` FROM `port_association_mode` WHERE pom_id = '1'[0m] SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '5' ORDER BY port_id[0m] ..................................... >> Runtime for discovery module 'ports': 1.6960 seconds with 4296 bytes >> SNMP: [4/1.69s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module ports #### Modules status: Global+ OS+ Device #### Load disco module ports-stack #### SQL[[0;33mSELECT * FROM `ports_stack` WHERE `device_id` = '5'[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ifStackStatus[0m] >> Runtime for discovery module 'ports-stack': 0.0390 seconds with 1768 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module ports-stack #### Modules status: Global+ OS+ Device #### Load disco module entity-physical #### Caching OIDs: entPhysicalEntrySNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 entPhysicalEntry[0m] SQL[[0;33mSELECT * FROM `entPhysical` WHERE `device_id` = '5'[0m] >> Runtime for discovery module 'entity-physical': 0.0390 seconds with 5184 bytes >> SNMP: [1/0.04s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module entity-physical #### Modules status: Global- OS- Device Module [ entity-state ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module processors #### hrDevice: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 hrDevice[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 hrProcessorLoad[0m] Ubiquiti UniFi: SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Ovqn -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 .1.3.6.1.4.1.10002.1.1.1.4.2.1.3.2[0m] 16 Discover Processor: .1.3.6.1.4.1.10002.1.1.1.4.2.1.3.2, 0, unifi, CPU, 1, 16, , SQL[[0;33mSELECT COUNT(processor_id) FROM `processors` WHERE `processor_index` = '0' AND `device_id` = '5' AND `processor_type` = 'unifi'[0m] .SQL[[0;33mUPDATE `processors` set `processor_descr` ='CPU',`processor_oid` ='.1.3.6.1.4.1.10002.1.1.1.4.2.1.3.2',`processor_usage` ='16',`processor_precision` ='1' WHERE `device_id`='5' AND `processor_index`='0' AND `processor_type`='unifi'[0m] SQL[[0;33mSELECT COUNT(*) FROM `processors` WHERE `device_id` = '5' AND `processor_type` != 'ucd-old'[0m] Array ( [unifi] => Array ( [0] => 1 ) ) SQL[[0;33mSELECT * FROM `processors` WHERE `device_id` = '5'[0m] 0 -> unifi >> Runtime for discovery module 'processors': 0.1060 seconds with 51736 bytes >> SNMP: [3/0.10s] MySQL: [4/0.00s] RRD: [0/0.00s] #### Unload disco module processors #### Modules status: Global+ OS+ Device #### Load disco module mempools #### SQL[[0;33mSELECT COUNT(*) FROM `mempools` WHERE `device_id` = '5' AND `mempool_type` = 'cemp'[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETSWITCH-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt:/opt/librenms/mibs/hp udp:HOSTNAME:161 hpLocal[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETSWITCH-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt:/opt/librenms/mibs/hp udp:HOSTNAME:161 hpGlobal[0m] 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:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 hrStorageEntry[0m] UNIFI-MEMORY-POOL: SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OvQ -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 .1.3.6.1.4.1.10002.1.1.1.1.1.0[0m] 126024 SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -OvQ -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 .1.3.6.1.4.1.10002.1.1.1.1.2.0[0m] 74808 Discover Mempool: 0, unifi, Memory, 1, , SQL[[0;33mSELECT COUNT(mempool_id) FROM `mempools` WHERE `mempool_index` = '0' AND `device_id` = '5' AND `mempool_type` = 'unifi'[0m] .SQL[[0;33mUPDATE `mempools` set `mempool_descr` ='Memory' WHERE device_id='5' AND mempool_index='0' AND mempool_type='unifi'[0m] Array ( [unifi] => Array ( [0] => 1 ) ) SQL[[0;33mSELECT * FROM `mempools` WHERE `device_id` = '5'[0m] 0 -> unifi >> Runtime for discovery module 'mempools': 0.1580 seconds with 20416 bytes >> SNMP: [5/0.15s] MySQL: [4/0.00s] RRD: [0/0.00s] #### Unload disco module mempools #### Modules status: Global+ OS+ Device #### Load disco module cisco-vrf-lite #### SQL[[0;33mSELECT * FROM vrf_lite_cisco WHERE device_id = '5' [0m] >> Runtime for discovery module 'cisco-vrf-lite': 0.0000 seconds with 2640 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module cisco-vrf-lite #### Modules status: Global- OS- Device Module [ cisco-mac-accounting ] disabled on os. Modules status: Global- OS- Device Module [ cisco-pw ] disabled on os. Modules status: Global- OS- Device Module [ cisco-vrf ] disabled on os. Modules status: Global- OS- Device Module [ cisco-cef ] disabled on os. Modules status: Global- OS- Device Module [ cisco-sla ] disabled on os. Modules status: Global- OS- Device Module [ cisco-cbqos ] disabled on os. Modules status: Global- OS- Device Module [ cisco-otv ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module ipv4-addresses #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Osq -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ipAdEntIfIndex[0m] SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ipAdEntNetMask.[0m] SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE device_id = '5' AND `ifIndex` = ''[0m] !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 = '5' OR `ports`.`device_id` IS NULL[0m] >> Runtime for discovery module 'ipv4-addresses': 0.2380 seconds with 33176 bytes >> SNMP: [2/0.24s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module ipv4-addresses #### Modules status: Global+ OS+ Device #### Load disco module ipv6-addresses #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Ln -Osq -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ipAddressIfIndex.ipv6[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Ln -Osq -OnU -m IPV6-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ipv6AddrPfxLength[0m] 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 = '5' OR `ports`.`device_id` IS NULL[0m] >> Runtime for discovery module 'ipv6-addresses': 0.0540 seconds with 9104 bytes >> SNMP: [2/0.05s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module ipv6-addresses #### Modules status: Global- OS- Device Module [ route ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module sensors #### ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m CISCO-ENTITY-SENSOR-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 entPhysicalDescr[0m] SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '5' AND `attrib_type` = 'ipmi_hostname' [0m] 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 = '5' AND S.poller_type = 'ipmi'[0m] 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 = '5' AND S.poller_type = 'ipmi'[0m] 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 = '5' AND S.poller_type = 'ipmi'[0m] 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 = '5' AND S.poller_type = 'ipmi'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] 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 = '5' AND S.poller_type = 'snmp'[0m] >> Runtime for discovery module 'sensors': 0.0380 seconds with 10512 bytes >> SNMP: [1/0.03s] MySQL: [26/0.01s] RRD: [0/0.00s] #### Unload disco module sensors #### Modules status: Global+ OS+ Device #### Load disco module storage #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m EQLVOLUME-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt:/opt/librenms/mibs/equallogic udp:HOSTNAME:161 EqliscsiVolumeEntry[0m] End of MIB SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m CPQHOST-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 cpqHoFileSysEntry[0m] 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:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 hrStorageEntry[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETAPP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 dfEntry[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 dskTable[0m] SQL[[0;33mSELECT `storage_descr` FROM `storage` WHERE `device_id` = '5' AND `storage_type` != 'dsk'[0m] SQL[[0;33mSELECT * FROM `storage` WHERE `device_id` = '5'[0m] >> Runtime for discovery module 'storage': 0.1450 seconds with 6712 bytes >> SNMP: [4/0.14s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module storage #### Modules status: Global+ OS+ Device #### Load disco module hr-device #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 hrDeviceEntry[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 hrProcessorEntry[0m] Array ( ) SQL[[0;33mSELECT * FROM `hrDevice` WHERE `device_id` = '5'[0m] >> Runtime for discovery module 'hr-device': 0.0590 seconds with 3096 bytes >> SNMP: [2/0.06s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module hr-device #### Modules status: Global+ OS+ Device #### Load disco module discovery-protocols #### CISCO-CDP-MIB: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m CISCO-CDP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 cdpCache[0m] LLDP-MIB: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m LLDP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 lldpRemTable[0m] OSPF Discovery: SQL[[0;33mSELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`='5'[0m] SQL[[0;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = '5'[0m] 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] 0 orphaned links deleted >> Runtime for discovery module 'discovery-protocols': 0.0680 seconds with 4688 bytes >> SNMP: [0/0.00s] MySQL: [3/0.00s] RRD: [0/0.00s] #### Unload disco module discovery-protocols #### Modules status: Global+ OS+ Device #### Load disco module arp-table #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ipNetToPhysicalPhysAddress[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 ipNetToMediaPhysAddress[0m] SQL[[0;33mSELECT * from `ipv4_mac` WHERE `device_id`='5' AND `context_name`=''[0m] 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] >> Runtime for discovery module 'arp-table': 0.0690 seconds with 2312 bytes >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module arp-table #### Modules status: Global- OS- Device Module [ discovery-arp ] disabled on os. Modules status: Global- OS- Device Module [ junose-atm-vp ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module bgp-peers #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -Oqvn -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 .1.3.6.1.2.1.15.2[0m] No BGP on hostPeers : SQL[[0;33mSELECT * FROM bgpPeers WHERE device_id = '5' AND (context_name = '' OR context_name IS NULL)[0m] >> Runtime for discovery module 'bgp-peers': 0.0400 seconds with 4704 bytes >> SNMP: [1/0.04s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module bgp-peers #### Modules status: Global+ OS+ Device #### Load disco module vlans #### SQL[[0;33mSELECT * FROM `vlans` WHERE `device_id` = '5'[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m BRIDGE-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 dot1dBasePortIfIndex[0m] IEEE8021-Q-BRIDGE-MIB VLANs: SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IEEE8021-Q-BRIDGE-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 dot1qVlanVersionNumber.0[0m] >> Runtime for discovery module 'vlans': 0.0620 seconds with 6832 bytes >> SNMP: [2/0.06s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module vlans #### Modules status: Global- OS- Device Module [ vmware-vminfo ] disabled on os. Modules status: Global- OS- Device Module [ libvirt-vminfo ] disabled on os. Modules status: Global- OS- Device Module [ toner ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module ucd-diskio #### SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-DISKIO-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 diskIOEntry[0m] Array ( ) SQL[[0;33mSELECT * FROM `ucd_diskio` where `device_id` = '5'[0m] >> Runtime for discovery module 'ucd-diskio': 0.0260 seconds with 2992 bytes >> SNMP: [1/0.03s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module ucd-diskio #### Modules status: Global- OS- Device Module [ applications ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module services #### >> Runtime for discovery module 'services': 0.0000 seconds with 328 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload disco module services #### Modules status: Global+ OS+ Device #### Load disco module stp #### SQL[[0;33mSELECT * FROM `stp` WHERE `device_id` = '5'[0m] SNMP[[0;36m/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 dot1dStpProtocolSpecification.0[0m] >> Runtime for discovery module 'stp': 0.0160 seconds with 5904 bytes >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module stp #### Modules status: Global+ OS+ Device #### Load disco module ntp #### >> Runtime for discovery module 'ntp': 8.7020 seconds with 144 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload disco module ntp #### Modules status: Global- OS- Device Module [ loadbalancers ] disabled on os. Modules status: Global- OS- Device Module [ mef ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module wireless #### Attempting to initialize OS: unifi OS initialized: LibreNMS\OS\Unifi SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='ap-count'[0m] clients: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UBNT-UniFi-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 unifiVapNumStations[0m] End of MIB SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='clients'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='quality'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='capacity'[0m] utilization: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UBNT-UniFi-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 unifiRadioCuTotal[0m] End of MIB SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='utilization'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='rate'[0m] ccq: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UBNT-UniFi-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 unifiVapCcq[0m] End of MIB SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='ccq'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='snr'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='ssr'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='mse'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='rssi'[0m] power: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UBNT-UniFi-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 unifiVapTxPower[0m] End of MIB SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='power'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='noise-floor'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='error-ratio'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='error-rate'[0m] frequency: SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UBNT-UniFi-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 unifiVapChannel[0m] End of MIB SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UBNT-UniFi-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 unifiVapRadio[0m] End of MIB SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='frequency'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='5' AND `sensor_class`='distance'[0m] >> Runtime for discovery module 'wireless': 0.1390 seconds with 235656 bytes >> SNMP: [6/0.13s] MySQL: [17/0.01s] RRD: [0/0.00s] #### Unload disco module wireless #### Modules status: Global+ OS+ Device #### Load disco module fdb-table #### SQL[[0;33mSELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = '5'[0m] SQL[[0;33mSELECT * FROM `ports_fdb` WHERE `device_id` = '5'[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m Q-BRIDGE-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 dot1qTpFdbPort[0m] SNMP[[0;36m/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m BRIDGE-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/ubnt udp:HOSTNAME:161 dot1dTpFdbPort[0m] >> Runtime for discovery module 'fdb-table': 0.0610 seconds with 3016 bytes >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module fdb-table #### SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '5' AND `attrib_type` = 'poll_mib' [0m] SQL[[0;33mUPDATE `devices` set `last_discovered` =NOW(),`last_discovered_timetaken` ='4.336' WHERE `device_id` = '5'[0m] Discovered in 4.336 seconds SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('discover','192.168.6.102','1514374909.6408','4.376','1','zabbix-proxy.trn.bonasource.ca')[0m] ./discovery.php 192.168.6.102 2017-12-27 06:41:54 - 1 devices discovered in 4.376 secs SNMP [43/3.03s]: Get[13/0.34s] Getnext[0/0.00s] Walk[30/2.69s] MySQL [84/0.03s]: Cell[8/0.00s] Row[4/0.00s] Rows[64/0.02s] Column[1/0.00s] Update[3/0.00s] Insert[2/0.00s] Delete[2/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]