More info:
"[2009/10/27 11:27:12] [Opsview.Web.Controller.Root] [ERROR] Errors
encountered: DBIx::Class::ResultSet::find(): DBI Connection failed: DBI
connect('database=opsview;host=localhost','opsview',...) failed: Can't connect
to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at
/usr/local/nagios/perl/lib/DBIx/Class/Storage/DBI.pm line 840
[2009/10/27 11:27:12] [Catalyst] [ERROR] DBIx::Class::ResultSet::find(): DBI
Connection failed: DBI connect('database=opsview;host=localhost','opsview',...)
failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) at
/usr/local/nagios/perl/lib/DBIx/Class/Storage/DBI.pm line 840
[2009/10/27 11:27:12] [Catalyst] [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/lib/mysql/mysql.sock' (2) at
/usr/local/nagios/perl/lib/Ima/DBI.pm line 329
"
But I can connect to mysql without issues:
"[r...@popsmas mysql-backup]# mysql -u opsview -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 313
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
[r...@popsmas mysql-backup]# mysql -u nagios -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 328
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
[r...@popsmas mysql-backup]# mysql -u odw -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 333
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
[r...@popsmas mysql-backup]# mysql -u reporter -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 343
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
"
Thanks,
Mark
----- "Mark Maas-Martin" <[email protected]> wrote:
>
> Hi Ton,
>
> You where right, the /var partition was full. And the "/usr/local/nagios/var"
> path is a symllink to "/var/nagios".
> Aparantly 32GB was not enough to hold all the backups in
> "/usr/local/nagios/var/backups".
>
> I've removed some of the older backups (September) and a few very large
> "files" backups.
> Unfortunatly... it still will not start ;-)
>
> "[2009/10/15 06:55:43] [Opsview.Web.Controller.Root] [ERROR] Errors
> encountered: Caught exception in
> Opsview::Web::Controller::Status::Service->default "DBD::mysql::st execute
> failed: Got error 28 from storage engine [for Statement "SELECT
> DISTINCT(opsview_host_services.service_object_id) as service_object_id,
> nagios_hosts.alias as alias, 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_hosts,
> nagios_hoststatus, nagios_servicestatus WHERE ( ( nagios_hosts.host_object_id
> = opsview_host_services.host_object_id AND
> opsview_host_services.host_object_id = nagios_hoststatus.host_object_id AND
> opsview_host_services.hostname LIKE ? AND
> opsview_host_services.service_object_id =
> nagios_servicestatus.service_object_id ) ) ORDER BY host, service" with
> ParamValues: 0='paixpearl'] at
> /usr/local/nagios/perl/lib/DBIx/ContextualFetch.pm line 52."
> "
>
> Thanks,
> Mark
>
>
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
