question Re: Unable to connect Ranger to mysql , failed to install ranger in Support Questions

Unable to connect Ranger to mysql , failed to install ranger

chahrimourad — Wed, 24 Aug 2016 22:30:17 GMT

stderr:

None

stdout:

DB connection check started.
WARNING: File /var/lib/ambari-agent/cache/DBConnectionVerification.jar already exists, assuming it was downloaded before
WARNING: File /var/lib/ambari-agent/cache/mysql-jdbc-driver.jar already exists, assuming it was downloaded before
2016-08-24 15:29:30,162 - call['/usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java -cp /var/lib/ambari-agent/cache/DBConnectionVerification.jar:/var/lib/ambari-agent/cache/mysql-jdbc-driver.jar -Djava.library.path=/var/lib/ambari-agent/cache org.apache.ambari.server.DBConnectionVerification "jdbc:mysql://manager/ranger" rangerdba [PROTECTED] com.mysql.jdbc.Driver'] {}
2016-08-24 15:29:30,688 - call returned (1, "ERROR: Unable to connect to the DB. Please check DB connection properties.\njava.sql.SQLException: Access denied for user 'rangerdba'@'manager' (using password: YES)")

structured_out:

ERROR: Unable to connect to the DB. Please check DB connection properties.
java.sql.SQLException: Access denied for user 'rangerdba'@'manager' (using password: YES)

Re: Unable to connect Ranger to mysql , failed to install ranger

kgopal — Wed, 24 Aug 2016 22:39:36 GMT

You need to create the user rangerdba with password manager to get the same working.

For more information on how to create the user please follow the article:

Documentation

Re: Unable to connect Ranger to mysql , failed to install ranger

chahrimourad — Wed, 24 Aug 2016 22:39:37 GMT

i have create the user randerdba im following the same documentation

Re: Unable to connect Ranger to mysql , failed to install ranger

chahrimourad — Wed, 24 Aug 2016 23:10:42 GMT

i found the solution , should execute /usr/bin/mysql_secure_installation then set a password for root

Re: Unable to connect Ranger to mysql , failed to install ranger

hyadav — Thu, 25 Aug 2016 16:02:56 GMT

@Mourad Chahri

use the following commands to create the 'rangerdba'@'manager' user

CREATE USER 'rangerdba'@'manager' IDENTIFIED BY 'rangerdba';
GRANT ALL PRIVILEGES ON *.* TO 'rangerdba'@'manager';

Re: Unable to connect Ranger to mysql , failed to install ranger

chahrimourad — Thu, 25 Aug 2016 16:47:22 GMT

i have create this user , i found the solution should execute /usr/bin/mysql_secure_installation then set a password for the root