Re: Getting check_mysql error in Nagios core
Posted: Wed Oct 31, 2018 10:24 am
The output of trying to install mysql-devel and was provided but not mysql-community-devel and mysql-community-libs. Run the following and provide the output if needed:
yum install -y mysql-community-devel mysql-community-libs
And as was pointed out, you may need to recompile the plugins and explicitly point the the location of the mysql libraries. For example:
./configure --with-mysql=/usr/lib64/mysql/
Lastly, instead of trying to run the plugin on the sql server, have you tried running the plugin on the Core machine:
/usr/local/nagios/check_mysql -d <database> -h <remote_ip> -u <username> -p <password>
?
yum install -y mysql-community-devel mysql-community-libs
And as was pointed out, you may need to recompile the plugins and explicitly point the the location of the mysql libraries. For example:
./configure --with-mysql=/usr/lib64/mysql/
Lastly, instead of trying to run the plugin on the sql server, have you tried running the plugin on the Core machine:
/usr/local/nagios/check_mysql -d <database> -h <remote_ip> -u <username> -p <password>
?