All now working thanks Mike

 

From: Mike Stupalov <mike@stupalov.ru> On Behalf Of Mike Stupalov
Sent: 23 September 2020 16:21
To: Observium <observium@observium.org>; Steven Rixon via observium <observium@observium.org>
Cc: Steven Rixon <steven.rixon@wtlholdings.com>
Subject: Re: [Observium] [EXTERNAL] Re: Error Adding Host

 

This Message originated outside your organization.


It seems as really same:

+---------------------------------+------------------------------------------+-----------------------------------------+

| Oid | lam-nvr-044.office.wtlholdings.com (new) | lam-nvr-040.office.wtlholdings.com (46) |

+---------------------------------+------------------------------------------+-----------------------------------------+

| SNMPv2-MIB::sysUpTime           | 12:19:45:12.39                           | 12:19:45:12.45                          |

| HIKVISION-MIB::hikEntityIndex.0 | 1620160810CCRR636100359WCVU              | 1620160810CCRR636100359WCVU             |

+---------------------------------+------------------------------------------+-----------------------------------------+

Uptime is complete same and same serials ;)
Check your devices.. and dns entries.

Steven Rixon via observium wrote on 23.09.2020 17:29:

Hi Mike

 

Thanks for all the effort on getting this working

 

I have how added all device expect lam-nvr-044

 

 

DEBUG!

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0169s]

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: 10735

Node Kind: directory

Schedule: normal

Last Changed Author: mike

Last Changed Rev: 10735

Last Changed Date: 2020-09-23 15:09:53 +0100 (Wed, 23 Sep 2020)

 

]

 

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSche                                                                                                                                                             ma';]

SQL RUNTIME[0.00026584s]

 

SQL[SELECT @@SESSION.sql_mode;]

SQL RUNTIME[0.00013614s]

 

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']

SQL RUNTIME[0.00007796s]

DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO

 

CMD[date "+%:z"]

 

CMD EXITCODE[0]

CMD RUNTIME[0.001s]

CMD EXITDELAY[10ms]

STDOUT[

+01:00

]

 

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]

SQL RUNTIME[0.00028515s]

 

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'curren                                                                                                                                                             t_rev';]

SQL RUNTIME[0.00050116s]

 

SQL[SELECT * FROM `config`]

SQL RUNTIME[0.00010419s]

 

CMD[/bin/hostname -f]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0019s]

STDOUT[

lam-obs-01.office.wtlholdings.com

]

Observium 20.9.10735

Add Device(s)

 

 

CMD[/opt/observium/scripts/distro]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0564s]

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.0043s]

CMD EXITDELAY[10ms]

STDOUT[

Python 2.7.16

]

 

SQL[SELECT version();]

SQL RUNTIME[0.00018787s]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0048s]

STDOUT[

NET-SNMP version: 5.7.3

]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0102s]

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]

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.0229s]

STDOUT[

Apache/2.4.38

]

 

SQL[SELECT @@SESSION.sql_mode;]

SQL RUNTIME[0.00019693s]

 

SQL[SHOW VARIABLES LIKE 'character_set_connection']

SQL RUNTIME[0.00182199s]

 

#####  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                 Wednesday, 23-Sep-20 15:22:44 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.offic                                                                                                      e.wtlholdings.com')]

SQL RUNTIME[0.00045300s]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.1278s]

STDOUT[

172.16.3.10 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 124/124/124

]

 

SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-044.offic                                                                                                                                                             e.wtlholdings.com')]

SQL RUNTIME[0.00016785s]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0505s]

STDOUT[

172.16.3.10 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 46.4/46.4/46.4

]

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':'16                                                                                                                                                             1' sysObjectID.0 sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.1431s]

STDOUT[

sysObjectID.0 = enterprises.50001

sysUpTime.0 = 12:19:45:10.19

]

SNMP STATUS[TRUE]

 

SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-044.offic                    e.wtlholdings.com')]

SQL RUNTIME[0.00019193s]

 

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '' AND `use` = 'mib' AN                                                                                                                                                             D `disabled` = '1']

SQL RUNTIME[0.00007820s]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.194s]

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':'16                                                                                                                                                             1' sysName.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0448s]

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':'16                                                                                                                                                             1' sysDescr.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.2239s]

STDOUT[

Hikvision company products

]

SNMP STATUS[TRUE]

 

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUvn -m SNMPv2-MIB -M /opt/observium/mib                                                                                                                                                             s/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-044.office.wtlholdings.com':'1                                                                                                                                                             61' sysObjectID.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.2137s]

