LibreNMS Discovery SQL[[1;33mselect `version` from `dbSchema` order by `version` desc limit 1 [0;33m[][0m 0.35ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.33ms] =================================== Version info: Commit SHA: de7ce7c757f430e6b87cff360b24a668bd9290d1 Commit Date: 1545668942 DB Schema: 275 PHP: 7.2.11 MySQL: 10.2.18-MariaDB RRDTool: 1.6.0 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 '10.0.2.49' ORDER BY device_id DESC [0;33m[][0m 8.11ms] SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[427][0m 0.33ms] 10.0.2.49 427 generic [FPING] /usr/sbin/fping -e -q -c 3 -p 500 -t 1000 10.0.2.49 Array ( [xmt] => 3 [rcv] => 3 [loss] => 0 [min] => 0.68 [max] => 2.01 [avg] => 1.43 [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.68","max":"2.01","avg":"1.43","device_id":427,"debug":"[]"}[0m 2.66ms] 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] MIB search path: /opt/librenms/mibs Cannot find module (VALERE-DC-POWER-MIB): At line 0 in (none) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-Ovqn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] .*.2.1.1 MIB search path: /opt/librenms/mibs Cannot find module (VALERE-DC-POWER-MIB): At line 0 in (none) | | .1.3.6.1.2.1.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 MIB search path: /opt/librenms/mibs Cannot find module (VALERE-DC-POWER-MIB): At line 0 in (none) Device os was updated to powerlogic!SQL[[1;33mUPDATE `devices` set `os`=? WHERE `device_id` = ? [0;33m["powerlogic",427][0m 2.87ms] SQL[[1;33mINSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) [0;33m{"host":427,"device_id":427,"reference":"NULL","type":"system","severity":3,"message":"Device type changed server => power","username":""}[0m 1.53ms] SQL[[1;33mUPDATE `devices` set `type`=? WHERE device_id=? [0;33m["power",427][0m 1.46ms] Device type changed to power! SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[427,"poll_mib"][0m 0.43ms] Attempting to initialize OS: powerlogic OS initilized as 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = PM8000 .*.*.0 = .*.2.1.1 .*.*.0 = >> Runtime for discovery module 'core': 0.0180 seconds with 936 bytes >> SNMP: [5/0.20s] MySQL: [7/0.02s] 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0'[0m] MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/schneider Cannot find module (VALERE-DC-POWER-MIB): At line 0 in (none) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-Ovqn' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] .*.2.1.1 MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/schneider Cannot find module (VALERE-DC-POWER-MIB): At line 0 in (none) | | .1.3.6.1.2.1.1 | SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' '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 MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/schneider Cannot find module (VALERE-DC-POWER-MIB): At line 0 in (none) OS: Schneider PowerLogic (powerlogic) SQL[[1;33mINSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) [0;33m{"host":427,"device_id":427,"reference":"NULL","type":"system","severity":3,"message":"Device Icon changed generic.svg => schneider.svg","username":""}[0m 3.39ms] SQL[[1;33mUPDATE `devices` set `icon`=? WHERE device_id=? [0;33m["schneider.svg",427][0m 1.67ms] Changed Icon! : schneider.svg >> Runtime for discovery module 'os': 0.1390 seconds with 2560 bytes >> SNMP: [3/0.13s] MySQL: [2/0.01s] 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ifDescr'[0m] ifDescr.1 = lo0 ifDescr.2 = seGmac0 ifDescr.3 = seGmac2 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ifName'[0m] ifName.1 = lo0 ifName.2 = seGmac0 ifName.3 = seGmac2 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ifAlias'[0m] ifAlias.1 = ifAlias.2 = ifAlias.3 = SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ifType'[0m] ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd Array ( [1] => Array ( [ifDescr] => lo0 [ifName] => lo0 [ifAlias] => [ifType] => softwareLoopback ) [2] => Array ( [ifDescr] => seGmac0 [ifName] => seGmac0 [ifAlias] => [ifType] => ethernetCsmacd ) [3] => Array ( [ifDescr] => seGmac2 [ifName] => seGmac2 [ifAlias] => [ifType] => ethernetCsmacd ) ) SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [0;33m[427][0m 1.18ms] SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["softwareLoopback","lo0","lo0","lo0",3584][0m 0.41ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","seGmac0","seGmac0","seGmac0",3585][0m 0.29ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","seGmac2","seGmac2","seGmac2",3586][0m 0.29ms] . >> Runtime for discovery module 'ports': 0.1000 seconds with 4504 bytes >> SNMP: [4/0.10s] MySQL: [4/0.00s] 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` = '427' [0;33m[][0m 0.35ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ifStackStatus'[0m] ifStackStatus = No Such Object available on this agent at this OID >> Runtime for discovery module 'ports-stack': 0.0340 seconds with 1688 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'entPhysicalEntry'[0m] entPhysicalEntry = No Such Object available on this agent at this OID SQL[[1;33mSELECT * FROM `entPhysical` WHERE `device_id` = ? [0;33m[427][0m 0.73ms] >> Runtime for discovery module 'entity-physical': 0.0640 seconds with 6096 bytes >> SNMP: [1/0.06s] 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'hrProcessorLoad'[0m] hrProcessorLoad = No Such Object available on this agent at this OID 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[427][0m 1.35ms] SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[427][0m 0.49ms] SQL[[1;33mSELECT * FROM `vrf_lite_cisco` WHERE `device_id` = ? [0;33m[427][0m 2.58ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-Ovq' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.11.11.0'[0m] No Such Object available on this agent at this OID MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/schneider Cannot find module (VALERE-DC-POWER-MIB): At line 0 in (none) SQL[[1;33mSELECT * FROM `processors` WHERE `device_id`=? [0;33m[427][0m 0.65ms] 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.74ms] >> Runtime for discovery module 'processors': 0.0880 seconds with 139328 bytes >> SNMP: [2/0.08s] MySQL: [5/0.01s] 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[427][0m 0.36ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'NETSWITCH-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider:/opt/librenms/mibs/hp' 'udp:HOSTNAME:161' 'hpLocal'[0m] hpLocalMem = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'NETSWITCH-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider:/opt/librenms/mibs/hp' 'udp:HOSTNAME:161' 'hpGlobal'[0m] hpGlobalMem = No Such Object available on this agent at this OID 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m] hrStorageEntry = No Such Object available on this agent at this OID SQL[[1;33mSELECT * FROM `mempools` WHERE `device_id` = '427' [0;33m[][0m 1.47ms] >> Runtime for discovery module 'mempools': 0.1180 seconds with 28200 bytes >> SNMP: [3/0.11s] 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[427][0m 1.22ms] >> Runtime for discovery module 'cisco-vrf-lite': 0.0010 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ipAdEntIfIndex'[0m] ipAdEntIfIndex No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-Oqv' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ipAdEntNetMask.'[0m] No Such Object available on this agent at this OID SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [0;33m[427,null][0m 3.5ms] !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[427][0m 3.84ms] >> Runtime for discovery module 'ipv4-addresses': 0.0950 seconds with 33368 bytes >> SNMP: [2/0.09s] MySQL: [1/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/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-Osq' '-Ln' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ipAddressIfIndex.ipv6'[0m] ipAddressIfIndex.ipv6."00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01" 1 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.4.34.1.5.2.16.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.1'[0m] IP-MIB::ipAddressPrefix.ipv6."00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01" = OID: IP-MIB::ipAddressPrefixOrigin.1.ipv6."00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01".128 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-Ovq' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.4.34.1.6.2.16.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.1'[0m] manual SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [0;33m[427,"1"][0m 0.61ms] 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[427][0m 0.55ms] >> Runtime for discovery module 'ipv6-addresses': 0.1170 seconds with 20752 bytes >> SNMP: [3/0.12s] 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 #### Pre-cache powerlogic: loadCurrentTable SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'PM8ECCMIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'loadCurrentTable'[0m] loadCurrentTable = No Such Object available on this agent at this OID powerTable SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'PM8ECCMIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'powerTable'[0m] powerTable = No Such Object available on this agent at this OID voltageTable SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'PM8ECCMIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'voltageTable'[0m] voltageTable = No Such Object available on this agent at this OID frequencyTable SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'PM8ECCMIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'frequencyTable'[0m] frequencyTable = No Such Object available on this agent at this OID Array ( [powerlogic_loadCurrentTable] => Array ( ) [powerlogic_powerTable] => Array ( ) [powerlogic_voltageTable] => Array ( ) [powerlogic_frequencyTable] => Array ( ) ) ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'ENTITY-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'entPhysicalDescr'[0m] entPhysicalDescr = 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[427,"ipmi_hostname"][0m 0.53ms] 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",427,"ipmi"][0m 0.64ms] 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",427,"ipmi"][0m 0.57ms] 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",427,"ipmi"][0m 0.54ms] 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",427,"ipmi"][0m 0.55ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.53ms] 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",427,"snmp"][0m 0.53ms] 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",427,"snmp"][0m 0.54ms] 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",427,"snmp"][0m 0.54ms] 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",427,"snmp"][0m 0.54ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.51ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.53ms] 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",427,"snmp"][0m 0.55ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.51ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.52ms] 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",427,"snmp"][0m 0.53ms] 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",427,"snmp"][0m 0.53ms] 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",427,"snmp"][0m 0.51ms] 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",427,"snmp"][0m 0.52ms] >> Runtime for discovery module 'sensors': 0.2540 seconds with 50584 bytes >> SNMP: [5/0.23s] MySQL: [28/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/schneider:/opt/librenms/mibs/datadomain' 'udp:HOSTNAME:161' 'fileSystemSpaceTable'[0m] fileSystemSpaceTable = No Such Object available on this agent at this OID 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m] hrStorageEntry = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'dskTable'[0m] dskTable = No Such Object available on this agent at this OID SQL[[1;33mSELECT `storage_descr` FROM `storage` WHERE `device_id` = '427' AND `storage_type` != 'dsk' [0;33m[][0m 0.59ms] SQL[[1;33mSELECT * FROM `storage` WHERE `device_id` = '427' [0;33m[][0m 0.31ms] >> Runtime for discovery module 'storage': 0.1310 seconds with 8872 bytes >> SNMP: [3/0.13s] 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'hrDeviceEntry'[0m] hrDeviceEntry = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'hrProcessorEntry'[0m] hrProcessorEntry = No Such Object available on this agent at this OID Array ( ) SQL[[1;33mSELECT * FROM `hrDevice` WHERE `device_id` = '427' [0;33m[][0m 9.78ms] >> Runtime for discovery module 'hr-device': 0.0950 seconds with 3640 bytes >> SNMP: [2/0.09s] MySQL: [1/0.01s] 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'cdpCache'[0m] cdpCache = No Such Object available on this agent at this OID LLDP-MIB: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUsetX' '-m' 'LLDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' '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[427][0m 0.68ms] SQL[[1;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [0;33m[427][0m 1.34ms] 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.63ms] 0 orphaned links deleted >> Runtime for discovery module 'discovery-protocols': 0.1510 seconds with 5064 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ipNetToPhysicalPhysAddress'[0m] ipNetToPhysicalPhysAddress[1][ipv4]["*"] = 0:0:0:0:0:0 ipNetToPhysicalPhysAddress[1][ipv4]["*"] = 0:0:0:0:0:0 ipNetToPhysicalPhysAddress[1][ipv4]["*"] = 0:0:0:0:0:0 ipNetToPhysicalPhysAddress[1][ipv6]["00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01"] = 0:0:0:0:0:0 ipNetToPhysicalPhysAddress[2][ipv4]["*"] = 18:66:da:aa:25:b2 ipNetToPhysicalPhysAddress[2][ipv4]["*"] = 0:c:29:25:28:3a ipNetToPhysicalPhysAddress[2][ipv4]["*"] = 0:60:78:5:5:e5 ipNetToPhysicalPhysAddress[2][ipv4]["*"] = 0:c:29:f7:5b:99 ipNetToPhysicalPhysAddress[2][ipv4]["*"] = 0:50:56:98:bc:b ipNetToPhysicalPhysAddress[2][ipv4]["*"] = ff:ff:ff:ff:ff:ff ipNetToPhysicalPhysAddress[2][ipv6]["fe:80:00:00:00:00:00:00:02:60:78:ff:fe:05:05:e5"] = 0:60:78:5:5:e5 ipNetToPhysicalPhysAddress[2][ipv6]["ff:02:00:00:00:00:00:00:00:00:00:00:00:01:00:03"] = 33:33:0:1:0:3 ipNetToPhysicalPhysAddress[3][ipv4]["*"] = 0:60:78:5:5:e5 ipNetToPhysicalPhysAddress[3][ipv4]["*"] = 84:eb:18:97:35:e3 ipNetToPhysicalPhysAddress[3][ipv4]["*"] = 1:0:5e:0:0:16 ipNetToPhysicalPhysAddress[3][ipv4]["*"] = 1:0:5e:0:0:fb ipNetToPhysicalPhysAddress[3][ipv4]["*"] = 1:0:5e:0:0:fc ipNetToPhysicalPhysAddress[3][ipv4]["*"] = 1:0:5e:0:1:2 ipNetToPhysicalPhysAddress[3][ipv4]["*"] = 1:0:5e:7f:ff:fa ipNetToPhysicalPhysAddress[3][ipv4]["*"] = ff:ff:ff:ff:ff:ff SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUsetX' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'ipNetToMediaPhysAddress'[0m] ipNetToMediaPhysAddress = No Such Object available on this agent at this OID SQL[[1;33mSELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [0;33m[427,""][0m 3.2ms] SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[427,1][0m 0.54ms] lo0: SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[427,2][0m 1.54ms] seGmac0: 18:66:da:aa:25:b2 => 10.0.2.7 0:c:29:25:28:3a => 10.0.2.9 0:60:78:5:5:e5 => 10.0.2.49 0:c:29:f7:5b:99 => 10.0.2.251 0:50:56:98:bc:b => 10.0.6.121 ff:ff:ff:ff:ff:ff => 10.0.15.255 SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[427,3][0m 0.63ms] seGmac2: 0:60:78:5:5:e5 => 169.254.254.1 84:eb:18:97:35:e3 => 169.254.254.2 1:0:5e:0:0:16 => 224.0.0.22 1:0:5e:0:0:fb => 224.0.0.251 1:0:5e:0:0:fc => 224.0.0.252 1:0:5e:0:1:2 => 224.0.1.2 1:0:5e:7f:ff:fa => 239.255.255.250 ff:ff:ff:ff:ff:ff => 255.255.255.255 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 9.17ms] >> Runtime for discovery module 'arp-table': 0.1050 seconds with 39112 bytes >> SNMP: [0/0.00s] MySQL: [5/0.02s] 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'bgpLocalAs'[0m] "lo0" No BGP on hostPeers : SQL[[1;33mDELETE FROM `bgpPeers` WHERE device_id=? AND context_name=? [0;33m[427,""][0m 0.36ms] SQL[[1;33mDELETE FROM `bgpPeers_cbgp` WHERE device_id=? AND context_name=? [0;33m[427,""][0m 0.33ms] SQL[[1;33mSELECT DISTINCT context_name FROM bgpPeers WHERE device_id=? [0;33m[427][0m 0.46ms] >> Runtime for discovery module 'bgp-peers': 0.0230 seconds with 5568 bytes >> SNMP: [1/0.02s] 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[427][0m 0.51ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'dot1dBasePortIfIndex'[0m] dot1dBasePortIfIndex = No Such Object available on this agent at this OID IEEE8021-Q-BRIDGE-MIB VLANs: SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-Oqv' '-m' 'IEEE8021-Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'dot1qVlanVersionNumber.0'[0m] No Such Object available on this agent at this OID >> Runtime for discovery module 'vlans': 0.0770 seconds with 9200 bytes >> SNMP: [2/0.08s] 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:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'diskIOEntry'[0m] diskIOEntry = No Such Object available on this agent at this OID Array ( ) SQL[[1;33mSELECT * FROM `ucd_diskio` where `device_id` = '427' [0;33m[][0m 0.78ms] >> Runtime for discovery module 'ucd-diskio': 0.0410 seconds with 3112 bytes >> SNMP: [1/0.04s] 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[427][0m 14.61ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] No Such Object available on this agent at this OID >> Runtime for discovery module 'stp': 0.0490 seconds with 5744 bytes >> SNMP: [1/0.03s] MySQL: [1/0.01s] 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 Module [ wireless ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module fdb-table #### SQL[[1;33mSELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = ? [0;33m[427][0m 0.39ms] SQL[[1;33mSELECT * FROM `ports_fdb` WHERE `device_id` = ? [0;33m[427][0m 0.28ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUsetX' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'dot1qTpFdbPort'[0m] dot1qTpFdbPort = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUsetX' '-m' 'BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/schneider' 'udp:HOSTNAME:161' 'dot1dTpFdbPort'[0m] dot1dTpFdbPort = No Such Object available on this agent at this OID >> Runtime for discovery module 'fdb-table': 0.0860 seconds with 2984 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[427,"poll_mib"][0m 0.57ms] SQL[[1;33mUPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [0;33m[3.008,427][0m 5.38ms] Discovered in 3.008 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":"10.0.2.49","start":1545935326.741821,"duration":"3.226","devices":1,"poller":"soc-tools.local"}[0m 5.61ms] ./discovery.php 10.0.2.49 2018-12-27 12:28:49 - 1 devices discovered in 3.226 secs SNMP [38/1.51s]: Get[14/0.54s] Getnext[1/0.02s] Walk[23/0.95s] MySQL [72/0.12s]: Cell[4/0.01s] Row[4/0.02s] Rows[46/0.06s] Column[2/0.00s] Update[7/0.01s] Insert[4/0.01s] Delete[5/0.01s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]