ok, please post another screenshot/check the error logs again.
Hello, dnsmichi.
As mentioned on yesterday, the only problem is the "hosts & Service IN TOTAL" does not show the data. But when I check it on today, the "hosts & Service IN TOTAL" does show all the services and hosts that's monitored by icinga.
Please see the following screenshot & log files.
Once again, thanks dnsmichi and also Vismon!
Have a nice day!
Regards,
Icinga-web 1.2.0 (problem solved)
/var/log/httpd/error_log (see the last line of the log, error for today)
[Thu Oct 21 13:43:14 2010] [notice] caught SIGTERM, shutting down
[Thu Oct 21 13:43:15 2010] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Oct 21 13:43:15 2010] [notice] Digest: generating secret for digest authentication ...
[Thu Oct 21 13:43:15 2010] [notice] Digest: done
PHP Warning: PHP Startup: rrdtool: Unable to initialize module\nModule compiled with module API=20050922\nPHP compiled with module API=20090626\nThese options need to match\n in Unknown on line 0
[Thu Oct 21 13:43:15 2010] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 configured -- resuming normal operations
[Thu Oct 21 17:02:22 2010] [error] [client 192.168.164.200] File does not exist: /var/www/html/favicon.ico
[Thu Oct 21 17:06:32 2010] [error] [client 192.168.164.200] File does not exist: /var/www/html/favicon.ico
[Thu Oct 21 17:08:36 2010] [error] [client 192.168.164.200] File does not exist: /var/www/html/favicon.ico
[Fri Oct 22 09:32:00 2010] [error] [client 192.168.164.200] File does not exist: /var/www/html/favicon.ico
/usr/local/icinga/share/icinga-api/log/icingaApi.log
2010-10-21T09:13:09+00:00 - [EXCEPTION] getColumn(): Unknown column "HOST_IS_PENDING"!
2010-10-21T09:13:09+00:00 - [EXCEPTION] getColumn(): Unknown column "HOST_IS_PENDING"!
2010-10-21T09:13:39+00:00 - [EXCEPTION] getColumn(): Unknown column "HOST_IS_PENDING"! <---- Problem until here!
2010-10-21T09:18:01+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_CRLHNYKVQXMIOFASTDBJGEUPZ in the query.
2010-10-21T09:18:01+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_FZCXTNBQGLOIDKUMSHVPJREAY in the query.
2010-10-21T09:18:01+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_SFTRMCPEVQKDZHGXBLUAOJYNI in the query.
A lot of entries between this....All line tagged with [WARNING]
2010-10-22T01:35:05+00:00 - [WARNING] Column STATEHISTORY_MAX_CHECK_ATTEMPTS is too long, will be COL_QMJZYRGPDKFEXNBTOIVCLHUAS in the query.
2010-10-22T01:36:07+00:00 - [WARNING] Column SERVICE_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_YCZSFGJADXEHQRINLKVUPBOTM in the query.
2010-10-22T01:36:07+00:00 - [WARNING] Column SERVICE_SCHEDULED_DOWNTIME_DEPTH is too long, will be COL_RJDAQEMGYSVLFIOKZNBCHTUXP in the query.
2010-10-22T01:36:08+00:00 - [WARNING] Column SERVICE_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_KSHRVTFBCQNUZIXJPDYALGOME in the query.
2010-10-22T01:36:08+00:00 - [WARNING] Column SERVICE_SCHEDULED_DOWNTIME_DEPTH is too long, will be COL_SMUANYCFBZTVRHXOQLEIJGPDK in the query.
2010-10-22T01:36:16+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_ICJGMZEAKTBVQFHDYSNLUOXRP in the query.
2010-10-22T01:36:16+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_ITSOLNXQCGPUKVFDJMYZBHAER in the query.
2010-10-22T01:36:16+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_CKXPNLDMHSYOTQUIGRJVFZABE in the query.
2010-10-22T01:36:16+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_QKVZCBDNPAGTOXMYFLIEJUSHR in the query.
2010-10-22T01:36:16+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_ASQLNGECJBVPKXTIHZODMYURF in the query.
2010-10-22T01:36:16+00:00 - [WARNING] Column HOST_PROBLEM_HAS_BEEN_ACKNOWLEDGED is too long, will be COL_OBLDHQYKCFGJVRTNMZXUAPSIE in the query.
/usr/local/icinga-web/app/data/log/debug-2010-10-22.log
[Fri Oct 22 01:31:56 2010] [debug] Auth.Provider: Object (name=internal) initialized
[Fri Oct 22 01:31:56 2010] [debug] Auth.Provider: Object (name=http-basic-authentication) initialized
[Fri Oct 22 01:31:56 2010] [debug] Auth.Provider.HTTPBasicAuthentification: Got data (auth_name=, auth_type

[Fri Oct 22 01:32:05 2010] [debug] Auth.Dispatch: Starting authenticate (username=root)
[Fri Oct 22 01:32:05 2010] [debug] Auth.Dispatch: Userdata found in db (uid=1)
[Fri Oct 22 01:32:05 2010] [debug] Auth.Provider: Object (name=internal) initialized
[Fri Oct 22 01:32:05 2010] [debug] Auth.Dispatch: Authoritative provider found (provider=internal, authid=root)
[Fri Oct 22 01:32:05 2010] [debug] Auth.Dispatch: Successfull authentication (provder=internal)
[Fri Oct 22 01:32:05 2010] [info] User root (Root, Enoch) logged in!
/usr/local/icinga-web/app/data/log/icinga-web-2010-10-21.log No log file for 2010-10-22 (icinga-web-2010-10-22.log)
[Thu Oct 21 09:08:53 2010] [fatal] Uncaught AppKitPHPError: PHP Error Undefined index: host_service (/usr/local/icinga/share/icinga-api/objects/search/IcingaApiSearchIdo.php:474) (/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Thu Oct 21 09:08:53 2010] [fatal] Uncaught AppKitPHPError: PHP Error Undefined index: host_service (/usr/local/icinga/share/icinga-api/objects/search/IcingaApiSearchIdo.php:474) (/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Thu Oct 21 09:13:06 2010] [fatal] Uncaught AppKitPHPError: PHP Error Undefined index: host_service (/usr/local/icinga/share/icinga-api/objects/search/IcingaApiSearchIdo.php:474) (/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Thu Oct 21 09:13:07 2010] [fatal] Uncaught AppKitPHPError: PHP Error Undefined index: host_service (/usr/local/icinga/share/icinga-api/objects/search/IcingaApiSearchIdo.php:474) (/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Thu Oct 21 09:13:09 2010] [fatal] Uncaught AppKitPHPError: PHP Error ob_end_clean(): failed to delete buffer. No buffer to delete. (/usr/local/icinga-web/lib/agavi/src/exception/AgaviException.class.php:249) (/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Thu Oct 21 09:13:09 2010] [fatal] Uncaught AppKitPHPError: PHP Error ob_end_clean(): failed to delete buffer. No buffer to delete. (/usr/local/icinga-web/lib/agavi/src/exception/AgaviException.class.php:249) (/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Thu Oct 21 09:13:39 2010] [fatal] Uncaught AppKitPHPError: PHP Error Undefined index: host_service (/usr/local/icinga/share/icinga-api/objects/search/IcingaApiSearchIdo.php:474) (/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Thu Oct 21 09:13:39 2010] [fatal] Uncaught AppKitPHPError: PHP Error ob_end_clean(): failed to delete buffer. No buffer to delete. (/usr/local/icinga-web/lib/agavi/src/exception/AgaviException.class.php:249) (/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)