Thanks Tom,
But I am actually more concerned that we are not getting email alerts when an alert is raised.
Can you point me in the right direction to fix?
Regards Laurence
On Sun, Jul 31, 2016 at 7:02 PM, Tom Laermans tom.laermans@powersource.cx wrote:
That bug will be closed with not a bug soon, though.
The alert ID is neither the alert checker ID nor the contact ID.
You need to use the alert entry ID, which you can find by going to an alert (not a checker, not a contact, but an actual alert, which is a checker<>entity association) in the web interface and looking at the URL.
Tom
On 31/07/2016 17:44, Cody Cook wrote:
You mean this bug?:) http://jira.observium.org/browse/OBSERVIUM-1947
On Jul 31, 2016 8:20 AM, "Laurence Mayer" laurence@istraresearch.com wrote:
Hi,
I have recently installed Observium and updated to the stable version. I have successfully configured a number of alerts, however despite the alerts being generated (I see them via the web gui) I do not receive them to email.
Using test_alert.php -a 1 (see below) I am able to receive email, however the test email looks a little empty from what I would expect.
I receive the following error, see below for the debug. *ERROR[Error in query: (Incorrect table name '') 1103]*
Any guidance will be appreciated.
Thanks Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/tab=alert/ *Alert* *Entity* *Metrics* *Duration* Unknown Device *Device* *Hardware* *Operating System* *Location* *Uptime* Never polled
E-mail sent to: laurence@ laurence@istraresearch.commydomain.com E-mail sent at: Sun, 31 Jul 2016 16:33:53 +0300
./test_alert.php -a 1 Observium 0.16.7.8003 Test Alert Notification
##### Software versions #####
o OS Linux 3.5.0-23-generic [amd64] (Ubuntu 12.04) o Apache 2.2.22 o PHP 5.3.10-1ubuntu3.23 o Python 2.7.3 o MySQL 5.5.46-0ubuntu0.12.04.2 (extension: mysqli 5.5.46) o SNMP NET-SNMP 5.4.3 o RRDtool 1.4.7
##### MySQL mode #####
o MySQL
##### Charset info #####
o PHP UTF-8 o MySQL utf8
##### Timezones info #####
o Date Sunday, 31-Jul-16 16:33:53 IDT o PHP +03:00 o MySQL +03:00
o Notifying [email] : {"email":"laurence@mydomain.com"} root@observiumsrv:/opt/observium# ./test_alert.php -a 1 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00009990s]
SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00012803s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007296s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00008488s]
CMD[/bin/hostname -f]
CMD EXITCODE[0] CMD RUNTIME[0.0017s] STDOUT[ observiumsrv.mydomain.com ] Observium 0.16.7.8003 Test Alert Notification
CMD[/opt/observium/scripts/distro]
CMD EXITCODE[0] CMD RUNTIME[0.038s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
CMD EXITCODE[0] CMD RUNTIME[0.0025s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017810s]
CMD[/usr/bin/snmpget --version 2>&1]
CMD EXITCODE[0] CMD RUNTIME[0.002s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
CMD EXITCODE[0] CMD RUNTIME[0.0036s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
CMD[date "+%:z"]
CMD EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ +03:00 ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00012493s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
CMD EXITCODE[0] CMD RUNTIME[0.0132s] STDOUT[ Apache/2.2.22 ]
SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00013804s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00036120s]
##### Software versions #####
o OS Linux 3.5.0-23-generic [amd64] (Ubuntu 12.04) o Apache 2.2.22 o PHP 5.3.10-1ubuntu3.23 o Python 2.7.3 o MySQL 5.5.46-0ubuntu0.12.04.2 (extension: mysqli 5.5.46) o SNMP NET-SNMP 5.4.3 o RRDtool 1.4.7
##### MySQL mode #####
o MySQL
##### Charset info #####
o PHP UTF-8 o MySQL utf8
##### Timezones info #####
o Date Sunday, 31-Jul-16 16:34:23 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008202s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00006294s]
SQL[SELECT * FROM `alert_table` WHERE `alert_table_id` = '1'] SQL RUNTIME[0.00006318s]
SQL[SELECT * FROM `devices` WHERE `device_id` = ''] SQL RUNTIME[0.00007415s]
SQL[SELECT * FROM `` WHERE ``.`` = ''] SQL RUNTIME[0.00006485s] *ERROR[Error in query: (Incorrect table name '') 1103]*
SQL[SELECT * FROM `devices` WHERE `device_id` = ''] SQL RUNTIME[0.00009012s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `aca_type` = 'alert' AND `alert_checker_id` = '');] SQL RUNTIME[0.00006199s] o Notifying [email] : {"email":"laurence@mydomain.com"}
SQL[UPDATE `alert_log` set `notified` ='1' WHERE `event_id` = ''] SQL RUNTIME[0.00025702s]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium