[Top][All Lists]

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

Re: MySQL host checks in Monit 5.9

From: Eric Bonfadini
Subject: Re: MySQL host checks in Monit 5.9
Date: Thu, 25 Sep 2014 23:02:09 +0200

Hi Martin,

Thanks for your answer.

I unblocked all the hosts using “mysqladmin flush-hosts” and fixed temporarily the issue, but one hour and a half later I’m in the same situation on all the machines.
My application is anyway working fine and I can connect to mysql using the command line.

I even tried with a brand new MySQL installation, with anything really connected to it (apart from Monit) and I notice the same behaviour.
The version I’m using is [5.6.20 MySQL Community Server (GPL)] on a CentOS 6.


On 25 Sep 2014, at 14:51, Martin Pala <address@hidden> wrote:


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).


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


To unsubscribe:

To unsubscribe:

reply via email to

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