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 [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 [mailto: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