Re: MySQL host checks in Monit 5.9

[Martin Pala]

Hi,

Monit 5.9 has new MySQL protocol test - the old one tried anonymous login (even negative response was interpreted as success, as MySQL processed the request), which generated lot of connection failures and flooded mysql log.

The new protocol test doesn't perform the login attempt and also checks the response code - if error was returned, the protocol test fails and logs details (as in your case). The new protocol test is correct, as when the client from which Monit runs the test is blocked, then even application which will run on the same host as Monit and will try to connect to MySQL will fail as well => MySQL won't work.

I recommend to fix the problem as suggested by MySQL error message (unblock the host).

Regards,

Martin

On 25 Sep 2014, at 13:46, Eric Bonfadini <address@hidden> wrote:

Hi all,

I installed the new version of Monit (5.9 - binary distribution - http://mmonit.com/monit/dist/binary/5.9/monit-5.9-linux-x64.tar.gz) and now all my MySQL host checks are failing with a message like the following one:

failed protocol test [MYSQL] at INET[XXX.XXX.XXX.XXX:3306] via TCP -- Server returned error code 1129 -- XXX.XXX.XXX.XXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Everything was working flawlessly with previous versions of Monit (like 5.8.1)

Are you aware of any issue with it?

Thanks,

Eric

--
To unsubscribe:
https://lists.nongnu.org/mailman/listinfo/monit-general