Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Ranger Admin Install Failed

avatar

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

avatar
@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

avatar
@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

avatar

@Mugdha

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

Is the default DB port 3306..?

17540-smallss.png