- observium - lists.observium.org

Re: [Observium] MariaDB upgrade
by Scott Driemeier-Showers 30 Sep '20

30 Sep '20

We upgraded from MariaDB 5.5.65 to 10.3.23-1 on CentOS 7.8 at the end of July following the steps given here: https://www.liquidweb.com/kb/how-to-upgrade-mariadb-5-5-to-mariadb-10-0-on-…

1 0

MariaDB upgrade
by Edvinas Kairys 30 Sep '20

30 Sep '20

Hello, Could someone provide a guide on Centos to upgrade MariaDB from 5.5 to 10.x ? Thanks

2 1

Observium deleting switch entries instead of alerting
by Pisano, Anthony D. 29 Sep '20

29 Sep '20

Hello, I ran into a weird situation today that I’m unsure of how to proceed with. Due to a power failure we lost power to 3 of 4 switches in a Cisco 9300 Stack. At 10:57am yesterday in the event log of this switch I can see the OperStatus of the Stack Ports go down. I have an alert configured against the status of “Switch Stack Failure” does not equal OK. However this alert did not go off at the time of the outage, it has for other switch stacks though. Then at 5am this morning the logs of the device indicate it went through and essentially removed switches 2-4 of this stack. We are currently running 20.7.10549. I know we need to update, but our linux team has not gotten around to it. Is there anyway to look into this? Anthony Pisano | Network Design Engineer | IMSS anthony.pisano(a)caltech.edu<mailto:anthony.pisano@caltech.edu> | (626) 395-4255<tel:(626)%20395-4255> | Caltech | caltech.edu<http://caltech.edu/>

1 0

HTML Base tag appears wrong when using IPv6
by Pieter De Wit 29 Sep '20

29 Sep '20

Hi, Yes, this is “wrong” but I have an internal server which happens to have IPv6 and no DNS. If I access my Observium installation using the address, the generated HTML is as follow: <!DOCTYPE html> <html lang="en"> <head> <base href="http://[[2406:xxxx:xxxx:3300::202]]/"/> <meta http-equiv="content-type" content="text/html; charset=utf-8”/> The base setting has double brackets which breaks loading. (Yes, I can override this in the config :) ) Cheers, Pieter

2 1

Invoice for our recent purchase for Observium subscription
by Renuka Arya 25 Sep '20

25 Sep '20

Hi Team, Can you please provide us the invoice for our purchase on aug 1, 2020 ? We didn't seem to have received it. please see the attachment below. Thanks! Regards Renuka Arya

1 0

SNMP - IPSEC VPN under VRF
by Dale Chambers 25 Sep '20

25 Sep '20

Hi, I am wondering if you can help. We have several Cisco 4331 routers which has IPSEC VPNs running inside a VRF, for some reason Observium is not able produce SNMP IPSEC tunnels within the VRF. Is there something I am missing? Many Thanks Dale Chambers[cid:image001.png@01D69320.F5A731A0]<http://www.nsslglobal.com/> Network Engineer NSSLGlobal Ltd ON LAND I ONBOARD I ONLINE [ccnp] [ccna-security] [ccna-routing] 6 Wells Place, Gatton Park Business Centre, Redhill, Surrey, UK, RH1 3DR Telephone: +44 (0) 1737 648 920 email: dale.chambers(a)nsslglobal.com<mailto:dale.chambers@nsslglobal.com> Web: www.nsslglobal.com<http://www.nsslglobal.com/> Social: [cid:image005.jpg@01D69320.F5A731A0] <http://www.twitter.com/nsslglobal> [cid:image006.jpg@01D69320.F5A731A0] <https://www.linkedin.com/company/nssl> Please consider the environment before printing this email CONFIDENTIALITY AND PRIVACY POLICY This communication is private and the information contained in this email and any attachments may be privileged, commercially sensitive, confidential, proprietary to NSSLGlobal Limited or otherwise legally exempt from disclosure. If you are not the intended recipient or have been sent this in error, you are prohibited from using, copying, relying upon, or disseminating the information, and the sender disclaims any liability for such unauthorised use. Further, if you are not the intended recipient, please notify the sender immediately and delete all copies of this message. In accordance with our email policy, emails sent or received may be monitored. Thank you. We have recently updated our Privacy Policy, which can be accessed at https://www.nsslglobal.com/uploads/documents/NSSLGlobal_Privacy_Policy.pdf We will hold and manage personal data that you provide us with in accordance with this Privacy Policy.

