su www-data -c '/opt/observium/discovery.php -r -h lv0-router.EDITED.FQDN -m vlans -dd' DEBUG! Load class 'Console_Color2' from '/opt/observium/libs/pear/Console/Color2.php': OK CMD[/usr/bin/svn info /opt/observium] Wrong process status! Issue in proc_get_status(), see: https://bugs.php.net/bug.php?id=69014 CMD EXITCODE[0] CMD RUNTIME[0.0337s] STDOUT[ Path: . Working Copy Root Path: /opt/observium Relative URL: ^/observium/branches/stable Revision: 10491 Node Kind: directory Schedule: normal Last Changed Author: adama Last Changed Rev: 10371 Last Changed Date: 2020-04-15 22:02:34 +0200 (Wed, 15 Apr 2020) ] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] ROWS[1] SQL RUNTIME[0.00050616s] SQL[SELECT @@SESSION.sql_mode;] ROWS[1] SQL RUNTIME[0.00034189s] SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'] ROWS[0] SQL RUNTIME[0.00024009s] DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] ROWS[1] SQL RUNTIME[0.00018692s] SQL[SELECT * FROM `config`] ROWS[54] SQL RUNTIME[0.00033712s] CMD[/bin/hostname -f] Wrong process status! Issue in proc_get_status(), see: https://bugs.php.net/bug.php?id=69014 CMD EXITCODE[0] CMD RUNTIME[0.0063s] STDOUT[ mms.EDITED.FQDN ] Load class 'Net_IPv6' from '/opt/observium/libs/pear/Net/IPv6.php': OK ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 20.4.10371 http://www.observium.org CMD[/opt/observium/scripts/distro] Wrong process status! Issue in proc_get_status(), see: https://bugs.php.net/bug.php?id=69014 CMD EXITCODE[0] CMD RUNTIME[0.206s] STDOUT[ Linux|4.19.0-9-amd64|amd64|Debian|10|kvm| ] CMD[/usr/bin/env python --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0092s] CMD EXITDELAY[10ms] STDOUT[ Python 2.7.16 ] SQL[SELECT version();] ROWS[1] SQL RUNTIME[0.00073385s] CMD[/usr/bin/snmpget --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0097s] CMD EXITDELAY[10ms] STDOUT[ NET-SNMP version: 5.7.3 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0274s] STDOUT[ RRDtool 1.7.1 Copyright by Tobias Oetiker ] CMD[/usr/bin/rrdcached -h | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0272s] STDOUT[ RRDCacheD 1.7.1 ] CMD[/usr/bin/fping -v 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0068s] CMD EXITDELAY[10ms] STDOUT[ /usr/bin/fping: Version 4.2 /usr/bin/fping: comments to david@schweikert.ch ] CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.0675s] STDOUT[ Apache/2.4.38 ] CMD[date "+%:z"] CMD EXITCODE[0] CMD RUNTIME[0.0045s] CMD EXITDELAY[10ms] STDOUT[ +02:00 ] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] ROWS[1] SQL RUNTIME[0.00047708s] SQL[SELECT @@SESSION.sql_mode;] ROWS[1] SQL RUNTIME[0.00043797s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] ROWS[1] SQL RUNTIME[0.00161386s] ##### Software versions ##### o OS Linux 4.19.0-9-amd64 [amd64] (Debian 10) o Apache 2.4.38 o PHP 7.3.14-1~deb10u1 (OPcache: ENABLED) o Python 2.7.16 o MySQL 10.3.22-MariaDB-0+deb10u1 (extension: mysqli 5.0.12-dev) o SNMP NET-SNMP 5.7.3 o RRDtool 1.7.1 (rrdcached 1.7.1: unix:/var/run/rrdcached.sock) o Fping 4.2 (IPv4 and IPv6) ##### Memory Limit ##### o PHP Unlimited ##### MySQL mode ##### o MySQL NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ##### Charset info ##### o PHP UTF-8 o MySQL utf8 ##### Timezones info ##### o Date Saturday, 13-Jun-20 13:08:39 CEST o PHP +02:00 o MySQL +02:00 SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] ROWS[1] SQL RUNTIME[0.00024009s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] ROWS[1] SQL RUNTIME[0.00019097s] ##### Starting discovery run at 2020-06-13 13:08:39 ##### SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'lv0-router.EDITED.FQDN' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] ROWS[1] SQL RUNTIME[0.00221801s] CMD[/usr/bin/snmpget -r '1' -v2c -c 'lv0-RO' -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lv0-router.EDITED.FQDN':'161' sysObjectID.0 sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0384s] STDOUT[ sysObjectID.0 = enterprises.2636.1.1.1.2.133 sysUpTime.0 = 62:23:40:36.60 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '73'] ROWS[3] SQL RUNTIME[0.00052309s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '73'] ROWS[0] SQL RUNTIME[0.00124884s] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('2074','discovery.php','2073','33','php /opt/observium/discovery.php -r -h lv0-router.EDITED.FQDN -m vlans -dd','1592046518','73')] ROWS[1] SQL RUNTIME[0.00880790s] ##### lv0-router.EDITED.FQDN [73] ##### > $device_discovery_cache_keys /opt/observium/includes/discovery/functions.inc.php:273 array( [0] => string(10) "db_version" [1] => string(9) "localhost" [2] => string(8) "versions" [3] => string(8) "timezone" [4] => string(7) "devices" [5] => string(14) "entity_attribs" [6] => string(18) "entity_attribs_all" ) SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '73' AND `use` = 'mib' AND `disabled` = '1'] ROWS[0] SQL RUNTIME[0.00096607s] > get_device_mibs_permitted($device) /opt/observium/includes/discovery/functions.inc.php:275 array( [0] => string(11) "JUNIPER-MIB" [1] => string(17) "JUNIPER-ALARM-MIB" [2] => string(15) "JUNIPER-DOM-MIB" [3] => string(20) "JUNIPER-IFOPTICS-MIB" [4] => string(34) "JUNIPER-SRX5000-SPU-MONITORING-MIB" [5] => string(16) "JUNIPER-VLAN-MIB" [6] => string(15) "JUNIPER-MAC-MIB" [7] => string(16) "JUNIPER-PING-MIB" [8] => string(15) "JUNIPER-VPN-MIB" [9] => string(15) "JUNIPER-COS-MIB" [10] => string(15) "Juniper-QoS-MIB" [11] => string(20) "JUNIPER-FIREWALL-MIB" [12] => string(19) "BGP4-V2-MIB-JUNIPER" [13] => string(18) "POWER-ETHERNET-MIB" [14] => string(18) "MPLS-L3VPN-STD-MIB" [15] => string(12) "MPLS-VPN-MIB" [16] => string(16) "JUNIPER-IPv6-MIB" [17] => string(8) "MPLS-MIB" [18] => string(10) "SNMPv2-MIB" [19] => string(18) "SNMP-FRAMEWORK-MIB" [20] => string(6) "IF-MIB" [21] => string(13) "ADSL-LINE-MIB" [22] => string(13) "EtherLike-MIB" [23] => string(12) "UCD-SNMP-MIB" [24] => string(18) "HOST-RESOURCES-MIB" [25] => string(12) "Q-BRIDGE-MIB" [26] => string(8) "LLDP-MIB" [27] => string(13) "CISCO-CDP-MIB" [28] => string(15) "DISMAN-PING-MIB" [29] => string(8) "BGP4-MIB" [30] => string(8) "OSPF-MIB" [31] => string(6) "IP-MIB" [32] => string(8) "IPV6-MIB" ) o OS Type junos o SNMP Version v2c o Last discovery 2020-06-13 13:08:34 o Last duration 0.78 seconds ##### Module Start: vlans ##### SQL[SELECT * FROM `vlans` WHERE `device_id` = '73';] ROWS[5] SQL RUNTIME[0.00023699s] SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '73';] ROWS[13] SQL RUNTIME[0.00021100s] > $ports_vlans_db /opt/observium/includes/discovery/vlans.inc.php:33 array( [9265] => array( [10] => array( [port_vlan_id] => string(3) "185" [device_id] => string(2) "73" [port_id] => string(4) "9265" [vlan] => string(2) "10" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) [20] => array( [port_vlan_id] => string(3) "186" [device_id] => string(2) "73" [port_id] => string(4) "9265" [vlan] => string(2) "20" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) [999] => array( [port_vlan_id] => string(3) "187" [device_id] => string(2) "73" [port_id] => string(4) "9265" [vlan] => string(3) "999" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) [1000] => array( [port_vlan_id] => string(3) "188" [device_id] => string(2) "73" [port_id] => string(4) "9265" [vlan] => string(4) "1000" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) ) [9266] => array( [10] => array( [port_vlan_id] => string(3) "189" [device_id] => string(2) "73" [port_id] => string(4) "9266" [vlan] => string(2) "10" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) [20] => array( [port_vlan_id] => string(3) "190" [device_id] => string(2) "73" [port_id] => string(4) "9266" [vlan] => string(2) "20" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) [999] => array( [port_vlan_id] => string(3) "191" [device_id] => string(2) "73" [port_id] => string(4) "9266" [vlan] => string(3) "999" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) [1000] => array( [port_vlan_id] => string(3) "192" [device_id] => string(2) "73" [port_id] => string(4) "9266" [vlan] => string(4) "1000" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) ) [9270] => array( [10] => array( [port_vlan_id] => string(3) "193" [device_id] => string(2) "73" [port_id] => string(4) "9270" [vlan] => string(2) "10" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) ) [9268] => array( [20] => array( [port_vlan_id] => string(3) "194" [device_id] => string(2) "73" [port_id] => string(4) "9268" [vlan] => string(2) "20" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) [999] => array( [port_vlan_id] => string(3) "195" [device_id] => string(2) "73" [port_id] => string(4) "9268" [vlan] => string(3) "999" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) [1000] => array( [port_vlan_id] => string(3) "196" [device_id] => string(2) "73" [port_id] => string(4) "9268" [vlan] => string(4) "1000" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) ) [9269] => array( [20] => array( [port_vlan_id] => string(3) "197" [device_id] => string(2) "73" [port_id] => string(4) "9269" [vlan] => string(2) "20" [baseport] => string(1) "0" [priority] => string(1) "0" [state] => string(0) "" [cost] => string(1) "0" ) ) ) o Q-BRIDGE-MIB CMD[/usr/bin/snmpbulkwalk -r '1' -v2c -c 'lv0-RO' -Pud -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lv0-router.EDITED.FQDN':'161' dot1qVlanStaticName] CMD EXITCODE[0] CMD RUNTIME[0.0952s] STDOUT[ dot1qVlanStaticName.1 = default+1 dot1qVlanStaticName.10 = LAN+10 dot1qVlanStaticName.20 = WAN+20 dot1qVlanStaticName.999 = DMZ+999 dot1qVlanStaticName.1000 = VPN+1000 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -r '1' -v2c -c 'lv0-RO' -Pud -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lv0-router.EDITED.FQDN':'161' dot1qVlanStaticRowStatus] Wrong process status! Issue in proc_get_status(), see: https://bugs.php.net/bug.php?id=69014 CMD EXITCODE[0] CMD RUNTIME[0.0984s] STDOUT[ dot1qVlanStaticRowStatus.1 = active dot1qVlanStaticRowStatus.10 = active dot1qVlanStaticRowStatus.20 = active dot1qVlanStaticRowStatus.999 = active dot1qVlanStaticRowStatus.1000 = active ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -r '1' -v2c -c 'lv0-RO' -Pud -Ih -OQUsx -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lv0-router.EDITED.FQDN':'161' dot1qVlanStaticEgressPorts] CMD EXITCODE[0] CMD RUNTIME[0.0949s] STDOUT[ dot1qVlanStaticEgressPorts.1 = "" dot1qVlanStaticEgressPorts.10 = "31 2C 32 2C 33 2C 34 2C 35 2C 37 2C 38 " dot1qVlanStaticEgressPorts.20 = "36 " dot1qVlanStaticEgressPorts.999 = "34 " dot1qVlanStaticEgressPorts.1000 = "34 " ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -r '1' -v2c -c 'lv0-RO' -Pud -OQUs -m JUNIPER-VLAN-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/juniper 'udp':'lv0-router.EDITED.FQDN':'161' jnxExVlanTable] Wrong process status! Issue in proc_get_status(), see: https://bugs.php.net/bug.php?id=69014 CMD EXITCODE[0] CMD RUNTIME[0.2054s] STDOUT[ jnxExVlanTable = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR - device: 73, cmd: snmpwalk, options: -OQUs, mib: 'JUNIPER-VLAN-MIB', oid: 'jnxExVlanTable', cmd exitcode: 0, snmp error code: #1000, reason: 'Failed response', runtime: 0.20539784431458 CMD[/usr/bin/snmpbulkwalk -r '1' -v2c -c 'lv0-RO' -Pud -OQUs -m BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lv0-router.EDITED.FQDN':'161' dot1dBasePortIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.1054s] CMD EXITDELAY[10ms] STDOUT[ dot1dBasePortIfIndex.1 = 516 dot1dBasePortIfIndex.2 = 517 dot1dBasePortIfIndex.3 = 519 dot1dBasePortIfIndex.4 = 520 dot1dBasePortIfIndex.5 = 521 dot1dBasePortIfIndex.6 = 522 dot1dBasePortIfIndex.7 = 523 dot1dBasePortIfIndex.8 = 524 ] SNMP STATUS[TRUE] Store in cache Table OID: BRIDGE-MIB::dot1dBasePortIfIndex > $binary_debug /opt/observium/includes/discovery/vlans/q-bridge-mib.inc.php:157 array( [10] => array( [2] => string(3) "519" [3] => string(3) "520" [7] => string(3) "524" ) [20] => array( [2] => string(3) "519" [3] => string(3) "520" [5] => string(3) "522" [6] => string(3) "523" ) [999] => array( [2] => string(3) "519" [3] => string(3) "520" [5] => string(3) "522" ) [1000] => array( [2] => string(3) "519" [3] => string(3) "520" [5] => string(3) "522" ) ) CMD[/usr/bin/snmpbulkwalk -r '1' -v2c -c 'lv0-RO' -Pud -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lv0-router.EDITED.FQDN':'161' dot1qPvid] CMD EXITCODE[0] CMD RUNTIME[0.0951s] CMD EXITDELAY[10ms] STDOUT[ dot1qPvid.1 = 10 dot1qPvid.2 = 10 dot1qPvid.3 = 10 dot1qPvid.4 = 10 dot1qPvid.5 = 10 dot1qPvid.6 = 20 dot1qPvid.7 = 10 dot1qPvid.8 = 10 ] SNMP STATUS[TRUE] 1 10 20 999 1000Load class 'cli\Table' from '/opt/observium/libs/cli/Table.php': OK Load class 'cli\Shell' from '/opt/observium/libs/cli/Shell.php': OK Load class 'cli\table\Renderer' from '/opt/observium/libs/cli/table/Renderer.php': OK Load class 'cli\table\Ascii' from '/opt/observium/libs/cli/table/Ascii.php': OK Load class 'cli\Colors' from '/opt/observium/libs/cli/Colors.php': OK Load class 'cli\Streams' from '/opt/observium/libs/cli/Streams.php': OK +--------+----------+-----------+----------+-------------+ | Domain | Vlan: ID | Name | Type | Status | +--------+----------+-----------+----------+-------------+ | 1 | 1 | default+1 | ethernet | operational | | 1 | 10 | LAN+10 | ethernet | operational | | 1 | 20 | WAN+20 | ethernet | operational | | 1 | 999 | DMZ+999 | ethernet | operational | | 1 | 1000 | VPN+1000 | ethernet | operational | +--------+----------+-----------+----------+-------------+ SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '519' AND `deleted` = '0' LIMIT 1] ROWS[1] SQL RUNTIME[0.00033784s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '9265'] ROWS[1] SQL RUNTIME[0.00070715s] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '9265'] ROWS[1] SQL RUNTIME[0.00086308s] SQL[SELECT * FROM `devices` WHERE `device_id` = '73'] ROWS[1] SQL RUNTIME[0.00152206s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '73'] ROWS[39] SQL RUNTIME[0.00055718s] SQL[UPDATE `ports_vlans` set `vlan` ='10',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '185'] ROWS[0] SQL RUNTIME[0.00209498s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[UPDATE `ports_vlans` set `vlan` ='20',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '186'] ROWS[0] SQL RUNTIME[0.00105500s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[UPDATE `ports_vlans` set `vlan` ='999',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '187'] ROWS[0] SQL RUNTIME[0.00099611s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[UPDATE `ports_vlans` set `vlan` ='1000',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '188'] ROWS[0] SQL RUNTIME[0.00127721s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '520' AND `deleted` = '0' LIMIT 1] ROWS[1] SQL RUNTIME[0.00024199s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '9266'] ROWS[1] SQL RUNTIME[0.00052094s] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '9266'] ROWS[1] SQL RUNTIME[0.00024390s] SQL[UPDATE `ports_vlans` set `vlan` ='10',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '189'] ROWS[0] SQL RUNTIME[0.00133085s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[UPDATE `ports_vlans` set `vlan` ='20',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '190'] ROWS[0] SQL RUNTIME[0.00109911s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[UPDATE `ports_vlans` set `vlan` ='999',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '191'] ROWS[0] SQL RUNTIME[0.00122118s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[UPDATE `ports_vlans` set `vlan` ='1000',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '192'] ROWS[0] SQL RUNTIME[0.00155187s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '524' AND `deleted` = '0' LIMIT 1] ROWS[1] SQL RUNTIME[0.00039387s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '9270'] ROWS[1] SQL RUNTIME[0.00050902s] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '9270'] ROWS[1] SQL RUNTIME[0.00055909s] SQL[UPDATE `ports_vlans` set `vlan` ='10',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '193'] ROWS[0] SQL RUNTIME[0.00114894s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '522' AND `deleted` = '0' LIMIT 1] ROWS[1] SQL RUNTIME[0.00047708s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '9268'] ROWS[1] SQL RUNTIME[0.00033402s] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '9268'] ROWS[1] SQL RUNTIME[0.00022912s] SQL[UPDATE `ports_vlans` set `vlan` ='20',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '194'] ROWS[0] SQL RUNTIME[0.00122499s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[UPDATE `ports_vlans` set `vlan` ='999',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '195'] ROWS[0] SQL RUNTIME[0.00158596s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[UPDATE `ports_vlans` set `vlan` ='1000',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '196'] ROWS[0] SQL RUNTIME[0.00101995s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '523' AND `deleted` = '0' LIMIT 1] ROWS[1] SQL RUNTIME[0.00068903s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '9269'] ROWS[1] SQL RUNTIME[0.00054693s] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '9269'] ROWS[1] SQL RUNTIME[0.00042605s] SQL[UPDATE `ports_vlans` set `vlan` ='20',`baseport` ='',`priority` ='',`state` ='',`cost` ='' WHERE `port_vlan_id` = '197'] ROWS[0] SQL RUNTIME[0.00110102s] SQL WARNINGS[ 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`baseport` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`priority` at row 1 1366: Incorrect integer value: '' for column `observium`.`ports_vlans`.`cost` at row 1 ] +---------+----------+------+---------------+-------+------+ | ifIndex | ifDescr | Vlan | STP: Priority | State | Cost | +---------+----------+------+---------------+-------+------+ | 519 | ge-0/0/2 | 10 | | | | | 519 | ge-0/0/2 | 20 | | | | | 519 | ge-0/0/2 | 999 | | | | | 519 | ge-0/0/2 | 1000 | | | | | 520 | ge-0/0/3 | 10 | | | | | 520 | ge-0/0/3 | 20 | | | | | 520 | ge-0/0/3 | 999 | | | | | 520 | ge-0/0/3 | 1000 | | | | | 524 | ge-0/0/7 | 10 | | | | | 522 | ge-0/0/5 | 20 | | | | | 522 | ge-0/0/5 | 999 | | | | | 522 | ge-0/0/5 | 1000 | | | | | 523 | ge-0/0/6 | 20 | | | | +---------+----------+------+---------------+-------+------+ Module [ vlans ] stats: 1[V.] 10[V.PU] 20[V.PU] 999[V.PU] 1000[V.PU] o Changes 5 unchanged o Duration 0.8484s SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.8682',`force_discovery` ='0' WHERE `device_id` = '73'] ROWS[1] SQL RUNTIME[0.00963283s] ##### lv0-router.EDITED.FQDN [73] completed discovery modules at 2020-06-13 13:08:40 ##### o Discovery time 0.8682 seconds > $device_discovery_cache_keys /opt/observium/includes/discovery/functions.inc.php:472 array( [7] => string(10) "port_index" [8] => string(4) "port" ) SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '2074' AND `process_name` = 'discovery.php' AND `device_id` = '73'] ROWS[1] SQL RUNTIME[0.00586796s] ##### Finished discovery run at 2020-06-13 13:08:40 ##### /opt/observium/discovery.php: lv0-router.EDITED.FQDN - 1 devices discovered in 1.377 secs SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1592032119'] ROWS[0] SQL RUNTIME[0.00109792s] 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.377 secs o Memory usage 4MB (peak: 4MB) o MySQL Usage Cell[9/0.009s] Row[10/0.012s] Rows[15/0.022s] Column[1/0.001s] Update[14/0.039s] Insert[1/0.01s] Delete[1/0.006s] o RRDTool Usage