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

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




ALERTModify
AlertMemory is above 75%
EntityI/O
Metrics
DurationUnknown
Device
Devicecisco1g1
HardwareWS-C2960X-48TS-L
Operating SystemCisco IOS 15.2(2)E3 UNIVERSALK9
LocationISRAEL
Uptime204 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[
]
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
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




_______________________________________________
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