CMD EXITDELAY[10ms]

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.00063515s]

 

SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '18' AND `entPhysicalSerialN                                                                                                                                                             um` != '' ORDER BY `entPhysicalClass` LIMIT 1]

SQL RUNTIME[0.00006604s]

 

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

SQL RUNTIME[0.00023699s]

 

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

SQL RUNTIME[0.00027800s]

 

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' A                                                                                                                                                             ND `entity_id` = '18' AND `attrib_type` = 'sysORID']

SQL RUNTIME[0.00003386s]

 

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

SQL RUNTIME[0.00002408s]

 

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':'16                                                                                                                                                             1' sysDescr.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0512s]

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':'16                                                                                                                                                             1' sysDescr.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0161s]

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':'16                                                                                                                                                             1' sysContact.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0419s]

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':'16                                                                                                                                                             1' sysContact.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0156s]

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':'16                                                                                                                                                             1' sysLocation.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0904s]

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':'16                                                                                                                                                             1' sysLocation.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0161s]

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':'16                                                                                                                                                             1' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0383s]

STDOUT[

12:19:45:11.30

]

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':'16                                                                                                                                                             1' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0153s]

STDOUT[

229:3:39:12.42

]

SNMP STATUS[TRUE]

Timeticks converted 229:3:39:12.42 -> 19798752

Timeticks converted 12:19:45:11.30 -> 1107911

The compared oids on devices:

+-------------------------+------------------------------------------+----------                                                                                                                                                             -------------------------------+

| Oid | lam-nvr-044.office.wtlholdings.com (new) | lam-nvr-0                                                                                                45.office.wtlholdings.com (18) |

+-------------------------+------------------------------------------+----------                                                                                                                                                             -------------------------------+

| SNMPv2-MIB::sysObjectID | .1.3.6.1.4.1.50001                       | 1.3.6.1.                                                                                          4.1.50001                      |

| SNMPv2-MIB::sysDescr    | Hikvision company products               | Hikvision                                                                                                                                                              company products              |

| SNMPv2-MIB::sysUpTime   | 12:19:45:11.30                           | 229:3:39:                                                                                                                                                             12.42                          |

+-------------------------+------------------------------------------+----------                                                                                                                                                             -------------------------------+

 

 

SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '36' AND `entPhysicalSerialN                                                                                                                                                             um` != '' ORDER BY `entPhysicalClass` LIMIT 1]

SQL RUNTIME[0.00018597s]

 

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

SQL RUNTIME[0.00062490s]

 

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

SQL RUNTIME[0.00045800s]

 

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' A                                                                                                                                                             ND `entity_id` = '36' AND `attrib_type` = 'sysORID']

SQL RUNTIME[0.00008392s]

 

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

SQL RUNTIME[0.00006890s]

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':'16                                                                                                                                                             1' sysDescr.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0264s]

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':'16                                                                                                                                                             1' sysContact.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0306s]

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':'16                                                                                                                                                             1' sysLocation.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0286s]

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':'16                                                                                                                                                             1' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0436s]

CMD EXITDELAY[10ms]

STDOUT[

12:19:45:11.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-043.office.wtlholdings.com':'16                                                                                                                                                             1' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0364s]

STDOUT[

167:0:56:03.39

]

SNMP STATUS[TRUE]

Timeticks converted 167:0:56:03.39 -> 14432163

Timeticks converted 12:19:45:11.46 -> 1107911

The compared oids on devices:

+-------------------------+------------------------------------------+----------                                                                                                                                                             -------------------------------+

| Oid | lam-nvr-044.office.wtlholdings.com (new) | lam-nvr-0                                                                                                                                                             43.office.wtlholdings.com (36) |

+-------------------------+------------------------------------------+----------                                                                                                                                                             -------------------------------+

| SNMPv2-MIB::sysObjectID | .1.3.6.1.4.1.50001                       | 1.3.6.1.                        4.1.50001                      |

| SNMPv2-MIB::sysDescr    | Hikvision company products               | Hikvision                                                                                                                                                              company products              |

| SNMPv2-MIB::sysUpTime   | 12:19:45:11.46                           | 167:0:56:                                                                                                                                                             03.39                          |

+-------------------------+------------------------------------------+----------                                                                                                                                                             -------------------------------+

 

 

SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '37' AND `entPhysicalSerialN                                                                                                                                                             um` != '' ORDER BY `entPhysicalClass` LIMIT 1]

