Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-1569

ERROR[Error in query: (Incorrect table name '') 1103]

    XMLWordPrintable

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

              1. 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

              1. MySQL mode #####

      o MySQL

              1. Charset info #####

      o PHP UTF-8
      o MySQL utf8

              1. 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

              1. 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

              1. MySQL mode #####

      o MySQL

              1. Charset info #####

      o PHP UTF-8
      o MySQL utf8

              1. 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]

              1. 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

              1. MySQL mode #####

      o MySQL

              1. Charset info #####

      o PHP UTF-8
      o MySQL utf8

              1. 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.

      Attachments

        Activity

          People

            adama Adam Armstrong
            michael.findlay@1clickcloud.net Michael Findlay
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: