Finally problem solved! I tried adding a new workstation and Observium refused. I checked the snmp settings on the workstation and saw that my Observium server’s address was missing so I checked my domain policy. Sure enough, the setting for configuring snmp mysteriously lost my Observium server’s address. I added that back in and now my workstations are back up.
From: observium [mailto:observium-bounces@observium.org] On Behalf Of adama@observium.org
Sent: Wednesday, May 16, 2018 9:13 AM
To: 'Observium' <observium@observium.org>
Subject: Re: [Observium] Did the revision update and my workstations are down now
This is strange, since the query to select the device doesn’t seem to be returning anything :
SQL[_[0;33mSELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE '192.168.2.22' ORDER BY `device_id` ASC_[0m]_[0m
SQL RUNTIME[_[0;32m0.00019908s_[0m]_[0m
WARNING: 0 devices polled. Did you specify a device that does not exist?
Are you able to give me ssh access to the Observium server?
Thanks,
Adam.
From: observium <observium-bounces@observium.org> On Behalf Of Joe Brouillette
Sent: 16 May 2018 16:54
To: 'Observium' <observium@observium.org>
Subject: Re: [Observium] Did the revision update and my workstations are down now
Here’s the output from the poller:
DEBUG!
CMD[_[0;33m/usr/bin/svn info /opt/observium_[0m]
_[0m
CMD EXITCODE[_[0;32m0_[0m]
CMD RUNTIME[_[0;32m0.0083s_[0m]_[0m
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/branches/stable
Relative URL: ^/observium/branches/stable
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 9229
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 9221
Last Changed Date: 2018-05-10 12:53:37 -0700 (Thu, 10 May 2018)
]_[0m
SQL[_[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';_[0m]_[0m
SQL RUNTIME[_[0;32m0.00006795s_[0m]_[0m
SQL[_[0;33mSELECT @@SESSION.sql_mode;_[0m]_[0m
SQL RUNTIME[_[0;32m0.00008988s_[0m]_[0m
SQL[_[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';_[0m]_[0m
SQL RUNTIME[_[0;32m0.00003290s_[0m]_[0m
SQL[_[0;33mSELECT * FROM `config`_[0m]_[0m
SQL RUNTIME[_[0;32m0.00003695s_[0m]_[0m
CMD[_[0;33m/bin/hostname -f_[0m]
_[0m
CMD EXITCODE[_[0;32m0_[0m]
CMD RUNTIME[_[0;32m0.0007s_[0m]_[0m
CMD EXITDELAY[_[0;31m10ms_[0m]_[0m
STDOUT[
Observe.link.com
]_[0m
_[1;37m
___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|_[0;36m
Observium Professional 18.5.9221
_[0m
SQL[_[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';_[0m]_[0m
SQL RUNTIME[_[0;32m0.00038505s_[0m]_[0m
SQL[_[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';_[0m]_[0m
SQL RUNTIME[_[0;32m0.00010610s_[0m]_[0m
SQL[_[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';_[0m]_[0m
SQL RUNTIME[_[0;32m0.00009894s_[0m]_[0m
CMD[_[0;33m/opt/observium/scripts/distro_[0m]
_[0m
CMD EXITCODE[_[0;32m0_[0m]
CMD RUNTIME[_[0;32m0.0256s_[0m]_[0m
STDOUT[
Linux|3.16.0-4-amd64|amd64|Debian|8.10|vmware|
]_[0m
CMD[_[0;33m/usr/bin/env python --version 2>&1_[0m]
_[0m
CMD EXITCODE[_[0;32m0_[0m]
CMD RUNTIME[_[0;32m0.0008s_[0m]_[0m
STDOUT[
Python 2.7.9
]_[0m
SQL[_[0;33mSELECT version();_[0m]_[0m
SQL RUNTIME[_[0;32m0.00013900s_[0m]_[0m
CMD[_[0;33m/usr/bin/snmpget --version 2>&1_[0m]
_[0m
CMD EXITCODE[_[0;32m0_[0m]
CMD RUNTIME[_[0;32m0.0018s_[0m]_[0m
CMD EXITDELAY[_[0;31m10ms_[0m]_[0m
STDOUT[
NET-SNMP version: 5.7.2.1
]_[0m
CMD[_[0;33m/usr/bin/rrdtool --version | head -n1_[0m]
_[0m
CMD EXITCODE[_[0;32m0_[0m]
CMD RUNTIME[_[0;32m0.0024s_[0m]_[0m
STDOUT[
RRDtool 1.4.8 Copyright 1997-2013 by Tobias Oetiker <tobi@oetiker.ch>
]_[0m
CMD[_[0;33m/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'_[0m]
_[0m
CMD EXITCODE[_[0;32m0_[0m]
CMD RUNTIME[_[0;32m0.0206s_[0m]_[0m
STDOUT[
Apache/2.4.10
]_[0m
CMD[_[0;33mdate "+%:z"_[0m]
_[0m
CMD EXITCODE[_[0;32m0_[0m]
CMD RUNTIME[_[0;32m0.0006s_[0m]_[0m
STDOUT[
-07:00
]_[0m
SQL[_[0;33mSELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);_[0m]_[0m
SQL RUNTIME[_[0;32m0.00016499s_[0m]_[0m
SQL[_[0;33mSELECT @@SESSION.sql_mode;_[0m]_[0m
SQL RUNTIME[_[0;32m0.00005984s_[0m]_[0m
SQL[_[0;33mSHOW VARIABLES LIKE 'character_set_connection'_[0m]_[0m
SQL RUNTIME[_[0;32m0.00035310s_[0m]_[0m
_[0;36m##### _[1;37mSoftware versions_[0;36m #####_[0m
_[0m
_[0;36m o _[1;37mOS _[0m Linux 3.16.0-4-amd64 [amd64] (Debian 8.10)
_[0;36m o _[1;37mApache _[0m 2.4.10
_[0;36m o _[1;37mPHP _[0m 7.0.29-1~dotdeb+8.1 (OPcache: DISABLED)
_[0;36m o _[1;37mPython _[0m 2.7.9
_[0;36m o _[1;37mMySQL _[0m 5.5.60-0+deb8u1 (extension: mysqli 5.0.12-dev)
_[0;36m o _[1;37mSNMP _[0m NET-SNMP 5.7.2.1
_[0;36m o _[1;37mRRDtool _[0m 1.4.8
_[0;35m##### _[1;37mMemory Limit_[0;35m #####_[0m
_[0m
_[0;35m o _[1;37mPHP _[0m Unlimited
_[0;35m##### _[1;37mMySQL mode_[0;35m #####_[0m
_[0m
_[0;35m o _[1;37mMySQL _[0m
_[0;35m##### _[1;37mCharset info_[0;35m #####_[0m
_[0m
_[0;35m o _[1;37mPHP _[0m UTF-8
_[0;35m o _[1;37mMySQL _[0m utf8
_[0;35m##### _[1;37mTimezones info_[0;35m #####_[0m
_[0m
_[0;35m o _[1;37mDate _[0m Wednesday, 16-May-18 08:48:39 PDT
_[0;35m o _[1;37mPHP _[0m -07:00
_[0;35m o _[1;37mMySQL _[0m -07:00
SQL[_[0;33mSELECT * FROM `alerts_maint` WHERE `maint_start` < '1526485719' AND `maint_end` > '1526485719'_[0m]_[0m
SQL RUNTIME[_[0;32m0.00037003s_[0m]_[0m
_[1;37m##### _[1;37m_[1;37mStarting polling run at 2018-05-16 08:48:39_[1;37m #####_[0m
_[0m
SQL[_[0;33mSELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE '192.168.2.22' ORDER BY `device_id` ASC_[0m]_[0m
SQL RUNTIME[_[0;32m0.00019908s_[0m]_[0m
WARNING: 0 devices polled. Did you specify a device that does not exist?
./poller.php: 192.168.2.22 - 0 devices polled in 0.072 secs
_[1;37m##### _[1;37m_[1;37mCompleted polling run at 2018-05-16 08:48:39_[1;37m #####_[0m
_[0m
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
_[1;37m o _[1;37mDevices Polled _[0m 0
_[1;37m o _[1;37mPoller Time _[0m 0.072 secs
_[1;37m o _[1;37mMemory usage _[0m 12MB (peak: 14MB)
_[1;37m o _[1;37mMySQL Usage _[0m Insert[0/0s] Update[0/0s] Delete[0/0s] Cell[4/0.001s] Row[5/0.001s] Rows[4/0.001s] Col[0/0s] (0.003s 4.62%)
_[1;37m o _[1;37mRRDTool Usage _[0m (0s 0%)
_[1;37m o _[1;37mSNMP Usage _[0m (0s 0%)
From: observium [mailto:observium-bounces@observium.org] On Behalf Of adama@memetic.org
Sent: Wednesday, May 16, 2018 8:46 AM
To: 'Observium' <observium@observium.org>
Subject: Re: [Observium] Did the revision update and my workstations are down now
I’ve never encountered this particular issue. What is the entire output from a debugged poller run for a device?
Adam.
From: observium <observium-bounces@observium.org> On Behalf Of Joe Brouillette
Sent: 16 May 2018 16:24
To: 'Observium' <observium@observium.org>
Subject: [Observium] Did the revision update and my workstations are down now
Hey all, I did the revision update and I’m now currently at 18.5.9221. Since I did the update my workstations are all showing as down. I can ping them from my Observium server and I can run an snmpwalk on them from the Observium server. I tried running both ./discovery.php -d -h <some_host> and ./poller.php -d -h <some_host> and both of them have this warning:
WARNING: 0 devices polled/discovered. Did you specify a device that does not exist?
I tried to re-add a device but Observium says it has already been added. Am I missing something simple here?
Thanks,
Joe Brouillette
IT Specialist
509.664.7643
