- observium - lists.observium.org

Adding mysql monitoring
by Lance Raymond 08 Jan '13

08 Jan '13

Checking out http://www.observium.org/wiki/Application/MySQL#Requirementsand seems pretty straight forward. I have my server running, added that box and see it collecting data now. php5-cli and php-mysql are installed on both the server and mysql server I wish to monitor, but nothing has been added and not sure how to force check, add, etc. Docs are simple enough; I created the user with access on the remote server. Then the steps are simply; *Copy* the mysql script *from scripts/agent-local/* in your observium install to */usr/local/check_mk_agent/local/* (/usr/lib/check_mk_agent/local/ on Debian systems) the *server* you wish to monitor. The remote server is running ubuntu, so I create a folder; /usr/lib/check_mk_agent/local with 2 files; mysql (script) mysql.cnf I can run the script locally and get a lot of data (here is a sample); root@mysql101:/usr/lib/check_mk_agent/local# ./mysql <<<mysql>>> a0:13362926 a1:50929 a2:4796992 a3:287789 So is it something on the server end I need to add/edit? Tnx -- *e*. lraymond(a)weatherflow.com *c.* 386.561.1509 *f.* 386.409.5178

3 5

netdot VM root password
by Ramzi Abdallah 07 Jan '13

07 Jan '13

Hi, What is the default root password for the netdot VM appliance. I need it to setup a static IP to the installation Regards, Ramzi

2 1

all hosts down moved observium to a new server
by Bao Nguyen 04 Jan '13

04 Jan '13

All, I'm kind of hitting a wall here. I moved Observium to a new server today and somehow Observium is unable to "ping" any hosts. sour% ./poller.php -h lab-lightning.sdsc.edu -d Observium Poller v0.13.1.3507 DEBUG! Starting polling run: SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'lab-lightning.sdsc.edu' ORDER BY `device_id` ASC] ./poller.php lab-lightning.sdsc.edu January 3, 2013, 17:17 - 0 devices polled in 0.001 secs MySQL: Cell[0/0s] Row[0/0s] Rows[1/0s] Column[0/0s] Update[0/0s] Insert[0/0s] Delete[0/0s] However, on the host it self, I can ping or snmpget any devices using the same FQDN name. sour% ping lab-lightning.sdsc.edu PING lab-lightning.sdsc.edu (198.202.79.48) 56(84) bytes of data. 64 bytes from lab-lightning.sdsc.edu (198.202.79.48): icmp_req=1 ttl=253 time=0.728 ms ^C --- lab-lightning.sdsc.edu ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.728/0.728/0.728/0.000 ms sour% snmpwalk -v 2c -c test lab-lightning.sdsc.edu sysName.0 SNMPv2-MIB::sysName.0 = STRING: "lab-lightning.sdsc.edu" thanks, -bn 0216331C

4 3

Re: [Observium] all hosts down moved observium to a new server
by Adam Armstrong 04 Jan '13

04 Jan '13

That hostname doesnt match the database, or that host is disabled. Adam. Bao Nguyen <ngqbao(a)gmail.com> wrote: >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 1

Aggrgation, Nagios Check, Graph Caching
by Tobias Brunner 01 Jan '13

01 Jan '13

Hi, After using Observium for some time I have some ideas and questions: * Is it possible to create aggregated graphs? F.e. I'd like to aggregate all uplinks (which are on different routers) into one big graph (all uplinks as a single line, in one graph (overlay). And the traffic aggregated). * This could maybe end up in a Dashboard, which shows me an overview of what's going on in the network. (Aggregated Graphs, Top Ports, Recent Syslog, High Values, ...) * I'd like to check some values collected by Observium with Nagios to generate an Alert (F.e. the temperatures, dBm, ...). This could be a plugin like "check_observium <device> <type> <thresholds>". How can I access the raw data in Observium from outside? Is there something like this available, or does it need to be written? My main concern is to have just one tool which Polls the devices and get the collected data out of it. I don't want to have many tools which are all doing SNMP. One single tool should be enough. * How can I get the graphs out of Observium to display in another tool? * Are there any caching mechanisms for the Graphs? Everytime I hover over a link which creates a Pop-Up the graphs are being generated. What about caching the generated graphs for f.e. 5 minutes? Cheers and thanks a lot for this great tool! Tobias -- Nine Internet Solutions AG, Albisriederstr. 243a, CH-8047 Zuerich Support +41 44 637 40 40 | Tel +41 44 637 40 00 | Direct +41 44 637 40 13 Skype nine.ch_support

