Nagios3 facing difficulties in retrieving MySql DB status.. with these messages..
 

hi everybody.. am facing a bit of a tricky problem here.. its my nagios3 again :( it keeps showing me that my MySql DBMS is CRITICAL while i KNOW it is NOT.. and displaying these error messages :
1> and displaying this for another server (another MySql):
2> the third one is :
3> HELP PLEASE :-)

Is this just something that started suddenly or have you always gotten these errors when trying to monitor a mysql instance on a (I'm assuming remote machine)? If it is, in fact, a remote machine, have you commented out the skip-networking line and added a bind-address=<your mysql server address> line to your my.cnf? Until that is done, your mysql server probably won't accept connections from remote machines. Just a thought.

thanks for replying :) and yes i always had this errors.. and also yes Ive tried to do the bind-address thing but no use unfortunately.. one friend here told me to try to create a nagios user on MySql and grant it the proper rights and try that.. so i will try it.. i hope you keep following with me :) thanks again

I've try the last one i told you but no use too :(

When you tried creating the new database user, did you specify the host portion to be the IP of your nagios server that the connections will be coming from? Like: where foo is replaced by the name of your database and 192.168.1.10 is replaced with your nagios server IP address.

For instance, if you're specifying in your nagios check that it should log into mysql using the root account, then you'd want to add root@'your nagios IP' to all your mysql databases.

Doing the above should at least help get rid of error #3 in your original post.

Let me know if you have any luck.