Hi Chris,

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