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.

Ranger Admin Install Failed

Solved Go to solution

Ranger Admin Install Failed

New Contributor

Hi,

Getting these two errors when trying to install ranger,

Internal Exception: java.sql.SQLException: No database selected Error Code: 1046

[E] applying java patch PatchPasswordEncryption_J10001 failed

When I googled regarding this,

ranger-admin-site.xml has bad/missing values for:

- ranger.externalurl

- ranger.jpa.audit.jdbc.url

- ranger.jpa.jdbc.url

Of which I have only one property configured in my blueprint(ranger.jpa.jdbc.url) what should be the values of this..

It was jdbc:mysql://ip_of_ranger_host

Then I changed it to jdbc:mysql://ip_of_ranger_host/ranger

Thanks in Advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Ranger Admin Install Failed

@Sujatha Veeswar

This error is seen when JDBC URL(ranger.jpa.jdbc.url) is not correct. Does the test connection work? Is the database on ranger host? Can you try:

jdbc:mysql://ip_of_DB_host:DBPORT/ranger

2 REPLIES 2
Highlighted

Re: Ranger Admin Install Failed

@Sujatha Veeswar

This error is seen when JDBC URL(ranger.jpa.jdbc.url) is not correct. Does the test connection work? Is the database on ranger host? Can you try:

jdbc:mysql://ip_of_DB_host:DBPORT/ranger

Re: Ranger Admin Install Failed

New Contributor

@Mugdha

Test connection works..The database is on ranger host..

Is the default DB port 3306..?

17540-smallss.png

Don't have an account?
Coming from Hortonworks? Activate your account here