2 1

Logstash and Observium
by Tobias Brunner 31 Dec '12

31 Dec '12

Hi everyone, We are using Logstash to collect Syslog messages from our network gear. Here is a way to send the collected messages to Observium: * Define a IOS filter in Logstash filter { ### IOS Grok grok { type => "syslog" pattern => [ "<%{POSINT:syslog_pri}>%{SYSLOGTIMESTAMP:syslog_timestamp} %{SYSLOGHOST:syslog_hostname} %{DATA:cisco_dummyvalue}: %{DATA:cisco_timestamp}: \%%{DATA:cisco_eventcode}: %{GREEDYDATA:syslog_message}" ] add_field => [ "received_at", "%{@timestamp}" ] add_field => [ "received_from", "%{@source_host}" ] } } * Add the following output to logstash: output { pipe { command => "/usr/bin/php /opt/observium/syslog.php" message_format => "%{@source_host}||%{syslog_facility}||%{syslog_severity_code}||%{syslog_severity}||00||%{@timestamp}||%{cisco_dummyvalue}: &{cisco_timestamp}: %%{cisco_eventcode}: %{@message}||cisco" } } As I did not find a way to convert the @timestamp field of Logstash to the needed format, there is one additional line in syslog.php needed: --- syslog.php.orig 2012-12-21 11:28:41.741696532 +0100 +++ syslog.php 2012-12-29 11:58:59.790246786 +0100 @@ -28,6 +28,8 @@ { #logfile($line); list($entry['host'],$entry['facility'],$entry['priority'], $entry['level'], $entry['tag'], $entry['timestamp'], $entry['msg'], $entry['program']) = explode("||", trim($line)); + ## reformat timestamp + $entry['timestamp'] = date("Y-m-d H:i:s",strtotime($entry['timestamp'])); process_syslog($entry, 1); unset($entry); unset($line); $i++; And I was also not able to find a value for the fields "TAG" and "PROGRAM" for the message_format. So I hardcoded them as "OO" and "cisco". This works for me. Cheers, Tobias -- Nine Internet Solutions AG, Albisriederstr. 243a, CH-8047 Zuerich Support +41 44 637 40 40 | Tel +41 44 637 40 00 | Direct +41 44 637 40 13 Skype nine.ch_support

1 0

Re: [Observium] No Devices Shown in New Installation
by Adam Armstrong 29 Dec '12

29 Dec '12

lol :-) Mark Kamichoff <prox(a)prolixium.com> wrote: >On Mon, Dec 24, 2012 at 11:28:26PM -0600, Adam Armstrong wrote: >> It might be something that's changed recently, with adding sorting. >> >> Interesting that it claims you have zero devices/ports in the header too. > >I had a few minutes to look into this, today. After adding debugging >print statements to devices.inc.php and then looking to see why all >devices were failing devices_permitted, I discovered the problem: > >mysql> SELECT * FROM users; >+---------+----------+------------------------------------+----------+-------+-------+-------+-------------------+ >| user_id | username | password | realname | email | descr | level | can_modify_passwd | >+---------+----------+------------------------------------+----------+-------+-------+-------+-------------------+ >| 1 | prox | (removed) | | | | 0 | 1 | > >I thought this was interesting, so I went back to the original terminal >capture of my installation, and saw this: > >(atlantis:20:31)# /opt/observium/adduser.php prox (removed) prox(a)prolixium.com >User prox added successfully >(atlantis:20:32)# > >Whoops! It looks like I failed to specify a user level but continued to >add arguments afterwards. My e-mail address didn't appear in the MySQL >DB (see above) and my privilege level defaulted to 0. I haven't looked >through the adduser.php code, but I suspect that it tried to interpret >my e-mail address as an integer: > >(atlantis:11:12)# ./adduser.php >Add User Tool >Usage: ./adduser.php <username> <password> <level 1-10> [email] > >I'm finally up and running and can see some pretty graphs that have >accumulated over the last few days ;) > >- Mark > >> >> adam. >> >> On 24/12/2012 22:29, Mark Kamichoff wrote: >> >Hi Adam - >> > >> >On Mon, Dec 24, 2012 at 07:09:42PM -0600, Adam Armstrong wrote: >> >>Put /debug/ on the end of the URL. >> >Well, that certainly produced some extra information. I think it boils >> >down to something happening between the MySQL query and getting the >> >output to the web UI. Here's what /devices/debug gives me: >> > >> >o http://www.prolixium.com/share/observium-devices-debug.pdf >> >o http://www.prolixium.com/share/observium-devices-debug.html >> > >> >I can run some of those queries directly on the MySQL command line and >> >get results consistent with what should be displayed by the web UI: >> > >> >mysql> SELECT COUNT(port_id) FROM `ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ignore` = '0'; >> >+----------------+ >> >| COUNT(port_id) | >> >+----------------+ >> >| 13 | >> >+----------------+ >> >1 row in set (0.00 sec) >> > >> >mysql> SELECT * FROM `devices` WHERE 1 ORDER BY hostname \G >> >*************************** 1. row *************************** >> > device_id: 3 >> > hostname: dax >> > sysName: dax.prolixium.com >> > community: <omitted> >> >[..output trimmed, but three devices are shown..] >> > >> >There are some errors that may be important, although PHP flags them as >> >warnings: >> > >> >Warning: sort() expects parameter 1 to be array, null given in /opt/observium/html/includes/functions.inc.php on line 738 >> > >> >Warning: Invalid argument supplied for foreach() in /opt/observium/html/pages/devices.inc.php on line 120 >> > >> >The queries directly above these PHP messages in the debug output result >> >in no rows returned: >> > >> >mysql> SELECT D.device_id,location FROM devices AS D, devices_perms AS P WHERE D.device_id = P.device_id AND P.user_id = '1' GROUP BY location ORDER BY location; >> >Empty set (0.00 sec) >> > >> >mysql> SELECT attrib_type,attrib_value,device_id FROM devices_attribs WHERE attrib_type LIKE 'override_sysLocation%' ORDER BY attrib_type; >> >Empty set (0.00 sec) >> > >> >In the meantime, I'm going to add a few more random devices and see if I >> >can get one to display correctly.. >> > >> >Thanks! >> > >> >- Mark >> > >> >>Mark Kamichoff <prox(a)prolixium.com> wrote: >> >> >> >>>Hi - >> >>> >> >>>Warning: Here's another one of the "I installed it but it doesn't work!" >> >>>e-mails. >> >>> >> >>>I recently setup Observium (SVN from Dec 23, 2012) on a Debian >> >>>testing/unstable x86_64-based host. I followed all of the instructions >> >>>with the exception of the installation of libvirt packages (I don't >> >>>appear to have a need for it) and although I appear to have successfully >> >>>added devices, none of them show up in the web UI. >> >>> >> >>>The three devices I've added are the following: >> >>> >> >>>o Juniper SRX100 >> >>>o FreeBSD x86_64 Host >> >>>o Linux x86_64 Host >> >>> >> >>>According to observium.log the cron jobs are running fine and the >> >>>devices are being polled: >> >>> >> >>>(atlantis:16:44)# tail -n 8 observium.log >> >>>/opt/observium/poller.php all December 24, 2012, 16:25 - 3 devices polled in 21.97 secs >> >>>/opt/observium/discovery.php new December 24, 2012, 16:30 - 0 devices discovered in 0.001 secs >> >>>/opt/observium/poller.php all December 24, 2012, 16:30 - 3 devices polled in 21.46 secs >> >>>/opt/observium/discovery.php new December 24, 2012, 16:35 - 0 devices discovered in 0.002 secs >> >>>/opt/observium/poller.php all December 24, 2012, 16:35 - 3 devices polled in 21.41 secs >> >>>/opt/observium/discovery.php new December 24, 2012, 16:40 - 0 devices discovered in 0.002 secs >> >>>/opt/observium/poller.php all December 24, 2012, 16:40 - 3 devices polled in 21.97 secs >> >>>/opt/observium/discovery.php new December 24, 2012, 16:45 - 0 devices discovered in 0.000 secs >> >>> >> >>>I'm not sure exactly what check-errors.php does (maybe it just checks >> >>>the RRDs), but it seems to indicate that there aren't any glaring >> >>>issues: >> >>> >> >>>(atlantis:16:45)# ./check-errors.php >> >>>Checked 80 interfaces >> >>>0 interfaces with errors over the past 5 minutes. >> >>> >> >>>I even looked in the MySQL DB and the `devices` table seems to be >> >>>populated correctly. >> >>> >> >>>The problem is that the web UI doesn't show any devices: >> >>> >> >>>http://www.prolixium.com/share/screens/observium-devices.png >> >>> >> >>>However, if I navigate to System -> About Observium, the statistics >> >>>table shows devices, interfaces, CPUs, etc.: >> >>> >> >>>http://www.prolixium.com/share/screens/observium-stats.png >> >>> >> >>>I've got to be missing something obvious. I thought the user I created >> >>>might not have sufficient privileges, but I created the user "prox" with >> >>>privilege level 10. >> >>> >> >>>The only thing that did not go 100% as expected was the DB schema load. >> >>>The instructions indicated that errors in the SQL revisions /up to/ 006 >> >>>will be expected, but I saw two errors past revision 006: >> >>> >> >>>(atlantis:18:06)# php includes/sql-schema/update.php >> >>>-- Updating database schema >> >>>000 -> 001 ... done. >> >>>001 -> 002 ... done. >> >>>002 -> 003 ... done. >> >>>003 -> 004 ... done. >> >>>004 -> 005 ... done. >> >>>005 -> 006 ... done. >> >>>006 -> 007 ... done (1 errors). >> >>>007 -> 008 ... done. >> >>>[..snip..] >> >>>031 -> 032 ... done. >> >>>032 -> 033 ... done (2 errors). >> >>>033 -> 034 ... done. >> >>>[..snip..] >> >>>039 -> 040 ... done. >> >>>-- Done >> >>> >> >>>I'm not sure if this is minor or something to be concerned about. Here >> >>>is some package information: >> >>> >> >>>mysql-server-5.5 5.5.24+dfsg-9 >> >>>libapache2-mod-php5 5.4.4-10 >> >>>apache2-mpm-prefork 2.2.22-12 >> >>> >> >>>There appear to be no PHP errors in the Apache error log I setup for the >> >>>Observium virtual host. >> >>> >> >>>Is there anything else I should check? >> >>> >> >>>Oh, I'm using Google Chrome 23.0.1271.101 on MacOS 10.8 (at the moment, >> >>>at least). >> >>> >> >>>Thanks! >> >>> >> >>>- Mark >> >>> >> >>>-- >> >>>Mark Kamichoff >> >>>prox(a)prolixium.com >> >>>http://www.prolixium.com/ >> >>> >> >>>_______________________________________________ >> >>>observium mailing list >> >>>observium(a)observium.org >> >>>http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> >>_______________________________________________ >> >>observium mailing list >> >>observium(a)observium.org >> >>http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> >> >> > >> > >> >_______________________________________________ >> >observium mailing list >> >observium(a)observium.org >> >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> > >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > >-- >Mark Kamichoff >prox(a)prolixium.com >http://www.prolixium.com/ >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0

