Details
-
Bug
-
Resolution: Fixed
-
Major
-
None
-
Professional Edition
-
None
-
Debian / Apache/ PHP 5.5.9
Description
Unable to send e-mails due to the following -
Observium 0.15.11.7203
Test Alert Notification
-
-
-
-
- Software versions #####
-
-
-
o OS Linux 3.13.0-32-generic [amd64] (Ubuntu 14.04)
o Apache 2.4.7
o PHP 5.5.9-1ubuntu4.14
o Python 2.7.6
o MySQL 5.5.46-0ubuntu0.14.04.2 (extension: mysql 5.5.46)
o SNMP NET-SNMP 5.7.2
o RRDtool 1.4.7
-
-
-
-
- MySQL mode #####
-
-
-
o MySQL
-
-
-
-
- Charset info #####
-
-
-
o PHP UTF-8
o MySQL utf8
-
-
-
-
- Timezones info #####
-
-
-
o Date Thursday, 19-Nov-15 17:09:38 UTC
o PHP +00:00
o MySQL +00:00
USAGE:
test_alert.php -a alert_entry [-d debug]
Flags
-d Turn on debug output
-dd More verbose debug output
Options
-a Send test notification to for an alert entry [default: <alert entry id>]
root@cnm-mon1:/opt/observium# php test_alert.php -a root_full ns.1clickcloud.net
Observium 0.15.11.7203
Test Alert Notification
-
-
-
-
- Software versions #####
-
-
-
o OS Linux 3.13.0-32-generic [amd64] (Ubuntu 14.04)
o Apache 2.4.7
o PHP 5.5.9-1ubuntu4.14
o Python 2.7.6
o MySQL 5.5.46-0ubuntu0.14.04.2 (extension: mysql 5.5.46)
o SNMP NET-SNMP 5.7.2
o RRDtool 1.4.7
-
-
-
-
- MySQL mode #####
-
-
-
o MySQL
-
-
-
-
- Charset info #####
-
-
-
o PHP UTF-8
o MySQL utf8
-
-
-
-
- Timezones info #####
-
-
-
o Date Thursday, 19-Nov-15 17:09:49 UTC
o PHP +00:00
o MySQL +00:00
root@cnm-mon1:/opt/observium# php test_alert.php -d -a root_full ns.1clickcloud.net
DEBUG!
SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00010109s]
CMD[/bin/hostname -f]
EXITCODE[0]
CMD RUNTIME[0.0017s]
STDOUT[
cnm-mon1
]
Observium 0.15.11.7203
Test Alert Notification
CMD[/opt/observium/scripts/distro]
EXITCODE[0]
CMD RUNTIME[0.0537s]
STDOUT[
Linux|3.13.0-32-generic|amd64|Ubuntu|14.04
]
CMD[/usr/bin/env python --version 2>&1]
EXITCODE[0]
CMD RUNTIME[0.002s]
STDOUT[
Python 2.7.6
]
SQL[SELECT version();]
SQL RUNTIME[0.00013399s]
CMD[/usr/bin/snmpget --version 2>&1]
EXITCODE[0]
CMD RUNTIME[0.002s]
STDOUT[
NET-SNMP version: 5.7.2
]
CMD[/usr/bin/rrdtool --version |head -n1]
EXITCODE[0]
CMD RUNTIME[0.0045s]
STDOUT[
RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker <tobi@oetiker.ch>
]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00011802s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/
{print $3}']
EXITCODE[0]
CMD RUNTIME[0.0363s]
STDOUT[
Apache/2.4.7
]
SQL[SELECT @@sql_mode;]
SQL RUNTIME[0.00011611s]
SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00041199s]
-
-
-
-
- Software versions #####
-
-
-
o OS Linux 3.13.0-32-generic [amd64] (Ubuntu 14.04)
o Apache 2.4.7
o PHP 5.5.9-1ubuntu4.14
o Python 2.7.6
o MySQL 5.5.46-0ubuntu0.14.04.2 (extension: mysql 5.5.46)
o SNMP NET-SNMP 5.7.2
o RRDtool 1.4.7
-
-
-
-
- MySQL mode #####
-
-
-
o MySQL
-
-
-
-
- Charset info #####
-
-
-
o PHP UTF-8
o MySQL utf8
-
-
-
-
- Timezones info #####
-
-
-
o Date Thursday, 19-Nov-15 17:10:13 UTC
o PHP +00:00
o MySQL +00:00
SQL[SELECT * FROM `alert_tests` WHERE 1]
SQL RUNTIME[0.00006795s]
Cached 7 alert rules.
SQL[SELECT * FROM `alert_assoc`]
SQL RUNTIME[0.00006199s]
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` = 'root_full']
SQL RUNTIME[0.00026393s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '']
SQL RUNTIME[0.00007510s]
SQL[SELECT * FROM `` WHERE ``.`` = '']
SQL RUNTIME[0.00006104s]
ERROR[Error in query: (Incorrect table name '') 1103]
Have attempted with smtp, sendmail and mail.