On 14 Jul 2009, at 13:38, Spoofov Spoof wrote:
appserv:/usr/local/opsview-web/script$ sudo ./opsview_web_server.pl
You can connect to your server at http://appserv:3000
ERROR - Errors encountered: Caught exception in
Opsview::Web::Controller::Status::Service->default "DBD::mysql::st
execute failed: Lost connection to MySQL server during query [for
Statement "SELECT DISTINCT(opsview_host_services.service_object_id)
as service_object_id, opsview_host_services.hostname as host,
opsview_host_services.host_object_id as host_object_id,
opsview_host_services.icon_filename as icon,
nagios_hoststatus.current_state as host_state,
nagios_hoststatus.is_flapping as host_flapping,
nagios_hoststatus.problem_has_been_acknowledged as
host_acknowledged, (nagios_hoststatus.current_state != 0 and
nagios_hoststatus.problem_has_been_acknowledged != 1 and
nagios_hoststatus.scheduled_downtime_depth = 0) as host_unhandled,
opsview_host_services.servicename as service,
nagios_servicestatus.current_state as service_state,
nagios_servicestatus.is_flapping as service_flapping,
nagios_servicestatus.problem_has_been_acknowledged as
service_acknowledged, nagios_servicestat
us.output as service_output, (nagios_servicestatus.current_state !=
0 and nagios_hoststatus.current_state = 0 and
nagios_hoststatus.scheduled_downtime_depth = 0 and
nagios_servicestatus.problem_has_been_acknowledged!=1 and
nagios_servicestatus.scheduled_downtime_depth = 0) as
service_unhandled, opsview_host_services.perfdata_available as
perfdata_available, nagios_servicestatus.current_check_attempt as
current_check_attempt, nagios_servicestatus.max_check_attempts as
max_check_attempts, CONVERT_TZ(nagios_servicestatus.last_check,
'+00:00', 'SYSTEM') as last_check,
UNIX_TIMESTAMP(nagios_servicestatus.last_state_change) as
last_state_change_timev FROM opsview_host_services,
nagios_hoststatus, nagios_servicestatus WHERE
( ( opsview_host_services.host_object_id =
nagios_hoststatus.host_object_id AND
opsview_host_services.service_object_id =
nagios_servicestatus.service_object_id ) ) ORDER BY host, service"]
at /usr/local/nagios/perl/lib/DBIx/ContextualFetch.pm line 52."
ERROR - Caught exception in
Opsview::Web::Controller::Status::Service->default "DBD::mysql::st
execute failed: Lost connection to MySQL server during query [for
Statement "SELECT DISTINCT(opsview_host_services.service_object_id)
as service_object_id, opsview_host_services.hostname as host,
opsview_host_services.host_object_id as host_object_id,
opsview_host_services.icon_filename as icon,
nagios_hoststatus.current_state as host_state,
nagios_hoststatus.is_flapping as host_flapping,
nagios_hoststatus.problem_has_been_acknowledged as
host_acknowledged, (nagios_hoststatus.current_state != 0 and
nagios_hoststatus.problem_has_been_acknowledged != 1 and
nagios_hoststatus.scheduled_downtime_depth = 0) as host_unhandled,
opsview_host_services.servicename as service,
nagios_servicestatus.current_state as service_state,
nagios_servicestatus.is_flapping as service_flapping,
nagios_servicestatus.problem_has_been_acknowledged as
service_acknowledged, nagios_servicestatus.output as service
_output, (nagios_servicestatus.current_state != 0 and
nagios_hoststatus.current_state = 0 and
nagios_hoststatus.scheduled_downtime_depth = 0 and
nagios_servicestatus.problem_has_been_acknowledged!=1 and
nagios_servicestatus.scheduled_downtime_depth = 0) as
service_unhandled, opsview_host_services.perfdata_available as
perfdata_available, nagios_servicestatus.current_check_attempt as
current_check_attempt, nagios_servicestatus.max_check_attempts as
max_check_attempts, CONVERT_TZ(nagios_servicestatus.last_check,
'+00:00', 'SYSTEM') as last_check,
UNIX_TIMESTAMP(nagios_servicestatus.last_state_change) as
last_state_change_timev FROM opsview_host_services,
nagios_hoststatus, nagios_servicestatus WHERE
( ( opsview_host_services.host_object_id =
nagios_hoststatus.host_object_id AND
opsview_host_services.service_object_id =
nagios_servicestatus.service_object_id ) ) ORDER BY host, service"]
at /usr/local/nagios/perl/lib/DBIx/ContextualFetch.pm line 52."
ERROR - Caught exception in Opsview::Web::Controller::Root->end
"Can't insert new Opsview::Auditlog: DBI
connect('database=opsview;host=localhost','opsview',...) failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/
mysqld.sock' (111) at /usr/local/nagios/perl/lib/Ima/DBI.pm line 329
at /usr/local/opsview-web/script/../lib/Opsview/Web/Controller/
Root.pm line 346"
Haven't seen this before.
Try changing the host from localhost to 127.0.0.1. This forces the
mysql connection to be via the tcp socket, rather than via the unix
socket.
However, I think you might have something very strange with your mysql
instance.
Ton
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
