Re: mysql connection errors bug?

[Andreas Rust]

> The problem with this configuration is that when monit checks the
> connection I guess it doesn't do it properly and mysql raises a connection
> error. When the max_connect_errors (the default is 10) is reached, mysql
> refuses further connections from the host. I've commented out the line "if
> failed port 3306 then restart" to prevent mysql from rejecting connections
> and it now works as expected.


Hi,

I am using this config for checking mysql:

check process mysql with pidfile /var/lib/mysql/mysqld.pid
    start program = "/etc/init.d/mysql start"
    stop program = "/etc/init.d/mysql stop"
    group server
    if failed host 127.0.0.1 port 3306 then restart
    if 3 restarts within 5 cycles then timeout


and never had any problems with it. I wonder if it actually would make a 
difference if you add the
"host 127.0.0.1" (or other IP) option ...

This part of the config was taken from that monitrc.d config with included 
configs of which I can only read
back "homyakov" on top of the included files. Don't know who supplied this, 
but it was mentioned on the list here.

This, however, works on mysql 3.x and 4.x for me so far.

l8r


    Andreas Rust     -   webnova GmbH
    address@hidden  -   www.webnova.de
    Tel:  +49 (0)700 - 20 30 7000
    Fax:  +49 (0)700 - 20 30 8000
+:----------------------------------------------------------:+
         www.Synergien-Nutzen.de
         Gemeinsam sind wir stark...