Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

From Ranger UI "Unable to connect db" and in ambari UI it shows "User:admin credentials on Ambari UI are not in sync with Ranger"

Highlighted

From Ranger UI "Unable to connect db" and in ambari UI it shows "User:admin credentials on Ambari UI are not in sync with Ranger"

New Contributor

Installed Ambari 2.7 HDP 3.1 version, after added Ranger service I couldn't able to login. From Ranger UI "Unable to connect db" and in ambari UI it shows "User:admin credentials on Ambari UI are not in sync with Ranger" I checked Ranger access logs, Checked DB connection, grant permissions everythings is fine. Also from Ranger Config, passwords for "Ranger Admin username for Ambari" and "Ranger Admin user's password" are same and I thought this was a bug. Can anyone help me on this? Thanks in advance.

4 REPLIES 4

Re: From Ranger UI "Unable to connect db" and in ambari UI it shows "User:admin credentials on Ambari UI are not in sync with Ranger"

Super Mentor

@Naveen Varma Ramesh

Can you please make sure that the "amb_ranger_admin" and ranger "admin" password are same. Please refer to the following links to see how to reset if needed.

Please check the following UI paths:


Ranger UI

Ranger UI --> Settings --> Users/Groups 

Then Search for 'admin' and 'amb_ranger_admin' users.


Ambari UI

Ambari UI --> Ranger --> Configs --> Admin Settings --> "Ranger Admin user's password for Ambari" 

Do you have the same password values that you used in Ranger UI ?


For additional info please refer to : https://docs.hortonworks.com/HDPDocuments/HDP3/HDP-3.1.0/authorization-ranger/content/ranger_install...


https://community.hortonworks.com/articles/186614/how-to-change-amb-ranger-admin-password.html


.

.


Re: From Ranger UI "Unable to connect db" and in ambari UI it shows "User:admin credentials on Ambari UI are not in sync with Ranger"

New Contributor

Jay Kumar SenSharma

We tried these already, both passwords are same even though we couldn't able to login Ranger. Also, on the backend we checked with mysql login through Rangeradmin user and we could able to login. check with the screenshots attached. 109641-ranger.png

Re: From Ranger UI "Unable to connect db" and in ambari UI it shows "User:admin credentials on Ambari UI are not in sync with Ranger"

Community Manager

The above question and the entire reply thread below was originally posted in the Community Help track. On Mon Jul 1 00:49 UTC 2019, a member of the HCC moderation staff moved it to the Security track. The Community Help Track is intended for questions about using the HCC site itself, not technical questions about Ranger.

Re: From Ranger UI "Unable to connect db" and in ambari UI it shows "User:admin credentials on Ambari UI are not in sync with Ranger"

New Contributor

We resolve this issue, while connecting to ranger it automatically looking for CA certs SSL even if we didn't enable SSL at that time since this is a new built cluster. We added ?useSSL=false on JDBC string and gave "false" to ranger.usersync.ssl from config. Try this hope this works.