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]