Skip to main content
Manoj690
Manoj690
Silver ⭐️⭐️⭐️
November 28, 2019
Solved

Mysql JDBC connection error for ambari installation

sudo apt-get install libmysql-java
Reading package lists... Done
Building dependency tree
Reading state information... Done
libmysql-java is already the newest version (5.1.45-1).
0 upgraded, 0 newly installed, 0 to remove and 92 not upgraded.

 

 

/usr/jdk64/jdk1.8.0_112/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/share/java/mysql-connector-java.jar org.apache.ambari.server.DBConnectionVerification "jdbc:mysql://XXXXXX:3306/ambari" "ambari" "password" com.mysql.jdbc.Driver
ERROR: Unable to connect to the DB. Please check DB connection properties.
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

 

sagarshimpi
sagarshimpiAnswer
Gold ⭐️
November 28, 2019

Hi @Manoj690 

 

Can you copy - "/var/lib/ambari-server/resources/mysql-connector-java.jar" to "/usr/share/java/"

and retry.

 

Make sure you use correct java path for the java version you are pointing too.

View in thread

12 replies

sagarshimpi
sagarshimpi
Gold ⭐️
November 28, 2019

Hi @Manoj690 

 

Can you share output of below commands -

 

  1. $ ls -ltr /usr/share/java/mysql.jar
  2. $find / -name mysql.jar
  3. $find / -name mysql-connector-java*.jar
Translate
Manoj690
Manoj690Author
Silver ⭐️⭐️⭐️
November 28, 2019

#ls -ltr /usr/share/java/mysql.jar
ls: cannot access '/usr/share/java/mysql.jar': No such file or directory

# find / -name mysql.jar
find: ‘/run/user/1000/doc’: Permission denied
find: ‘/run/user/1000/gvfs’: Permission denied

 

# find / -name mysql-connector-java*.jar
/usr/share/java/mysql-connector-java.jar
/var/lib/ambari-server/resources/mysql-connector-java.jar
find: ‘/run/user/1000/doc’: Permission denied
find: ‘/run/user/1000/gvfs’: Permission denied
/home/gaian/Downloads/mysql-connector-java.jar

Translate
sagarshimpi
sagarshimpiAnswer
Gold ⭐️
November 28, 2019

Hi @Manoj690 

 

Can you copy - "/var/lib/ambari-server/resources/mysql-connector-java.jar" to "/usr/share/java/"

and retry.

 

Make sure you use correct java path for the java version you are pointing too.

Translate
Terms & ConditionsAccessibility statement