[Top][All Lists]

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

Re: Protocol options for mysql server

From: Martin Pala
Subject: Re: Protocol options for mysql server
Date: Wed, 15 Aug 2007 22:17:25 +0200
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv: Gecko/20070802 Iceape/1.1.4 (Debian-1.1.4-1)


the mysql protocol test will work for you even when you don't allow the anonymous login. The mysql ping won't be performed however, since it needs the authenticated session.

The protocol test works this way:

1.) try anonymous login

2a.) if login passed, send mysql ping

2b.) if login denied, mysql test succeeds immediately since the server is responding to requests - the fact that the login failed is represented as correct state (the server just doesn't allow anonymous login thus it is not possible to check further requests such as mysql ping)

The 'depends' line is not necessary.


Sergio Trejo wrote:

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

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




To unsubscribe:

reply via email to

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