- LibreNMS Discovery
- SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 1.23ms]
- SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.26ms]
- SQL[[1;33mSELECT version() [0;33m[][0m 0.16ms]
- ===================================
- Version info:
- Commit SHA: 431b645303d7bd251909df30ba17016cdad32bba
- Commit Date: 1548952820
- DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
- PHP: 7.2.14-1+ubuntu14.04.1+deb.sury.org+1
- MySQL: 5.6.33-0ubuntu0.14.04.1
- RRDTool: 1.4.7
- SNMP: NET-SNMP 5.7.2
- ==================================DEBUG!
- Updating os_def.cache... Done
- SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE 'beamer-1001' ORDER BY device_id DESC [0;33m[][0m 1.8ms]
- SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[25][0m 0.37ms]
- beamer-1001 25 generic [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 beamer-1001
- Array
- (
- [xmt] => 3
- [rcv] => 3
- [loss] => 0
- [min] => 0.28
- [max] => 0.58
- [avg] => 0.39
- [exitcode] => 0
- )
- SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"0.28","max":"0.58","avg":"0.39","device_id":25,"debug":"[]"}[0m 25.26ms]
- SNMP Check response code: 0
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovq' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0'[0m]
- EPSON Network Projector
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovqn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]
- .*.4.1.1248.4.1
- | EPSON Network Projector | .1.3.6.1.4.1.1248.4.1 |
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.12148.10.2.6.0'[0m]
- No Such Object available on this agent at this OID
- SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[25,"poll_mib"][0m 0.66ms]
- Attempting to initialize OS: generic
- OS initialized: LibreNMS\OS\Generic
- Modules status: Global+ OS Device
- #### Load disco module core ####
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
- .*.*.0 = Raum1001
- .*.*.0 = .*.4.1.1248.4.1
- .*.*.0 = EPSON Network Projector
- >> Runtime for discovery module 'core': 0.0190 seconds with 976 bytes
- >> SNMP: [5/0.10s] MySQL: [4/0.03s] RRD: [0/0.00s]
- #### Unload disco module core ####
- Modules status: Global+ OS+ Device
- #### Load disco module os ####
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovq' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0'[0m]
- EPSON Network Projector
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovqn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]
- .*.4.1.1248.4.1
- | EPSON Network Projector | .1.3.6.1.4.1.1248.4.1 |
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.12148.10.2.6.0'[0m]
- No Such Object available on this agent at this OID
- OS: Generic Device (generic)
- >> Runtime for discovery module 'os': 0.0560 seconds with 1344 bytes
- >> SNMP: [3/0.05s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload disco module os ####
- Modules status: Global+ OS+ Device
- #### Load disco module ports ####
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifDescr'[0m]
- ifDescr.1 = lo
- ifDescr.2 = eth0
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifName'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifAlias'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifType'[0m]
- ifType.1 = softwareLoopback
- ifType.2 = ethernetCsmacd
- Array
- (
- [1] => Array
- (
- [ifDescr] => lo
- [ifType] => softwareLoopback
- )
- [2] => Array
- (
- [ifDescr] => eth0
- [ifType] => ethernetCsmacd
- )
- )
- SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [0;33m[25][0m 1.15ms]
- Using ifDescr as ifAlias Using ifDescr as ifNameSQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? [0;33m["lo","softwareLoopback",1,"lo","lo",194][0m 39.41ms]
- . Using ifDescr as ifAlias Using ifDescr as ifNameSQL[[1;33mUPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? [0;33m["eth0","ethernetCsmacd",2,"eth0","eth0",195][0m 22.28ms]
- .
- >> Runtime for discovery module 'ports': 12.1500 seconds with 4976 bytes
- >> SNMP: [4/12.09s] MySQL: [3/0.06s] RRD: [0/0.00s]
- #### Unload disco module ports ####
- Modules status: Global+ OS+ Device
- #### Load disco module ports-stack ####
- SQL[[1;33mSELECT * FROM `ports_stack` WHERE `device_id` = '25' [0;33m[][0m 0.27ms]
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifStackStatus'[0m]
- Timeout: No Response from udp:beamer-1001:161
- >> Runtime for discovery module 'ports-stack': 6.0270 seconds with 1736 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/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'entPhysicalEntry'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SQL[[1;33mSELECT * FROM `entPhysical` WHERE `device_id` = ? [0;33m[25][0m 0.86ms]
- >> Runtime for discovery module 'entity-physical': 6.0450 seconds with 5456 bytes
- >> SNMP: [1/6.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 ####
- No YAML Discovery data.
- Host Resources: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrProcessorLoad'[0m]
- Timeout: No Response from udp:beamer-1001:161
- UCD Resources: SQL[[1;33mSELECT `devices`.*, `location`, `lat`, `lng` FROM `devices` LEFT JOIN locations ON `devices`.location_id=`locations`.`id` WHERE `device_id` = ? [0;33m[25][0m 0.84ms]
- SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[25][0m 0.28ms]
- SQL[[1;33mSELECT * FROM `vrf_lite_cisco` WHERE `device_id` = ? [0;33m[25][0m 0.25ms]
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovq' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.11.11.0'[0m]
- No Such Object available on this agent at this OID
- SQL[[1;33mSELECT * FROM `processors` WHERE `device_id`=? [0;33m[25][0m 0.68ms]
- 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 0.42ms]
- >> Runtime for discovery module 'processors': 6.0590 seconds with 65584 bytes
- >> SNMP: [2/6.05s] MySQL: [5/0.00s] RRD: [0/0.00s]
- #### Unload disco module processors ####
- Modules status: Global+ OS+ Device
- #### Load disco module mempools ####
- SQL[[1;33mSELECT COUNT(*) FROM `mempools` WHERE `device_id` = ? AND `mempool_type` = 'cemp' [0;33m[25][0m 0.29ms]
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'NETSWITCH-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/hp' 'udp:HOSTNAME:161' 'hpLocal'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'NETSWITCH-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/hp' 'udp:HOSTNAME:161' 'hpGlobal'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES:NetWare-Host-Ext-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SQL[[1;33mSELECT * FROM `mempools` WHERE `device_id` = '25' [0;33m[][0m 1.78ms]
- >> Runtime for discovery module 'mempools': 18.1100 seconds with 28720 bytes
- >> SNMP: [3/18.10s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload disco module mempools ####
- Modules status: Global+ OS+ Device
- #### Load disco module cisco-vrf-lite ####
- SQL[[1;33mSELECT * FROM vrf_lite_cisco WHERE device_id = ? [0;33m[25][0m 0.31ms]
- >> Runtime for discovery module 'cisco-vrf-lite': 0.0000 seconds with 2624 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 [ 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/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-Osq' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipAdEntIfIndex'[0m]
- ipAdEntIfIndex.* 2
- ipAdEntIfIndex.* 1
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipAdEntNetMask.10.0.0.214'[0m]
- *
- SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [0;33m[25,"2"][0m 0.75ms]
- SQL[[1;33mSELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[25,"2"][0m 0.22ms]
- SQL[[1;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? [0;33m["10.0.0.214\/24"][0m 0.32ms]
- SQL[[1;33mUPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [0;33m[null,"10.0.0.214\/24"][0m 20ms]
- sSQL[[1;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? [0;33m["10.0.0.214\/24"][0m 0.24ms]
- SQL[[1;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [0;33m["10.0.0.214",24,195][0m 0.28ms]
- SQL[[1;33mUPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [0;33m[null,"10.0.0.214",24,195][0m 23.32ms]
- .SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipAdEntNetMask.127.0.0.1'[0m]
- *
- SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [0;33m[25,"1"][0m 0.66ms]
- SQL[[1;33mSELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[25,"1"][0m 0.22ms]
- SQL[[1;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? [0;33m["127.0.0.1\/8"][0m 0.27ms]
- SQL[[1;33mUPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [0;33m[null,"127.0.0.1\/8"][0m 22.43ms]
- sSQL[[1;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? [0;33m["127.0.0.1\/8"][0m 0.22ms]
- SQL[[1;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [0;33m["127.0.0.1",8,194][0m 0.27ms]
- SQL[[1;33mUPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [0;33m[null,"127.0.0.1",8,194][0m 19.95ms]
- .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[25][0m 0.68ms]
- >> Runtime for discovery module 'ipv4-addresses': 0.1720 seconds with 34288 bytes
- >> SNMP: [3/0.08s] MySQL: [5/0.09s] RRD: [0/0.00s]
- #### Unload disco module ipv4-addresses ####
- Modules status: Global+ OS+ Device
- #### Load disco module ipv6-addresses ####
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-Osq' '-Ln' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipAddressIfIndex.ipv6'[0m]
- ipAddressIfIndex.ipv6 No Such Object available on this agent at this OID
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OsqnU' '-Ln' '-m' 'IPV6-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipv6AddrPfxLength'[0m]
- Timeout: No Response from udp:beamer-1001:161
- 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[25][0m 0.76ms]
- >> Runtime for discovery module 'ipv6-addresses': 6.0500 seconds with 3296 bytes
- >> SNMP: [2/6.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/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'entPhysicalDescr'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[25,"ipmi_hostname"][0m 0.69ms]
- 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",25,"ipmi"][0m 0.78ms]
- 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",25,"ipmi"][0m 0.49ms]
- 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",25,"ipmi"][0m 0.52ms]
- 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",25,"ipmi"][0m 0.48ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.48ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.51ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.47ms]
- Power_consumed: 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",25,"snmp"][0m 0.5ms]
- Power_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["power_factor",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.5ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.47ms]
- Count: 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.48ms]
- 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",25,"snmp"][0m 0.5ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.48ms]
- 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",25,"snmp"][0m 0.49ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.46ms]
- 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",25,"snmp"][0m 0.47ms]
- 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",25,"snmp"][0m 0.48ms]
- >> Runtime for discovery module 'sensors': 6.0480 seconds with 47200 bytes
- >> SNMP: [1/6.03s] MySQL: [31/0.02s] RRD: [0/0.00s]
- #### Unload disco module sensors ####
- Modules status: Global+ OS+ Device
- #### Load disco module storage ####
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'DATA-DOMAIN-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/datadomain' 'udp:HOSTNAME:161' 'fileSystemSpaceTable'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES:NetWare-Host-Ext-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-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` = '25' AND `storage_type` != 'dsk' [0;33m[][0m 0.74ms]
- SQL[[1;33mSELECT * FROM `storage` WHERE `device_id` = '25' [0;33m[][0m 0.28ms]
- >> Runtime for discovery module 'storage': 12.1000 seconds with 8936 bytes
- >> SNMP: [3/12.11s] MySQL: [1/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/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrDeviceEntry'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrProcessorEntry'[0m]
- Timeout: No Response from udp:beamer-1001:161
- Array
- (
- )
- SQL[[1;33mSELECT * FROM `hrDevice` WHERE `device_id` = '25' [0;33m[][0m 1.05ms]
- >> Runtime for discovery module 'hr-device': 12.0500 seconds with 3704 bytes
- >> SNMP: [2/12.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/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'CISCO-CDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'cdpCache'[0m]
- Timeout: No Response from udp:beamer-1001:161
- LLDP-MIB: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'LLDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'lldpRemTable'[0m]
- lldpRemTable = No Such Object available on this agent at this OID
- OSPF Discovery: SQL[[1;33mSELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`=? [0;33m[25][0m 0.82ms]
- SQL[[1;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [0;33m[25][0m 0.66ms]
- 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 0.32ms]
- 0 orphaned links deleted
- >> Runtime for discovery module 'discovery-protocols': 6.0800 seconds with 5112 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/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipNetToPhysicalPhysAddress'[0m]
- ipNetToPhysicalPhysAddress = No Such Object available on this agent at this OID
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipNetToMediaPhysAddress'[0m]
- ipNetToMediaPhysAddress[2][*] = 0:c:29:af:52:7d
- SQL[[1;33mSELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [0;33m[25,""][0m 0.98ms]
- SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[25,2][0m 0.56ms]
- eth0:
- 0:c:29:af:52:7d => 10.0.0.248
- SQL[[1;33mDELETE FROM `ipv4_mac` WHERE `port_id` = ? AND `mac_address`=? AND `ipv4_address`=? AND `context_name`=? [0;33m[195,"906caca8927f","10.0.0.254",""][0m 30.09ms]
- 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 1.26ms]
- >> Runtime for discovery module 'arp-table': 0.0830 seconds with 15208 bytes
- >> SNMP: [0/0.00s] MySQL: [4/0.03s] 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/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-Oqvn' '-m' 'BGP4-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'bgpLocalAs'[0m]
- 349
- AS349 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-Oq' '-m' 'BGP4-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'bgpPeerRemoteAs'[0m]
- Timeout: No Response from udp:beamer-1001:161
- Peers :
- SQL[[1;33mDELETE FROM `bgpPeers` WHERE device_id=? AND context_name=? [0;33m[25,""][0m 0.98ms]
- SQL[[1;33mDELETE FROM `bgpPeers_cbgp` WHERE device_id=? AND context_name=? [0;33m[25,""][0m 0.27ms]
- SQL[[1;33mSELECT DISTINCT context_name FROM bgpPeers WHERE device_id=? [0;33m[25][0m 0.34ms]
- >> Runtime for discovery module 'bgp-peers': 6.0470 seconds with 6464 bytes
- >> SNMP: [2/6.04s] MySQL: [2/0.00s] RRD: [0/0.00s]
- #### Unload disco module bgp-peers ####
- Modules status: Global+ OS+ Device
- #### Load disco module vlans ####
- SQL[[1;33mSELECT * FROM `vlans` WHERE `device_id` = ? [0;33m[25][0m 0.26ms]
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dBasePortIfIndex'[0m]
- Timeout: No Response from udp:beamer-1001:161
- IEEE8021-Q-BRIDGE-MIB VLANs: SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'IEEE8021-Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qVlanVersionNumber.0'[0m]
- No Such Object available on this agent at this OID
- >> Runtime for discovery module 'vlans': 6.1150 seconds with 9248 bytes
- >> SNMP: [2/6.11s] 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/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-DISKIO-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'diskIOEntry'[0m]
- diskIOEntry = No more variables left in this MIB View (It is past the end of the MIB tree)
- Array
- (
- )
- SQL[[1;33mSELECT * FROM `ucd_diskio` where `device_id` = '25' [0;33m[][0m 0.9ms]
- >> Runtime for discovery module 'ucd-diskio': 0.0600 seconds with 3160 bytes
- >> SNMP: [1/0.06s] 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 296 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[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[25][0m 0.35ms]
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
- No Such Object available on this agent at this OID
- >> Runtime for discovery module 'stp': 0.0570 seconds with 5792 bytes
- >> SNMP: [1/0.06s] 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': 0.0000 seconds with 232 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 ####
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"ap-count"][0m 0.91ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"clients"][0m 2.84ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"quality"][0m 9.01ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"capacity"][0m 0.53ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"utilization"][0m 0.31ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"rate"][0m 0.3ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"ccq"][0m 0.34ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"snr"][0m 1.23ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"ssr"][0m 0.29ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"mse"][0m 0.32ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"xpi"][0m 0.45ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"rssi"][0m 0.29ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"power"][0m 0.29ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"noise-floor"][0m 0.3ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"errors"][0m 0.29ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"error-ratio"][0m 0.29ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"error-rate"][0m 0.3ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"frequency"][0m 0.3ms]
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [0;33m[25,"distance"][0m 0.31ms]
- >> Runtime for discovery module 'wireless': 0.0310 seconds with 142000 bytes
- >> SNMP: [0/0.00s] MySQL: [19/0.03s] RRD: [0/0.00s]
- #### Unload disco module wireless ####
- Modules status: Global+ OS+ Device
- #### Load disco module fdb-table ####
- SQL[[1;33mSELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = ? [0;33m[25][0m 0.25ms]
- SQL[[1;33mSELECT * FROM `ports_fdb` WHERE `device_id` = ? [0;33m[25][0m 0.26ms]
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qTpFdbPort'[0m]
- Timeout: No Response from udp:beamer-1001:161
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dTpFdbPort'[0m]
- Timeout: No Response from udp:beamer-1001:161
- >> Runtime for discovery module 'fdb-table': 12.2300 seconds with 3016 bytes
- >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s]
- #### Unload disco module fdb-table ####
- SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[25,"poll_mib"][0m 1.55ms]
- SQL[[1;33mUPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [0;33m[116.77,25][0m 22.72ms]
- Discovered in 116.77 seconds
- 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":"beamer-1001","start":1549375399.38222,"duration":"117.0","devices":1,"poller":"management"}[0m 21.76ms]
- ./discovery.php beamer-1001 2019-02-05 15:05:16 - 1 devices discovered in 117.0 secs
- SNMP [35/91.04s]: Get[13/0.38s] Getnext[1/0.02s] Walk[21/90.64s]
- MySQL [91/0.32s]: Cell[12/0.01s] Row[-6/0.00s] Rows[68/0.06s] Column[2/0.00s] Update[7/0.17s] Insert[2/0.05s] Delete[6/0.04s]
- RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]