DEBUG! DEFINITIONS Time : 0.0995419 ms DEFINITIONS Memory: 17.1MB SQL[SELECT * FROM `observium_attribs`] SQL RUNTIME[0.00370693s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00090098s] SQL[SET SESSION `sql_mode` = 'NO_ENGINE_SUBSTITUTION'] SQL RUNTIME[0.00074291s] DB mode(s) disabled: STRICT_TRANS_TABLES, ONLY_FULL_GROUP_BY, NO_ZERO_DATE, NO_ZERO_IN_DATE, ERROR_FOR_DIVISION_BY_ZERO SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00097513s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.000875s] CMD[/bin/hostname -f] CMD EXITCODE[0] CMD RUNTIME[0.0056s] CMD EXITDELAY[5ms] STDOUT[ observium ] ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Community Edition 24.4.13528 https://www.observium.org CMD[/opt/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.056s] STDOUT[ Linux|6.8.0-40-generic|amd64|Ubuntu|24.04|kvm| ] CMD[/usr/bin/env python --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0047s] STDOUT[ Python 3.12.3 ] SQL[SELECT VERSION();] SQL RUNTIME[0.00116611s] CMD[/usr/bin/snmpget --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0052s] STDOUT[ NET-SNMP version: 5.9.4.pre2 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0213s] STDOUT[ RRDtool 1.7.2 Copyright by Tobias Oetiker ] CMD[/usr/bin/fping -v 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0049s] STDOUT[ /usr/bin/fping: Version 5.1 ] CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.0313s] STDOUT[ Apache/2.4.58 ] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00091696s] SQL[SHOW VARIABLES LIKE 'log_bin'] SQL RUNTIME[0.01913095s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00530195s] ##### Software versions ##### o OS Linux 6.8.0-40-generic [amd64] (Ubuntu 24.04) o Apache 2.4.58 o PHP 8.3.6 (OPcache: DISABLED) o Python 3.12.3 o MySQL 8.0.39-0ubuntu0.24.04.2 (extension: mysqli 8.3.6) o SNMP NET-SNMP 5.9.4.pre2 o RRDtool 1.7.2 o Fping 5.1 (IPv4 and IPv6) o Fetch cURL 8.5.0 (OpenSSL/3.0.13, LibZ 1.3, LibIDN 2.3.7) ##### Memory Limit ##### o PHP Unlimited ##### DB info ##### o DB schema 493 o MySQL binlog ON o MySQL mode NO_ENGINE_SUBSTITUTION ##### Charset info ##### o PHP UTF-8 o MySQL utf8mb3 ##### Timezones info ##### o Date Wednesday, 04-Sep-24 16:01:05 UTC o PHP +00:00 o MySQL +00:00 Request [https://www.observium.org/versions.php] #1: HTTP 'curl' library used. SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'http_rate_https://www.observium.org')] SQL RUNTIME[0.00162315s] SQL[UPDATE `observium_attribs` SET `attrib_value` ='{\"2024-09-04\":5}' WHERE `attrib_type` = 'http_rate_https://www.observium.org'] SQL RUNTIME[0.03406096s] REQUEST[https://www.observium.org/versions.php] REQUEST STATUS[TRUE] REQUEST RUNTIME[0.4589s] RESPONSE CODE[200 OK] TRUE Response [13606] valid: [stable->revision] regex [^\d+$] Array ( [stable] => Array ( [version] => 24.8.13606 [revision] => 13606 [date] => 2024-08-02 ) [current] => Array ( [version] => 24.9.13634 [revision] => 13634 [date] => 2024-09-03 ) [ce] => Array ( [version] => 23.09 [revision] => 13005 [date] => 2023-09-20 ) ) SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver')] SQL RUNTIME[0.00110292s] SQL[UPDATE `observium_attribs` SET `attrib_value` ='23.09' WHERE `attrib_type` = 'latest_ver'] SQL RUNTIME[0.00083303s] SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev')] SQL RUNTIME[0.0014379s] SQL[UPDATE `observium_attribs` SET `attrib_value` ='13005' WHERE `attrib_type` = 'latest_rev'] SQL RUNTIME[0.0007441s] SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date')] SQL RUNTIME[0.00072598s] SQL[UPDATE `observium_attribs` SET `attrib_value` ='2023-09-20' WHERE `attrib_type` = 'latest_rev_date'] SQL RUNTIME[0.00072193s] SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck')] SQL RUNTIME[0.00070095s] SQL[UPDATE `observium_attribs` SET `attrib_value` ='1725465665' WHERE `attrib_type` = 'last_versioncheck'] SQL RUNTIME[0.00910997s] ##### Starting discovery run at 2024-09-04 16:01:05 ##### SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE '' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00281811s] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.4.1.46706.100.10.1.1.1.25.1] CMD EXITCODE[0] CMD RUNTIME[0.0658s] STDOUT[ .1.3.6.1.4.1.15004.4.17.2.1.1.25.1 = 1000 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49'] SQL RUNTIME[0.00194597s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '49' AND `poller_id` = '0'] SQL RUNTIME[0.00233102s] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('950738','discovery.php','948314','1002','php ./discovery.php -d -h 10.10.2.23','1725465664','49')] SQL RUNTIME[0.01104903s] ##### [49] ##### CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' sysObjectID.0] CMD EXITCODE[0] CMD RUNTIME[0.0636s] STDOUT[ .1.3.6.1.4.1.15004.2.1 ] SNMP STATUS[TRUE] o OS Type wowza-engine o OS Group enterprise_tree_only o SNMP Version v2c o Last discovery 2024-09-04 15:45:03 o Last duration 0.87 seconds ##### Module Start: os ##### CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.067s] STDOUT[ Siemens, RUGGEDCOM, RST2228, 6GK62226AB, HW: Version RST2228, FW: Version Main v5.7.0, SRUMR417020908 ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 +-------------+-------------------------------------------------------------------------------------------------------+ | OID | | +-------------+-------------------------------------------------------------------------------------------------------+ | sysDescr | Siemens, RUGGEDCOM, RST2228, 6GK62226AB, HW: Version RST2228, FW: Version Main v5.7.0, SRUMR417020908 | | sysObjectID | .1.3.6.1.4.1.15004.2.1 | +-------------+-------------------------------------------------------------------------------------------------------+ CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m WOWZA-STREAMING-ENGINE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/wowza 'udp':'':'161' serverCounterGetVersion.1] CMD EXITCODE[0] CMD RUNTIME[0.0635s] STDOUT[ 13000 ] SNMP STATUS[TRUE] Store in cache OID: WOWZA-STREAMING-ENGINE-MIB::serverCounterGetVersion.1 o Re-Detect OS matched (wowza-engine: Wowza Streaming Engine): +-------------------------------------------------------+--------------------+-------+ | OID | Matched definition | | +-------------------------------------------------------+--------------------+-------+ | WOWZA-STREAMING-ENGINE-MIB::serverCounterGetVersion.1 | /.+/ | 13000 | +-------------------------------------------------------+--------------------+-------+ o Duration 0.2394s ##### Module Start: mibs ##### CMD[/usr/bin/snmptranslate -On -Pu -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'SNMPv2-MIB::sysORID'] CMD EXITCODE[0] CMD RUNTIME[0.0513s] STDOUT[ .1.3.6.1.2.1.1.9.1.2 ] SNMP TRANSLATE (CMD): 'SNMPv2-MIB::sysORID' -> '.1.3.6.1.2.1.1.9.1.2' CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.1.9.1.2] CMD EXITCODE[0] CMD RUNTIME[0.076s] STDOUT[ .1.3.6.1.2.1.1.9.1.2.1 = .1.3.6.1.4.1.15004.6.30.1.1 .1.3.6.1.2.1.1.9.1.2.2 = .1.3.6.1.4.1.15004.6.30.19.1 .1.3.6.1.2.1.1.9.1.2.3 = .1.3.6.1.4.1.15004.6.30.20.1 .1.3.6.1.2.1.1.9.1.2.4 = .1.3.6.1.4.1.15004.6.30.21.1 .1.3.6.1.2.1.1.9.1.2.5 = .1.3.6.1.4.1.15004.6.30.2.1 .1.3.6.1.2.1.1.9.1.2.6 = .1.3.6.1.4.1.15004.6.30.5.1 .1.3.6.1.2.1.1.9.1.2.7 = .1.3.6.1.4.1.15004.6.30.6.1 .1.3.6.1.2.1.1.9.1.2.8 = .1.3.6.1.4.1.15004.6.30.7.1 .1.3.6.1.2.1.1.9.1.2.9 = .1.3.6.1.4.1.15004.6.30.8.2 .1.3.6.1.2.1.1.9.1.2.10 = .1.3.6.1.4.1.15004.6.30.11.3 .1.3.6.1.2.1.1.9.1.2.11 = .1.3.6.1.4.1.15004.6.30.12.3 .1.3.6.1.2.1.1.9.1.2.12 = .1.3.6.1.4.1.15004.6.30.3.1 .1.3.6.1.2.1.1.9.1.2.13 = .1.3.6.1.4.1.15004.6.30.4.1 .1.3.6.1.2.1.1.9.1.2.14 = .1.3.6.1.4.1.15004.6.30.22.1 .1.3.6.1.2.1.1.9.1.2.15 = .1.3.6.1.4.1.15004.6.30.15.1 .1.3.6.1.2.1.1.9.1.2.16 = .1.3.6.1.4.1.15004.6.30.9.1 .1.3.6.1.2.1.1.9.1.2.17 = .1.3.6.1.4.1.15004.6.30.10.1 .1.3.6.1.2.1.1.9.1.2.18 = .1.3.6.1.4.1.15004.6.30.13.1 .1.3.6.1.2.1.1.9.1.2.19 = .1.3.6.1.4.1.15004.6.30.50.1 .1.3.6.1.2.1.1.9.1.2.20 = .1.3.6.1.4.1.15004.6.30.44.1 .1.3.6.1.2.1.1.9.1.2.21 = .1.3.6.1.4.1.15004.6.30.46.1 .1.3.6.1.2.1.1.9.1.2.22 = .1.3.6.1.4.1.15004.6.30.47.2 .1.3.6.1.2.1.1.9.1.2.23 = .1.3.6.1.4.1.15004.6.30.45.1 .1.3.6.1.2.1.1.9.1.2.24 = .1.3.6.1.4.1.15004.6.30.48.1 .1.3.6.1.2.1.1.9.1.2.25 = .1.3.6.1.4.1.15004.6.30.48.2 .1.3.6.1.2.1.1.9.1.2.26 = .1.3.6.1.4.1.15004.6.30.49.1 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' sysORDescr] CMD EXITCODE[0] CMD RUNTIME[0.0821s] STDOUT[ sysORDescr.1 = SNMPv2-MIB Agent Capabilities. sysORDescr.2 = SNMP-FRAMEWORK-MIB Agent Capabilities. sysORDescr.3 = SNMP-USER-BASED-SM-MIB Agent Capabilities. sysORDescr.4 = SNMP-VIEW-BASED-ACM-MIB Agent Capabilities. sysORDescr.5 = IF-MIB Agent Capabilities. sysORDescr.6 = TCP-MIB Agent Capabilities. sysORDescr.7 = UDP-MIB Agent Capabilities. sysORDescr.8 = IP-MIB Agent Capabilities. sysORDescr.9 = RUGGEDCOM-IP-MIB Agent Capabilities for ROS devices with two management interfaces. sysORDescr.10 = RUGGEDCOM-TRAPS-MIB Agent Capabilities 02. sysORDescr.11 = RUGGEDCOM-SYS-INFO-MIB Agent Capabilities 02. sysORDescr.12 = BRIDGE-MIB Agent Capabilities. sysORDescr.13 = LLDP-MIB Agent Capabilities. sysORDescr.14 = RSTP-MIB Agent Capabilities. sysORDescr.15 = RUGGEDCOM-STP-MIB Agent Capabilities. sysORDescr.16 = RMON-MIB Agent Capabilities. sysORDescr.17 = Q-BRIDGE-MIB Agent Capabilities. sysORDescr.18 = IEEE8023-LAG-MIB Agent Capabilities. Note that this MIB is not implemented per compliance statement the IEEE8023-LAG-MIB because of specific implemetation of Link Aggregation. sysORDescr.19 = RUGGEDCOM-SFP-DDM-MIB Agent Capabilities. sysORDescr.20 = IEEEC37_238_MIB Agent Capabilities. sysORDescr.21 = PTP1588 Agent Capabilities. sysORDescr.22 = NTP Agent Capabilities. sysORDescr.23 = TimeConfig Agent Capabilities. sysORDescr.24 = RADIUS Server Agent Capabilities. sysORDescr.25 = TACACS Server Agent Capabilities. sysORDescr.26 = IEC-62439-2-MIB Agent Capabilities. ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m OSPF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ospfAdminStat.0] CMD EXITCODE[0] CMD RUNTIME[0.0374s] STDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] Store in cache OID: OSPF-MIB::ospfAdminStat.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m OSPFV3-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ospfv3AdminStatus.0] CMD EXITCODE[0] CMD RUNTIME[0.0371s] STDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] Store in cache OID: OSPFV3-MIB::ospfv3AdminStatus.0 o MIBs discovered SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00187802s] +------------------------------+-----+---------+------------------+ | Identity | MIB | Source | Status | +------------------------------+-----+---------+------------------+ | .1.3.6.1.4.1.15004.6.30.1.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.19.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.20.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.21.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.2.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.5.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.6.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.7.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.8.2 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.11.3 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.12.3 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.3.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.4.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.22.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.15.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.9.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.10.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.13.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.50.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.44.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.46.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.47.2 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.45.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.48.1 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.48.2 | - | sysORID | Unknown Identity | | .1.3.6.1.4.1.15004.6.30.49.1 | - | sysORID | Unknown Identity | +------------------------------+-----+---------+------------------+ SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00123382s] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '49' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[0.00139999s] Array ( [0] => WOWZA-STREAMING-ENGINE-MIB ) o Duration 0.3337s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_vrf'] SQL RUNTIME[0.00077105s] ##### Module Start: vrf ##### SQL[SELECT COUNT(*) FROM `vrfs` WHERE `device_id` = '49' AND 1] SQL RUNTIME[0.00143194s] SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '49' AND `ifVrf` IS NOT NULL AND 1] SQL RUNTIME[0.0014658s] o Duration 0.0057s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_ports'] SQL RUNTIME[0.00089002s] ##### Module Start: ports ##### o Caching OIDs o Caching DB SQL[SELECT * FROM `ports` WHERE `device_id` = '49'] SQL RUNTIME[0.00129104s] 0 ports o Discovering ports o Duration 0.0035s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_ports-stack'] SQL RUNTIME[0.00078797s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_vlans'] SQL RUNTIME[0.00093699s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_oids'] SQL RUNTIME[0.00094295s] ##### Module Start: oids ##### SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '49'] SQL RUNTIME[0.00180697s] SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1'] SQL RUNTIME[0.00079584s] o Duration 0.0045s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_ip-addresses'] SQL RUNTIME[0.00085402s] ##### Module Start: ip-addresses ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00093794s] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '49'] SQL RUNTIME[0.0011878s] SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '49'] SQL RUNTIME[0.00123906s] o Duration 0.0069s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_processors'] SQL RUNTIME[0.00090504s] ##### Module Start: processors ##### SQL[SELECT * FROM `processors` WHERE `device_id` = '49'] SQL RUNTIME[0.00138712s] o Duration 0.0027s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_mempools'] SQL RUNTIME[0.00084686s] ##### Module Start: mempools ##### SQL[SELECT * FROM `mempools` WHERE `device_id` = '49'] SQL RUNTIME[0.00106001s] o Duration 0.0027s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_inventory'] SQL RUNTIME[0.00044203s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_printersupplies'] SQL RUNTIME[0.00034189s] ##### Module Start: printersupplies ##### SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '49'] SQL RUNTIME[0.00056696s] o Duration 0.0017s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_sensors'] SQL RUNTIME[0.00031114s] ##### Module Start: sensors ##### SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00142598s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00082397s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00062084s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00047493s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00041294s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00040102s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00094509s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00102592s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00078011s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00066614s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00090814s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00086999s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00080514s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00059605s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00060797s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00059199s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'attenuation' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00053191s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00050712s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00087714s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'concentration' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00054789s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00053191s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00052595s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00054789s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00059485s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'age' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00079203s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00054288s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00048685s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00070906s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00067306s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'distance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00079298s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00064802s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00069094s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '49' AND `sensor_class` = 'gauge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00096703s] SQL[SELECT * FROM `status` WHERE `device_id` = '49' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00120902s] SQL[SELECT * FROM `counters` WHERE `device_id` = '49' AND `poller_type` = 'snmp' AND `counter_deleted` = '0'] SQL RUNTIME[0.00123906s] o Duration 0.0799s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_storage'] SQL RUNTIME[0.00058699s] ##### Module Start: storage ##### SQL[SELECT * FROM `storage` WHERE `device_id` = '49'] SQL RUNTIME[0.00087881s] o Duration 0.0025s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_neighbours'] SQL RUNTIME[0.00048614s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_arp-table'] SQL RUNTIME[0.00067997s] ##### Module Start: arp-table ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00066996s] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT * FROM `ip_mac` WHERE `device_id` = '49'] SQL RUNTIME[0.00103188s] o Duration 0.0042s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_junose-atm-vp'] SQL RUNTIME[0.0005641s] ##### Module Start: junose-atm-vp ##### o Duration 0.0003s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_bgp-peers'] SQL RUNTIME[0.00045204s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_mac-accounting'] SQL RUNTIME[0.0004468s] ##### Module Start: mac-accounting ##### o Duration 0.0004s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_sla'] SQL RUNTIME[0.00085902s] ##### Module Start: sla ##### SQL[SELECT * FROM `slas` WHERE `device_id` = '49'] SQL RUNTIME[0.00125408s] o Duration 0.0039s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_lsp'] SQL RUNTIME[0.00088406s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_pseudowires'] SQL RUNTIME[0.0009079s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_virtual-machines'] SQL RUNTIME[0.00120306s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_cisco-cbqos'] SQL RUNTIME[0.00074506s] ##### Module Start: cisco-cbqos ##### SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '49'] SQL RUNTIME[0.00099897s] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUs -m CISCO-CLASS-BASED-QOS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'':'161' cbQosIfType] CMD EXITCODE[0] CMD RUNTIME[0.2834s] STDOUT[ cbQosIfType = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] QoS not configured. o Duration 0.2904s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_ucd-diskio'] SQL RUNTIME[0.00137806s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_wifi'] SQL RUNTIME[0.00061607s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_p2p-radios'] SQL RUNTIME[0.00092697s] ##### Module Start: p2p-radios ##### o Duration 0.0004s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_graphs'] SQL RUNTIME[0.00091386s] ##### Module Start: graphs ##### o Duration 0.0011s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '49' AND `attrib_type` = 'discover_raid'] SQL RUNTIME[0.00092506s] o Modules Disabled ports-stack, vlans, inventory, neighbours, bgp-peers, lsp, pseudowires, virtual-machines, ucd-diskio, wifi, raid o Modules Enabled os, mibs, vrf, ports, oids, ip-addresses, processors, mempools, printersupplies, sensors, storage, arp-table, junose-atm-vp,mac-accounting, sla, cisco-cbqos, p2p-radios, graphs SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '49';] SQL RUNTIME[0.00095296s] SQL[UPDATE `devices` SET `last_discovered` =NOW(),`type` ='video',`last_discovered_timetaken` ='1.1382',`force_discovery` ='0',`device_state` ='a:4:{s:15:\"poller_mod_perf\";a:21:{s:6:\"system\";d:0.2571;s:2:\"os\";d:0.0028;s:7:\"sensors\";d:0.0054;s:6:\"status\";d:0.0011;s:7:\"counter\";d:0.0017;s:10:\"processors\";d:0.0014;s:8:\"mempools\";d:0.004;s:7:\"storage\";d:0.0015;s:7:\"ucd-mib\";d:0.0004;s:13:\"ipSystemStats\";d:0.0003;s:9:\"bgp-peers\";d:0.001;s:15:\"printersupplies\";d:0.0008;s:10:\"ucd-diskio\";d:0.0006;s:10:\"p2p-radios\";d:0.0008;s:4:\"ospf\";d:0.0002;s:3:\"sla\";d:0.001;s:11:\"pseudowires\";d:0.0018;s:14:\"mac-accounting\";d:0.0011;s:15:\"entity-physical\";d:0.0004;s:9:\"fdb-table\";d:0.0048;s:6:\"graphs\";d:0.0006;}s:14:\"poller_history\";a:4:{i:1725465635;d:0.4202;i:1725465335;d:0.2455;i:1725465034;d:0.3785;i:1725464734;d:0.4305;}s:17:\"discovery_history\";a:2:{i:1725465665;d:1.1382;i:1725464702;d:0.866;}s:18:\"discovery_mod_perf\";a:18:{s:2:\"os\";d:0.2394;s:4:\"mibs\";d:0.3337;s:3:\"vrf\";d:0.0057;s:5:\"ports\";d:0.0035;s:4:\"oids\";d:0.0045;s:12:\"ip-addresses\";d:0.0069;s:10:\"processors\";d:0.0027;s:8:\"mempools\";d:0.0027;s:15:\"printersupplies\";d:0.0017;s:7:\"sensors\";d:0.0799;s:7:\"storage\";d:0.0025;s:9:\"arp-table\";d:0.0042;s:13:\"junose-atm-vp\";d:0.0003;s:14:\"mac-accounting\";d:0.0004;s:3:\"sla\";d:0.0039;s:11:\"cisco-cbqos\";d:0.2904;s:10:\"p2p-radios\";d:0.0004;s:6:\"graphs\";d:0.0011;}}' WHERE `device_id` = '49'] SQL RUNTIME[0.029181s] ##### 10.10.2.23 [49] completed discovery modules at 2024-09-04 16:01:06 ##### o Discovery time 1.1382 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '950738' AND `process_name` = 'discovery.php' AND `device_id` = '49' AND `poller_id` = '0'] SQL RUNTIME[0.02671289s] ##### Finished discovery run at 2024-09-04 16:01:07 ##### SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00081921s] Cached 0 alert rules. SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00072503s] ./discovery.php: - 1 devices discovered in 1.984 secs Log file '/opt/observium/logs/observium.log' is not writeable, check file permissions. SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1725451265'] SQL RUNTIME[0.00052619s] NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output. o Devices Discovered 1 o Discovery Time 1.984 secs o Definitions 0.099541902542114 secs o Memory usage 26MB (peak: 26MB) o MySQL Usage Cell[12/0.036s] Row[30/0.059s] Rows[55/0.141s] Column[1/0.002s] Update[6/0.086s] Insert[1/0.013s] Delete[2/0.033s] o RRDTool Usage