DEBUG!

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

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

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

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

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0149s]
STDOUT[
+01:00
]

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

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

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

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0058s]
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.128s]
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.0025s]
CMD EXITDELAY[10ms]
STDOUT[
Python 2.7.16
]

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

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

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

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

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

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

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

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0246s]
STDOUT[
172.16.4.20 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 17.3/17.3/17.3
]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.026s]
STDOUT[
sysObjectID.0 = enterprises.50001
sysUpTime.0 = 177:2:52:39.42
]
SNMP STATUS[TRUE]

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

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

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

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

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

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

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

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

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0282s]
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.011s]
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-082.office.wtlholdings.com':'161' sysContact.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0291s]
CMD EXITDELAY[10ms]
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.0383s]
CMD EXITDELAY[10ms]
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-082.office.wtlholdings.com':'161' sysLocation.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0677s]
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.0359s]
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-082.office.wtlholdings.com':'161' sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0601s]
STDOUT[
177:2:52:39.89
]
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.0458s]
CMD EXITDELAY[10ms]
STDOUT[
228:8:58:16.60
]
SNMP STATUS[TRUE]
Timeticks converted 228:8:58:16.60 -> 19731496
Timeticks converted 177:2:52:39.89 -> 15303159
The compared oid differs on devices:
+------------------------------------+----------------+
| Device                             | sysUpTime.0    |
+------------------------------------+----------------+
| lam-nvr-082.office.wtlholdings.com | 177:2:52:39.89 |
| lam-nvr-045.office.wtlholdings.com | 228:8:58:16.60 |
+------------------------------------+----------------+


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

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

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

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

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '36' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00004506s]
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.0608s]
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.045s]
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.0448s]
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-082.office.wtlholdings.com':'161' sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0307s]
STDOUT[
177:2:52:40.13
]
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.0329s]
STDOUT[
166:6:15:08.57
]
SNMP STATUS[TRUE]
Timeticks converted 166:6:15:08.57 -> 14364908
Timeticks converted 177:2:52:40.13 -> 15303160

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

CMD EXITCODE[0]
CMD RUNTIME[0.0268s]
STDOUT[
2
]
SNMP STATUS[TRUE]
Store in cache OID: IF-MIB::ifNumber.0

SQL[SELECT `ifIndex`, `ifPhysAddress` FROM `ports` WHERE `device_id` = '36' AND `deleted` = '0']
SQL RUNTIME[0.00035810s]
Already got device with SNMP-read sysName () and other system Oids (lam-nvr-043.office.wtlholdings.com).
Could not reach lam-nvr-082.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.