SQL RUNTIME[0.00015211s]

 

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

SQL RUNTIME[0.00050092s]

 

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

SQL RUNTIME[0.00036907s]

 

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' A                                                                                                                                                             ND `entity_id` = '37' AND `attrib_type` = 'sysORID']

SQL RUNTIME[0.00005102s]

 

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

SQL RUNTIME[0.00004196s]

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':'16                                                                                                                                                             1' sysDescr.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0296s]

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':'16                                                                                                                                                             1' sysContact.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0275s]

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':'16                                                                                                                                                             1' sysLocation.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0282s]

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':'16                                                                                                                                                             1' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.1251s]

STDOUT[

12:19:45:11.65

]

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':'16                                                                                                                                                             1' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0323s]

STDOUT[

3:22:14:17.25

]

SNMP STATUS[TRUE]

Timeticks converted 3:22:14:17.25 -> 339257

Timeticks converted 12:19:45:11.65 -> 1107911

 

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' i                                                                                                                                                             fNumber.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.1127s]

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.00067592s]

 

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m HIKVISION-MIB -M /opt/observium/m                                                                                                                                                             ibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/hikvision 'udp':'lam-nv                                                                                                                                                             r-044.office.wtlholdings.com':'161' hikEntityIndex.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0546s]

STDOUT[

"1620160810CCRR636100359WCVU"

]

SNMP STATUS[TRUE]

Store in cache OID: HIKVISION-MIB::hikEntityIndex.0

 

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m HIKVISION-MIB -M /opt/observium/m                                                                                                                                                             ibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/hikvision 'udp':'lam-nv                                                                                                                                                             r-047.office.wtlholdings.com':'161' hikEntityIndex.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0329s]

STDOUT[

"0420160417AARR593220980WCVU"

]

SNMP STATUS[TRUE]

Store in cache OID: HIKVISION-MIB::hikEntityIndex.0

The compared oids on devices:

+---------------------------------+------------------------------------------+--                                                                                                                                                             ---------------------------------------+

| Oid | lam-nvr-044.office.wtlholdings.com (new) | l                                                                                                                                                             am-nvr-047.office.wtlholdings.com (37) |

+---------------------------------+------------------------------------------+--                                                                                                                                                             ---------------------------------------+

| SNMPv2-MIB::sysObjectID         | .1.3.6.1.4.1.50001                       | .                                                                                                                                                             1.3.6.1.4.1.50001                      |

| SNMPv2-MIB::sysDescr            | Hikvision company products               | H                                                                                                                                                             ikvision company products              |

| SNMPv2-MIB::sysUpTime           | 12:19:45:11.65                           | 3                                                                                                                                                             :22:14:17.25                           |

| HIKVISION-MIB::hikEntityIndex.0 | 1620160810CCRR636100359WCVU              | 0                                                                                                                                                             420160417AARR593220980WCVU             |

+---------------------------------+------------------------------------------+--                                                                                                                                                             ---------------------------------------+

 

 

SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '46' AND `entPhysicalSerialN                                                                                                                                                             um` != '' ORDER BY `entPhysicalClass` LIMIT 1]

SQL RUNTIME[0.00024414s]

 

SQL[SELECT * FROM `devices` WHERE `device_id` = '46']

SQL RUNTIME[0.00063705s]

 

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '46']

SQL RUNTIME[0.00036502s]

 

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' A                                                                                                                                                             ND `entity_id` = '46' AND `attrib_type` = 'sysORID']

SQL RUNTIME[0.00009704s]

 

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

SQL RUNTIME[0.00008798s]

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-040.office.wtlholdings.com':'16                                                                                                                                                             1' sysDescr.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.1693s]

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-040.office.wtlholdings.com':'16                                                                                                                                                             1' sysContact.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.1079s]

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-040.office.wtlholdings.com':'16                                                                                                                                                             1' sysLocation.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0595s]

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':'16                                                                                                                                                             1' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0672s]

STDOUT[

12:19:45:12.39

]

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-040.office.wtlholdings.com':'16                                                                                                                                                             1' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.096s]

STDOUT[

12:19:45:12.45

]

SNMP STATUS[TRUE]

Timeticks converted 12:19:45:12.45 -> 1107912

Timeticks converted 12:19:45:12.39 -> 1107912

Get cached OID: IF-MIB::ifNumber.0

 

SQL[SELECT `ifIndex`, `ifPhysAddress` FROM `ports` WHERE `device_id` = '46' AND                                                                                                                                                              `deleted` = '0']

