Nagios Support Forum

Posted: **Fri Jan 27, 2017 7:39 am**

I get this error: "Error connecting to database." when I try to open Nagios CCM. Nagios in itself does not report any errors on the console and it's working fine. What can be the cause of this and how do I fix it ?

Thanks for any help

Posted: **Fri Jan 27, 2017 12:47 pm**

Are you using Nagios XI? The Nagios Core Pro VM? Did you install the CCM yourself?

Posted: **Fri Jan 27, 2017 12:51 pm**

Hi,

Thanks for your reply to my question.

I am using the pro Version 3.5.0 which we bought on a VM on CentOS

Posted: **Fri Jan 27, 2017 2:55 pm**

Can you share the outputs of the following commands executed from the CLI of your Nagios Core machine:

Code: Select all

cat /var/www/html/ccm/config.inc.php
echo "SELECT count(*) FROM tbl_info;" | mysql -unagiosql -pn@gweb nagiosql
service mysqld status
tail -n 30 /var/log/mysqld.log

Posted: **Sat Jan 28, 2017 11:17 am**

Hi,

Here are the result from the 4 commands:

cat /var/www/html/ccm/config.inc.php:

Code: Select all

<?php //config.inc.php

//global configuration options for Nagios CCM
$CFG = array(); 
if(ENVIRONMENT=='nagiosxi') {
	//use XI's generated config
	require_once('/usr/local/nagiosxi/etc/components/ccm_config.inc.php');
	$CFG['audit_send'] = '/usr/local/nagiosxi/scripts/send_to_auditlog.php'; 
}
else { //nagioscore 

//nagios file locations
$CFG['plugins_directory'] = '/usr/local/nagios/libexec';
$CFG['command_file'] = '/usr/local/nagios/var/rw/nagios.cmd'; 
$CFG['lock_file'] = '/usr/local/nagios/var/nagios.lock';
$CFG['audit_send'] = '/dev/null'; 

//mysql database connection info 
$CFG['db'] = array(
	'server'       => 'localhost',
	'port'     		=> '3306',
	'database'     => 'nagiosql',
	'username'     => 'nagiosql',
	'password'     => 'n@gweb',
	);
}

//misc global settings 	
$CFG['common']['install'] = 'passed'; 	
$CFG['domain'] = 'localhost'; 
$CFG['default_pagelimit'] = 15;
$CFG['lock_file'] = '/usr/local/nagios/var/nagios.lock';
$CFG['pear_include'] = '/usr/share/pear/HTML/Template/IT.php';
?>

echo "SELECT count(*) FROM tbl_info;" | mysql -unagiosql -pn@gweb nagiosql:

Code: Select all

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

service mysqld status:

Code: Select all

mysqld is stopped

tail -n 30 /var/log/mysqld.log:

Code: Select all

Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160506 15:39:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160506 15:39:38  InnoDB: Initializing buffer pool, size = 8.0M
160506 15:39:38  InnoDB: Completed initialization of buffer pool
160506 15:39:39  InnoDB: Started; log sequence number 0 44233
160506 15:39:39 [Note] Event Scheduler: Loaded 0 events
160506 15:39:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
161201 13:08:08 [Note] /usr/libexec/mysqld: Normal shutdown
161201 13:08:08 [Note] Event Scheduler: Purging the queue. 0 events
161201 13:08:09  InnoDB: Starting shutdown...
161201 13:08:11  InnoDB: Shutdown completed; log sequence number 0 44233
161201 13:08:11 [Note] /usr/libexec/mysqld: Shutdown complete
161201 13:08:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
161201 13:09:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161201 13:09:36  InnoDB: Initializing buffer pool, size = 8.0M
161201 13:09:36  InnoDB: Completed initialization of buffer pool
161201 13:09:37  InnoDB: Started; log sequence number 0 44233
161201 13:09:37 [Note] Event Scheduler: Loaded 0 events
161201 13:09:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170103 11:30:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170103 11:30:59  InnoDB: Initializing buffer pool, size = 8.0M
170103 11:30:59  InnoDB: Completed initialization of buffer pool
170103 11:30:59  InnoDB: Started; log sequence number 0 44233
170103 11:30:59 [Note] Event Scheduler: Loaded 0 events
170103 11:30:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Posted: **Mon Jan 30, 2017 3:31 pm**

Hmm, it doesn't look like the mysql server is running. There's a couple more commands I would like to see the output of in light of the new information:

Code: Select all

service mysqld restart
tail -n 30 /var/log/mysqld.log
service mysql status

Posted: **Tue Jan 31, 2017 4:17 am**

Hi, thanks for the reply,

Here is the info you asked for:

service mysqld restart:

Code: Select all

Stopping mysqld:  [60G[[0;32m  OK  [0;39m]
Another MySQL daemon already running with the same unix socket.
Starting mysqld:  [60G[[0;31mFAILED[0;39m]

tail -n 30 /var/log/mysqld.log:

Code: Select all

Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160506 15:39:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160506 15:39:38  InnoDB: Initializing buffer pool, size = 8.0M
160506 15:39:38  InnoDB: Completed initialization of buffer pool
160506 15:39:39  InnoDB: Started; log sequence number 0 44233
160506 15:39:39 [Note] Event Scheduler: Loaded 0 events
160506 15:39:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
161201 13:08:08 [Note] /usr/libexec/mysqld: Normal shutdown
161201 13:08:08 [Note] Event Scheduler: Purging the queue. 0 events
161201 13:08:09  InnoDB: Starting shutdown...
161201 13:08:11  InnoDB: Shutdown completed; log sequence number 0 44233
161201 13:08:11 [Note] /usr/libexec/mysqld: Shutdown complete
161201 13:08:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
161201 13:09:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161201 13:09:36  InnoDB: Initializing buffer pool, size = 8.0M
161201 13:09:36  InnoDB: Completed initialization of buffer pool
161201 13:09:37  InnoDB: Started; log sequence number 0 44233
161201 13:09:37 [Note] Event Scheduler: Loaded 0 events
161201 13:09:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170103 11:30:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170103 11:30:59  InnoDB: Initializing buffer pool, size = 8.0M
170103 11:30:59  InnoDB: Completed initialization of buffer pool
170103 11:30:59  InnoDB: Started; log sequence number 0 44233
170103 11:30:59 [Note] Event Scheduler: Loaded 0 events
170103 11:30:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

service mysql status :

Code: Select all

mysqld is stopped

Thanks for your help!

Posted: **Tue Jan 31, 2017 11:45 am**

What is the full output of ps -ef | grep mysql? It appears there may be a runaway process as it seems to continue to run.

Posted: **Tue Jan 31, 2017 11:59 am**

The result of the command is:

root 11945 11310 0 16:57 tty1 00:00:00 grep mysql

Posted: **Tue Jan 31, 2017 5:40 pm**

Have you tried completely restarting this server? The mysql process is thoroughly stuck and does not seem to want to free up the socket file.

Nagios Support Forum

"Error connecting to database" When I open Nagios CCM 1.03

"Error connecting to database" When I open Nagios CCM 1.03

Re: "Error connecting to database" When I open Nagios CCM 1.

Re: "Error connecting to database" When I open Nagios CCM 1.

Re: "Error connecting to database" When I open Nagios CCM 1.

Re: "Error connecting to database" When I open Nagios CCM 1.

Re: "Error connecting to database" When I open Nagios CCM 1.

Re: "Error connecting to database" When I open Nagios CCM 1.

Re: "Error connecting to database" When I open Nagios CCM 1.

Re: "Error connecting to database" When I open Nagios CCM 1.

Re: "Error connecting to database" When I open Nagios CCM 1.