LibreNMS Discovery SQL[[0;33mSELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1[0m] SQL[[0;33mSELECT version()[0m] =================================== Version info: Commit SHA: 63a4977489699c62f96dd2ee757bcae853704bb3 Commit Date: 1533624589 DB Schema: 258 PHP: 7.1.17-1+ubuntu16.04.1+deb.sury.org+1 MySQL: 5.6.38 RRDTool: 1.5.5 SNMP: NET-SNMP 5.7.3 ==================================DEBUG! Updating os_def.cache... Done SQL[[0;33mSELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE 'fortimail.lepeer.local' ORDER BY device_id DESC[0m] SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '9'[0m] fortimail.lepeer.local 9 generic SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','0.34','0.40','0.36','9',NOW())[0m] SNMP Check response code: 0 SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Ovq -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0[0m] fortimail SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Ovqn -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0[0m] .*.4.1.12356.105 | fortimail | .1.3.6.1.4.1.12356.105 | SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -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[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '9' AND `attrib_type` = 'poll_mib' [0m] 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OUQn -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysName.0 sysObjectID.0 sysDescr.0[0m] .*.*.0 = FEVM000000151155 .*.*.0 = .*.4.1.12356.105 .*.*.0 = fortimail >> Runtime for discovery module 'core': 0.0730 seconds with 1032 bytes >> SNMP: [5/0.41s] MySQL: [8/0.22s] RRD: [0/0.00s] #### Unload disco module core #### Modules status: Global+ OS+ Device #### Load disco module os #### SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Ovq -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0[0m] fortimail SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Ovqn -M /opt/librenms/mibs udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0[0m] .*.4.1.12356.105 | fortimail | .1.3.6.1.4.1.12356.105 | SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -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.2500 seconds with 1320 bytes >> SNMP: [3/0.25s] 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifDescr[0m] ifDescr.1 = port1 ifDescr.2 = port2 ifDescr.3 = port3 ifDescr.4 = port4 SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifName[0m] ifName = No Such Object available on this agent at this OID SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifAlias[0m] ifAlias = No Such Object available on this agent at this OID SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifType[0m] ifType.1 = ethernetCsmacd ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd Array ( [1] => Array ( [ifDescr] => port1 [ifType] => ethernetCsmacd ) [2] => Array ( [ifDescr] => port2 [ifType] => ethernetCsmacd ) [3] => Array ( [ifDescr] => port3 [ifType] => ethernetCsmacd ) [4] => Array ( [ifDescr] => port4 [ifType] => ethernetCsmacd ) ) SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '9' ORDER BY port_id[0m] .... >> Runtime for discovery module 'ports': 0.3360 seconds with 4168 bytes >> SNMP: [4/0.33s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module ports #### Modules status: Global+ OS+ Device #### Load disco module ports-stack #### SQL[[0;33mSELECT * FROM `ports_stack` WHERE `device_id` = '9'[0m] SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifStackStatus[0m] ifStackStatus = No Such Object available on this agent at this OID >> Runtime for discovery module 'ports-stack': 0.0780 seconds with 1768 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module ports-stack #### Modules status: Global+ OS+ Device #### Load disco module entity-physical #### Caching OIDs: entPhysicalEntrySNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 entPhysicalEntry[0m] entPhysicalEntry = No Such Object available on this agent at this OID SQL[[0;33mSELECT * FROM `entPhysical` WHERE `device_id` = '9'[0m] >> Runtime for discovery module 'entity-physical': 0.1110 seconds with 16448 bytes >> SNMP: [1/0.11s] 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 hrProcessorLoad[0m] hrProcessorLoad = No Such Object available on this agent at this OID UCD Resources: SQL[[0;33mSELECT `devices`.*, `lat`, `lng` FROM `devices` LEFT JOIN locations ON `devices`.`location`=`locations`.`location` WHERE `device_id` = '9'[0m] SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '9'[0m] SQL[[0;33mSELECT * FROM `vrf_lite_cisco` WHERE `device_id` = '9'[0m] SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -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[[0;33mSELECT * FROM `processors` WHERE `device_id`='9'[0m] SQL[[0;33mDELETE T FROM `processors` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `devices`.`device_id` IS NULL[0m] >> Runtime for discovery module 'processors': 0.1810 seconds with 69648 bytes >> SNMP: [2/0.17s] MySQL: [5/0.00s] RRD: [0/0.00s] #### Unload disco module processors #### Modules status: Global+ OS+ Device #### Load disco module mempools #### SQL[[0;33mSELECT COUNT(*) FROM `mempools` WHERE `device_id` = '9' AND `mempool_type` = 'cemp'[0m] SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m NETSWITCH-MIB -M /opt/librenms/mibs:/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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m NETSWITCH-MIB -M /opt/librenms/mibs:/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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES:NetWare-Host-Ext-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 hrStorageEntry[0m] hrStorageEntry = No Such Object available on this agent at this OID SQL[[0;33mSELECT * FROM `mempools` WHERE `device_id` = '9'[0m] >> Runtime for discovery module 'mempools': 0.2950 seconds with 36664 bytes >> SNMP: [3/0.29s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module mempools #### Modules status: Global+ OS+ Device #### Load disco module cisco-vrf-lite #### SQL[[0;33mSELECT * FROM vrf_lite_cisco WHERE device_id = '9' [0m] >> Runtime for discovery module 'cisco-vrf-lite': 0.0010 seconds with 2640 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module cisco-vrf-lite #### Modules status: Global- OS- Device Module [ cisco-mac-accounting ] disabled on os. Modules status: Global- OS- Device Module [ cisco-pw ] disabled on os. Modules status: Global- OS- Device Module [ 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Osq -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntIfIndex[0m] ipAdEntIfIndex.* 1 ipAdEntIfIndex.* 2 SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Oqv -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntNetMask.10.1.1.244[0m] * SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE device_id = '9' AND `ifIndex` = '1'[0m] SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '9' AND `ifIndex` = '1'[0m] SQL[[0;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = '10.1.1.244/24'[0m] SQL[[0;33mUPDATE `ipv4_networks` set `context_name` ='' WHERE `ipv4_network` = '10.1.1.244/24'[0m] sSQL[[0;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.1.1.244/24'[0m] SQL[[0;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = '10.1.1.244' AND `ipv4_prefixlen` = '24' AND `port_id` = '127' [0m] SQL[[0;33mUPDATE `ipv4_addresses` set `context_name` ='' WHERE `ipv4_address` = '10.1.1.244' AND `ipv4_prefixlen` = '24' AND `port_id` = '127'[0m] .SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Oqv -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAdEntNetMask.192.168.2.99[0m] * SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE device_id = '9' AND `ifIndex` = '2'[0m] SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `device_id` = '9' AND `ifIndex` = '2'[0m] SQL[[0;33mSELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = '192.168.2.99/24'[0m] SQL[[0;33mUPDATE `ipv4_networks` set `context_name` ='' WHERE `ipv4_network` = '192.168.2.99/24'[0m] sSQL[[0;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '192.168.2.99/24'[0m] SQL[[0;33mSELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = '192.168.2.99' AND `ipv4_prefixlen` = '24' AND `port_id` = '128' [0m] SQL[[0;33mUPDATE `ipv4_addresses` set `context_name` ='' WHERE `ipv4_address` = '192.168.2.99' AND `ipv4_prefixlen` = '24' AND `port_id` = '128'[0m] .SQL[[0;33mSELECT `ipv4_addresses`.*, `ports`.`device_id`, `ports`.`ifIndex` FROM `ipv4_addresses` LEFT JOIN `ports` ON `ipv4_addresses`.`port_id` = `ports`.`port_id` WHERE `ports`.device_id = '9' OR `ports`.`device_id` IS NULL[0m] >> Runtime for discovery module 'ipv4-addresses': 0.7270 seconds with 35032 bytes >> SNMP: [3/0.27s] MySQL: [15/0.46s] 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Ln -Osq -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipAddressIfIndex.ipv6[0m] ipAddressIfIndex.ipv6 No Such Instance currently exists at this OID SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Ln -Osq -OnU -m IPV6-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipv6AddrPfxLength[0m] .*.*.8.1.2 No Such Object available on this agent at this OID SQL[[0;33mSELECT `ipv6_addresses`.*, `ports`.`device_id`, `ports`.`ifIndex` FROM `ipv6_addresses` LEFT JOIN `ports` ON `ipv6_addresses`.`port_id` = `ports`.`port_id` WHERE `ports`.device_id = '9' OR `ports`.`device_id` IS NULL[0m] >> Runtime for discovery module 'ipv6-addresses': 0.1790 seconds with 3376 bytes >> SNMP: [2/0.18s] 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m CISCO-ENTITY-SENSOR-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 entPhysicalDescr[0m] entPhysicalDescr = No Such Object available on this agent at this OID SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '9' AND `attrib_type` = 'ipmi_hostname' [0m] SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'ipmi'[0m] SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'ipmi'[0m] SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'ipmi'[0m] SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'ipmi'[0m] Airflow: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='airflow' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Current: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='current' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Charge: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='charge' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Dbm: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='dbm' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Fanspeed: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Frequency: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='frequency' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Humidity: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='humidity' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Load: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='load' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Power: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Runtime: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='runtime' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Signal: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='signal' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] State: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='state' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Temperature: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Voltage: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Snr: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='snr' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Pressure: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='pressure' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Cooling: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='cooling' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Delay: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='delay' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Quality_factor: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='quality_factor' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Chromatic_dispersion: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='chromatic_dispersion' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Ber: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='ber' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Eer: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='eer' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] Waterflow: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='waterflow' AND S.device_id = D.device_id AND D.device_id = '9' AND S.poller_type = 'snmp'[0m] >> Runtime for discovery module 'sensors': 0.1190 seconds with 110088 bytes >> SNMP: [1/0.08s] MySQL: [28/0.03s] RRD: [0/0.00s] #### Unload disco module sensors #### Modules status: Global+ OS+ Device #### Load disco module storage #### SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES:NetWare-Host-Ext-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 hrStorageEntry[0m] hrStorageEntry = No Such Object available on this agent at this OID SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dskTable[0m] dskTable = No Such Object available on this agent at this OID SQL[[0;33mSELECT `storage_descr` FROM `storage` WHERE `device_id` = '9' AND `storage_type` != 'dsk'[0m] SQL[[0;33mSELECT * FROM `storage` WHERE `device_id` = '9'[0m] >> Runtime for discovery module 'storage': 0.1590 seconds with 8376 bytes >> SNMP: [2/0.16s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module storage #### Modules status: Global+ OS+ Device #### Load disco module hr-device #### SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs udp:HOSTNAME:161 hrDeviceEntry[0m] hrDeviceEntry = No Such Object available on this agent at this OID SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs udp:HOSTNAME:161 hrProcessorEntry[0m] hrProcessorEntry = No Such Object available on this agent at this OID Array ( ) SQL[[0;33mSELECT * FROM `hrDevice` WHERE `device_id` = '9'[0m] >> Runtime for discovery module 'hr-device': 0.1660 seconds with 3704 bytes >> SNMP: [2/0.16s] 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUsetX -m CISCO-CDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 cdpCache[0m] cdpCache = No Such Object available on this agent at this OID LLDP-MIB: SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -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[[0;33mSELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`='9'[0m] SQL[[0;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = '9'[0m] SQL[[0;33mDELETE T FROM `links` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`local_device_id` WHERE `devices`.`device_id` IS NULL[0m] 0 orphaned links deleted >> Runtime for discovery module 'discovery-protocols': 0.1900 seconds with 4848 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUsetX -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipNetToPhysicalPhysAddress[0m] ipNetToPhysicalPhysAddress = No Such Instance currently exists at this OID SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUsetX -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipNetToMediaPhysAddress[0m] ipNetToMediaPhysAddress = No Such Instance currently exists at this OID SQL[[0;33mSELECT * from `ipv4_mac` WHERE `device_id`='9' AND `context_name`=''[0m] SQL[[0;33mDELETE T FROM `ipv4_mac` T LEFT JOIN `ports` ON `ports`.`port_id` = T.`port_id` LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `ports`.`port_id` IS NULL AND `devices`.`device_id` IS NULL[0m] >> Runtime for discovery module 'arp-table': 0.1670 seconds with 2344 bytes >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module arp-table #### Modules status: Global- OS- Device Module [ discovery-arp ] disabled on os. Modules status: Global- OS- Device Module [ junose-atm-vp ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module bgp-peers #### SNMP[[0;36m/usr/bin/snmpgetnext -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -Oqvn -m BGP4-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 bgpLocalAs[0m] "fortimail" No BGP on hostPeers : SQL[[0;33mDELETE FROM `bgpPeers` WHERE device_id='9' AND context_name=''[0m] SQL[[0;33mDELETE FROM `bgpPeers_cbgp` WHERE device_id='9' AND context_name=''[0m] SQL[[0;33mSELECT DISTINCT context_name FROM bgpPeers WHERE device_id='9'[0m] >> Runtime for discovery module 'bgp-peers': 0.1160 seconds with 5464 bytes >> SNMP: [1/0.11s] MySQL: [3/0.00s] RRD: [0/0.00s] #### Unload disco module bgp-peers #### Modules status: Global+ OS+ Device #### Load disco module vlans #### SQL[[0;33mSELECT * FROM `vlans` WHERE `device_id` = '9'[0m] SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m BRIDGE-MIB -M /opt/librenms/mibs 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -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': 0.1960 seconds with 9352 bytes >> SNMP: [2/0.19s] 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 -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUs -m UCD-DISKIO-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 diskIOEntry[0m] diskIOEntry = No Such Object available on this agent at this OID Array ( ) SQL[[0;33mSELECT * FROM `ucd_diskio` where `device_id` = '9'[0m] >> Runtime for discovery module 'ucd-diskio': 0.0780 seconds with 3080 bytes >> SNMP: [1/0.08s] 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[[0;33mSELECT * FROM `stp` WHERE `device_id` = '9'[0m] SNMP[[0;36m/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -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.0800 seconds with 5904 bytes >> SNMP: [1/0.08s] 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[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='ap-count'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='clients'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='quality'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='capacity'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='utilization'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='rate'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='ccq'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='snr'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='ssr'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='mse'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='rssi'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='power'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='noise-floor'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='errors'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='error-ratio'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='error-rate'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='frequency'[0m] SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id`='9' AND `sensor_class`='distance'[0m] >> Runtime for discovery module 'wireless': 0.0200 seconds with 123128 bytes >> SNMP: [0/0.00s] MySQL: [18/0.01s] RRD: [0/0.00s] #### Unload disco module wireless #### Modules status: Global+ OS+ Device #### Load disco module fdb-table #### SQL[[0;33mSELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = '9'[0m] SQL[[0;33mSELECT * FROM `ports_fdb` WHERE `device_id` = '9'[0m] SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUsetX -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qTpFdbPort[0m] dot1qTpFdbPort = No Such Object available on this agent at this OID SNMP[[0;36m/usr/bin/snmpbulkwalk -v3 -n '' -l 'authPriv' -a 'MD5' -A PASSWORD -u USER -x 'AES' -X PASSWORD -OQUsetX -m BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dTpFdbPort[0m] dot1dTpFdbPort = No Such Object available on this agent at this OID >> Runtime for discovery module 'fdb-table': 0.1790 seconds with 3016 bytes >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module fdb-table #### SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '9' AND `attrib_type` = 'poll_mib' [0m] SQL[[0;33mUPDATE `devices` set `last_discovered` =NOW(),`last_discovered_timetaken` ='5.318' WHERE `device_id` = '9'[0m] Discovered in 5.318 seconds SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('discover','fortimail.lepeer.local','1533642494.2326','5.834','1','30855affd989')[0m] ./discovery.php fortimail.lepeer.local 2018-08-07 13:48:20 - 1 devices discovered in 5.834 secs SNMP [33/2.87s]: Get[13/1.11s] Getnext[1/0.11s] Walk[19/1.65s] MySQL [100/0.88s]: Cell[13/0.01s] Row[5/0.00s] Rows[68/0.06s] Column[2/0.00s] Update[5/0.54s] Insert[2/0.27s] Delete[5/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]