SQL RUNTIME[0.00061703s]

Get cached OID: HIKVISION-MIB::hikEntityIndex.0

 

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m HIKVISION-MIB -M /opt/observium/m                                                                                                                                                             ibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/hikvision 'udp':'lam-nv                                                                                                                                                             r-040.office.wtlholdings.com':'161' hikEntityIndex.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0982s]

STDOUT[

"1620160810CCRR636100359WCVU"

]

SNMP STATUS[TRUE]

Store in cache OID: HIKVISION-MIB::hikEntityIndex.0

The compared oids on devices:

+---------------------------------+------------------------------------------+-----------------------------------------+

| Oid | lam-nvr-044.office.wtlholdings.com (new) | lam-nvr-040.office.wtlholdings.com (46) |

+---------------------------------+------------------------------------------+-----------------------------------------+

| SNMPv2-MIB::sysObjectID         | .1.3.6.1.4.1.50001                       | .1.3.6.1.4.1.50001                      |

| SNMPv2-MIB::sysDescr            | Hikvision company products               | Hikvision company products              |

| SNMPv2-MIB::sysUpTime           | 12:19:45:12.39                           | 12:19:45:12.45                          |

| HIKVISION-MIB::hikEntityIndex.0 | 1620160810CCRR636100359WCVU              | 1620160810CCRR636100359WCVU             |

+---------------------------------+------------------------------------------+-----------------------------------------+

 

Already got device with SNMP-read sysName () and other system Oids (lam-nvr-040.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.

 

From: Mike Stupalov <mike@stupalov.ru> On Behalf Of Mike Stupalov
Sent: 23 September 2020 15:11
To: Observium <observium@observium.org>; Steven Rixon via observium <observium@observium.org>
Cc: Steven Rixon <steven.rixon@wtlholdings.com>
Subject: Re: [Observium] [EXTERNAL] Re: Error Adding Host

 

This Message originated outside your organization.


Try again with latest revision (r10735).
Now correctly fixed. :)

Steven Rixon via observium wrote on 22.09.2020 22:59:


Hi Mike

 

I have changed to rolling as requested and updated and now showing version 20.9.10731 (22nd September 2020) hopefully this is what you are expecting?

 

I am still unable to add the devices however

 

 

I have attached the snmp walks for all devices that I still cant add and all the debug logs for adding each

 

Thanks

 

Steven

 

P.S sorry just keep hitting reply

 

From: Mike Stupalov <mike@stupalov.ru> On Behalf Of Mike Stupalov
Sent: 22 September 2020 12:55
To: Steven Rixon
<steven.rixon@wtlholdings.com>
Subject: Re: [Observium] [EXTERNAL] Re: Error Adding Host

 

This Message originated outside your organization.


Updated os definition (based on your snmp dumps).

Adding your devices should work in latest rolling (as written previously).

P.S. Pls do not answer with private data to ML.

Steven Rixon wrote on 22.09.2020 12:32:



Hi Mike

 

Sorry did not see the request but here is the requested info

 

Thanks again

 

Steven

 

wrix@lam-obs-01 /o/observium> sudo ./add_device.php -d lam-nvr-057.office.wtlholdings.com lambs

DEBUG!

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0172s]

CMD EXITDELAY[10ms]

STDOUT[

Path: .

Working Copy Root Path: /opt/observium

URL: https://svn.observium.org/svn/observium/branches/stable

Relative URL: ^/observium/branches/stable

Repository Root: https://svn.observium.org/svn

Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8

Revision: 10679

Node Kind: directory

Schedule: normal

Last Changed Author: adama

Last Changed Rev: 10645

Last Changed Date: 2020-08-25 18:32:18 +0100 (Tue, 25 Aug 2020)

 

]

 

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]

SQL RUNTIME[0.00013900s]

 

SQL[SELECT @@SESSION.sql_mode;]

SQL RUNTIME[0.00030303s]

 

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']

SQL RUNTIME[0.00014114s]

DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO

 

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

SQL RUNTIME[0.00007510s]

 

SQL[SELECT * FROM `config`]

SQL RUNTIME[0.00009894s]

 

CMD[/bin/hostname -f]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0011s]

STDOUT[

lam-obs-01.office.wtlholdings.com

]

Observium 20.8.10645

Add Device(s)

 

 

CMD[/opt/observium/scripts/distro]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0622s]

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.0015s]

STDOUT[

Python 2.7.16

]

 

SQL[SELECT version();]

SQL RUNTIME[0.00019097s]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0028s]

