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]
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* 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]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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 mailto: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@ <mailto:laurence@istraresearch.com>mydomain.com <http://mydomain.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 <mailto: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 <http://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 <mailto: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 <http://mydomain.com/>"} SQL[UPDATE `alert_log` set `notified` ='1' WHERE `event_id` = ''] SQL RUNTIME[0.00025702s] _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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 mailto: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 <mailto: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@ <mailto:laurence@istraresearch.com>mydomain.com <http://mydomain.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 <mailto: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 <http://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 <mailto: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 <http://mydomain.com/>"} SQL[UPDATE `alert_log` set `notified` ='1' WHERE `event_id` = ''] SQL RUNTIME[0.00025702s] _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium_______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/device=9/tab=alert/ *Alert* Memory is above 75% *Entity* I/O http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=mempool/ *Metrics* *Duration* Unknown Device *Device* cisco1g1 http://observiumsrv.istraresearch.com/device/device=9/ *Hardware* WS-C2960X-48TS-L *Operating System* Cisco IOS 15.2(2)E3 UNIVERSALK9 *Location* ISRAEL *Uptime* 204 days, 9h 16m 13s mempool_usage
-------------------------------------------------------------------------------------------------------------------------
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.22
]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22 ============================================================ array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@ mydomain.com"}
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans tom.laermans@powersource.cx wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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
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
That all looks fine to me. So what isn't working?
You are running poller wrapper, and it's executing alerter.php, right?
Adam.
Sent from BlueMail
On 31 Jul 2016, 23:30, at 23:30, Laurence Mayer laurence@istraresearch.com wrote:
Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/device=9/tab=alert/ *Alert* Memory is above 75% *Entity* I/O http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=mempool/ *Metrics* *Duration* Unknown Device *Device* cisco1g1 http://observiumsrv.istraresearch.com/device/device=9/ *Hardware* WS-C2960X-48TS-L *Operating System* Cisco IOS 15.2(2)E3 UNIVERSALK9 *Location* ISRAEL *Uptime* 204 days, 9h 16m 13s mempool_usage
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.22
]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22
array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@ mydomain.com"}
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans tom.laermans@powersource.cx wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it
might
give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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"
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
]
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
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Woow Adam you're expecting too much of me.... ; )
I have defined contacts and associated all the alerts to that contact, however when an alert occurs the contact does not receive an alert in email.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:02 AM, Adam Armstrong adama@memetic.org wrote:
That all looks fine to me. So what isn't working?
You are running poller wrapper, and it's executing alerter.php, right?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 31 Jul 2016, at 23:30, Laurence Mayer laurence@istraresearch.com wrote:
Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/device=9/tab=alert/ *Alert* Memory is above 75% *Entity* I/O http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=mempool/ *Metrics* *Duration* Unknown Device *Device* cisco1g1 http://observiumsrv.istraresearch.com/device/device=9/ *Hardware* WS-C2960X-48TS-L *Operating System* Cisco IOS 15.2(2)E3 UNIVERSALK9 *Location* ISRAEL *Uptime* 204 days, 9h 16m 13s mempool_usage
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.22
]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22
array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@ mydomain.com"}
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans < tom.laermans@powersource.cx> wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Adam, just to clarify I am using the built in Method of E-mail.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:07 AM, Laurence Mayer laurence@istraresearch.com wrote:
Woow Adam you're expecting too much of me.... ; )
I have defined contacts and associated all the alerts to that contact, however when an alert occurs the contact does not receive an alert in email.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:02 AM, Adam Armstrong adama@memetic.org wrote:
That all looks fine to me. So what isn't working?
You are running poller wrapper, and it's executing alerter.php, right?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 31 Jul 2016, at 23:30, Laurence Mayer laurence@istraresearch.com wrote:
Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/device=9/tab=alert/ *Alert* Memory is above 75% *Entity* I/O http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=mempool/ *Metrics* *Duration* Unknown Device *Device* cisco1g1 http://observiumsrv.istraresearch.com/device/device=9/ *Hardware* WS-C2960X-48TS-L *Operating System* Cisco IOS 15.2(2)E3 UNIVERSALK9 *Location* ISRAEL *Uptime* 204 days, 9h 16m 13s mempool_usage
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.22
]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22
array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@ mydomain.com"}
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans < tom.laermans@powersource.cx> wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Anyone?
On Mon, Aug 1, 2016 at 1:05 PM, Laurence Mayer laurence@istraresearch.com wrote:
Adam, just to clarify I am using the built in Method of E-mail.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:07 AM, Laurence Mayer <laurence@istraresearch.com
wrote:
Woow Adam you're expecting too much of me.... ; )
I have defined contacts and associated all the alerts to that contact, however when an alert occurs the contact does not receive an alert in email.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:02 AM, Adam Armstrong adama@memetic.org wrote:
That all looks fine to me. So what isn't working?
You are running poller wrapper, and it's executing alerter.php, right?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 31 Jul 2016, at 23:30, Laurence Mayer laurence@istraresearch.com wrote:
Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/device=9/tab=alert/ *Alert* Memory is above 75% *Entity* I/O http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=mempool/ *Metrics* *Duration* Unknown Device *Device* cisco1g1 http://observiumsrv.istraresearch.com/device/device=9/ *Hardware* WS-C2960X-48TS-L *Operating System* Cisco IOS 15.2(2)E3 UNIVERSALK9 *Location* ISRAEL *Uptime* 204 days, 9h 16m 13s mempool_usage
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.22
]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22
array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@ mydomain.com"}
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans < tom.laermans@powersource.cx> wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
But didn't you just generate an alert to a contact correctly?
Since there's no problem generating and sending email, the most likely problem is not running alerter.php. Does the alert log show notifications being sent?
adam. On 01/08/2016 00:08:28, Laurence Mayer laurence@istraresearch.com wrote: Woow Adam you're expecting too much of me.... ; )
I have defined contacts and associated all the alerts to that contact, however when an alert occurs the contact does not receive an alert in email.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:02 AM, Adam Armstrong <adama@memetic.org [mailto:adama@memetic.org]> wrote:
That all looks fine to me. So what isn't working? You are running poller wrapper, and it's executing alerter.php, right? Adam. Sent from BlueMail [http://www.bluemail.me/r]
On 31 Jul 2016, at 23:30, Laurence Mayer <laurence@istraresearch.com [mailto:laurence@istraresearch.com]> wrote: Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify [http://observiumsrv.istraresearch.com/device/device=9/tab=alert/] Alert Memory is above 75% Entity I/O [http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=memp...] Metrics Duration Unknown Device Device cisco1g1 [http://observiumsrv.istraresearch.com/device/device=9/] Hardware WS-C2960X-48TS-L Operating System Cisco IOS 15.2(2)E3 UNIVERSALK9 Location ISRAEL Uptime 204 days, 9h 16m 13s mempool_usage
-------------------------------------------------------------------------------------------------------------------------
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com [http://observiumsrv.mydomain.com] ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker <tobi@oetiker.ch [mailto:tobi@oetiker.ch]> ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0] CMD RUNTIME[0.0133s] STDOUT[ Apache/2.2.22 ]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22 ============================================================ array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@mydomain.com [http://mydomain.com%5D%22%7D
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans <tom.laermans@powersource.cx [mailto:tom.laermans@powersource.cx]> wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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 [mailto: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 [http://jira.observium.org/browse/OBSERVIUM-1947]
On Jul 31, 2016 8:20 AM, "Laurence Mayer" <laurence@istraresearch.com [mailto: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@ [mailto:laurence@istraresearch.com]mydomain.com [http://mydomain.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 [mailto: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 [http://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 [mailto: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 [http://mydomain.com/%5D%22%7D
SQL[UPDATE `alert_log` set `notified` ='1' WHERE `event_id` = ''] SQL RUNTIME[0.00025702s]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Yep, I did.
I am obviously missing something, where/how am I supposed to run alerter.php?
I have defined a contact etc, but where am I to add alerter.php?
Thanks Laurence
On Mon, Aug 1, 2016 at 6:39 PM, Adam Armstrong adama@memetic.org wrote:
But didn't you just generate an alert to a contact correctly?
Since there's no problem generating and sending email, the most likely problem is not running alerter.php. Does the alert log show notifications being sent?
adam.
On 01/08/2016 00:08:28, Laurence Mayer laurence@istraresearch.com wrote: Woow Adam you're expecting too much of me.... ; )
I have defined contacts and associated all the alerts to that contact, however when an alert occurs the contact does not receive an alert in email.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:02 AM, Adam Armstrong adama@memetic.org wrote:
That all looks fine to me. So what isn't working?
You are running poller wrapper, and it's executing alerter.php, right?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 31 Jul 2016, at 23:30, Laurence Mayer laurence@istraresearch.com wrote:
Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/device=9/tab=alert/ *Alert* Memory is above 75% *Entity* I/O http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=mempool/ *Metrics* *Duration* Unknown Device *Device* cisco1g1 http://observiumsrv.istraresearch.com/device/device=9/ *Hardware* WS-C2960X-48TS-L *Operating System* Cisco IOS 15.2(2)E3 UNIVERSALK9 *Location* ISRAEL *Uptime* 204 days, 9h 16m 13s mempool_usage
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.22
]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22
array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@ mydomain.com"}
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans < tom.laermans@powersource.cx> wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
I think I got it, this should run in cron ?
On Mon, Aug 1, 2016 at 6:42 PM, Laurence Mayer laurence@istraresearch.com wrote:
Yep, I did.
I am obviously missing something, where/how am I supposed to run alerter.php?
I have defined a contact etc, but where am I to add alerter.php?
Thanks Laurence
On Mon, Aug 1, 2016 at 6:39 PM, Adam Armstrong adama@memetic.org wrote:
But didn't you just generate an alert to a contact correctly?
Since there's no problem generating and sending email, the most likely problem is not running alerter.php. Does the alert log show notifications being sent?
adam.
On 01/08/2016 00:08:28, Laurence Mayer laurence@istraresearch.com wrote: Woow Adam you're expecting too much of me.... ; )
I have defined contacts and associated all the alerts to that contact, however when an alert occurs the contact does not receive an alert in email.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:02 AM, Adam Armstrong adama@memetic.org wrote:
That all looks fine to me. So what isn't working?
You are running poller wrapper, and it's executing alerter.php, right?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 31 Jul 2016, at 23:30, Laurence Mayer laurence@istraresearch.com wrote:
Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/device=9/tab=alert/ *Alert* Memory is above 75% *Entity* I/O http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=mempool/ *Metrics* *Duration* Unknown Device *Device* cisco1g1 http://observiumsrv.istraresearch.com/device/device=9/ *Hardware* WS-C2960X-48TS-L *Operating System* Cisco IOS 15.2(2)E3 UNIVERSALK9 *Location* ISRAEL *Uptime* 204 days, 9h 16m 13s mempool_usage
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.22
]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22
array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@ mydomain.com"}
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans < tom.laermans@powersource.cx> wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
By default it should run at the end of poller-wrapper.py, if you have that already in cron (no one should have poller.php directly in cron anymore)
adam. On 01/08/2016 10:53:44, Laurence Mayer laurence@istraresearch.com wrote: I think I got it, this should run in cron ?
On Mon, Aug 1, 2016 at 6:42 PM, Laurence Mayer <laurence@istraresearch.com [mailto:laurence@istraresearch.com]> wrote:
Yep, I did.
I am obviously missing something, where/how am I supposed to run alerter.php?
I have defined a contact etc, but where am I to add alerter.php?
Thanks Laurence
On Mon, Aug 1, 2016 at 6:39 PM, Adam Armstrong <adama@memetic.org [mailto:adama@memetic.org]> wrote:
But didn't you just generate an alert to a contact correctly?
Since there's no problem generating and sending email, the most likely problem is not running alerter.php. Does the alert log show notifications being sent?
adam. On 01/08/2016 00:08:28, Laurence Mayer <laurence@istraresearch.com [mailto:laurence@istraresearch.com]> wrote: Woow Adam you're expecting too much of me.... ; )
I have defined contacts and associated all the alerts to that contact, however when an alert occurs the contact does not receive an alert in email.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:02 AM, Adam Armstrong <adama@memetic.org [mailto:adama@memetic.org]> wrote:
That all looks fine to me. So what isn't working? You are running poller wrapper, and it's executing alerter.php, right? Adam. Sent from BlueMail [http://www.bluemail.me/r]
On 31 Jul 2016, at 23:30, Laurence Mayer <laurence@istraresearch.com [mailto:laurence@istraresearch.com]> wrote: Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify [http://observiumsrv.istraresearch.com/device/device=9/tab=alert/] Alert Memory is above 75% Entity I/O [http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=memp...] Metrics Duration Unknown Device Device cisco1g1 [http://observiumsrv.istraresearch.com/device/device=9/] Hardware WS-C2960X-48TS-L Operating System Cisco IOS 15.2(2)E3 UNIVERSALK9 Location ISRAEL Uptime 204 days, 9h 16m 13s mempool_usage
-------------------------------------------------------------------------------------------------------------------------
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com [http://observiumsrv.mydomain.com] ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker <tobi@oetiker.ch [mailto:tobi@oetiker.ch]> ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0] CMD RUNTIME[0.0133s] STDOUT[ Apache/2.2.22 ]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22 ============================================================ array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@mydomain.com [http://mydomain.com%5D%22%7D
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans <tom.laermans@powersource.cx [mailto:tom.laermans@powersource.cx]> wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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 [mailto: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 [http://jira.observium.org/browse/OBSERVIUM-1947]
On Jul 31, 2016 8:20 AM, "Laurence Mayer" <laurence@istraresearch.com [mailto: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@ [mailto:laurence@istraresearch.com]mydomain.com [http://mydomain.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 [mailto: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 [http://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 [mailto: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 [http://mydomain.com/%5D%22%7D
SQL[UPDATE `alert_log` set `notified` ='1' WHERE `event_id` = ''] SQL RUNTIME[0.00025702s]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Ok got it thank you.
On Mon, Aug 1, 2016 at 7:05 PM, Adam Armstrong adama@memetic.org wrote:
By default it should run at the end of poller-wrapper.py, if you have that already in cron (no one should have poller.php directly in cron anymore)
adam.
On 01/08/2016 10:53:44, Laurence Mayer laurence@istraresearch.com wrote: I think I got it, this should run in cron ?
On Mon, Aug 1, 2016 at 6:42 PM, Laurence Mayer <laurence@istraresearch.com
wrote:
Yep, I did.
I am obviously missing something, where/how am I supposed to run alerter.php?
I have defined a contact etc, but where am I to add alerter.php?
Thanks Laurence
On Mon, Aug 1, 2016 at 6:39 PM, Adam Armstrong adama@memetic.org wrote:
But didn't you just generate an alert to a contact correctly?
Since there's no problem generating and sending email, the most likely problem is not running alerter.php. Does the alert log show notifications being sent?
adam.
On 01/08/2016 00:08:28, Laurence Mayer laurence@istraresearch.com wrote: Woow Adam you're expecting too much of me.... ; )
I have defined contacts and associated all the alerts to that contact, however when an alert occurs the contact does not receive an alert in email.
Thanks Laurence
On Mon, Aug 1, 2016 at 8:02 AM, Adam Armstrong adama@memetic.org wrote:
That all looks fine to me. So what isn't working?
You are running poller wrapper, and it's executing alerter.php, right?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 31 Jul 2016, at 23:30, Laurence Mayer laurence@istraresearch.com wrote:
Hi Tom,
: )
The test email indeed looks better now.
Here you go:
Regards Laurence
ALERT Modify http://observiumsrv.istraresearch.com/device/device=9/tab=alert/ *Alert* Memory is above 75% *Entity* I/O http://observiumsrv.istraresearch.com/device/device=9/tab=health/metric=mempool/ *Metrics* *Duration* Unknown Device *Device* cisco1g1 http://observiumsrv.istraresearch.com/device/device=9/ *Hardware* WS-C2960X-48TS-L *Operating System* Cisco IOS 15.2(2)E3 UNIVERSALK9 *Location* ISRAEL *Uptime* 204 days, 9h 16m 13s mempool_usage
./test_alert.php -a 610 -d DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00007391s]
SQL[SELECT * FROM `config`] SQL RUNTIME[0.00006008s]
CMD[/bin/hostname -f]
EXITCODE[0] CMD RUNTIME[0.0016s] STDOUT[ observiumsrv.mydomain.com ] Observium CE 0.16.1.7533 Test Alert Notification
CMD[/opt/observium-old/scripts/distro]
EXITCODE[0] CMD RUNTIME[0.0422s] STDOUT[ Linux|3.5.0-23-generic|amd64|Ubuntu|12.04 ]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.3 ]
SQL[SELECT version();] SQL RUNTIME[0.00017905s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.4.3 ]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker tobi@oetiker.ch ]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015211s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.22
]
SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00015807s]
SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00042200s]
##### 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 Monday, 01-Aug-16 07:25:58 IDT o PHP +03:00 o MySQL +03:00
SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00008488s] Cached 12 alert rules.
SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00009799s]
SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = '610'] SQL RUNTIME[0.00036001s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9'] SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '9'] SQL RUNTIME[0.00026083s]
SQL[SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `mempools`.`mempool_id` = '32'] SQL RUNTIME[0.00022411s]
$graphtype - /opt/observium-old/includes/alerts.inc.php:1152
/opt/observium-old/html/includes/graphs/graph.inc.php:22
array( [0] => string(13) "mempool_usage" [type] => string(7) "mempool" [1] => string(7) "mempool" [subtype] => string(5) "usage" [2] => string(5) "usage" )
SQL[SELECT * FROM `mempools` AS C, `devices` AS D where C.`mempool_id` = '32' AND C.device_id = D.device_id] SQL RUNTIME[0.00031090s]
RRD CMD[graph /tmp/sDctqGPQ0BYSK5ig.png -g -Y --alt-autoscale --rigid --start 1469852758 --end 1470025558 --width 400 --height 150 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -u 100 -l 0 -E -b 1024 COMMENT:' Total Used Free\l' DEF:32used=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:used:AVERAGE DEF:32free=/opt/observium-old/rrd/cisco1g1/mempool-cisco-memory-pool-mib-2.rrd:free:AVERAGE CDEF:32size=32used,32free,+ CDEF:32perc=32used,32size,/,100,* CDEF:32percx=100,32perc,- AREA:32perc#7fbc41: LINE1.25:32perc#4d9221:'I/O ' GPRINT:32size:LAST:.2lf%sB GPRINT:32used:LAST:.2lf%sB GPRINT:32free:LAST:.2lf%sB COMMENT:'\l' COMMENT:' ' GPRINT:32perc:LAST:'.2lf% ' GPRINT:32percx:LAST:'.2lf% ' COMMENT:'\l'] RRD RUNTIME[0.031s] RRD STDOUT[481x189] RRD_STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '9' AND `attrib_type` = 'disable_notify'] SQL RUNTIME[0.00014210s]
SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '3');] SQL RUNTIME[0.00039101s] o Notifying [email] Laurence Mayer: {"email":"laurence@ mydomain.com"}
On Sun, Jul 31, 2016 at 8:50 PM, Tom Laermans < tom.laermans@powersource.cx> wrote:
Laurence,
That's why you need to use the test_alert script (correctly) so it might give you something more to go on :-)
Tom
On 31/07/2016 19:37, Laurence Mayer wrote:
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 > >
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (4)
-
Adam Armstrong -
Cody Cook -
Laurence Mayer -
Tom Laermans