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

Alert

Entity

Metrics

Duration Unknown

Device

Device

Hardware

Operating System

Location

Uptime Never polled

E-mail sent to: laurence@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"}

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 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