- observium - lists.observium.org

Better poller for Observium
by Alex Povolotsky 24 Jul '14

24 Jul '14

Hello While Observium has a nice interface, it's database lacks foreign keys a lot, and poller.php is AWFUL. It's slow and unreadable. I've started a new, about 40-50 times lighter observium poller https://github.com/tarkhil/observium-poller It supports only SNMP for now, and is work-in-progress. Only os, processor and memory modules are working, and ports is about 50% finished. If anyone is interested, please join. I'm sure to complete SNMP support for Cisco, but quite unsure if I'll be interested in implementing much else. Alex

8 17

Interesting experiment with poll over SSH
by Peter Childs 24 Jul '14

24 Jul '14

We have a host about 320ms from our observium node (yes.. The other side of the planet). Doing a full poll circa 650-700ms (including mac and bgp tables... Its a IOS-XR ASR9K ..). Adjusting the Cr/max-reps did increase speeds, and caused several nasty snmpd explosions on the chassis. As a exercise in interest I spun up a VM much closer to the host, unpacked /opt/observium/mibs etc and configured snmp on that remote host. Then did this root@obs1:/opt/observium# diff -c includes/snmp.inc.php.orig includes/snmp.inc.php *** includes/snmp.inc.php.orig 2014-07-23 17:43:53.720274321 +0930 --- includes/snmp.inc.php 2014-07-23 17:56:23.092286235 +0930 *************** *** 333,338 **** --- 333,345 ---- // Add the OID(s) to the strong $cmd .= " ".$oids; + if( $device['hostname'] == 'faraway.router.com' ){ + $cmd = "ssh -i ~x/x.pem x@remote-poller-node -C " . escapeshellarg($cmd) ; + } This was interesting, but the ssh establishment phase for each snmp execution was a lot of overhead.. So I also did this root@obs1:/opt/observium# cat ~/.ssh/config Host remote-poller-node # HostName machine1.example.org ControlPath ~/.ssh/controlmasters/%r@%h:%p ControlMaster auto ControlPersist 10m This means that a ssh 'master instance' was setup at the start of the poll, and hangs around in the background between executions of various snmpcmd's during the poll. Full poll went from 650-700ms -> ~170ms Thought this might be of interest to some people. Cheers, Peter

4 7

Alert checks with load average ?
by Xavier Beaudouin 23 Jul '14

23 Jul '14

Dear Observium gurus, Do you know if it is possible to make alert uppon load average (1minutes) like for example if load average if > 5.0 (this is a random value, but here is an idea). Kind regards, Xavier -- Xavier Beaudouin - Senior Network and System Administrator Infrastructure and network director Horizon Software - http://www.hsoftware.com/ 13 rue La Fayette - 75009 PARIS - France Phone: +33 (0)1 4260 9490 Fax: +33 (0)1 44 56 97 01

2 1

About Vmware / Observium
by Paolo De Michele 23 Jul '14

23 Jul '14

hi guys, I have a problem with a machine via vmware (esxi 5.1) because I can't be able to modify the locality to setup the correct point into the world map in the world map the point result completely wrong I have other machines via gnu/linux and it works perfectly in the snmp options I cannot setup the locality somebody has had an issue like that? thanks in advance, regards

5 6

Stop Email Alerts
by Kiru Pananthan 23 Jul '14

23 Jul '14

Dear all new to observium, how do we stop the email alerts from observium to our email account setup earlier, we are getting an device up/down alerts every 5 minutes for all our windows virtual machines and network devices. thanks kiru -- *Confidentiality Disclaimer:* This e-mail and any attachments are confidential and intended solely for the intended addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the intended addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose, distribute or otherwise act in reliance upon any part of this e-mail or its attachments. Australian International School Malaysia and all affiliates under Taylor's Education Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any internet communications by any third party in reliance to this email, or from the transmission of any viruses. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Australian International School Malaysia and all affiliates under Taylor's Education Group. Replies to this e-mail may be monitored by Australian International School Malaysia and all affiliates under Taylor's Education Group for operational or business reasons.

2 1

[SOLVED] Housekeeping not deleting records if you have a stupid number to kill.
by Crozier, Doug 23 Jul '14

23 Jul '14

I have a rather old and crufty installation of Observium (now at 5668) with over 70 million syslog, eventlog, and timing records that are older than 7 days. The first time I ran housekeeping -s to trim syslog messages it took about 30 minutes to return showing 42 million records. Just to be sure I was actually done deleting 42 million records, I re-ran the command. The same 42 million records were found. Meh. I ran the housekeeping in debug mode and noticed that I didn't have posix support installed. So I installed the php-process package and tried again. Still no records deleted. I tried deleting fewer records by keeping 18 months worth and that didn't help either. Here's the debug output from attempting to delete records older than 7 days: [root@xxx ~]# php /opt/observium/housekeeping.php -s -d DEBUG! SQL[SELECT COUNT(*) FROM `syslog` WHERE UNIX_TIMESTAMP(`timestamp`) < 1405322208;] 42123350 syslog entries from before 2014-07-14 15:16:48 will be deleted [y/N]: y SQL[DELETE FROM `syslog` WHERE UNIX_TIMESTAMP(`timestamp`) < 1405322208;] Syslog housekeeping: deleted entries Deleting the eventlog records also fails to remove the records: [root@xxxx observium]# php housekeeping.php -e -d DEBUG! SQL[SELECT COUNT(*) FROM `eventlog` WHERE UNIX_TIMESTAMP(`timestamp`) < 1380059875;] 29289378 eventlog entries from before 2013-09-25 05:57:55 will be deleted [y/N]: y SQL[DELETE FROM `eventlog` WHERE UNIX_TIMESTAMP(`timestamp`) < 1380059875] Event log housekeeping: deleted entries (As an aside, I'm not sure, but there may be a semi-colon missing on the delete statement for event log records.) What I eventually found was that trying to delete this many records exhausts the lock table (?). ERROR 1206 (HY000): The total number of locks exceeds the lock table size Issuing the same command from the mysql CLI and adding a 10,000,000 limit allowed the deletion to work correctly mysql> SELECT COUNT(*) FROM `eventlog` WHERE UNIX_TIMESTAMP(`timestamp`) < 1380059875; +----------+ | COUNT(*) | +----------+ | 28177378 | +----------+ 1 row in set (51.76 sec) mysql> DELETE FROM `eventlog` WHERE UNIX_TIMESTAMP(`timestamp`) < 1380059875 LIMIT 10000000; Query OK, 10000000 rows affected (3 min 40.32 sec) mysql> SELECT COUNT(*) FROM `eventlog` WHERE UNIX_TIMESTAMP(`timestamp`) < 1380059875; +----------+ | COUNT(*) | +----------+ | 18177378 | +----------+ 1 row in set (37.01 sec) Interesting to note that deleting 10 million records at a time with the LIMIT statement doesn't always work. Adjusting the LIMIT up and down eventually got me where I was going. Now that I have it the system down to a reasonable number of records, a nightly/weekly cron job should do just fine. Thanks for the effort you put into this Tom. For me, this was like a hardware upgrade.

