Re: Protocol options for mysql server

[Martin Pala]

Hi,

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.

Martin


Sergio Trejo wrote:
> 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 <http://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
>
>
> ------------------------------------------------------------------------
>
> --
> To unsubscribe:
> http://lists.nongnu.org/mailman/listinfo/monit-general