STDOUT[

NET-SNMP version: 5.7.3

]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0123s]

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]

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.0224s]

STDOUT[

Apache/2.4.38

]

 

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.00030017s]

 

SQL[SELECT @@SESSION.sql_mode;]

SQL RUNTIME[0.00013995s]

 

SQL[SHOW VARIABLES LIKE 'character_set_connection']

SQL RUNTIME[0.00207686s]

 

#####  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 10:24:19 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.00037289s]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0396s]

STDOUT[

172.16.5.201 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 36.3/36.3/36.3

]

 

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

SQL RUNTIME[0.00014997s]

 

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.0373s]

CMD EXITDELAY[10ms]

STDOUT[

172.16.5.201 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 35.4/35.4/35.4

]

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.054s]

STDOUT[

sysObjectID.0 = enterprises.50001

sysUpTime.0 = 83:15:47:40.98

]

SNMP STATUS[TRUE]

 

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

SQL RUNTIME[0.00017405s]

 

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

SQL RUNTIME[0.00135899s]

 

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.3829s]

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.0508s]

CMD EXITDELAY[10ms]

STDOUT[

 

]

SNMP STATUS[FALSE]

SNMP ERROR[#1 - Empty response]

 

SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `sysName` = '']

SQL RUNTIME[0.00161815s]

 

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

SQL RUNTIME[0.00059605s]

 

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

SQL RUNTIME[0.00053382s]

 

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

SQL RUNTIME[0.00011897s]

 

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

SQL RUNTIME[0.00039101s]

 

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

SQL RUNTIME[0.00009894s]

 

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.0525s]

STDOUT[

.1.3.6.1.4.1.50001

]

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

 

CMD EXITCODE[0]

CMD RUNTIME[0.3338s]

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.0166s]

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.3794s]

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.0169s]

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.0455s]

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.0144s]

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.0476s]

STDOUT[

83:15:47:42.36

]

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.0154s]

CMD EXITDELAY[10ms]

STDOUT[

227:22:40:47.88

]

SNMP STATUS[TRUE]

Timeticks converted 227:22:40:47.88 -> 19694447

Timeticks converted 83:15:47:42.36 -> 7228062

The compared oid differs on devices:

+------------------------------------+-----------------+

| Device                             | sysUpTime.0     |

+------------------------------------+-----------------+

| lam-nvr-057.office.wtlholdings.com | 83:15:47:42.36 |

| lam-nvr-045.office.wtlholdings.com | 227:22:40:47.88 |

+------------------------------------+-----------------+

 

 

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

SQL RUNTIME[0.00040388s]

 

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

SQL RUNTIME[0.00038910s]

 

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

SQL RUNTIME[0.00006700s]

 

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

SQL RUNTIME[0.00042105s]

 

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

SQL RUNTIME[0.00003791s]

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.0322s]

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.0332s]

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.0314s]

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.1826s]

STDOUT[

83:15:47:42.70

]

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.0335s]

STDOUT[

165:19:57:39.89

]

SNMP STATUS[TRUE]

Timeticks converted 165:19:57:39.89 -> 14327859

Timeticks converted 83:15:47:42.70 -> 7228062

The compared oid differs on devices:

+------------------------------------+-----------------+

| Device                             | sysUpTime.0     |

+------------------------------------+-----------------+

| lam-nvr-057.office.wtlholdings.com | 83:15:47:42.70 |

| lam-nvr-043.office.wtlholdings.com | 165:19:57:39.89 |

+------------------------------------+-----------------+

 

 

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

SQL RUNTIME[0.00078487s]

 

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

SQL RUNTIME[0.00021410s]

 

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

SQL RUNTIME[0.00009394s]

 

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

SQL RUNTIME[0.00041509s]

 

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

SQL RUNTIME[0.00009704s]

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.032s]

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.0334s]

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.0298s]

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.051s]

STDOUT[

83:15:47:42.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-047.office.wtlholdings.com':'161' sysUpTime.0]

 

CMD EXITCODE[0]

CMD RUNTIME[0.0323s]

STDOUT[

2:17:15:53.50

]

SNMP STATUS[TRUE]

Timeticks converted 2:17:15:53.50 -> 234953

Timeticks converted 83:15:47:42.89 -> 7228062

 

CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'lam-nvr-057.office.wtlholdings.com':'161' ipAdEntAddr]

 

CMD EXITCODE[0]

CMD RUNTIME[0.4271s]

STDOUT[

ipAdEntAddr = No Such Object available on this agent at this OID

]

