On 20.05.2014 14:33, el majdoubi Driss wrote:
I'm not able to see any information on my icinga-web interface . i have
installed icinga2 and icinga-web.In my icinga-web interface i get an
error "icinga is currently reloading".
when i've checked my log file (/var/log/icinga2/icinga2.log) i've found
this:[PN6icinga12ContextTraceE] =
         (0) Reconnecting to MySQL IDO database 'ido-mysql'

[PN6icinga16errinfo_message_E] = Unknown column 'is_reachable' in 'field
list'

Mhm. Did you upgrade the db schema with 0.0.11? That column was added with that specific milestone.



[PN6icinga23errinfo_database_query_E] = UPDATE icinga_servicestatus SET
acknowledgement_type = '0',  active_checks_enabled = '1',  check_command
= 'disk',  check_source = 'localhost',  check_type = '0',
current_check_attempt = '1',  current_notification_number = '2',
current_state = '2',  event_handler = '',  event_handler_enabled = '0',
execution_time = '0.022823810577392578',  flap_detection_enabled = '1',
has_been_checked = '1',  instance_id = 1,  is_flapping = '0',
is_reachable = '1',  last_check = FROM_UNIXTIME(1400487153),
last_hard_state_change = FROM_UNIXTIME(1400485503),  last_notification =
FROM_UNIXTIME(1400487083),  last_state_change =
FROM_UNIXTIME(1400485413),  last_time_critical =
FROM_UNIXTIME(1400487153),  last_time_ok = FROM_UNIXTIME(1400485353),
last_time_unknown = FROM_UNIXTIME(1399974076),  latency = '0',
long_output = '',  max_check_attempts = '3',
modified_service_attributes = '0',  next_check =
FROM_UNIXTIME(1400487213),  next_notification =
FROM_UNIXTIME(1400488883),  normal_check_interval = '1',
notifications_enabled = '1',  output = 'DISK CRITICAL - /root/.gvfs is
not accessible: Permission denied',  passive_checks_enabled = '1',
percent_state_change = '0',  perfdata = '',
problem_has_been_acknowledged = '0',  process_performance_data = '1',
retry_check_interval = '0.5',  scheduled_downtime_depth = '0',
service_object_id = 31,  should_be_scheduled = '1',  state_type = '1',
status_update_time = FROM_UNIXTIME(1400487208) WHERE service_object_id = 31

[2014-05-19 10:13:32 +0200] <Q #0x8b3ac4 W #0x8b3b7c> information/base:
Running command '/usr/lib/nagios/plugins/check_ssh 127.0.0.1': PID 11041
[2014-05-19 10:13:33 +0200] <Q #0x8b3d3c W #0x8b3df4> information/base:
Running command '/usr/lib/nagios/plugins/check_disk -c 10% -w 20%': PID
11084
[2014-05-19 10:13:36 +0200] <Q #0x8b3ac4 W #0x8b3b7c> information/base:
Running command '/usr/lib/nagios/plugins/check_ping -4 -H 127.0.0.1 -c
200,15% -w 100,5%': PID 11240
[2014-05-19 10:13:36 +0200] <Q #0x8b3fb4 W #0x8b406c> information/base:
Running command '/usr/lib/nagios/plugins/check_users -c 50 -w 20': PID 11242
[2014-05-19 10:13:37 +0200] <WQ #2> information/db_ido_mysql: MySQL IDO
instance id: 1 (schema version: '1.11.0')
[2014-05-19 10:13:38 +0200] <WQ #2> critical/db_ido_mysql: Exception
during database operation:
/home/abuild/rpmbuild/BUILD/icinga2-abuild/components/db_ido_mysql/idomysqlconnection.cpp(294):
Throw in function icinga::IdoMysqlResult
icinga::IdoMysqlConnection::Query(const icinga::String&)
Dynamic exception type:
N5boost16exception_detail10clone_implIN6icinga14database_errorEEE
std::exception::what: std::exception


_______________________________________________
icinga-users mailing list
[email protected]
https://lists.icinga.org/mailman/listinfo/icinga-users



--
DI (FH) Michael Friedrich

[email protected]  || icinga open source monitoring
https://twitter.com/dnsmichi || lead core developer
[email protected]       || https://www.icinga.org/team
irc.freenode.net/icinga      || dnsmichi
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.icinga.org/mailman/listinfo/icinga-users

Reply via email to