Support Questions
Find answers, ask questions, and share your expertise

Ranger Mysql Host 'xx.xx.x.x' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.

Explorer

Hello Everyone - We have HDP-3.1.0 Installed. Kerberised the cluster. We have enabled Ranger. 

We use the same Mysql Database for Ambari/Hive/Ranger. Ambari & Hive works fine, but for Ranger

- we are getting the below error:

Mysql Host 'xx.xx.x.x' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.

 

If I run the "flush Hosts" from mysqldb, Ranger "Test connection" works fine but after a minute or two, it stops connecting.

 

I followed below the post and made sure all the steps were performed as mentioned:
https://community.cloudera.com/t5/Support-Questions/Ranger-Admin-does-not-start/td-p/194424

 

When I run the "SHOW PROCESSLIST" from Mysql DB, I see connections from Hive and Ambari but nothing from Ranger.

 

Please let me know if I am missing anything.

 

0 REPLIES 0