email alerts not working after update to r8661
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
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
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
You can ignore that table column, it shouldn't really be there :)
Thanks, Adam.
Sent from BlueMail
On 15 Jun 2017, 14:03, at 14:03, Chris Smith csmith@vailsys.com wrote:
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
]
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
participants (2)
-
Adam Armstrong -
Chris Smith