Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Connecting to mysql using nifi

avatar
Expert Contributor

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

avatar
Expert Contributor

@Shu If you can have a look too

avatar
Master 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...

avatar
Expert Contributor

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