question Ranger Admin Install Failed in Archives of Support Questions (Read Only)

Ranger Admin Install Failed

sujathaveeswar — Tue, 27 Jun 2017 19:44:25 GMT

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!

mugdha — Wed, 28 Jun 2017 05:58:39 GMT

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

sujathaveeswar — Sun, 18 Aug 2019 03:10:04 GMT

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

Is the default DB port 3306..?