DEBUG!

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

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

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

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

CMD[date "+%:z"]

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

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

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

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

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0028s]
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.0562s]
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.0029s]
CMD EXITDELAY[10ms]
STDOUT[
Python 2.7.16
]

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.006s]
CMD EXITDELAY[10ms]
STDOUT[
NET-SNMP version: 5.7.3
]

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

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

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

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

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0146s]
STDOUT[
172.16.2.8 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 11.2/11.2/11.2
]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.03s]
STDOUT[
sysObjectID.0 = enterprises.50001
sysUpTime.0 = 90:8:39:29.56
]
SNMP STATUS[TRUE]

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

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

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

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

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

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

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

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

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

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0237s]
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.0116s]
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-046.office.wtlholdings.com':'161' sysContact.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0288s]
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.0162s]
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-046.office.wtlholdings.com':'161' sysLocation.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0285s]
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.0106s]
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-046.office.wtlholdings.com':'161' sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0187s]
STDOUT[
90:8:39:29.88
]
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.0129s]
STDOUT[
228:8:51:34.45
]
SNMP STATUS[TRUE]
Timeticks converted 228:8:51:34.45 -> 19731094
Timeticks converted 90:8:39:29.88 -> 7807169
The compared oid differs on devices:
+------------------------------------+----------------+
| Device                             | sysUpTime.0    |
+------------------------------------+----------------+
| lam-nvr-046.office.wtlholdings.com | 90:8:39:29.88  |
| lam-nvr-045.office.wtlholdings.com | 228:8:51:34.45 |
+------------------------------------+----------------+


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

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

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

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

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '36' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00011206s]
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.0274s]
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.0315s]
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.0287s]
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-046.office.wtlholdings.com':'161' sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0228s]
STDOUT[
90:8:39:30.02
]
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.0295s]
STDOUT[
166:6:08:26.35
]
SNMP STATUS[TRUE]
Timeticks converted 166:6:08:26.35 -> 14364506
Timeticks converted 90:8:39:30.02 -> 7807170
The compared oid differs on devices:
+------------------------------------+----------------+
| Device                             | sysUpTime.0    |
+------------------------------------+----------------+
| lam-nvr-046.office.wtlholdings.com | 90:8:39:30.02  |
| lam-nvr-043.office.wtlholdings.com | 166:6:08:26.35 |
+------------------------------------+----------------+


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

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

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

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

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '37' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00010610s]
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.0294s]
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.0336s]
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.0309s]
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-046.office.wtlholdings.com':'161' sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0312s]
STDOUT[
90:8:39:30.18
]
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.0322s]
STDOUT[
3:3:26:39.38
]
SNMP STATUS[TRUE]
Timeticks converted 3:3:26:39.38 -> 271599
Timeticks converted 90:8:39:30.18 -> 7807170

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

CMD EXITCODE[0]
CMD RUNTIME[0.023s]
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.00022817s]
Already got device with SNMP-read sysName () and other system Oids (lam-nvr-047.office.wtlholdings.com).
Could not reach lam-nvr-046.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.