Getting check_mysql error in Nagios core

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Getting check_mysql error in Nagios core

Post by cdienger »

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>

?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
sandeep027
Posts: 33
Joined: Tue May 08, 2018 2:12 am

Re: Getting check_mysql error in Nagios core

Post by sandeep027 »

Thank you so much guys... i am able to configure successfully by using the links which was provided by you.

Thanks for your help.
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Getting check_mysql error in Nagios core

Post by cdienger »

Glad to hear!
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked