Ranger Admin Install Failed

[#1]

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!

[#2 · Accepted solution]

@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

[#3]

@Mugdha

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

Is the default DB port 3306..?