Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

@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

@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

@Mugdha

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

Is the default DB port 3306..?

17540-smallss.png