[op5-users] Errors on ninja
Pier
pierg75 at yahoo.it
Mon Oct 19 14:35:58 CEST 2009
Hi.
Since last week, i had some error with the latest version of ninja (cvs).
When i go to "Host Problems" i get this:
Database Error
A database error occurred while performing the requested procedure. Please review the database error below for more information.
/etc/nagios/addons/ninja/system/libraries/drivers/Database/Mysql.php [367]:
There was an SQL error: Unknown column 'auth_host.current_state' in 'where clause' - SELECT h.id AS host_id, h.host_name, h.address, h.alias, h.current_state, h.last_check, h.next_check, h.should_be_scheduled, h.notes_url, h.notifications_enabled, h.active_checks_enabled, h.icon_image, h.icon_image_alt, h.is_flapping, h.action_url, (UNIX_TIMESTAMP() - h.last_state_change) AS duration, UNIX_TIMESTAMP() AS cur_time, h.current_attempt, h.max_check_attempts, h.problem_has_been_acknowledged, h.scheduled_downtime_depth, h.output FROM host h WHERE 1 AND 1 << auth_host.current_state & 6 ORDER BY host_name ASC
and the the stack trace.
Then under the "Service Problems" i get an empty page when i should see some services down (in the Tactical Overview it show many problems).
In the services detail it shows me only the services from nagios (localhost)...i should see more then 1000 services.
Thanks
Pier
More information about the op5-users
mailing list