Support Questions

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

How to change Ranger database in sandbox

avatar

Greetings,

I need to change the Ranger database to PostgreSQL for a Proof Of Concept in the Sandbox, so I ran /usr/hdp/current/ranger-admin.setup.sh, which failed due to what due to the inability to connect to the PostgreSQL as root.

2016-07-15 13:34:22,906  [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/share/java/postgresql-jdbc.jar:/usr/hdp/2.4.0.0-169/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://localhost/postgres -u root -p '********' -noheader -trim -c \; -query "SELECT 1;"
SQLException : SQL state: 28000 org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "root" ErrorCode: 0

I tried creating a superuser rangerdba in PostgreSQL and running the setup.sh with it and ended up with this pg_hba.conf, which seemed to allow me to load the database

# "local" is for Unix domain socket connections only
local   all   postgres                               ident
# IPv4 local connections:
host    all   postgres         127.0.0.1/32          ident
host    postgres   root,rangerdba,rangeradmin         127.0.0.1/32          md5
host    ranger   root,rangerdba,rangeradmin         127.0.0.1/32          md5
host    ranger_audit   root,rangerdba,rangeradmin,rangerlogger         127.0.0.1/32          md5
# IPv6 local connections:
host    all   postgres         ::1/128               ident

However, the setup still does not complete successfully, it fails applying the PatchPasswordEncryption_J10001

2016-07-14 21:51:58,319  [I] java patch PatchPasswordEncryption_J10001 is being applied..
[EL Severe]: 2016-07-14 21:52:37.343--ServerSession(1446840711)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20131113-a7346c6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Error Code: 0
[EL Severe]: ejb: 2016-07-14 21:52:37.363--ServerSession(1446840711)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20131113-a7346c6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Error Code: 0
2016-07-14 21:52:37,498  [E] java patch PatchPasswordEncryption_J10001 failed

My question is, how can I switch the Ranger database to PostgreSQL? TIA.

-aaron

1 ACCEPTED SOLUTION

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login