Opsview shows web-interface, but when I try to get page http://appservaddr.domain:3000/status/service it offers to come back later on several languages.
Here is an output of opsview_web_server.pl, started handly: 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" MySQL-server is running and works fine: appserv:~$ sudo /etc/init.d/mysql status * /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on x86_64 Copyright (C) 2000-2006 MySQL AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.0.51a-3ubuntu5.1-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 4 min 58 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.013 Port is open: appserv:~$ sudo netstat -lnp | grep mysqld tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 21339/mysqld unix 2 [ ACC ] STREAM LISTENING 2681224 21339/mysqld /var/run/mysqld/mysqld.sock Socket-file exists: appserv:~$ file /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock: socket appserv:~$ ls -l /var/run/mysqld/mysqld.sock srwxrwxrwx 1 mysql mysql 0 2009-07-14 16:11 /var/run/mysqld/mysqld.sock I connect to opsview database: appserv:~$ mysql -u root -p opsview Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.0.51a-3ubuntu5.1-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. ... and recieve any data from any table of opsview database. Example: mysql> select * from icons; +------------------------------+----------------+ | name | filename | +------------------------------+----------------+ | LOGO - Debian Linux | debian | | LOGO - Linux Penguin | linux | | LOGO - NetBSD | netbsd | | LOGO - OpenBSD | openbsd | | LOGO - Opsview | opsview | | LOGO - Xterminal | xwindows | | SYMBOL - Application | application | | SYMBOL - Environment Monitor | meter | | SYMBOL - Equipment Rack | cabinet | | SYMBOL - Firewall | firewall | | SYMBOL - Hub | hub | | SYMBOL - Load Balancer | loadbalancer | | SYMBOL - Network | network | | SYMBOL - Network Cloud | network_cloud | | SYMBOL - Network Device | network_device | | SYMBOL - Proxy | proxy | | SYMBOL - Router | router | | SYMBOL - Server | server | | SYMBOL - Storage | storage | | SYMBOL - Switch | switch | | SYMBOL - VLAN | vlan | | SYMBOL - VPN | vpn | | SYMBOL - Web Site | website | | SYMBOL - Wireless Network | wireless | | SYMBOL - xDSL | dsl | +------------------------------+----------------+ 25 rows in set (0.00 sec) So, what's wrong? Why can't opsview web-server work correctly? In advance thanks and sorry for my English. _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
