MySQL Alive

[Andrew Cruse]

Jeff Koch wrote:
> Hi:
> 
> We're new with nagios but learning.
> 
> We need to be able to check whether mysql is alive on a server - we
> don't 
> want to log in. I've looked at the check_mysql and check_mysql_query
> plugins and they seem to require username and password.
> 
> Can anyone advise on how to verify that MySQL is alive?


Assuming the reason you don't want to log in is to avoid sending the login
information over the network, an alternative would be to run check_mysql
and/or check_mysql_query locally on the MySQL server via
check_by_ssh/NSClient/NRPE/etc.   Or if you don't like the security
ramifications of those you could run those checks locally on the MySQL and
publish the output via SNMP or even on a web page if you have a web server
running on your MySQL server.  Lots of options.

Andrew


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null