Updated to r8663.

Email alerts are working now, however the Alert Log still says Notified: No, rather than Notified: Ok.

test_alert.php run with r8663 if thats helpful:

observium]$ sudo -u apache ./test_alert.php -a 35069 -dd
DEBUG!
Load class 'Console_Color2' from '/u1/observium/libs/pear/Console/Color2.php': OK

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
ROWS[1]
SQL RUNTIME[0.00011396s]

SQL[SELECT @@SESSION.sql_mode;]
ROWS[1]
SQL RUNTIME[0.00033212s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
ROWS[1]
SQL RUNTIME[0.00008202s]

SQL[SELECT * FROM `config`]
ROWS[0]
SQL RUNTIME[0.00009298s]
Load class 'Net_IPv6' from '/u1/observium/libs/pear/Net/IPv6.php': OK
CACHE DISABLED. Disabled in config.
Observium 17.6.8663
Test Alert Notification


CMD[/u1/observium/scripts/distro]

Wrong process status! Issue in proc_get_status(), see: https://bugs.php.net/bug.php?id=69014
CMD EXITCODE[0]
CMD RUNTIME[0.0165s]
STDOUT[
Linux|2.6.32-642.13.1.el6.x86_64|amd64|CentOS|6.8|none
]

CMD[/usr/bin/env python --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0025s]
STDOUT[
Python 2.6.6
]

SQL[SELECT version();]
ROWS[1]
SQL RUNTIME[0.00018191s]

CMD[/usr/bin/snmpget --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0023s]
STDOUT[
NET-SNMP version: 5.5
]

CMD[/usr/bin/rrdtool --version | head -n1]

CMD EXITCODE[0]
CMD RUNTIME[0.0027s]
STDOUT[
RRDtool 1.3.8  Copyright 1997-2009 by Tobias Oetiker <tobi@oetiker.ch>
]

CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.0021s]
STDOUT[

]

CMD[/usr/sbin/httpd -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.0133s]
STDOUT[
Apache/2.2.15
]

CMD[date "+%:z"]

Wrong process status! Issue in proc_get_status(), see: https://bugs.php.net/bug.php?id=69014
CMD EXITCODE[0]
CMD RUNTIME[0.002s]
STDOUT[
-04:00
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
ROWS[1]
SQL RUNTIME[0.00029492s]

SQL[SELECT @@SESSION.sql_mode;]
ROWS[1]
SQL RUNTIME[0.00012898s]

SQL[SHOW VARIABLES LIKE 'character_set_connection']
ROWS[1]
SQL RUNTIME[0.00047493s]

#####  Software versions  #####

 o OS                   Linux 2.6.32-642.13.1.el6.x86_64 [amd64] (CentOS 6.8)
 o Apache               2.2.15
 o PHP                  5.6.30
 o Python               2.6.6
 o MySQL                5.1.73 (extension: mysqli 5.0.11-dev)
 o SNMP                 NET-SNMP 5.5
 o RRDtool              1.3.8

#####  Memory Limit  #####

 o PHP                  256B

#####  MySQL mode  #####

 o MySQL               

#####  Charset info  #####

 o PHP                  UTF-8
 o MySQL                utf8

#####  Timezones info  #####

 o Date                 Thursday, 15-Jun-17 08:24:37 EDT
 o PHP                  -04:00
 o MySQL                -04:00


SQL[SELECT * FROM `alert_tests` WHERE 1]
ROWS[18]
SQL RUNTIME[0.00015497s]
Cached 18 alert rules.

SQL[SELECT * FROM `alert_assoc`]
ROWS[37]
SQL RUNTIME[0.00014997s]

SQL[SELECT * FROM `alert_table` WHERE `alert_table_id` = '35069']
ROWS[1]
SQL RUNTIME[0.00024605s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '84']
ROWS[1]
SQL RUNTIME[0.00027514s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '84']
ROWS[21]
SQL RUNTIME[0.00041890s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '2966']
ROWS[1]
SQL RUNTIME[0.00036597s]


 > $graphtype /u1/observium/html/includes/graphs/graph.inc.php:33
array(
  [0]       => string(9) "port_bits"
  [type]    => string(4) "port"
  [1]       => string(4) "port"
  [subtype] => string(4) "bits"
  [2]       => string(4) "bits"
)

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '2966']
ROWS[1]
SQL RUNTIME[0.00021720s]
Load class 'Net_IPv4' from '/u1/observium/libs/pear/Net/IPv4.php': OK
RRD PIPE OPEN[TRUE]
RRD PIPE CLOSE[TRUE]
RRD PIPE STDOUT[
OK u:0.02 s:0.00 r:0.03

]

