Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Connecting to mysql using nifi

Highlighted

Connecting to mysql using nifi

Rising Star

Hi,

I'm trying to connect to nifi from mysql, so while connecting i'm facing some poolable connection error like

My client nifi is set up on docker and mysql is on host that is local.

I can see sql workbench able to connect to mysql on 127.0.0.1 and 3306 so it means port is opened.

But looking the below error suggest that there is some problem connecting to mysql

Any help on this would be appreciated

74549-nifi-error.png

3 REPLIES 3
Highlighted

Re: Connecting to mysql using nifi

Rising Star

@Shu If you can have a look too

Highlighted

Re: Connecting to mysql using nifi

Super Guru
@Vaibhav Kumar

Make sure you are using correct mysql jdbc jar and check the connectivity between docker nifi instance,Local mysql.

Please refer to the below links that having solutions for same exact issue,

https://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysq...

https://serverfault.com/questions/89955/unable-to-connect-to-mysql-through-jdbc-connector-through-to...

Re: Connecting to mysql using nifi

Rising Star

@shu tried almost all the thing mentioned above but still no luck

Don't have an account?
Coming from Hortonworks? Activate your account here