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