SNMP STATUS[FALSE]

SNMP ERROR[#1000 - Failed response]

 

SQL[SELECT `ipv4_address` FROM `ipv4_addresses` WHERE `device_id` = '37']

SQL RUNTIME[0.00067997s]

 

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.0531s]

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.00073314s]

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 <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.

wrix@lam-obs-01 /o/observium>

 

From: Mike Stupalov <mike@stupalov.ru> On Behalf Of Mike Stupalov
Sent: 22 September 2020 10:15
To: Steven Rixon
<steven.rixon@wtlholdings.com>
Subject: Re: [Observium] [EXTERNAL] Re: Error Adding Host

 

This Message originated outside your organization.


Hi Steven,

 
maybe I missed your response, but I still not see requested debug :)

Try to add secondary hikvision device from console,
but with debug argument and send me output:

 ./add_device.php -d <hostname> <community>

Steven Rixon wrote on 22.09.2020 11:03:




Morning Mike

 

Sorry but I think you may have missed my response

 

Thanks

 

Steven

 

From: observium <observium-bounces@observium.org> On Behalf Of Steven Rixon via observium
Sent: 13 September 2020 18:15
To: Mike Stupalov
<mike@observium.org>; Observium <observium@observium.org>
Cc: Steven Rixon
<steven.rixon@wtlholdings.com>
Subject: Re: [Observium] [EXTERNAL] Re: Error Adding Host

 

This Message originated outside your organization.


Hi Mike

 

I am currently running version 20.8.10645 (25th August 2020) with a professional license

 

Adam was correct with respect of the second issue thanks

 

Steven

 

 

From: Mike Stupalov <mike@stupalov.ru> On Behalf Of Mike Stupalov
Sent: 11 September 2020 17:07
To: Observium <
observium@observium.org>; Steven Rixon via observium <observium@observium.org>
Cc: Steven Rixon <
steven.rixon@wtlholdings.com>
Subject: [EXTERNAL] Re: [Observium] Error Adding Host

 

This Message originated outside your organization.


Hi,

 I think you use old version of observium (or community edition).

In recent version(s) additional checks are used for such devices (ie list of interfaces and mac addresses).

Steven Rixon via observium wrote on 10.09.2020 22:08:

 

Hi

 

I am trying to add a new device but receiving the following error

 

Try to add lam-nvr-057.example.com

Trying v2c community *** [0] ...

Already got device with SNMP-read sysName () and other system Oids (lam-nvr-047.example.com).

 

The device is a hikvision nvr and I do have multiple Hikvision nvr’s already monitored

 

 

I have also experienced this on a completely different install of observium while adding a cisco AP but unlike on the first install this is the only AP being monitored

 

Adding SNMPv2c host rix-ap-05.example.com port 161

×

Trying v2c community *** [0] ...

Already got device with SNMP-read sysName (rix-sw-02), 'snmpEngineID' = 8000113D0304097399A298 and 'entPhysicalSerialNum' = CN7BK3Q04W (rix-sw-02.example.com).

 

The results are the same from both the gui or cli

 

Thanks

 

Steven

Steven Rixon

IT & Infrastructure Manager

WT Lamb Holdings Ltd

​T: 01403 785141

​D: 01403 787425

M: 07793 463179

E: steven.rixon@wtlholdings.com

W: www.wtlholdings.com

A: Nyewood Court, Brookers Road, Billingshurst
​West Sussex, RH14 9RZ, United Kingdom


​WT Lamb Holdings Limited is a limited company registered in England and Wales. Registered Number: 447302. 
​Registered office: Nyewood Court, Brookers Road, Billingshurst, West Sussex. RH14 9RZ.​

​Please note that WT Lamb Holdings Limited may monitor email traffic data and also the content of email for the purposes of security and staff training. This message contains confidential information and is intended only for the addressee. If you are not the addressee you should not disseminate, distribute or copy this e-mail. Please notify our IT Manager on 01403 785141 (UK) immediately or by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. WT Lamb Holdings Limited therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. Opinions expressed in this email are those of the sender & may not reflect the opinions or views of WT Lamb Holdings Limited.







_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

 

--
Mike Stupalov
Observium Limited,
http://observium.org

 

--
Mike Stupalov
Observium Limited,
http://observium.org

 

--
Mike Stupalov
Observium Limited,
http://observium.org





_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

 

--
Mike Stupalov
Observium Limited,
http://observium.org




_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

 

--
Mike Stupalov
Observium Limited, http://observium.org