Martin, Thank you very much for clarifying how monit works with mysql -- it helped a lot!
Cheers, Serg On 8/15/07, Martin Pala <[EMAIL PROTECTED]> wrote: > > 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 > > > -- > To unsubscribe: > http://lists.nongnu.org/mailman/listinfo/monit-general >
-- To unsubscribe: http://lists.nongnu.org/mailman/listinfo/monit-general