2 2

Mikrotik Custom OID issue
by Joey Stanford 24 Sep '20

24 Sep '20

Hello All, I’ve run into a device specific issue with Mikrotik and am looking for some advice. I want to track a few MIB-defined variables like mtxrWlRtabStrength (signal strength, source https://mibs.observium.org/mib/MIKROTIK-MIB) and produce graphs. I added a custom OID for this but the snmpget command is failing. In theory, if I want to get data on OID .1.3.6.1.4.1.14988.1.1.1.2.1.3 I should be able to get it, but unfortunately snmpget in the poller errors out. It appears that for Mikrotik we need to attach the rest of the, and this is the problem, device-specific address to the OID. e.g. 1.3.6.1.4.1.14988.1.1.1.2.1.3 (and .0,.1) does not work but .1.3.6.1.4.1.14988.1.1.1.2.1.3.100.209.84.175.14.243.1 does. It will only get the data from that one device, not from any others. The easy way for me test this is to run the poller command: snmpget -t '10' -v1 -c xxx -Pud -OUQnv 'udp':'radio-leehill.nv0n.qth':'161’ 1.3.6.1.4.1.14988.1.1.1.2.1.3 Anyway, I’m wondering if there is a way in observium that I haven’t discovered yet that will get me graphs on various wireless activities from the registration table. The use case is to monitor things like signal strength and signal to noise to know when a wireless link is below a threshold. High winds up here tend to bend and destroy dishes even with a stiff-arm attached. Thanks, Joey ps. Adam, the Mikrotik MIB was updated on 15 Sept if you haven’t seen it: https://box.mikrotik.com/f/a41daf63d0c14347a088/?dl=1 <https://box.mikrotik.com/f/a41daf63d0c14347a088/?dl=1>

2 3

Re: [Observium] [EXTERNAL] Re: Error Adding Host
by Steven Rixon 23 Sep '20

23 Sep '20

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 [cid:image002.png@01D69123.4C47B8E0] 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(a)stupalov.ru> On Behalf Of Mike Stupalov Sent: 22 September 2020 12:55 To: Steven Rixon <steven.rixon(a)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<http://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<https://svn.observium.org/svn/observium/branches/stable> Relative URL: ^/observium/branches/stable Repository Root: https://svn.observium.org/svn<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<http://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(a)oetiker.ch<mailto: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(a)schweikert.ch<mailto: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<http://lam-nvr-057.office.wtlholdings.com> SQL[SELECT EXISTS (SELECT 1 FROM `devices` WHERE `hostname` = 'lam-nvr-057.office.wtlholdings.com<http://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<http://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<http://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<http://lam-nvr-057.office.wtlholdings.com> | 83:15:47:42.36 | | lam-nvr-045.office.wtlholdings.com<http://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<http://lam-nvr-057.office.wtlholdings.com> | 83:15:47:42.70 | | lam-nvr-043.office.wtlholdings.com<http://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<http://lam-nvr-047.office.wtlholdings.com>). Could not reach lam-nvr-057.office.wtlholdings.com<http://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(a)stupalov.ru><mailto:mike@stupalov.ru> On Behalf Of Mike Stupalov Sent: 22 September 2020 10:15 To: Steven Rixon <steven.rixon(a)wtlholdings.com><mailto: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(a)observium.org><mailto:observium-bounces@observium.org> On Behalf Of Steven Rixon via observium Sent: 13 September 2020 18:15 To: Mike Stupalov <mike(a)observium.org><mailto:mike@observium.org>; Observium <observium(a)observium.org><mailto:observium@observium.org> Cc: Steven Rixon <steven.rixon(a)wtlholdings.com><mailto: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(a)stupalov.ru<mailto:mike@stupalov.ru>> On Behalf Of Mike Stupalov Sent: 11 September 2020 17:07 To: Observium <observium(a)observium.org<mailto:observium@observium.org>>; Steven Rixon via observium <observium(a)observium.org<mailto:observium@observium.org>> Cc: Steven Rixon <steven.rixon(a)wtlholdings.com<mailto: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<http://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<http://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<http://rix-ap-05.appletree.rixonnet.co.uk/> 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<http://rix-sw-02.home.rixonnet.co.uk/>). The results are the same from both the gui or cli Thanks Steven [cid:image001.jpg@01D6911D.ADAACF60]<https://www.wtlholdings.com/> Steven Rixon IT & Infrastructure Manager , WT Lamb Holdings Ltd T: 01403 785141<tel:01403785141> D: 01403 787425<tel:01403%20787425> M: 07793 463179<tel:07793%20463179> E: steven.rixon(a)wtlholdings.com<mailto:steven.rixon@wtlholdings.com> W: www.wtlholdings.com<https://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(a)observium.org<mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium<http://postman.memetic.org/cgi-bin/mailman/listinfo/observium> -- Mike Stupalov Observium Limited, http://observium.org<http://observium.org> -- Mike Stupalov Observium Limited, http://observium.org<http://observium.org> -- Mike Stupalov Observium Limited, http://observium.org<http://observium.org>

2 4

Web interface blank screen after last Update
by Marios.P＠crowe.com.cy 23 Sep '20

23 Sep '20

Hi, We have updated our Observium platform to the latest version CE 19.8 and we are facing the following issue. After finishing the upgrade using the instructions on the website we were able to access the web interface just once. When we logged in the first time after the upgrade we received a message that the php version also must be updated. After that we were unable to logon to the web interface (after login we see a blank screen) and we receive the following error in the apache error log: [Wed Sep 16 12:33:07 2020] [error] [client PHP Fatal error: Call to undefined function password_hash() in /opt/observium/html/includes/authentication/mysql.inc.php on line 101, Is it possible to backup the configuration and update php version and use Observium installation again? If yes is there any guide how to perform the update? We have observium installed on a Debian 7 machine. Regards, Marios Palechoros Information Technology Senior/System Administrator Crowe Cyprus Limited 8 Stasinos Avenue, 1st Floor, Photiades Business Center, 1060 Nicosia, Cyprus P.O.Box 22545, 1522 Nicosia, Cyprus T +357 22 755656 D +357 22 473187 F +357 22 452055 marios.p(a)crowe.com.cy www.crowe.com.cy Facebook Linkedin Twitter Crowe Cyprus Limited is a member of Crowe Global, a Swiss verein. Each member firm of Crowe Global is a separate and independent legal entity. Crowe Cyprus Limited and its affiliates are not responsible or liable for any acts or omissions of Crowe Global or any other member of Crowe Global.

5 7

RELEASE: Observium Community Edition 20.9
by adama＠observium.com 22 Sep '20

22 Sep '20

Hi Guys, We've just released a new CE, version 20.9. The release covers 790 commits since the last release, and a very large number of changes! The new release can be installed using the upgrade instructions in our documentation: https://docs.observium.org/updating/#upgrade-to-latest-major-release Please make sure you meet these absolute minimum requirements beforehand: MySQL 5.6.5 / MariaDB 10.0 PHP 5.6.26 Though we would recommend a PHP version above 7.1 and rrdtool versions above 1.7. Thanks, Adam.

2 1