Re: [Observium] No Devices Shown in New Installation
by Adam Armstrong 29 Dec '12

29 Dec '12

Put /debug/ on the end of the URL. Mark Kamichoff <prox(a)prolixium.com> wrote: >Hi - > >Warning: Here's another one of the "I installed it but it doesn't work!" >e-mails. > >I recently setup Observium (SVN from Dec 23, 2012) on a Debian >testing/unstable x86_64-based host. I followed all of the instructions >with the exception of the installation of libvirt packages (I don't >appear to have a need for it) and although I appear to have successfully >added devices, none of them show up in the web UI. > >The three devices I've added are the following: > >o Juniper SRX100 >o FreeBSD x86_64 Host >o Linux x86_64 Host > >According to observium.log the cron jobs are running fine and the >devices are being polled: > >(atlantis:16:44)# tail -n 8 observium.log >/opt/observium/poller.php all December 24, 2012, 16:25 - 3 devices polled in 21.97 secs >/opt/observium/discovery.php new December 24, 2012, 16:30 - 0 devices discovered in 0.001 secs >/opt/observium/poller.php all December 24, 2012, 16:30 - 3 devices polled in 21.46 secs >/opt/observium/discovery.php new December 24, 2012, 16:35 - 0 devices discovered in 0.002 secs >/opt/observium/poller.php all December 24, 2012, 16:35 - 3 devices polled in 21.41 secs >/opt/observium/discovery.php new December 24, 2012, 16:40 - 0 devices discovered in 0.002 secs >/opt/observium/poller.php all December 24, 2012, 16:40 - 3 devices polled in 21.97 secs >/opt/observium/discovery.php new December 24, 2012, 16:45 - 0 devices discovered in 0.000 secs > >I'm not sure exactly what check-errors.php does (maybe it just checks >the RRDs), but it seems to indicate that there aren't any glaring >issues: > >(atlantis:16:45)# ./check-errors.php >Checked 80 interfaces >0 interfaces with errors over the past 5 minutes. > >I even looked in the MySQL DB and the `devices` table seems to be >populated correctly. > >The problem is that the web UI doesn't show any devices: > >http://www.prolixium.com/share/screens/observium-devices.png > >However, if I navigate to System -> About Observium, the statistics >table shows devices, interfaces, CPUs, etc.: > >http://www.prolixium.com/share/screens/observium-stats.png > >I've got to be missing something obvious. I thought the user I created >might not have sufficient privileges, but I created the user "prox" with >privilege level 10. > >The only thing that did not go 100% as expected was the DB schema load. >The instructions indicated that errors in the SQL revisions /up to/ 006 >will be expected, but I saw two errors past revision 006: > >(atlantis:18:06)# php includes/sql-schema/update.php >-- Updating database schema >000 -> 001 ... done. >001 -> 002 ... done. >002 -> 003 ... done. >003 -> 004 ... done. >004 -> 005 ... done. >005 -> 006 ... done. >006 -> 007 ... done (1 errors). >007 -> 008 ... done. >[..snip..] >031 -> 032 ... done. >032 -> 033 ... done (2 errors). >033 -> 034 ... done. >[..snip..] >039 -> 040 ... done. >-- Done > >I'm not sure if this is minor or something to be concerned about. Here >is some package information: > >mysql-server-5.5 5.5.24+dfsg-9 >libapache2-mod-php5 5.4.4-10 >apache2-mpm-prefork 2.2.22-12 > >There appear to be no PHP errors in the Apache error log I setup for the >Observium virtual host. > >Is there anything else I should check? > >Oh, I'm using Google Chrome 23.0.1271.101 on MacOS 10.8 (at the moment, >at least). > >Thanks! > >- Mark > >-- >Mark Kamichoff >prox(a)prolixium.com >http://www.prolixium.com/ > >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 3

