question Re: Not able to Connect NIFI to mysql through windows in Support Questions

Not able to Connect NIFI to mysql through windows

san_re — Thu, 14 Apr 2022 03:16:35 GMT

I have tried to connect local NIFI to Local mysql, I have been getting an error on the processor "cannot create poolableconnectionfactory communications link failure nifi". JDBC Url and Driver are correct. i assume there may be an error while connecting with Mysql.

And also i have tried to Connect local NIFI in mac with local Mysql, i am facing an error while i enable the DBCP connection pool the error is mentioned in the image.

Thank you

Re: Not able to Connect NIFI to mysql through windows

ask_bill_brooks — Thu, 14 Apr 2022 06:58:11 GMT

Hi @san_re

The first error message you included is likely the result of not enabling connection over the network (or locally, as the case may be) to the Mysql server. You have to take some administrative action on a newly-installed Mysql server in order to allow outside applications (in this case, that would be the local NiFi) to connect to the server. It's difficult to troubleshoot that remotely because it could be something else, but in my experience that is the most common root cause.

This error message:

Driver class com.mysql.jdbc.driver is not found - Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.driver: Driver class com.mysql.jdbc.driver is not found

Typically means that the JDBC driver is not being found on the relevant CLASSPATH, which is in this case is NiFi. After you ensure you haven't mistyped the name of the java Driver class, you need to make sure you installed the appropriate .jar file in the location where NiFi is expecting to find it, and that the file is not corrupted, etc.

Re: Not able to Connect NIFI to mysql through windows

san_re — Fri, 15 Apr 2022 01:24:20 GMT

Hello @ask_bill_brooks

I have tried to enable the connection in windows by making few modificationsin mysql,

I have tried almost all the things in the internet like adding bind-address in my.ini file.
but facing the same error again.

Re: Not able to Connect NIFI to mysql through windows

san_re — Fri, 15 Apr 2022 05:04:14 GMT

HI @ask_bill_brooks ,

In Mac i have tried few methods and I am facing a new issue now similar to the windows error cannot create poolable connection, attached image for your reference

Re: Not able to Connect NIFI to mysql through windows

ask_bill_brooks — Thu, 21 Apr 2022 16:53:59 GMT

@san_re What documentation are you following for what you are attempting to do here? You're much better off following a specific set of instructions from the site where you are downloading Mysql and/or NiFi from.

For NiFi, the canonical instructions can be found here:

NiFi System Administrator's Guide