This way I solved the controller service problem and I have been able to enable it. Hi have corrected a typo in Ni-Fi controller service configuration: Still, in a separate Linux terminal I am able to access the local mysql database In a separate terminal I accessed the remote MySQL database:įinally, I tried to connect to my local mysql database in my local Linux instance by using the following Ni-Fi settings: Proto Recv -Q Send -Q Local Address Foreign Address State PID /Program name Then I checked if the problem was in the SSH tunnel.Īctive Internet connections ( only servers)
MYSQL CONNECTORJ DOWNLOAD DRIVER
Database Driver Location: /usr/share/java/mysql-connector-java-5.1.45.jarĬauses: .exception.ProcessException: No suitable driver for the given Database Connection URL.This is the updated configuration in the DBCPConnectionPool1.15.2 controller service in Apache Ni-Fi: $ sudo jar xvf /usr /share /java /mysql -connector -java -5.1. jar file is in /usr/share/java/mysql-connector-java-5.1.45.jar Unpack the. I have cleaned /home/bernardo/Download and /usr/share/java from the old sql related files. I thought it could be an issue related to the driver version so I re-installed the jdbc driver. Database Driver Location: /usr/share/java/mysql-connector-java-8.0.26.jar.Database Driver Class Name: .jdbc.Driver.Modify the configuration of the controller service with: $ cat /usr /share /java /META -INF /services / To find the driver class name, open /usr/share/java/META-INF/services/ $ sudo jar xvf /usr /share /java /mysql -connector -java -8.0. 26.jarĬlean /usr/share/java from the previous jdbc driver usr /share /java /mysql -connector -java -8.0. $ dpkg -L mysql -connector -java | fgrep jar 04_all.debĬheck where is the connector location in the file system In a CLI terminal go to the Downloads directory It was related to the version of the jdbc driver. StandardControllerServiceNode, name=, active=true] Failed to invoke method due to : .()Ĭauses: : Ĭauses: .exception.ProcessException: Creating driver instance is failed: Creating driver instance is failed When enabling the controller service, I get the following error: Database Driver Location: /usr/share/java/META-INF/services.In NiFi I have used a DBCPConnectionPool1.15.2 controller service which is configured as follows: I have installed the jdbc connector in Linux and set up the user to use JDBCĪdded the following lines at the end of the file:ĬLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java-8.0.26.jar The file is located in the directory /usr/share/java/META-INF/services in Linux I have uploaded and unzipped the JDBC driver from $ ssh -i /home/bernardo/.ssh/sshbernardo3.pem -N -L .com:3306 -p The MySQL database is accessible through another Linux terminal. The MySQL database is behind a SSH tunnel which is working in a dedicated terminal.
I am trying to connect to a MySQL RDS instance in AWS with Apache NiFi on Linux Ubuntu.
0 kommentar(er)
