Announcement

Collapse
No announcement yet.

Blank page when I click on a service

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Blank page when I click on a service

    Hi all,
    I have an issue where I get a blank page when I click on a service under monitoring.

    For example, this URL:
    http://hostserver/centreon/main.php?...on=someservice


    Has anyone else seen this issue? Where should I look first to resolve this?
    Last edited by hybrid; 26 January 2010, 23:49.

  • #2
    And what error.log of Apache says ?
    Auteur de Shinken, outil de supervision compatible avec Nagios et orientée supervision distribuée hautement disponible et mulitplateforme.

    Comment


    • #3
      It looks like there might be an sql error.
      sh: /usr/local/centreon/log//error-sql-2010-01-26.log: Permission denied

      -rw-r--r-- 1 nagios nagios 23763 Jan 26 08:52 error-sql-2010-01-26.log

      Comment


      • #4
        When I get the blank page, I see this in my centreon sql log:

        10:09|0|0|DB Error: no such table QUERY : SELECT DISTINCT host_name, service_description FROM centreon_acl


        But this table does exist, and I can run this query in phpmyadmin and the query works fine.

        I put a dummy line in that table and then did this query using the centreon user:
        mysql> SELECT DISTINCT host_name, service_description FROM centreon_acl;
        +----------------+---------------------+
        | host_name | service_description |
        +----------------+---------------------+
        | Oberg_SBS_2003 | Win32-Check_Drive_F |
        +----------------+---------------------+
        1 row in set (0.00 sec)

        Comment


        • #5
          Ok, I fixed this problem.
          Tables were missing from my dbo database.
          I ran the createNDODB.sql script on the dbo database and its fixed.

          Comment

          Working...
          X