MariaDB/MySQL health plugin for Nagios Core?

[reynierpm]

I was testing all this in a local environment (meaning a VM running Centos 6.7). Now I have moved to an online server which share the same meaning CentOS 6.7 and after get all setup I can see this in /usr/local/nagios/var/nagios.log:

Code: Select all

[1441373776] SERVICE ALERT: qa.pdone.com;MySQL Slow Queries;CRITICAL;SOFT;3;CRITICAL - statefilesdir /var/tmp/check_mysql_health does not exist or is not writable
[1441373778] SERVICE ALERT: qa.pdone.com;MySQL Index Usage;CRITICAL;HARD;4;CRITICAL - statefilesdir /var/tmp/check_mysql_health does not exist or is not writable

What I miss here? Do I need something else on that server? How I can fix that? I follow exactly the same steps as in my local environment, any advice?

[tgriep]

The plugin uses state files to store data and the Nagios system cannot write to them.
Lets delete the state files and see if that fixes the issue.

Code: Select all

rm -fr /var/tmp/check_mysql_health