Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to connect Ranger to mysql , failed to install ranger

Solved Go to solution

Unable to connect Ranger to mysql , failed to install ranger

Expert Contributor
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)
1 ACCEPTED SOLUTION

Accepted Solutions

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

Expert Contributor

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

5 REPLIES 5

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

Contributor

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

Expert Contributor

i have create the user randerdba im following the same documentation

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

Expert Contributor

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

Highlighted

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

Contributor
@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

Expert Contributor

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