RRD CMD[graph /tmp/It9xZfS5QTXpo0SI.png  <rrd_cmd_text_removed....>]
RRD RUNTIME[0.0314s]
RRD STDOUT[481x204]
RRD_STATUS[TRUE]


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '84' AND `attrib_type` = 'disable_notify']
ROWS[0]
SQL RUNTIME[0.00041604s]

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` = '19');]
ROWS[0]
SQL RUNTIME[0.00025988s]

SQL[INSERT INTO `notifications_queue` (<notifications_queue_sql_removed...>)]
ROWS[1]
SQL RUNTIME[0.00322795s]
 o Queueing Notification  [42]

SQL[SELECT * FROM `notifications_queue` WHERE 1]
ROWS[1]
SQL RUNTIME[0.00019407s]

SQL[SELECT `notification_locked` FROM `notifications_queue` WHERE `notification_id` = '42']
ROWS[1]
SQL RUNTIME[0.00026488s]

SQL[UPDATE `notifications_queue` set `notification_locked` ='1' WHERE `notification_id` = '42']
ROWS[1]
SQL RUNTIME[0.00019312s]
 o Notifying            [email] : {"email":"<internal_alert_distro_email_editedout"}
Load class 'Mail_mime' from '/u1/observium/libs/pear/Mail/mime.php': OK
Load class 'Mail' from '/u1/observium/libs/pear/Mail/Mail.php': OK
PHP Strict Standards:  Only variables should be assigned by reference in /u1/observium/includes/alerting/email.inc.php on line 179

Strict Standards: Only variables should be assigned by reference in /u1/observium/includes/alerting/email.inc.php on line 179

SQL[DELETE FROM `notifications_queue` WHERE `notification_id` = '42']
ROWS[1]
SQL RUNTIME[0.00032091s]

On 06/14/2017 07:29 PM, Adam Armstrong wrote:
Hi Chris,

Could you try in r8662?

Thanks,
adam.

On 15/06/2017 00:55:43, Chris Smith <csmith@vailsys.com> wrote:

After we update Observium subscription version from r8637 to r8661 emailed alerts are no longer working.

Alerts are still logged in the alert log, however the "Notified" status says "No" and no emails are generated.

Used the test_alert.php util and at the bottom it ends with an error about a missing include.

Output:

observium]$ sudo -u apache ./test_alert.php -a 35069 -dd

DEBUG!
Load class 'Console_Color2' from '/u1/observium/libs/pear/Console/Color2.php': OK

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
ROWS[1]
SQL RUNTIME[0.00008607s]

SQL[SELECT @@SESSION.sql_mode;]
ROWS[1]
SQL RUNTIME[0.00008798s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
ROWS[1]
SQL RUNTIME[0.00027394s]

SQL[SELECT * FROM `config`]
ROWS[0]
SQL RUNTIME[0.00005698s]
Load class 'Net_IPv6' from '/u1/observium/libs/pear/Net/IPv6.php': OK
CACHE DISABLED. Disabled in config.
Observium 17.6.8661
Test Alert Notification


CMD[/u1/observium/scripts/distro]

Wrong process status! Issue in proc_get_status(), see: https://bugs.php.net/bug.php?id=69014
CMD EXITCODE[0]
CMD RUNTIME[0.0379s]
STDOUT[
Linux|2.6.32-642.13.1.el6.x86_64|amd64|CentOS|6.8|none
]

CMD[/usr/bin/env python --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0213s]
STDOUT[
Python 2.6.6
]

SQL[SELECT version();]
ROWS[1]
SQL RUNTIME[0.00012589s]

CMD[/usr/bin/snmpget --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0038s]
STDOUT[
NET-SNMP version: 5.5
]

CMD[/usr/bin/rrdtool --version | head -n1]

CMD EXITCODE[0]
CMD RUNTIME[0.0046s]
STDOUT[
RRDtool 1.3.8  Copyright 1997-2009 by Tobias Oetiker <tobi@oetiker.ch>
]

CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.0089s]
STDOUT[

]

CMD[/usr/sbin/httpd -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.0409s]
STDOUT[
Apache/2.2.15
]

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0127s]
CMD EXITDELAY[10ms]
STDOUT[
-04:00
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
ROWS[1]
SQL RUNTIME[0.00018001s]

SQL[SELECT @@SESSION.sql_mode;]
ROWS[1]
SQL RUNTIME[0.00011206s]

SQL[SHOW VARIABLES LIKE 'character_set_connection']
ROWS[1]
SQL RUNTIME[0.00039697s]

#####  Software versions  #####

 o OS                   Linux 2.6.32-642.13.1.el6.x86_64 [amd64] (CentOS 6.8)
 o Apache               2.2.15
 o PHP                  5.6.30
 o Python               2.6.6
 o MySQL                5.1.73 (extension: mysqli 5.0.11-dev)
 o SNMP                 NET-SNMP 5.5
 o RRDtool              1.3.8

#####  Memory Limit  #####

 o PHP                  256B

#####  MySQL mode  #####

 o MySQL               

#####  Charset info  #####

 o PHP                  UTF-8
 o MySQL                utf8

#####  Timezones info  #####

 o Date                 Wednesday, 14-Jun-17 19:37:27 EDT
 o PHP                  -04:00
 o MySQL                -04:00


SQL[SELECT * FROM `alert_tests` WHERE 1]
ROWS[18]
SQL RUNTIME[0.00012898s]
Cached 18 alert rules.

SQL[SELECT * FROM `alert_assoc`]
ROWS[37]
SQL RUNTIME[0.00009298s]

SQL[SELECT * FROM `alert_table` WHERE `alert_table_id` = '35069']
ROWS[1]
SQL RUNTIME[0.00028110s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '84']
ROWS[1]
SQL RUNTIME[0.00022697s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '84']
ROWS[21]
SQL RUNTIME[0.00006294s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '2966']
ROWS[1]
SQL RUNTIME[0.00027490s]


 > $graphtype /u1/observium/html/includes/graphs/graph.inc.php:33
array(
  [0]       => string(9) "port_bits"
  [type]    => string(4) "port"
  [1]       => string(4) "port"
  [subtype] => string(4) "bits"
  [2]       => string(4) "bits"
)

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '2966']
ROWS[1]
SQL RUNTIME[0.00011206s]
Load class 'Net_IPv4' from '/u1/observium/libs/pear/Net/IPv4.php': OK
RRD PIPE OPEN[TRUE]
RRD PIPE CLOSE[TRUE]
RRD PIPE STDOUT[
OK u:0.03 s:0.00 r:0.11

]

RRD CMD[graph /tmp/mTymlIwqPU80Uriu.png  <edited_out_giant_rrd_command.....>]
RRD RUNTIME[0.1122s]
RRD STDOUT[481x204]
RRD_STATUS[TRUE]


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '84' AND `attrib_type` = 'disable_notify']
ROWS[0]
SQL RUNTIME[0.00063896s]

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` = '19');]
ROWS[0]
SQL RUNTIME[0.00005817s]
 o Missing include      /u1/observium/includes/alerting/.inc.php



_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium