Skip to Content
0
Jul 18, 2019 at 08:15 AM

MYSQL Connection Block

163 Views

Dear Member,

We are actually facing a very strange issue:-

We have an ETL bo services which consist of different table coming from various database like AS400, Salesforce, MySQL.

All our connection is working perfectly fine but i cannot connect to that DB using other SAS tools when BODS jobs is executing.

I got the following errors:-

MySQL][ODBC 5.3(w) Driver]Host '90.85.95.113' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

The only way to resolve the issue is to run the command FLUSH HOSTS

But when no job is executing, we can connect to those database?

Is there any parameter that we can set on BODS to avoid this issue?

BODS:- 14.2.11.2066

BI platform :- BI 4.2 Support Pack 6 Patch 2

BI Windows (server):- Windows server 2016 standard 64 bits

BI Windows (Client):- Windows 10 pro 64 bits version 1803

MYSQL Version:- MySQL 5.5.37

SAP IQ Version: 16_1

At first glance, the issue is related to MYSQL connectivity issue:

https://www.cyberciti.biz/faq/error-1129-hy000-host-is-blocked-because-of-many-connection-errors/

Thank in advanced for any help on this

Cordially