Brekeke Contact Center Suite Wiki

MySQL - Error message: "Host 'XXX.XXX.XXX.XXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

Problem:

Brekeke CCS application cannot connect to the MySQL database, and the following error message is shown in application logs(cim.log / crm.log).

Example of the error message:

2022-10-11 15:08:49,562 [main] ERROR (Tenant.java:531) - [] [$] java.sql.SQLException: null,  message from server: "Host '172.16.0.12' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

 

 

Solution:

Increase the value of the server system variable “max_connect_errors“.

my.cnf file:

[mysqld] 
max_connect_errors=10000

To change the value at runtime:

SET GLOBAL max_connect_errors=10000;

 

For details and precise instructions, please refer to the MySQL official manuals.

 

 

Yes No
Suggest Edit