DEBUG! CMD[/usr/bin/svn info /opt/observium] CMD EXITCODE[0] CMD RUNTIME[0.0164s] CMD EXITDELAY[10ms] STDOUT[ Path: . Working Copy Root Path: /opt/observium URL: https://svn.observium.org/svn/observium/trunk Relative URL: ^/observium/trunk Repository Root: https://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 10732 Node Kind: directory Schedule: normal Last Changed Author: mike Last Changed Rev: 10731 Last Changed Date: 2020-09-22 14:56:16 +0100 (Tue, 22 Sep 2020) ] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00009704s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00027299s] SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'] SQL RUNTIME[0.00012493s] DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO CMD[date "+%:z"] CMD EXITCODE[0] CMD RUNTIME[0.0013s] STDOUT[ +01:00 ] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00026202s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00009489s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.00008011s] CMD[/bin/hostname -f] CMD EXITCODE[0] CMD RUNTIME[0.0014s] CMD EXITDELAY[10ms] STDOUT[ lam-obs-01.office.wtlholdings.com ] Observium 20.9.10731 Add Device(s) CMD[/opt/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.0569s] CMD EXITDELAY[10ms] STDOUT[ Linux|4.19.0-10-amd64|amd64|Debian|10|vmware| ] CMD[/usr/bin/env python --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0041s] STDOUT[ Python 2.7.16 ] SQL[SELECT version();] SQL RUNTIME[0.00024080s] CMD[/usr/bin/snmpget --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0051s] CMD EXITDELAY[10ms] STDOUT[ NET-SNMP version: 5.7.3 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0128s] STDOUT[ RRDtool 1.7.1 Copyright by Tobias Oetiker ] CMD[/usr/bin/fping -v 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0025s] 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.03s] STDOUT[ Apache/2.4.38 ] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00018597s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00103617s] ##### Software versions ##### o OS Linux 4.19.0-10-amd64 [amd64] (Debian 10) o Apache 2.4.38 o PHP 7.3.19-1~deb10u1 (OPcache: DISABLED) o Python 2.7.16 o MariaDB 10.3.23-MariaDB-0+deb10u1 (extension: mysqli 5.0.12-dev) o SNMP NET-SNMP 5.7.3 o RRDtool 1.7.1 o Fping 4.2 (IPv4 and IPv6) ##### Memory Limit ##### o PHP Unlimited ##### MariaDB mode ##### o MariaDB NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ##### Charset info ##### o PHP UTF-8 o MariaDB utf8 ##### Timezones info ##### o Date Tuesday, 22-Sep-20 20:39:12 BST o PHP +01:00 o MariaDB +01:00 Try to add lam-nvr-057.office.wtlholdings.com: SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-057.office.wtlholdings.com')] SQL RUNTIME[0.00038099s] CMD[/usr/bin/fping -t 500 -c 1 -q 172.16.5.201 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0394s] STDOUT[ 172.16.5.201 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 35.9/35.9/35.9 ] SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-057.office.wtlholdings.com')] SQL RUNTIME[0.00010586s] CMD[/usr/bin/fping -t 500 -c 1 -q 172.16.5.201 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0386s] STDOUT[ 172.16.5.201 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 36.9/36.9/36.9 ] Trying v2c community *** [0] ... CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysObjectID.0 sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0526s] CMD EXITDELAY[10ms] STDOUT[ sysObjectID.0 = enterprises.50001 sysUpTime.0 = 84:2:02:34.76 ] SNMP STATUS[TRUE] SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-057.office.wtlholdings.com')] SQL RUNTIME[0.00027919s] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[0.00013804s] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' snmpEngineID.0] CMD EXITCODE[0] CMD RUNTIME[0.3865s] STDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysName.0] CMD EXITCODE[0] CMD RUNTIME[0.0695s] CMD EXITDELAY[10ms] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.055s] STDOUT[ Hikvision company products ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysObjectID.0] CMD EXITCODE[0] CMD RUNTIME[0.3841s] STDOUT[ .1.3.6.1.4.1.50001 ] SNMP STATUS[TRUE] +-------------+----------------------------+ | OID | | +-------------+----------------------------+ | sysDescr | Hikvision company products | | sysObjectID | .1.3.6.1.4.1.50001 | +-------------+----------------------------+ o Detect OS matched (hikvision-dvr: Hikvision DVR): +-------------+--------------------+--------------------+ | OID | Matched definition | | +-------------+--------------------+--------------------+ | sysObjectID | .1.3.6.1.4.1.50001 | .1.3.6.1.4.1.50001 | +-------------+--------------------+--------------------+ SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `sysName` = '' AND `os` = 'hikvision-dvr'] SQL RUNTIME[0.00122499s] SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '18' AND `entPhysicalSerialNum` != '' ORDER BY `entPhysicalClass` LIMIT 1] SQL RUNTIME[0.00010014s] SQL[SELECT * FROM `devices` WHERE `device_id` = '18'] SQL RUNTIME[0.00051308s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '18'] SQL RUNTIME[0.00007701s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '18' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00006914s] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '18' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[0.00005507s] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.0517s] STDOUT[ Hikvision company products ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-045.office.wtlholdings.com':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.0167s] STDOUT[ Hikvision company products ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysContact.0] CMD EXITCODE[0] CMD RUNTIME[0.3813s] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] Store in cache OID: SNMPv2-MIB::sysContact.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-045.office.wtlholdings.com':'161' sysContact.0] CMD EXITCODE[0] CMD RUNTIME[0.0157s] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] Store in cache OID: SNMPv2-MIB::sysContact.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysLocation.0] CMD EXITCODE[0] CMD RUNTIME[0.0461s] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] Store in cache OID: SNMPv2-MIB::sysLocation.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-045.office.wtlholdings.com':'161' sysLocation.0] CMD EXITCODE[0] CMD RUNTIME[0.0168s] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] Store in cache OID: SNMPv2-MIB::sysLocation.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.3786s] STDOUT[ 84:2:02:36.32 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-045.office.wtlholdings.com':'161' sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0171s] STDOUT[ 228:8:55:41.06 ] SNMP STATUS[TRUE] Timeticks converted 228:8:55:41.06 -> 19731341 Timeticks converted 84:2:02:36.32 -> 7264956 The compared oid differs on devices: +------------------------------------+----------------+ | Device | sysUpTime.0 | +------------------------------------+----------------+ | lam-nvr-057.office.wtlholdings.com | 84:2:02:36.32 | | lam-nvr-045.office.wtlholdings.com | 228:8:55:41.06 | +------------------------------------+----------------+ SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '36' AND `entPhysicalSerialNum` != '' ORDER BY `entPhysicalClass` LIMIT 1] SQL RUNTIME[0.00018501s] SQL[SELECT * FROM `devices` WHERE `device_id` = '36'] SQL RUNTIME[0.00040507s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '36'] SQL RUNTIME[0.00011802s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '36' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00004697s] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '36' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[0.00004005s] Get cached OID: SNMPv2-MIB::sysDescr.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-043.office.wtlholdings.com':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.027s] STDOUT[ Hikvision company products ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 Get cached OID: SNMPv2-MIB::sysContact.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-043.office.wtlholdings.com':'161' sysContact.0] CMD EXITCODE[0] CMD RUNTIME[0.0308s] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] Store in cache OID: SNMPv2-MIB::sysContact.0 Get cached OID: SNMPv2-MIB::sysLocation.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-043.office.wtlholdings.com':'161' sysLocation.0] CMD EXITCODE[0] CMD RUNTIME[0.0278s] CMD EXITDELAY[10ms] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] Store in cache OID: SNMPv2-MIB::sysLocation.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0538s] STDOUT[ 84:2:02:36.85 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-043.office.wtlholdings.com':'161' sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0326s] STDOUT[ 166:6:12:32.51 ] SNMP STATUS[TRUE] Timeticks converted 166:6:12:32.51 -> 14364752 Timeticks converted 84:2:02:36.85 -> 7264956 The compared oid differs on devices: +------------------------------------+----------------+ | Device | sysUpTime.0 | +------------------------------------+----------------+ | lam-nvr-057.office.wtlholdings.com | 84:2:02:36.85 | | lam-nvr-043.office.wtlholdings.com | 166:6:12:32.51 | +------------------------------------+----------------+ SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '37' AND `entPhysicalSerialNum` != '' ORDER BY `entPhysicalClass` LIMIT 1] SQL RUNTIME[0.00015402s] SQL[SELECT * FROM `devices` WHERE `device_id` = '37'] SQL RUNTIME[0.00053310s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '37'] SQL RUNTIME[0.00008321s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '37' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00007081s] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '37' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[0.00006795s] Get cached OID: SNMPv2-MIB::sysDescr.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-047.office.wtlholdings.com':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.0301s] STDOUT[ Hikvision company products ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 Get cached OID: SNMPv2-MIB::sysContact.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-047.office.wtlholdings.com':'161' sysContact.0] CMD EXITCODE[0] CMD RUNTIME[0.0335s] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] Store in cache OID: SNMPv2-MIB::sysContact.0 Get cached OID: SNMPv2-MIB::sysLocation.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-047.office.wtlholdings.com':'161' sysLocation.0] CMD EXITCODE[0] CMD RUNTIME[0.0278s] STDOUT[ ] SNMP STATUS[FALSE] SNMP ERROR[#1 - Empty response] Store in cache OID: SNMPv2-MIB::sysLocation.0 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0471s] STDOUT[ 84:2:02:37.04 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-047.office.wtlholdings.com':'161' sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.034s] STDOUT[ 3:3:30:46.41 ] SNMP STATUS[TRUE] Timeticks converted 3:3:30:46.41 -> 271846 Timeticks converted 84:2:02:37.04 -> 7264957 CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' ifNumber.0] CMD EXITCODE[0] CMD RUNTIME[0.0522s] STDOUT[ 2 ] SNMP STATUS[TRUE] Store in cache OID: IF-MIB::ifNumber.0 SQL[SELECT `ifIndex`, `ifPhysAddress` FROM `ports` WHERE `device_id` = '37' AND `deleted` = '0'] SQL RUNTIME[0.00073600s] Already got device with SNMP-read sysName () and other system Oids (lam-nvr-047.office.wtlholdings.com). Could not reach lam-nvr-057.office.wtlholdings.com with given SNMP parameters using . Devices failed: 1. USAGE: add_device.php [community] [v1|v2c] [port] [udp|udp6|tcp|tcp6] add_device.php [any|nanp|anp|ap] [v3] [user] [password] [enckey] [md5|sha] [aes|des] [port] [udp|udp6|tcp|tcp6] add_device.php EXAMPLE: SNMPv1/2c: add_device.php [community] [v1|v2c] [port] [udp|udp6|tcp|tcp6] [context] SNMPv3 : Defaults : add_device.php any v3 [user] [port] [udp|udp6|tcp|tcp6] [context] No Auth, No Priv : add_device.php nanp v3 [user] [port] [udp|udp6|tcp|tcp6] [context] Auth, No Priv : add_device.php anp v3 [md5|sha] [port] [udp|udp6|tcp|tcp6] [context] Auth, Priv : add_device.php ap v3 [md5|sha] [aes|des] [port] [udp|udp6|tcp|tcp6] [context] FILE : add_device.php ADD FROM FILE: To add multiple devices, create a file in which each line contains one device with or without options. Format for device options, the same as specified in USAGE. OPTIONS: -p Skip icmp echo checks, device added only by SNMP checks DEBUGGING OPTIONS: -d Enable debugging output. -dd More verbose debugging output. -t Do not add device(s), only test auth options.