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