DEBUG!

CMD[/usr/bin/svn info /opt/observium]

CMD EXITCODE[0]
CMD RUNTIME[0.0137s]
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.00018406s]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00022697s]

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']
SQL RUNTIME[0.00011706s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0012s]
CMD EXITDELAY[10ms]
STDOUT[
+01:00
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00028706s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00012803s]

SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00009799s]

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0025s]
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.0612s]
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.0045s]
STDOUT[
Python 2.7.16
]

SQL[SELECT version();]
SQL RUNTIME[0.00037599s]

CMD[/usr/bin/snmpget --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0038s]
STDOUT[
NET-SNMP version: 5.7.3
]

CMD[/usr/bin/rrdtool --version | head -n1]

CMD EXITCODE[0]
CMD RUNTIME[0.0093s]
STDOUT[
RRDtool 1.7.1  Copyright by Tobias Oetiker <tobi@oetiker.ch>
]

CMD[/usr/bin/fping -v 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0009s]
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.022s]
STDOUT[
Apache/2.4.38
]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00016284s]

SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00090313s]

#####  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:33:09 BST
 o PHP                  +01:00
 o MariaDB              +01:00

Try to add lam-nvr-044.office.wtlholdings.com:

SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-044.office.wtlholdings.com')]
SQL RUNTIME[0.00037694s]

CMD[/usr/bin/fping -t 500 -c 1 -q 172.16.3.10 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0293s]
STDOUT[
172.16.3.10 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 26.8/26.8/26.8
]

SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-044.office.wtlholdings.com')]
SQL RUNTIME[0.00016189s]

CMD[/usr/bin/fping -t 500 -c 1 -q 172.16.3.10 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0246s]
STDOUT[
172.16.3.10 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 21.0/21.0/21.0
]
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-044.office.wtlholdings.com':'161' sysObjectID.0 sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0438s]
STDOUT[
sysObjectID.0 = enterprises.50001
sysUpTime.0 = 12:0:55:34.05
]
SNMP STATUS[TRUE]

SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-044.office.wtlholdings.com')]
SQL RUNTIME[0.00019979s]

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00008702s]

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-044.office.wtlholdings.com':'161' snmpEngineID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0375s]
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-044.office.wtlholdings.com':'161' sysName.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0422s]
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-044.office.wtlholdings.com':'161' sysDescr.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0426s]
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-044.office.wtlholdings.com':'161' sysObjectID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0355s]
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.00072098s]

SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '18' AND `entPhysicalSerialNum` != '' ORDER BY `entPhysicalClass` LIMIT 1]
SQL RUNTIME[0.00005698s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '18']
SQL RUNTIME[0.00035501s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '18']
SQL RUNTIME[0.00003815s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '18' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00002813s]

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '18' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00002503s]

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-044.office.wtlholdings.com':'161' sysDescr.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0409s]
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.016s]
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-044.office.wtlholdings.com':'161' sysContact.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0367s]
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.0148s]
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-044.office.wtlholdings.com':'161' sysLocation.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0363s]
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.0148s]
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-044.office.wtlholdings.com':'161' sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0355s]
STDOUT[
12:0:55:34.46
]
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.0125s]
STDOUT[
228:8:49:35.95
]
SNMP STATUS[TRUE]
Timeticks converted 228:8:49:35.95 -> 19730975
Timeticks converted 12:0:55:34.46 -> 1040134
The compared oid differs on devices:
+------------------------------------+----------------+
| Device                             | sysUpTime.0    |
+------------------------------------+----------------+
| lam-nvr-044.office.wtlholdings.com | 12:0:55:34.46  |
| lam-nvr-045.office.wtlholdings.com | 228:8:49:35.95 |
+------------------------------------+----------------+


SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '36' AND `entPhysicalSerialNum` != '' ORDER BY `entPhysicalClass` LIMIT 1]
SQL RUNTIME[0.00019789s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '36']
SQL RUNTIME[0.00075293s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '36']
SQL RUNTIME[0.00008607s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '36' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00006795s]

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '36' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00006199s]
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.0269s]
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.0307s]
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.033s]
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-044.office.wtlholdings.com':'161' sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0375s]
STDOUT[
12:0:55:34.61
]
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.034s]
STDOUT[
166:6:06:27.87
]
SNMP STATUS[TRUE]
Timeticks converted 166:6:06:27.87 -> 14364387
Timeticks converted 12:0:55:34.61 -> 1040134
The compared oid differs on devices:
+------------------------------------+----------------+
| Device                             | sysUpTime.0    |
+------------------------------------+----------------+
| lam-nvr-044.office.wtlholdings.com | 12:0:55:34.61  |
| lam-nvr-043.office.wtlholdings.com | 166:6:06:27.87 |
+------------------------------------+----------------+


SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '37' AND `entPhysicalSerialNum` != '' ORDER BY `entPhysicalClass` LIMIT 1]
SQL RUNTIME[0.00019598s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '37']
SQL RUNTIME[0.00073195s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '37']
SQL RUNTIME[0.00017691s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '37' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00011897s]

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '37' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00012589s]
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.0319s]
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.0331s]
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.0316s]
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-044.office.wtlholdings.com':'161' sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0363s]
STDOUT[
12:0:55:34.80
]
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.0292s]
STDOUT[
3:3:24:40.52
]
SNMP STATUS[TRUE]
Timeticks converted 3:3:24:40.52 -> 271480
Timeticks converted 12:0:55:34.80 -> 1040134

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-044.office.wtlholdings.com':'161' ifNumber.0]

CMD EXITCODE[0]
CMD RUNTIME[0.04s]
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.00073886s]
Already got device with SNMP-read sysName () and other system Oids (lam-nvr-047.office.wtlholdings.com).
Could not reach lam-nvr-044.office.wtlholdings.com with given SNMP parameters using .
Devices failed: 1.

USAGE:
add_device.php <hostname> [community] [v1|v2c] [port] [udp|udp6|tcp|tcp6]
add_device.php <hostname> [any|nanp|anp|ap] [v3] [user] [password] [enckey] [md5|sha] [aes|des] [port] [udp|udp6|tcp|tcp6]
add_device.php <filename>

EXAMPLE:
SNMPv1/2c:                    add_device.php <hostname> [community] [v1|v2c] [port] [udp|udp6|tcp|tcp6] [context]
SNMPv3   :         Defaults : add_device.php <hostname> any v3 [user] [port] [udp|udp6|tcp|tcp6] [context]
           No Auth, No Priv : add_device.php <hostname> nanp v3 [user] [port] [udp|udp6|tcp|tcp6] [context]
              Auth, No Priv : add_device.php <hostname> anp v3 <user> <password> [md5|sha] [port] [udp|udp6|tcp|tcp6] [context]
              Auth,    Priv : add_device.php <hostname> ap v3 <user> <password> <enckey> [md5|sha] [aes|des] [port] [udp|udp6|tcp|tcp6] [context]
FILE     :                    add_device.php <filename>

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.