CMD[/usr/bin/svn info /opt/observium] CMD EXITCODE[0] CMD RUNTIME[0.0089s] CMD EXITDELAY[5ms] STDOUT[ Path: . Working Copy Root Path: /opt/observium URL: https://svn.observium.org/svn/observium/branches/stable Relative URL: ^/observium/branches/stable Repository Root: https://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 12944 Node Kind: directory Schedule: normal Last Changed Author: adama Last Changed Rev: 12912 Last Changed Date: 2023-08-02 15:24:07 +0200 (Wed, 02 Aug 2023) ] DEFINITIONS Time : 0.104248 ms DEFINITIONS Memory: 15.2MB SQL[SELECT * FROM `observium_attribs`] SQL RUNTIME[0.00049496s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00022006s] SQL[SET SESSION `sql_mode` = 'NO_ENGINE_SUBSTITUTION'] SQL RUNTIME[0.00008488s] 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.00009704s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.00019598s] CMD[/bin/hostname -f] CMD EXITCODE[0] CMD RUNTIME[0.0029s] STDOUT[ obs.workgroup ] SQL[SELECT EXISTS (SELECT 1 FROM `pollers`)] SQL RUNTIME[0.00021291s] ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 23.8.12912 https://www.observium.org CMD[/opt/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.0144s] STDOUT[ Linux|5.15.0-79-generi c|amd64|Ubuntu|22.04|vmware| ] CMD[/usr/bin/env python --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.003s] STDOUT[ Python 3.10.12 ] SQL[SELECT version();] SQL RUNTIME[0.00019503s] CMD[/usr/bin/snmpget --version 2>&1] --More--(2%) CMD EXITCODE[0] CMD RUNTIME[0.0072s] STDOUT[ NET-SNMP version: 5.9.1 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0099s] STDOUT[ RRDtool 1.7.2 Copyright by Tobias Oetiker ] CMD[/usr/bin/fping -v 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0024s] CMD EXITDELAY[5ms] STDOUT[ /usr/bin/fping: Version 5.1 ] CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.019s] STDOUT[ Apache/2.4.52 ] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00025892s] SQL[SHOW VARIABLES LIKE 'log_bin'] SQL RUNTIME[0.00194597s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00136995s] ##### Software versions ##### o OS Linux 5.15.0-79-generic [amd64] (Ubuntu 22.04) o Apache 2.4.52 o PHP 8.1.2-1ubuntu2.14 (OPcache: DISABLED) o Python 3.10.12 o MySQL 8.0.34-0ubuntu0.22.04.1 (extension: mysqli 8.1.2-1ubuntu2.14) o SNMP NET-SNMP 5.9.1 o RRDtool 1.7.2 o Fping 5.1 (IPv4 and IPv6) o Fetch cURL 7.81.0 (OpenSSL/3.0.2, LibZ 1.2.11, LibIDN 2.3.2) ##### Memory Limit ##### o PHP Unlimited ##### DB info ##### o DB schema 485 o MySQL binlog ON o MySQL mode NO_ENGINE_SUBSTITUTION ##### Charset info ##### o PHP UTF-8 o MySQL utf8mb3 ##### Timezones info ##### o Date Tuesday, 29-Aug-23 14:50:08 CEST o PHP +02:00 o MySQL +02:00 ##### Starting discovery run at 2023-08-29 14:50:08 ##### SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'fgm.placeholder.nl' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00047088s] Not found device [10] model 'fortinet' association for .1.3.6.1.4.1.12356.103.1.64 CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' .1.3.6.1.2.1.1.2.0 .1.3.6.1.2.1.1.3.0] --More--(5%) CMD EXITCODE[0] CMD RUNTIME[0.0435s] STDOUT[ .1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.12356.103.1.64 .1.3.6.1.2.1.1.3.0 = 0:2:03:48.31 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10'] SQL RUNTIME[0.00035691s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '10' AND `poller_id` = '0'] SQL RUNTIME[0.00021100s] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('1151846','discovery.php','531571','0','php ./discovery.php -d -h fgm.placeholder.nl','1693313408' ,'10')] SQL RUNTIME[0.00229311s] ##### fgm.placeholder.nl [10] ##### o OS Type forti-os o OS Group fortinet o SNMP Version v3 o Last discovery 2023-08-29 13:59:18 o Last duration 3.19 seconds ##### Module Start: os ##### Device-specific no-bulk option. CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.0506s] STDOUT[ Fortimanager ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 Device-s pecific no-bulk option. CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' sysObjectID.0] CMD EXITCODE[0] CMD RUNTIME[0.0447s] STDOUT[ .1.3.6.1.4.1.12356.103.1.64 ] SNMP STATUS[TRUE] +-------------+-----------------------------+ | OID | | +-------------+-----------------------------+ | sysDescr | Fortimanager | | sysObjectID | .1.3.6.1.4.1.12356.103.1.64 | +-------------+-----------------------------+ o Detect OS matched (forti-os: Fortinet OS): +-------------+------------------------+-----------------------------+ | OID | Matched definition | | +-------------+------------------------+-----------------------------+ | sysObjectID | .1.3.6.1.4.1.12356.103 | .1.3.6.1.4.1.12356.103.1.64 | +-------------+------------------------+-----------------------------+ o Duration 0.1258s ##### 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.0192s] 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 -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' .1.3.6.1.2.1.1.9.1.2] CMD EXITCODE[0] CMD RUNTIME[0.0433s] STDOUT[ .1.3.6.1.2.1.1.9.1.2 = No Such Instance currently exists at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' sysORDescr] CMD EXITCODE[0] CMD RUNTIME[0.0438s] STDOUT[ sysORDescr = No Such Instance currently exists at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m OSPF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ospfAdminStat.0] CMD EXITCODE[0] CMD RUNTIME[0.0401s] 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 -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m OSPFV3-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ospfv3AdminStatus.0] CMD EXITCODE[0] CMD RUNTIME[0.0443s] 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 CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m LLDP-V2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' lldpV2LocChassisId.0] CMD EXITCODE[0] CMD RUNTIME[0.0445s] STDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] Store in cache OID: LLDP-V2-MIB::lldpV2LocChassisId.0 CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m LLDP-EXT-MED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' lldpXMedLocModelName.0] CMD EXITCODE[0] CMD RUNTIME[0.0455s] STDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] Store in cache OID: LLDP-EXT-MED-MIB::lldpXMedLocModelName.0 o MIBs discovered SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00032997s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00022984s] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '10' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[0.00017095s] Array ( [0] => FORTINET-FORTIMAIL-MIB [1] => FORTINET-CORE-MIB [2] => SNMPv2-MIB [3] => SNMP-FRAMEWORK-MIB [4] => IF-MIB [5] => ADSL-LINE-MIB [6] => EtherLike-MIB [7] => ENTITY-MIB [8] => ENTITY-SENSOR-MIB [9] => UCD-SNMP-MIB --More--(13%) [10] => HOST-RESOURCES-MIB [11] => Q-BRIDGE-MIB [12] => IP-MIB [13] => IPV6-MIB [14] => LLDP-MIB [15] => CISCO-CDP-MIB [16] => PW-STD-MIB [17] => DISMAN-PING-MIB [18] => BGP4-MIB ) o Duration 0.2965s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_vrf'] SQL RUNTIME[0.00014400s] ##### Module Start: vrf ##### SQL[SELECT COUNT(*) FROM `vrfs` WHERE `device_id` = '10' AND 1] SQL RUNTIME[0.00016403s] SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '10' AND `ifVrf` IS NOT NULL AND 1] SQL RUNTIME[0.00021005s] o Duration 0.0021s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_ports'] SQL RUNTIME[0.00015092s] ##### Module Start: ports ##### o Caching OIDs ifDescr CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ifDescr] CMD EXITCODE[0] CMD RUNTIME[0.0484s] STDOUT[ ifDescr.1 = port1 ifDescr.2 = port2 ifDescr.3 = port3 ifDescr.4 = port4 ifDescr.5 = port5 ifDescr.6 = port6 ifDescr.7 = port7 ifDescr.8 = port8 ifDescr.9 = port9 ifDescr.10 = port10 ifDescr.11 = port11 ifDescr.12 = port12 ] SNMP STATUS[ TRUE] ifAlias CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ifAlias] CMD EXITCODE[0] CMD RUNTIME[0.0476s] STDOUT[ ifAlias.1 = ifAlias.2 = ifAlias.3 = ifAlias.4 = ifAlias.5 = ifAlias.6 = ifAlias.7 = ifAlias.8 = ifAlias.9 = ifAlias.10 = ifAlias.11 = ifAlias.12 = ] SNMP STATUS[TRUE] ifName CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ifName] CMD EXITCODE[0] CMD RUNTIME[0.0473s] STDOUT[ ifName.1 = port1 ifName.2 = port2 ifName.3 = port3 ifName.4 = port4 --More--(16%) ifName.5 = port5 ifName.6 = port6 ifName.7 = port7 ifName.8 = port8 ifName.9 = port9 ifName.10 = port10 ifName.11 = port11 ifName.12 = port12 ] SNMP STATUS[TRUE] ifType CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ifType] CMD EXITCODE[0] CMD RUNTIME[0.0491s] STDOUT[ ifType.1 = ethernetCsmacd ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = ethernetCsmacd ifType.6 = ethernetCsmacd ifType.7 = ethernetCsmacd ifType.8 = ethernetCsmacd ifType.9 = ethernetCsmacd ifType.10 = ethernetCsmacd ifType.11 = ethernetCsmacd ifType.12 = ethernetCsmacd ] SNMP STATUS[TRUE] ifOperStatus CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ifOperStatus] CMD EXITCODE[0] CMD RUNTIME[0.0481s] STDOUT[ ifOperStatus.1 = up ifOperStatus.2 = down ifOperStatus.3 = down ifOperStatus.4 = down ifOperStatus.5 = down ifOperStatus.6 = down ifOperStatus.7 = down ifOperStatus.8 = down ifOperStatus.9 = down ifOperStatus.10 = down ifOperStatus.11 = down ifOperStatus.12 = down ] SNMP STATUS[TRUE] Array ( [1] => Array ( [ifDescr] => port1 [ifAlias] => [ifName] => port1 [ifType] => ethernetCsmacd [ifOperStatus] => up ) [2] => Array ( [ifDescr] => port2 [ifAlias] => [ifName] => port2 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [3] => Array ( [ifDescr] => port3 [ifAlias] => [ifName] => port3 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [4] => Array ( [ifDescr] => port4 --More--(18%) [ifAlias] => [ifName] => port4 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [5] => Array ( [ifDescr] => port5 [ifAlias] => [ifName] => port5 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [6] => Array ( [ifDescr] => port6 [ifAlias] => [ifName] => port6 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [7] => Array ( [ifDescr] => port7 [ifAlias] => [ifName] => port7 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [8] => Array ( [ifDescr] => port8 [ifAlias] => [ifName] => port8 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [9] => Array ( [ifDescr] => port9 [ifAlias] => [ifName] => port9 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [10] => Array ( [ifDescr] => port10 [ifAlias] => [ifName] => port10 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [11] => Array ( [ifDescr] => port11 [ifAlias] => [ifName] => port11 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [12] => Array ( [ifDescr] => port12 [ifAlias] => [ifName] => port12 [ifType] => ethernetCsmacd [ifOperStatus] => down ) ) o Caching DB SQL[SELECT * FROM `ports` WHERE `device_id` = '10'] SQL RUNTIME[0.00066710s] --More--(20%) 12 ports o Discovering ports ............ +---------+---------+--------+---------+----------------+-------------+---------+ | ifIndex | ifDescr | ifName | ifAlias | ifType | Oper Status | Ignored | +---------+---------+--------+---------+----------------+-------------+---------+ | 1 | port1 | port1 | ... | ethernetCsmacd | up | no | | 2 | port2 | port2 | ... | ethernetCsmacd | down | no | | 3 | port3 | port3 | ... | ethernetCsmacd | down | no | | 4 | port4 | port4 | ... | ethernetCsmacd | down | no | | 5 | port5 | port5 | ... | ethernetCsmacd | down | no | | 6 | port6 | port6 | ... | ethernetCsmacd | down | no | | 7 | port7 | port7 | ... | ethernetCsmacd | down | no | | 8 | port8 | port8 | ... | ethernetCsmacd | down | no | | 9 | port9 | port9 | ... | ethernetCsmacd | down | no | | 10 | port10 | port10 | ... | ethernetCsmacd | down | no | | 11 | port11 | port11 | ... | ethernetCsmacd | down | no | | 12 | port12 | port12 | ... | ethernetCsmacd | down | no | +---------+---------+--------+---------+----------------+-------------+---------+ o Duration 0.2693s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_ports-stack'] SQL RUNTIME[0.00037193s] ##### Module Start: ports-stack ##### SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '10'] SQL RUNTIME[0.00019884s] CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rf c:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ifStackStatus] CMD EXITCODE[0] CMD RUNTIME[0.1126s] STDOUT[ ifStackStatus = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o Duration 0.1151s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_vlans'] SQL RUNTIME[0.00041389s] ##### Module Start: vlans ##### SQL[SELECT * FROM `vlans` WHERE `device_id` = '10';] SQL RUNTIME[0.00024796s] SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '10';] SQL RUNTIME[0.00015712s] o Q-BRIDGE-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' dot1qVlanStaticName] CMD EXITCODE[0] CMD RUNTIME[0.0508s] STDOUT[ dot1qVlanStaticName = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o Duration 0.0546s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10 ' AND `attrib_type` = 'discover_oids'] SQL RUNTIME[0.00047994s] ##### Module Start: oids ##### SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '10'] SQL RUNTIME[0.00042486s] SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1'] SQL RUNTIME[0.00023007s] o Duration 0.0018s --More--(25%) SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_ip-addresses'] SQL RUNTIME[0.00024605s] ##### Module Start: ip-addresses ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00020003s] JSON DECODE[Not string passed] JSON RAW[ ] o IP-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipAdEntIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.0906s] STDOUT[ ipAdEntIfIndex.10.31.240.100 = 1 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipAdEntNetMask] CMD EXITCODE[0] CMD RUNTIME[0.0779s] STDOUT[ ipAdEntNetMask.10.31.240.100 = 255.255.252.0 ] SNMP STATUS[TRUE] Added 10.31.240.100 . CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipAddressIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.099s] STDOUT[ ipAddressIfIndex = No Such Instance currently exists at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o IPV6-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsb -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipv6AddrEntry] CMD EXITCODE[0] CMD RUNTIME[0.1109s] STDOUT[ ipv6AddrEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o LLDP-MIB SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '10'] SQL RUNTIME[0.00044489s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '10' AND `ifIndex` = '1' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[0.00028801s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '125'] SQL RUNTIME[0.00029397s] SQL[SELECT DISTINCT `entity_type` FROM `entity_attribs` WHERE `device_id` = '10'] SQL RUNTIME[0.00029182s] SQL[SELECT * FROM `devices` LEFT JOIN `devices_locations` USING (`device_id`) WHERE `device_id` = '10'] SQL RUNTIME[0.00033522s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '10'] SQL RUNTIME[0.00023007s] SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.31.240.0/22'] SQL RUNTIME[0.00020695s] SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '10'] SQL RUNTIME[0.00019407s] SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '10'] SQL RUNTIME[0.00020599s] --More--(30%) +---------+---------+-------------+------------------+----------------+---------+--------+ | ifIndex | ifDescr | IP: Version | Address | Network | Type | Origin | +---------+---------+-------------+------------------+----------------+---------+--------+ | 1 | port1 | IPv4 | 10.31.240.100/22 | 10.31.240.0/22 | private | | +---------+---------+-------------+------------------+----------------+---------+--------+ o Changes 1 unchanged o Duration 0.4001s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_processors'] SQL RUNTIME[0.00022388s] ##### Module Start: processors ##### o UCD-SNMP-MIB SQL[SELECT EXISTS (SELECT 1 FROM `processors` WHERE `device_id` = '10' AND `processor_type` != 'ucd-old')] SQL RUNTIME[0.00024390s] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrProcessorLoad] CMD EXITCODE[0] CMD RUNTIME[0.0425s] STDOUT[ hrProcessorLoad.1 = 5 hrProcessorLoad.2 = 1 hrProcessorLoad.3 = 0 hrProcessorLoad.4 = 4 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrDevice] CMD EXITCODE[0] CMD RUNTIME[0.0456s] STDOUT[ hrDeviceIndex.1 = 1 hrDeviceIndex.2 = 2 hrDeviceIndex.3 = 3 hrDeviceIndex.4 = 4 hrDeviceType.1 = hrDeviceProcessor hrDeviceType.2 = hrDeviceProcessor hrDeviceType.3 = hrDeviceProcessor hrDeviceType.4 = hrDeviceProcessor hrDeviceDescr.1 = CPU Processor hrDeviceDescr.2 = CPU Processor hrDeviceDescr.3 = CPU Processor hrDeviceDescr.4 = CPU Processor hrDeviceID.1 = zeroDotZero.0 hrDeviceID.2 = zeroDotZero.0 hrDeviceID.3 = zeroDotZero.0 hrDeviceID.4 = zeroDotZero.0 hrDeviceStatus.1 = running hrDeviceStatus.2 = running hrDeviceStatus.3 = running hrDeviceStatus.4 = running hrDeviceErrors.1 = 0 hrDeviceErrors.2 = 0 hrDeviceErrors.3 = 0 hrDeviceErrors.4 = 0 hrProcessorFrwID.1 = zeroDotZero.0 hrProcessorFrwID.2 = zeroDotZero.0 hrProcessorFrwID.3 = zeroDotZero.0 hrProcessorFrwID.4 = zeroDotZero.0 hrProcessorLoad.1 = 5 hrProcessorLoad.2 = 1 hrProcessorLoad.3 = 0 hrProcessorLoad.4 = 4 ] SNMP STATUS[TRUE] 10 -> .1.3.6.1.2.1.25.3.3.1.2.1, 1, hr, Processor, 1, 5, , 1 SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '1' AND `processor_type` = 'hr'] SQL RUNTIME[0.00055122s] 10 -> .1.3.6.1.2.1.25.3.3.1.2.2, 2, hr, Processor, 1, 1, , 2 SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '2' AND `processor_type` = 'hr'] SQL RUNTIME[0.00030398s] 10 -> .1.3.6.1.2.1.25.3.3.1.2.3, 3, hr, Processor, 1, 0, , 3 SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '3' AND `processor_type` = 'hr'] SQL RUNTIME[0.00022793s] --More--(34%) 10 -> .1.3.6.1.2.1.25.3.3.1.2.4, 4, hr, Processor, 1, 4, , 4 SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '4' AND `processor_type` = 'hr'] SQL RUNTIME[0.00022697s] 10 -> 1, 1, hr-average, Average, 1, 2.5, , SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '1' AND `processor_type` = 'hr-average'] SQL RUNTIME[0.00020409s] SQL[SELECT EXISTS (SELECT 1 FROM `processors` WHERE `device_id` = '10' AND `processor_type` = 'ucd-old')] SQL RUNTIME[0.00020099s] o FORTINET-FORTIMAIL-MIB CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m FORTINET-FORTIMAIL-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/fortinet 'udp':'fgm.placeholder.nl':'161' fmlSysCpuUsage.0] CMD EXITCODE[0] CMD RUNTIME[0.0426s] STDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `processors` WHERE `device_id` = '10'] SQL RUNTIME[0.00044894s] 1 -> hr 2 -> hr 3 -> hr 4 -> hr 1 -> hr-average Array ( [hr] => Array ( [1] => 1 [2] => 1 [3] => 1 [4] => 1 ) [hr-average] => Array ( [1] => 1 ) ) o Changes 5 unchanged o Duration 0.1461s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_mempools'] SQL RUNTIME[0.00024796s] ##### Module Start: mempools ##### o UCD-SNMP-MIB CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' memTotalReal.0 memAvailReal.0 memBuffer.0 memCached.0] CMD EXITCODE[0] CMD RUNTIME[0.038s] STDOUT[ memTotalReal.0 = No Such Object available on this agent at this OID memAvailReal.0 = No Such Object available on this agent at this OID memBuffer.0 = No Such Object available on this agent at this OID memCached.0 = No Such Object available on this agent at this OID ] SNMP ERROR[#1000 - Failed response] SNMP STATUS[FALSE] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrStorageEntry] CMD EXITCODE[0] CMD RUNTIME[0.0398s] STDOUT[ hrStorageIndex.1 = 1 hrStorageIndex.2 = 2 hrStorageIndex.3 = 3 hrStorageIndex.4 = 4 hrStorageType.1 = hrStorageRam hrS torageType.2 = hrStorageVirtualMemory --More--(38%) hrStorageType.3 = hrStorageFixedDisk hrStorageType.4 = hrStorageFixedDisk hrStorageDescr.1 = Physical Memory hrStorageDescr.2 = Swap Memory hrStorageDescr.3 = Compact Flash Disk hrStorageDescr.4 = Internal Hard Disk hrStorageAllocationUnits.1 = 1024 hrStorageAllocationUnits.2 = 1024 hrStorageAllocationUnits.3 = 4096 hrStorageAllocationUnits.4 = 4096 hrStorageSize.1 = 8166936 hrStorageSize.2 = 2097148 hrStorageSize.3 = 251878 hrStorageSize.4 = 20608614 hrStorageUsed.1 = 6227940 hrStorageUsed.2 = 0 hrStorageUsed.3 = 61865 hrStorageUsed.4 = 13569229 hrStorageAllocationFailures.1 = 0 hrStorageAllocationFailures.2 = 0 hrStorageAllocationFailures.3 = 0 hrStorageAllocationFailures.4 = 0 ] SNMP STATUS[TRUE] Store in cache Table OID: HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES::hrStorageEntry 10 -> 1, HOST-RESOURCES-MIB::, Physical Memory, 1024, 8166936, 6227940 SQL[SELECT * FROM `mempools` WHERE `device_id` = '10' AND `mempool_index` = '1' AND `mempool_mib` = 'HOST-RESOURCES-MIB'] SQL RUNTIME[0.00044322s] 10 -> 2, HOST-RESOURCES-MIB::, Swap Memory, 1024, 2097148, 0 SQL[SELECT * FROM `mempools` WHERE `device_id` = '10' AND `mempool_index` = '2' AND `mempool_mib` = 'HOST-RESOURCES-MIB'] SQL RUNTIME[0.00023508s] SQL[SELECT * FROM `mempools` WHERE `device_id` = '10'] SQL RUNTIME[0.00019097s] 1 -> HOST-RESOURCES-MIB 2 -> HOST-RESOURCES-MIB Array ( [HOST-RESOURCES-MIB] => Array ( [1] => 1 [2] => 1 ) ) o Changes 2 unchanged o Duration 0.0858s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_inventory'] SQL RUNTIME[0.00016999s] ##### Module Start: inventory ##### o ENTITY-MIB ENTITY-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m ENTITY-MIB:FORTINET-CORE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/fortinet 'udp':'fgm.placeholder.nl':'161' entPhysicalEntry] CMD EXITCODE[0] CMD RUNTIME[0.1128s] STDOUT[ entPhysicalEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrDeviceEntry] CMD EXITCODE[0] CMD RUNTIME[0.0444s] STDOUT[ hrDeviceIndex.1 = 1 hrDeviceIndex.2 = 2 hrDeviceIndex.3 = 3 hrDeviceIndex.4 = 4 hrDeviceType.1 = hrDeviceProcessor hrDeviceType.2 = hrDeviceProcessor hrDeviceType.3 = hrDeviceProcessor hrDeviceType.4 = hrDeviceProcessor --More--(41%) hrDeviceDescr.1 = CPU Processor hrDeviceDescr.2 = CPU Processor hrDeviceDescr.3 = CPU Processor hrDeviceDescr.4 = CPU Processor hrDeviceID.1 = zeroDotZero.0 hrDeviceID.2 = zeroDotZero.0 hrDeviceID.3 = zeroDotZero.0 hrDeviceID.4 = zeroDotZero.0 hrDeviceStatus.1 = running hrDeviceStatus.2 = running hrDeviceStatus.3 = running hrDeviceStatus.4 = running hrDeviceErrors.1 = 0 hrDeviceErrors.2 = 0 hrDeviceErrors.3 = 0 hrDeviceErrors.4 = 0 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrProcessorEntry] CMD EXITCODE[0] CMD RUNTIME[0.0398s] STDOUT[ hrProcessorFrwID.1 = zeroDotZero.0 hrProcessorFrwID.2 = zeroDotZero.0 hrProcessorFrwID.3 = zeroDotZero.0 hrProcessorFrwID.4 = zeroDotZero.0 hrProcessorLoad.1 = 5 hrProcessorLoad.2 = 1 hrProcessorLoad.3 = 0 hrProcessorLoad.4 = 4 ] SNMP STATUS[TRUE] SQL[SELECT EXISTS (SELECT 1 FROM `hrDevice` WHERE `device_id` = '10' AND `hrDeviceIndex` = '1')] SQL RUNTIME[0.00041413s] SQL[UPDATE `hrDevice` set `hrDeviceType` ='hrDeviceProcessor',`hrDeviceDescr` ='CPU Processor',`hrDeviceStatus` ='running',`hrDeviceErrors` ='0',`hrProcessorLoad` ='5' WHERE device_id = '10' AND hrDeviceIndex = '1'] SQL RUNTIME[0.00253797s] . SQL[SELECT EXISTS (SELECT 1 FROM `hrDevice` WHERE `device_id` = '10' AND `hrDeviceIndex` = '2')] SQL RUNTIME[0.00029707s] SQL[UPDATE `hrDevice` set `hrDeviceType` ='hrDeviceProcessor',`hrDeviceDescr` ='CPU Processor',`hrDeviceStatus` ='running',`hrDeviceErrors` ='0',`hrProcessorLoad` ='1' WHERE device_id = '10' AND hrDeviceIndex = '2'] SQL RUNTIME[0.00227499s] . SQL[SELECT EXISTS (SELECT 1 FROM `hrDevice` WHERE `device_id` = '10' AND `hrDeviceIndex` = '3')] SQL RUNTIME[0.00023484s] SQL[UPDATE `hrDevice` set `hrDeviceType` ='hrDeviceProcessor',`hrDeviceDescr` ='CPU Processor',`hrDeviceStatus` ='running',`hrDeviceErrors` ='0',`hrProcessorLoad` ='0' WHERE device_id = '10' AND hrDeviceIndex = '3'] SQL RUNTIME[0.00189281s] . SQL[SELECT EXISTS (SELECT 1 FROM `hrDevice` WHERE `device_id` = '10' AND `hrDeviceIndex` = '4')] SQL RUNTIME[0.00018001s] SQL[UPDATE `hrDevice` set `hrDeviceType` ='hrDeviceProcessor',`hrDeviceDescr` ='CPU Processor',`hrDeviceStatus` ='running',`hrDeviceErrors` ='0',`hrProcessorLoad` ='4' WHERE device_id = '10' AND hrDeviceIndex = '4'] SQL RUNTIME[0.00203204s] . SQL[SELECT * FROM `hrDevice` WHERE `device_id` = '10'] SQL RUNTIME[0.00016904s] SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '10'] SQL RUNTIME[0.00016403s] o Duration 0.2189s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_printersupplies'] SQL RUNTIME[0.00015521s] ##### Module Start: printersupplies ##### SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '10'] SQL RUNTIME[0.00019717s] o Duration 0.0011s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_sensors'] SQL RUNTIME[0.00018001s] --More--(47%) ##### Module Start: sensors ##### o ENTITY-SENSOR-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' entPhySensorValue] CMD EXITCODE[0] CMD RUNTIME[0.1164s] STDOUT[ entPhySensorValue = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00047803s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00029397s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021410s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022483s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00025201s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00027394s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020409s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00017381s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00018501s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016713s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016308s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00017095s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016499s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00018907s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00018311s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00018811s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'attenuation' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020123s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016689s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021100s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'concentration' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020599s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00018001s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016785s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00017905s] --More--(55%) SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00017595s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00015903s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00018597s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016499s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00017691s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'distance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00015593s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016999s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016618s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'gauge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016499s] SQL[SELECT * FROM `status` WHERE `device_id` = '10' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00018001s] SQL[SELECT * FROM `counters` WHERE `device_id` = '10' AND `poller_type` = 'snmp' AND `counter_deleted` = '0'] SQL RUNTIME[0.00017595s] o Duration 0.1424s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_storage'] SQL RUNTIME[0.00016618s] ##### Module Start: storage ##### o UCD-SNMP-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' dskEntry] CMD EXITCODE[0] CMD RUNTIME[0.1192s] STDOUT[ dskEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o HOST-RESOURCES-MIB Get cached Table OID: HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES::hrStorageEntry skip(memory) skip(memory) 10 -> 3, hrStorageFixedDisk, HOST-RESOURCES-MIB, Compact Flash Disk, 4096, 1031692288, 253399040, 0 SQL[SELECT * FROM `storage` WHERE `device_id` = '10' AND `storage_index` = '3' AND `storage_mib` = 'HOST-RESOURCES-MIB'] SQL RUNTIME[0.00074887s] 10 -> 4, hrStorageFixedDisk, HOST-RESOURCES-MIB, Internal Hard Disk, 4096, 84412882944, 55579561984, 0 SQL[SELECT * FROM `storage` WHERE `device_id` = '10' AND `storage_index` = '4' AND `storage_mib` = 'HOST-RESOURCES-MIB'] SQL RUNTIME[0.00036216s] SQL[SELECT * FROM `storage` WHERE `device_id` = '10'] SQL RUNTIME[0.00040698s] 3 -> HOST-RESOURCES-MIB 4 -> HOST-RESOURCES-MIB Array ( [HOST-RESOURCES-MIB] => Array ( [3] => Compact Flash Disk [4] => Internal Hard Disk ) ) o Changes 2 unchanged o Duration 0.1258s --More--(61%) SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_neighbours'] SQL RUNTIME[0.00036001s] ##### Module Start: neighbours ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00028610s] JSON DECODE[Not string passed] JSON RAW[ ] o LLDP-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' lldpRemChassisIdSubtype] CMD EXITCODE[0] CMD RUNTIME[0.0446s] STDOUT[ lldpRemChassisIdSubtype = No more variables left in this MIB View (It is past the end of the MIB tree) ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o CISCO-CDP-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -Ih -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'fgm.placeholder.nl':'161' cdpCache] CMD EXITCODE[0] CMD RUNTIME[0.1476s] STDOUT[ cdpCache = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `neighbours` WHERE `device_id` = '10'] SQL RUNTIME[0.00039196s] o Duration 0.1987s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_arp-table'] SQL RUNTIME[0.00026894s] ##### Module Start: arp-table ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00023890s] JSON DECODE[Not string passed] JSON RAW[ ] o IP-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u ** * -Pud -OQUsX -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipNetToPhysicalPhysAddress] CMD EXITCODE[0] CMD RUNTIME[0.1125s] STDOUT[ ipNetToPhysicalPhysAddress = No Such Instance currently exists at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsX -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipNetToMediaPhysAddress] CMD EXITCODE[0] CMD RUNTIME[0.0432s] STDOUT[ ipNetToMediaPhysAddress[1][10.31.240.1] = 0:0:11:11:22:22 ipNetToMediaPhysAddress[1][10.31.240.10] = 0:50:56:a3:5d:c5 ipNetToMediaPhysAddress[1][10.31.243.254] = 0:9:f:9:8:5 ] SNMP STATUS[TRUE] Used IP-MIB::ipNetToMediaPhysAddress o IPV6-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsX -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipv6NetToMediaPhysAddress] CMD EXITCODE[0] --More--(66%) CMD RUNTIME[0.107s] STDOUT[ ipv6NetToMediaPhysAddress = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `ip_mac` WHERE `device_id` = '10'] SQL RUNTIME[0.00055599s] +---------+---------+-----+-------------+-----------------+ | ifIndex | ifDescr | VRF | IP: Version | Addresses Count | +---------+---------+-----+-------------+-----------------+ | 1 | port1 | | IPv4 | 3 | +---------+---------+-----+-------------+-----------------+ o Changes 3 unchanged o Duration 0.2762s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_junose-atm-vp'] SQL RUNTIME[0.00046396s] ##### Module Start: junose-atm-vp ##### o Duration 0.0008s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_bgp-peers'] SQL RUNTIME[0.00025892s] ##### Module Start: bgp-peers ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'bgp_localas'] SQL RUNTIME[0.00021315s] CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' bgpLocalAs.0] CMD EXITCODE[0] CMD RUNTIME[0.0372s] STDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] No BGP on host SQL[SELECT * FROM `bgpPeers` WHERE `device_id` = '10'] SQL RUNTIME[0.00045300s] o Duration 0.0412s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_mac-accounting'] SQL RUNTIME[0.00023913s] ##### Module Start: mac-accounting ##### o Duration 0.0002s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_sla'] SQL RUNTIME[0.00019193s] ##### Module Start: sla ##### o DISMAN-PING-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m DISMAN-PING-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl': '161' pingCtlEntry] CMD EXITCODE[0] CMD RUNTIME[0.1214s] STDOUT[ pingCtlEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `slas` WHERE `device_id` = '10'] SQL RUNTIME[0.00037599s] o Duration 0.1246s --More--(70%) SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_lsp'] SQL RUNTIME[0.00025487s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_pseudowires'] SQL RUNTIME[0.00020504s] ##### Module Start: pseudowires ##### SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '10'] SQL RUNTIME[0.00020218s] o PW-STD-MIB CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' pwID] CMD EXITCODE[0] CMD RUNTIME[0.0399s] STDOUT[ pwID = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o Duration 0.0435s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_virtual-machines'] SQL RUNTIME[0.00038218s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_cisco-cbqos'] SQL RUNTIME[0.00054288s] ##### Module Start: cisco-cbqos ##### SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '10'] SQL RUNTIME[0.00026488s] CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-CLASS-BASED-QOS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'fgm.placeholder.nl':'161' cbQosIfType] CMD EXITCODE[0] CMD RUNTIME[0.1718s] 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.1747s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_ucd-diskio'] SQL RUNTIME[0.00053501s] ##### Module Start: ucd-diskio ##### CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m UCD-DISKIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' diskIOEntry] CMD EXITCODE[0] CMD RUNTIME[0.1208s] STDOUT[ diskIOEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[ SELECT * FROM `ucd_diskio` WHERE `device_id` = '10'] SQL RUNTIME[0.00039387s] - SQL[DELETE FROM `ucd_diskio` WHERE `diskio_id` = ''] SQL RUNTIME[0.00018787s] o Duration 0.1249s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_wifi'] SQL RUNTIME[0.00022697s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_p2p-radios'] SQL RUNTIME[0.00018811s] ##### Module Start: p2p-radios ##### --More--(75%) o Duration 0.0001s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_graphs'] SQL RUNTIME[0.00018191s] ##### Module Start: graphs ##### o Duration 0.0004s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_raid'] SQL RUNTIME[0.00019598s] o Modules Disabled lsp, virtual-machines, wifi, raid o Modules Enabled os, mibs, vrf, ports, ports-stack, vlans, oids, ip-addresses, processors, mempools, inventory, printersupplies, sensors, storage,neighbours, arp-table, junose-atm-vp, bgp-peers, mac-accounting, sla, pseudowires, cisco-cbqos, ucd-diskio, p2p-radios,graphs SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '10';] SQL RUNTIME[0.00017118s] SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='security',`last_discovered_timetaken` ='3.0008',`force_discovery` ='0',`device_state` ='a:5:{s:15:\"poller_mod_perf\";a:26:{s:6:\"system\";d:0.513;s:2:\"os\";d:0.2412;s:7:\"sensors\";d:0.0009;s:6:\"status\";d:0.0004;s:7:\"counter\";d :0.0005;s:10:\"pro cessors\";d:0.3228;s:8:\"mempools\";d:0.0826;s:7:\"storage\";d:0.0069;s:8:\"netstats\";d:0.5795;s:7:\"ucd-mib\";d:0.1263;s:13:\"ipSystemStats\";d:0.1151;s:5:\"ports\";d:0.7621;s:9:\"bgp-peers\";d:0.0013;s:15:\"printersupplies\";d:0.0006;s:10:\"ucd-diskio\";d:0.0006;s:10:\"p2p-radios\";d:0.0005;s:4:\"ospf\";d:0.0001;s:3:\"sla\";d:0.0005;s:11:\"pseudowires\";d:0.0006;s:14:\"mac-accounting\";d:0.0008;s:12:\"loadbalancer\";d:0.0002;s:15:\"entity-physical\";d:0.0002;s:9:\"fdb-table\";d:0.0708;s:6:\"graphs\";d:0.1085;s:4:\"oids\";d:0.0445;s:6:\"probes\";d:0.0012;}s:17:\"poller_ports_perf\";a:4:{s:6:\"IF-MIB\";d:0.32122111320495605;s:13:\"EtherLike-MIB\";d:0.05432295799255371;s:12:\"Q-BRIDGE-MIB\";d:0.1885969638824463;s:6:\"IP-MIB\";d:0.12035989761352539;}s:14:\"poller_history\";a:25:{i:1693313402;d:3.1536;i:1693313102;d:3.2064;i:1693312802;d:3.2337;i:1693312502;d:3.4188;i:1693312202;d:3.4495;i:1693311901;d:3.2916;i:1693311602;d:3.2621;i:1693311301;d:3.4216;i:1693311001;d:3.0182;i:1693310702;d:3.1586;i:1693310401;d:2.9539;i:1693310102;d:3.1878;i:1693309801;d:3.0893;i:1693309502;d:3.9898;i:1693309202;d:3.2208;i:1693308902;d:3.0107;i:1693308602;d:3.1337;i:1693308302;d:2.9999;i:1693308002;d:2.9587;i:1693307702;d:3.2777;i:1693307402;d:3.1143;i:1693307102;d:3.2791;i:1693306802;d:3.1023;i:1693306502;d:3.527;i:1693306202;d:5.1759;}s:17:\"discovery_history\";a:3:{i:1693313408;d:3.0008;i:1693310355;d:3.1893;i:1693306201;d:3.4966;}s:18:\"discovery_mod_perf\";a:26:{s:2:\"os\";d:0.1258;s:4:\"mibs\";d:0.2965;s:3:\"vrf\";d:0.0021;s:5:\"ports\";d:0.2693;s:11:\"ports-stack\";d:0.1151;s:5:\"vlans\";d:0.0546;s:11:\"ports_vlans\";N;s:4:\"oids\";d:0.0018;s:12:\"ip-addresses\";d:0.4001;s:10:\"processors\";d:0.1461;s:8:\"mempools\";d:0.0858;s:9:\"inventory\";d:0.2189;s:15:\"printersupplies\";d:0.0011;s:7:\"sensors\";d:0.1424;s:7:\"storage\";d:0.1258;s:10:\"neighbours\";d:0.1987;s:9:\"arp-table\";d:0.2762;s:13:\"junose-atm-vp\";d:0.0008;s:9:\"bgp-peers\";d:0.0412;s:14:\"m ac-accounting\";d:0.0002;s:3:\"sla\";d:0.1246;s:11:\"pseudowires\";d:0.0435;s:11:\"cisco-cbqos\";d:0.1747;s:10:\"ucd-diskio\";d:0.1249;s:10:\"p2p-radios\";d:0.0001;s:6:\"graphs\";d:0.0004;}}' WHERE `device_id` = '10'] SQL RUNTIME[0.00504494s] ##### fgm.placeholder.nl [10] completed discovery modules at 2023-08-29 14:50:11 ##### o Discovery time 3.0008 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '1151846' AND `process_name` = 'discovery.php' AND `device_id` = '10' AND `poller_id` = '0'] SQL RUNTIME[0.00227404s] ##### Finished discovery run at 2023-08-29 14:50:11 ##### SQL[SELECT * FROM `groups` ORDER BY `entity_type`] SQL RUNTIME[0.00029588s] SQL[SELECT * FROM `groups_assoc`] SQL RUNTIME[0.00019789s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`syscontact` = 'infra_24x7')] SQL RUNTIME[0.00021386s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '1'] SQL RUNTIME[0.00030589s] Group 'infra_24x7': 4 existing, 4 new entries (+0/-0). SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`syscontact` = 'infra_10x5')] SQL RUNTIME[0.00026202s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '2'] SQL RUNTIME[0.00022388s] Group 'infra_10x5': 1 existing, 1 new entries (+0/-0). SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`syscontact` = 'infra_be')] SQL RUNTIME[0.00020599s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '3'] SQL RUNTIME[0.00023699s] Group 'infra_be': 1 existing, 1 new entries (+0/-0). SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00023699s] Cached 14 alert rules. SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00012708s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00017905s] SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device _id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10', '8','4')) AND `mempools`.`mempool_deleted` != '1'] SQL RUNTIME[0.00032306s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '1'] SQL RUNTIME[0.00024104s] --More--(83%) Alert Checker 'fw-memory-warning': 8 existing, 8 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00027394s] SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10', '8','4')) AND `mempools`.`mempool_deleted` != '1'] SQL RUNTIME[0.00031590s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '2'] SQL RUNTIME[0.00022697s] Alert Checker 'fw-memory-critical': 8 existing, 8 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00020099s] SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10', '8','4'))] SQL RUNTIME[0.00024295s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '3'] SQL RUNTIME[0.00025988s] Alert Checker 'fw-cpu-cr itical': 33 existing, 33 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00019217s] SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10', '8','4'))] SQL RUNTIME[0.00026512s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '4'] SQL RUNTIME[0.00027609s] Alert Checker 'fw-cpu-warning': 33 existing, 33 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00021315s] SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10','8 ','4') AND IFNULL(`status`.`status_type`, '') = 'FgHaMode') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00061679s] SQL[SELECT * FROM `alert_table` WHERE `aler t_test_id` = '5'] SQL RUNTIME[0.00032306s] Alert Checker 'fw_ha_status': 4 existing, 4 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00032592s] SQL[SELECT `bgpPeer_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10', '8','4'))] SQL RUNTIME[0.00046706s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '6'] SQL RUNTIME[0.00050402s] Alert Checker 'fw_bgp_up': 5 existing, 5 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00032187s] SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5' ,'9','10', '8','4') AND IFNULL(`sensors`.`sensor_class`, '') = 'temperature') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00061393s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '7'] SQL RUNTIME[0.00028801s] Alert Checker 'fw-temperature-critical': 8 existing, 8 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00051188s] SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10', '8','4') AND IFNULL(`sensors`.`sensor_class`, '') = 'temperature') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00066304s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '8'] SQL RUNTIME[0.00021005s] Alert Checker 'fw-temperature-warning': 8 existing, 8 new entries (+0/-0). SQL[SELECT DISTINCT ` entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00020003s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN ('3','5','9','10','8','4'))] --More--(92%) SQL RUNTIME[0.00014710s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '9'] SQL RUNTIME[0.00018287s] Alert Checker 'fw-reacahable-critical': 6 existing, 6 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00016093s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10','8' ,'4') AND IFNULL(`ports`.`ifType`, '') = 'ethernetCsmacd') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00050402s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '10'] SQL RUNTIME[0.00041890s] Alert Checker 'fw-port-error-warning': 61 existing, 61 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00022221s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10','8' ,'4') AND IFNULL(`ports`.`ifType`, '') = 'ethernetCsmacd') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00053191s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '11'] SQL RUNTIME[0.00034904s] Alert Checker 'fw-port-error-critical': 61 existing, 61 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 A ND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00018597s] SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10','8 ','4') AND IFNULL(`status`.`status_type`, '') = 'FgHaStatsSyncStatusType') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00031686s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '12'] SQL RUNTIME[0.00023007s] Alert Checker 'fw_ha_sync': 7 existing, 7 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00018001s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10','8' ,'4' ) AND IFNULL(`ports`.`ifType`, '') = 'ethernetCsmacd') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00049901s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '13'] SQL RUNTIME[0.00033784s] Alert Checker 'fw-port-status': 61 existing, 61 new entries (+0/-0). SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')] SQL RUNTIME[0.00017786s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10','8' ,'4') AND IFNULL(`ports`.`ifType`, '') = 'tunnel' AND IFNULL(`ports`.`ifName`, "") NOT LIKE '%.root%' AND IFNULL(`ports`.`ifName`, "") NOT LIKE '%.Guest%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00050592s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '14'] SQL RUNTI ME[0.00019217s] Alert Checker 'fw-port-vpn': 4 existing, 4 new entries (+0/-0). ./discovery.php: fgm.placeholder.nl - 1 devices discovered in 3.143 secs SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1693299008'] SQL RUNTIME[0.00014520s] 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 3.143 secs o Definitions 0.104248046875 secs o Memory usage 24MB (peak: 24MB) o MySQL Usage Cell[16/0.014s] Row[43/0.037s] Rows[119/0.095s] Column[19/0.013s] Update[5/0.017s] Insert[1/0.003s] Delete[3/0.004s] o RRDTool Usage root@obs:/opt/observium#