Support Questions
Find answers, ask questions, and share your expertise

Ranger Admin Install Failed

Solved Go to solution
Highlighted

Ranger Admin Install Failed

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

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

View solution in original post

2 REPLIES 2

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

View solution in original post

Highlighted

Re: Ranger Admin Install Failed

@Mugdha

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

Is the default DB port 3306..?

17540-smallss.png

Don't have an account?