Created on 11-28-2019 12:11 AM - last edited on 11-28-2019 12:37 AM by VidyaSargur
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
Created on 11-28-2019 02:06 AM - edited 11-28-2019 02:07 AM
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.
Created on 11-28-2019 10:20 PM - edited 11-28-2019 11:02 PM
Again its getting the same error
#/usr/jdk64/jdk1.8.0_112/bin/java -cp
/usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/share/java/mysql-connector-java-5.1.37.jar
org.apache.ambari.server.DBConnectionVerification "jdbc:mysql://
xxxxxxx:3306/ambari" "ambari" "xxxxx" com.mysql.jdbc.Driver
ERROR: Unable to connect to the DB. Please check DB connection properties.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
link failure
The last packet sent successfully to the server was 0 milliseconds ago. The
driver has not received any packets from the server.
#ambari-server setup --jdbc-db=mysql
--jdbc-driver=/usr/share/java/mysql-connector-java-5.1.37.jar
Using python /usr/bin/python
Setup ambari-server
Copying /usr/share/java/mysql-connector-java-5.1.37.jar to
/var/lib/ambari-server/resources/mysql-connector-java-5.1.37.jar
Creating symlink
/var/lib/ambari-server/resources/mysql-connector-java-5.1.37.jar to
/var/lib/ambari-server/resources/mysql-connector-java.jar
If you are updating existing jdbc driver jar for mysql with
mysql-connector-java-5.1.37.jar. Please remove the old driver jar, from all
hosts. Restarting services that need the driver, will automatically copy
the new jar to the hosts.
JDBC driver was successfully initialized.
Ambari Server 'setup' completed successfully.
Created 11-28-2019 10:51 PM
Created 11-28-2019 11:05 PM
It gets error because i already created this user.
mysql> CREATE USER 'ambari'@'%' IDENTIFIED BY 'xxxxxxx';
ERROR 1396 (HY000): Operation CREATE USER failed for 'ambari'@'%'
mysql> GRANT ALL PRIVILEGES ON *.* TO 'ambari'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE USER 'ambari'@'localhost' IDENTIFIED BY 'xxxxxx';
ERROR 1396 (HY000): Operation CREATE USER failed for 'ambari'@'localhost'
mysql> GRANT ALL PRIVILEGES ON *.* TO 'xxxxxx'@'localhost';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> CREATE USER 'ambari'@'xxxxxx' IDENTIFIED BY 'xxxxxx';
ERROR 1396 (HY000): Operation CREATE USER failed for 'ambari'@'xxxxxxx'
mysql> GRANT ALL PRIVILEGES ON *.* TO 'ambari'@'xxxxxxx';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE USER 'ambari'@'%' IDENTIFIED BY 'xxxxxxxx';
ERROR 1396 (HY000): Operation CREATE USER failed for 'ambari'@'%'
mysql> GRANT ALL PRIVILEGES ON *.* TO 'ambari'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql> GRANT ALL PRIVILEGES ON *.* TO 'ambari'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE USER 'ambari'@'xxxxx' IDENTIFIED BY 'xxxx';
ERROR 1396 (HY000): Operation CREATE USER failed for 'ambari'@'xxxxxx'
mysql> GRANT ALL PRIVILEGES ON *.* TO 'ambari'@'xxxxxxxx';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)