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* http://observiumsrv.istraresearch.com/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]