MySQL Alive

[Thomas Guyot-Sionnest]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 16/07/08 10:40 AM, 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?

If MySQL is listening on the network you can use check_tcp on port 3306.
That would be the simplest way:

check_tcp -H hostname -p 3306

Even on localhost you can check the socket with:

check_tcp -H /path/to/mysqld.sock

Thomas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIfnCb6dZ+Kt5BchYRAn8FAKDWfvS2xiULga3nzrDSb+xeBXVrOACgip5Y
zlZ4JjI4P8zUndEdfkOzi3w=
=6uFv
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
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