- observium - lists.observium.org

Duplicate entry in applications table
by Simon Smith 18 Dec '15

18 Dec '15

Hi All, not sure if ive found a bug or something is wrong on my server that is being monitored in my db.log I’m getting [2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:05:10 +0000] poller.php(6976): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','') [2015/12/17 17:09:23 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:09:23 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:09:24 +0000] poller.php(12106): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-apache-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','apache','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-freeradius-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','freeradius','') [2015/12/17 17:15:15 +0000] poller.php(17083): Failed dbQuery (#1062 - Duplicate entry '64-mysql-' for key 'dev_type_inst'), Query: INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('64','mysql','') currently the machine runs apache, freeradius, mysql, openvpn I’m using the unix agents ? and they are installed correctly in /usr/lib/observium_agent/local i can even execute them correctly and get data out from out observium server whats also weird is I’m getting data for openvpn, just not the other? i have deleted the table entrys, but they just re-appear, and then the logs appear again is the a bug possible? regards Simon

3 5

broken app (apache/mysql) integration
by Nils Podzich 18 Dec '15

18 Dec '15

Hello, I have some problems with the 7274 version and the apps. Especially with the mysql and apache app. Mailgraph seems to work fine, the others are not tested. The app script of mysql/apache seem to run fine, if I telnet to 36602 I get output which seems valid to me - and is similar to a release where apache is working. I have no working version of mysql for comparison at the moment. I think I narrowed to problem down. If I try to run the poller-script manually in debug there is an error ---snip--- SQL[SELECT * FROM `applications` WHERE `device_id` = '40' AND `app_type` = 'mysql'] SQL RUNTIME[0.00032902s] Including: applications/mysql.inc.php mysql SQL[SELECT * FROM `applications` WHERE `device_id` = '40' AND `app_type` = 'mysql' AND `app_instance` IS NULL] SQL RUNTIME[0.00021815s] + SQL[INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('40','mysql','')] SQL RUNTIME[0.00914192s] ERROR[Error in query: (Duplicate entry '40-mysql-' for key 'dev_type_inst') 1062] ---snip--- SQL[SELECT * FROM `applications` WHERE `device_id` = '38' AND `app_type` = 'apache'] SQL RUNTIME[0.00032187s] Including: applications/apache.inc.php apache SQL[SELECT * FROM `applications` WHERE `device_id` = '38' AND `app_type` = 'apache' AND `app_instance` IS NULL] SQL RUNTIME[0.00016117s] + SQL[INSERT INTO `applications` (`device_id`,`app_type`,`app_instance`) VALUES ('38','apache','')] SQL RUNTIME[0.00899100s] ERROR[Error in query: (Duplicate entry '38-apache-' for key 'dev_type_inst') 1062] ---snip--- The hosts are newly added. I also did a restore of the observium machine because I thought I somehow broke it by adding and testing... but the problems return with readding the hosts. The graphs are showing mainly nothing which is not surprising I think The grahics are there but no values.... I noticed that the demo installation shows similar problems or. graphics, at least for the mysql. Apache seems to work there which it doesn't for me. http://demo.observium.org/apps/app=mysql/ Additionally I have problems removing a group definition. When you click "delete" it always shows "edit" which it makes hard to remove the group because of a typo. Can anyone help me? Am I doing something wrong? Thank you, Best regards Nils

2 1

test_email.php
by Elmas, Murat 17 Dec '15

17 Dec '15

Hi, I'm trying to define e-mail alert using config.php file. I looked the page at http://www.observium.org/docs/config_options/ for configuration options. It says here I can try the settings using the test_mail.php but no test-email.php in observium folder. "SMTP specific options To test email settings use test_mail.php script from main observium dirrectory." What should I do ? Thanks in advance ?NL? & Co ve ba?l? ortakl?klar? hakk?nda daha fazla bilgi www.unluco.com adresinde mevcuttur. Kisiye ?zel bu mesaj ve i?eri?indeki bilgiler gizlidir. ?NL? & Co ve ba?l? ortakl?klar? ("?irket"), bu mesajin icerigi ve ekleri ile ilgili olarak hukuksal hi?bir sorumluluk kabul etmez. Yetkili al?c?lardan biri de?ilseniz, bu mesajin herhangi bir ?ekilde if?a edilmesi, kullan?lmas?, kopyalanmas?, yay?lmas? veya mesajda yeralan hususlarla ilgili olarak herhangi bir i?lem yap?lmas?n?n kesinlikle yasak oldu?unu bildiririz. B?yle bir durumda, l?tfen hemen mesaj?n g?ndericisini bilgilendiriniz ve mesaj? sisteminizden siliniz. ?irketimiz, internet ortam?nda g?nderilen e-posta mesajlar?n?n ve bilgilerinin size de?i?ikli?e u?rayarak veya ge? ula?mas?ndan, b?t?nl???n?n ve gizlili?inin korunamamas?ndan, vir?s i?ermesinden ve bilgisayar sisteminize verebilece?i herhangi bir zarardan sorumlu tutulamaz. More information on ?NL? & Co and its subsidiaries is available at www.unluco.com The information contained in this communication may contain confidential or legally privileged information. ?NL? & Co and its subsidiaries ("the Company") do not accept any legal responsibility for the contents and attachments of this message. If you are not the intended recipient you are hereby notified that any disclosure, use, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited. If you have received this communication in error, please notify the sender immediately by responding to this e-mail and then delete it from your system. The Company shall have no liability for any changes or late receiving, loss of integrity and confidentiality, viruses and any damages caused in anyway to your computer system.

5 7

Re: [Observium] update.php fails to run on latest svn release 7273
by Jason Scholl 17 Dec '15

17 Dec '15

That worked, thanks. I also see that update.php got updated so that it doesn't support direct calls, nice touch.

1 0

New alert options
by Anders Johansson 17 Dec '15

17 Dec '15

Hi, After upgrading to the latest Observium (pro) I've noticed a lot of new alerting destination options. Just curios. * Are they all implemented or just in UI? * If any are activated, how do I configure them? We have internal email to SMS gateways, would it be possible to create one that uses a specific SMS template? I'd like to keep my sms messages short and don't mind creating one myself. When I looked at the code last time it didn't seems to be to much trouble, but perhaps it easier know when some of the code might be written? //Anders

3 3

Re: [Observium] update.php fails to run on latest svn release 7273
by Jason Scholl 17 Dec '15

17 Dec '15

Deleting and re-syncing includes didn't work, though I was able to get it to run successfully by swapping these two lines in update.php include_once("includes/definitions.inc.php"); include("includes/functions.inc.php"); get_obs_attrib is defined in 'includes/common.inc.php', but that is only getting included into update.php through 'includes/functions.inc.php'.

2 1

update.php fails to run on latest svn release 7273
by Jason Scholl 16 Dec '15

16 Dec '15

I just attempted to upgrade to release 7273 and update.php fails to run. It gives no output (just return code 255), and logs nothing to update-errors.log or any other log file. My php skills are pretty weak, but a bit of "got here" debugging lead me through the following. includes/update/update.php 21: include_once("includes/definitions.inc.php"); #bailed on this line includes/definitions.inc.php 513: $rev_old = @get_obs_attrib('current_rev'); #bailed on this line I wasn't able to track it down any further than that because I couldn't even seem to get get_obs_attrib to execute. As a last ditch effort, I also tried commenting out all of my config except the absolutely required pieces, but it still failed in the same way. Is anyone else having this problem or have any ideas?

2 1

Contact Destination - Local file
by Spencer Ryan 16 Dec '15

16 Dec '15

Would it be possible to add a local file option to the providers for a contact? There are situations where we would like to manipulate the data with a script of our own based on triggered alerts and recoveries and instead of mucking around the DB by hand having Observium write out the alerts to a file would be the easiest. Maybe just have it take a path and just >> the alert contents to whatever the user enters? *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

5 7

Not alerting (probably user fail)
by Robert Williams 16 Dec '15

16 Dec '15

Hi, We've just finished migrating some of our monitoring targets to an additional instance of Observium, everything is polling fine and all the historic data etc. has been moved OK. The only thing which remains broken is that none of the alerts are actually sending their emails. They do show as being in an alert state OK, for example: However, no actual 'Alerted' time is ever recorded - and no email is ever sent. The sendmail element works fine with: sendmail -vt < testmail.txt The test contains the correct FROM and DEFAULT from the config.php in Observium and this delivers fine. Problem is, it was a very long time ago that I originally configured Observium alerting on the first box and I'm probably missing something stupid. Relevant config sections below: Both of these sections are identical to the working system they were copied from, which works fine. The postfix config is also identical to the working server and I'm confident postfix is OK as the test from it are fine: myhostname = OBSERVIUM.x.y alias_maps = hash:/etc/aliases alias_database = hash:/etc/aliases myorigin = /etc/mailname mydestination = OBSERVIUM, OBSERVIUM.x.y, localhost relayhost = 1.2.3.4 mailbox_size_limit = 0 recipient_delimiter = + Can anyone assist by pointing me at the switch I've obviously failed to turn on, or let me know what additional debugs I can provide to help track this? Cheers! Robert Williams Custodian Data Centre Email: Robert(a)CustodianDC.com http://www.CustodianDC.com

2 2

Alerts, metrics and attributes for applications
by Alex Winder ＠ M5i 16 Dec '15

16 Dec '15

Hi everyone, Does anyone know if there are any attributes or metrics for the UNIX agent applications, in particular NGINX, MySQL, Apache, and PowerDNS Recursor. I'm looking to create some alert checkers for them if it's at all possible. The only information I can find about the attributes and metrics is the following: http://www.observium.org/docs/attribs_metrics/ https://github.com/mgmoerman/docs/blob/master/observium-alert-checkers.md Regards, Alex.

2 2