Nagios/MySQL QUestions

lce411 · 11-08-2012, 12:06 PM

I've posted a question on the Nagios forum, but there is much more traffic here. I'm trying to get Nagios to start using a MySQL db, so the Nagios server isn't so taxed. I can log into the MySQL server from the Nagios server, so I know the iptables exception is working. When I try to start a mysqldump, from the Nagios server I get "mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect". That file does exist on the MySQL server, so I'm not sure why its erroring out. Does anyone have any experience with Nagios and MySQL? Or can anyone point me in the direction of documentation for doing this? I've searched but can't find anything.

I am running RHEL 5.8 and Nagios 2.12 (old version, I know). MySQL is Ver 14.14 Distrib 5.5.27, for Linux.

Habitual · 11-08-2012, 12:51 PM

The mysql_root password "may" be different than the system root_password, so some thing to check is on the mysql server are

Code:

sudo mysqldump -u <user> -p <pass> nagios_db > /path/to/nagios.sql

or

Code:

sudo mysqldump -u root -p <mysql_root_pass> nagios_db > /path/to/nagios.sql

If it's a remote host:

Code:

ssh user@host mysqldump -u user -p <userpass> nagios_db > /path/to/nagios.sql

and then check /path/to/nagios.sql on the remote host.

you can check your connection remotely using mysql like so:

Code:

mysql -h remotehost -u root -p <pass> or 
mysql -h remotehost -u user -p <pass>

if those get you into a mysql > prompt you should be good to go.

See mysqldump — A Database Backup Program for more info.

lce411 · 11-08-2012, 01:02 PM

Quote:

Originally Posted by Habitual

The mysql_root password "may" be different than the system root_password, so some thing to check is on the mysql server are

Code:

sudo mysqldump -u <user> -p <pass> nagios_db > /path/to/nagios.sql

or

Code:

sudo mysqldump -u root -p <mysql_root_pass> nagios_db > /path/to/nagios.sql

If it's a remote host:

Code:

ssh user@host mysqldump -u user -p <userpass> nagios_db > /path/to/nagios.sql

and then check /path/to/nagios.sql on the remote host.

you can check your connection remotely using mysql like so:

Code:

mysql -h remotehost -u root -p <pass> or 
mysql -h remotehost -u user -p <pass>

if those get you into a mysql > prompt you should be good to go.

See mysqldump — A Database Backup Program for more info.

Thanks for the response. The only command I could get to work was: mysql -h remotehost -u user -p <pass>. That got me the 'mysql' prompt, from the Nagios server. I have the root passwords for both the systems and mysql, so I'm not sure why I can't get there as root. I could only get user nagios to connect.

Habitual · 11-08-2012, 01:21 PM

Then you should be able to dump the nagios_db as the nagios user using

Code:

mysqldump -h remotehost -u nagios -p <pass> nagios_db > /path/to/nagios.sql

"/path/to/nagios.sql" must be writable by the nagios user, if in doubt, use

Code:

mysqldump -h remotehost -u nagios -p <pass> nagios_db >/tmp/nagios.sql

After the dump what happens is up to you.