monit-general
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Protocol options for mysql server


From: Sergio Trejo
Subject: Protocol options for mysql server
Date: Wed, 15 Aug 2007 05:08:53 -1000

Hello,

I have noticed some previous messages in this list about monit and mysql server.

I have a mysql server instance running and even though I do not have networking turned off explicitly in my.cnf, I am not allowing anonymous connections on port 3306.

Someone very helpful several months ago (Martin I think?) responded to a previous person on the mailing list and said:

There are also specific protocol tests (such as mysql for example) which
are testing more details - for example mysql test tries to login as
anonymous user and if succeeded then performs mysql ping as well.

You can enable it using the 'protocol' option in the port or unix socket
rule:

  if failed port 3306 protocol mysql then alert

Since I am not allowing anonymous logins, all I want to do is test the mysql daemon with a "ping", so I am wondering what protocol should I use in my monit configuration file instead of the protocol named "mysql"? In other words, replace the word "mysql" in the configuration line below with ???

   if failed host 127.0.0.1 port 3306 protocol mysql then restart

Do I also need any "depends" lines in the configuration for merely "pinging" the mysql server daemon? Thank you for very much for any suggestions!

Cheers,

Serg
reply via email to

[Prev in Thread] Current Thread [Next in Thread]