Nagios Support Forum

Hi Team,
I am facing issue with Nagios XI for the MYSQL.

As provided in the PDF , https://assets.nagios.com/downloads/nag ... Server.pdf

I have successfully installed the MySQL using the
=========================================
yum -y install mysql mysql-server mysql-devel

mysql
======
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

There is no /tmp/mysql.sock nor a /var/lib/mysql.sock.

1. /var/lib/mysql
======================
-rwxrwxrwx 1 mysql mysql 10485760 Mar 8 20:26 ibdata1
-rwxrwxrwx 1 mysql mysql 5242880 Mar 8 20:26 ib_logfile0
-rwxrwxrwx 1 mysql mysql 5242880 Mar 8 13:51 ib_logfile1
drwxrwxrwx 2 mysql mysql 4096 Mar 8 13:51 mysql
drwxrwxrwx 2 mysql mysql 12288 Mar 8 18:54 nagios
drwxrwxrwx 2 mysql mysql 20480 Mar 8 19:11 nagiosql
drwxrwxrwx 2 mysql mysql 4096 Mar 8 13:51 test


but when i run the Nagiosxi directories , ./fullinstall facing the issue
==============================================

MySQL installed OK - continuing...
Starting MySQL...
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
ERROR: MySQL failed to start - exiting.

Can you please help on this.. ?

Thank you,
Kris,

It would be easier to first install Nagios XI with a local MySQL database, then worry about offloading to a remote MySQL server once you have verified Nagios XI is running just fine with a local database.

Please do that first, then run through the offloading documentation and let us know if you encounter additional problems.