2 messages in com.mysql.lists.mysqlHost '...' is blocked error
FromSent OnAttachments
David Sklar21 Apr 1999 07:45 
Michael Widenius21 Apr 1999 19:42 
Subject:Host '...' is blocked error
From:Michael Widenius (mon@monty.pp.sci.fi)
Date:04/21/1999 07:42:46 PM
List:com.mysql.lists.mysql

Hi!

"David" == David Sklar <skl@student.net> writes:

Description:

David> What are the networking conditions that cause MySQL to increment the David> counter that triggers the "Host '...' is blocked" error message? I am
getting David> that error from servers that are only being connected to by valid
clients.

David> The only thing I can think of that makes the connections unusual is that
the David> MySQL servers are sitting behind a Cisco LocalDirector. Even still, David> connections usually work fine.

The error number is incremented if one of the following happens:

- One gets an error reading/writing to the client while connectiong. - If it takes more than 'connect_timeout' before the client answers to a the connect handshaking.

When a connection succedes from a host, the counter is reset.

How-To-Repeat: Fix:

David> If I set max_connect_errors to 0, will MySQL never generate that error?

No; You should instead set max_connect_errors to a real big value. For example 16M should work nicely.

Regards, Monty