Re: [Observium] APC UPS Current Sensor
by Michael F. Kisser 27 Dec '12

27 Dec '12

Tom, Thanks for the reply. I did get more into the UPS's and they all show "Load Power % of Watts" Only the RT shows Load Current and also all show runtime remaining. Thanks, Mike ---------------------------------------------------------------------- Message: 1 Date: Wed, 26 Dec 2012 19:08:29 +0000 From: "Michael F. Kisser" <mike.kisser(a)railstream.biz> To: "observium(a)observium.org" <observium(a)observium.org> Subject: [Observium] APC UPS Current Sensor Message-ID: <7863F40C09BE9941A578A8AC4AB48DE056EEA8BA(a)RSSERV02.railstream.local> Content-Type: text/plain; charset="us-ascii" Hello all, I have the fallowing UPS's With APC 9617 Management cards Smart-UPS 1000 600.3.D Does not report Current draw Smart-UPS RT 2000 XL 801.3.D Everything works SMART-UPS 2200 80.11.D Does not report Current draw Everything else is reporting just not the draw on the other UPS's I have updated to APC Management Module AOS v3.7.3 / App v3.7.2 Can I Upgrade the Firmware on the UPS its self? Still Only the 2000 XL reports Current If I could ask it would be nice to see the Runtime on the UPS. Any sugestions on how to fix the current for the 1000 & 2200 UPS's I know there older UPS's but they work very well and was looking at getting more 1000's down the road but if I have to go with a newer UPS to get this to work that's ok to. Thanks, Mike

1 0

APC UPS Current Sensor
by Michael F. Kisser 26 Dec '12

26 Dec '12

Hello all, I have the fallowing UPS's With APC 9617 Management cards Smart-UPS 1000 600.3.D Does not report Current draw Smart-UPS RT 2000 XL 801.3.D Everything works SMART-UPS 2200 80.11.D Does not report Current draw Everything else is reporting just not the draw on the other UPS's I have updated to APC Management Module AOS v3.7.3 / App v3.7.2 Can I Upgrade the Firmware on the UPS its self? Still Only the 2000 XL reports Current If I could ask it would be nice to see the Runtime on the UPS. Any sugestions on how to fix the current for the 1000 & 2200 UPS's I know there older UPS's but they work very well and was looking at getting more 1000's down the road but if I have to go with a newer UPS to get this to work that's ok to. Thanks, Mike

2 1