Page 1 of 1

check_mysql_health unable to apply configuration

Posted: Fri Jan 25, 2019 11:59 am
by nms_system_support
Hello

I create a service to check MySQL on a server and as you can see from the run_check.jpg the command is working successfully. But when I am trying to apply the configuration I get an error -> check failed_configuration.jpg

Is it because we haven't installed the MySQL plugin at the client?

Thank you

Re: check_mysql_health unable to apply configuration

Posted: Fri Jan 25, 2019 3:45 pm
by 455157
Hello,

As a starting point, I'd recommend that you investigate the items noted in the bottom red box in your screenshot.

It looks like max_attempts, check_interval, etc... may have an invalid value on the mysql_uptime service on the host noted.

What do you see if you navigate to that service in the Core Config Manager, in the Check Settings tab?

Once there are valid values there, you can try to apply configuration again.

Re: check_mysql_health unable to apply configuration

Posted: Fri Jan 25, 2019 3:56 pm
by benjaminsmith
Thanks @455157. Let us know if you're able to correct those errors and apply configuration, looks like check_mysql_health is returning valid results.

By the way, if you'd like to know more about those specific values, check out the object definition documentation for Nagios:

Object Definitions
https://assets.nagios.com/downloads/nag ... tions.html

Re: check_mysql_health unable to apply configuration

Posted: Sat Jan 26, 2019 6:19 am
by nms_system_support
Hi,

Thanks both. Its quite strange. I tried on another nagios and I get the same error.

Even though I tried to create a new service just to check service mysqld and I get error again. When I use a service that I already have for localhost I don't get any error!

So what I did is to add it with vi at the .cfg file manually. and it works!

But I cannot see the service now at GUI

Re: check_mysql_health unable to apply configuration

Posted: Mon Jan 28, 2019 2:04 pm
by benjaminsmith
Hi @nms_system_support,
So what I did is to add it with vi at the .cfg file manually. and it works!
But I cannot see the service now at GUI
Configurations manually loaded in the static directory are loaded loaded into Nagios Core but these are not shown in the CCM (Core Configuration Manager) in Nagios XI.

Can you send me your system profile, and I can review the configuration files for you. To send your profile:

Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and upload it to a cloud storage of your choice. You can share a link with me in a personal message.
After you upload the profile please post something in this thread to bring it up in the support queue.