3 2

About PPPOE / VPDN
by Paolo Giustiniani 23 Jul '14

23 Jul '14

I would like to monitor several interfaces pppoe connections. I enabled the feature and vpdn pppoe # $ config ['bad_if'] [] = "pppoe-"; $ config ['poller_modules'] ['cisco-vpdn'] = 1; The process of self discovery did not detect it. The command show vpdn order properly connections. How can I do?

5 18

Re: [Observium] observium Digest, Vol 48, Issue 97
by Kiru Pananthan 23 Jul '14

23 Jul '14

Hi Peter the machine we are polling is windows VM and also getting for the network switches also On Sun, Jul 20, 2014 at 6:55 AM, <observium-request(a)observium.org> wrote: > Send observium mailing list submissions to > observium(a)observium.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > or, via email, send a message with subject or body 'help' to > observium-request(a)observium.org > > You can reach the person managing the list at > observium-owner(a)observium.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of observium digest..." > > > Today's Topics: > > 1. Re: Device up / Down (Peter Persson) > 2. Does this product have server agents? (Chris Lawrence) > 3. Re: Does this product have server agents? (Adam Armstrong) > 4. Re: About PPPOE / VPDN (Adam Armstrong) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 19 Jul 2014 16:09:56 +0200 > From: Peter Persson <peter.persson(a)bredband2.se> > To: Observium Network Observation System <observium(a)observium.org> > Subject: Re: [Observium] Device up / Down > Message-ID: > < > CAPwoXysEEEmTBwWxGZFK6NdnsxoAujz40Oy+s8Pj2wbrWcgdPg(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > The machines doesnt respond as requested. > What type of machines are you polling? > > And thank you for your notice that the mail is confidential, I will not > show this mail for anyone! > > > 2014-07-19 2:41 GMT+02:00 Kiru Pananthan <kirup(a)aism.edu.my>: > > > Dear all > > We are getting an alerts message for every five minutes for 5 > > machines. Stating Device up: / Device Down > > > > Thanks > > Kiru > > > > -- > > *Confidentiality Disclaimer:* This e-mail and any attachments are > > confidential and intended solely for the intended addressee and may also > be > > privileged or exempt from disclosure under applicable law. If you are not > > the intended addressee, or have received this e-mail in error, please > > notify the sender immediately, delete it from your system and do not > copy, > > disclose, distribute or otherwise act in reliance upon any part of this > > e-mail or its attachments. Australian International School Malaysia and > all > > affiliates under Taylor's Education Group does not accept responsibility > > for any loss arising from unauthorised access to, or interference with, > any > > internet communications by any third party in reliance to this email, or > > from the transmission of any viruses. Please note that any views or > > opinions presented in this email are solely those of the author and do > not > > necessarily represent those of Australian International School Malaysia > > and > > all affiliates under Taylor's Education Group. Replies to this e-mail may > > be monitored by Australian International School Malaysia and all > > affiliates under Taylor's Education Group for operational or business > > reasons. > > _______________________________________________ > > observium mailing list > > observium(a)observium.org > > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > >

1 0

Meru Networks Controllers + Access Points
by Sean Huggans 22 Jul '14

22 Jul '14

Any chance to have Meru Networks wireless controllers added? Running a model MC1550 managing 11 Aps and would love to be able to pull it in. Sean Huggans I.S. Services Manager Network Operations Engineer Minneola Healthcare shuggans(a)minneolahealthcare.com [image: A+_CE_tiny]

3 2

Login issue. IP works hostname does not?
by Scott Benninger 21 Jul '14

21 Jul '14

I have a strange issue that I cannot resolve. I have a recent install of the community edition on Ubuntu 14.04. Only difference is the sites available directive changes to make it work compared to the official install docs. Everything was working perfectly and I could login via IP, hostname, or FQDN. The server is a VMware VM and I forgot to install the VMware tools so our VMware monitoring software would stop complaining. I installed the tools and rebooted and now I can only login via the IP. If I try via hostname etc the form just clears with no errors. Adding /debug=1/ shows the mysql commands etc but no errors. I have checked all the hostname settings, defaulted the host file, checked the apache and site configs and nothing working. Seems like a php issue to me. Any ideas? Thanks in advance and my apologies if this something simple that I have missed. Scott

4 4