Ranger Password reset

[#1]

Hello, Friends.

I have a problem with Ranger, I have a Kerberized Cluster, I try to access Ranger UI with user admin:admin and I get error" The username or password you entered is incorrect". likewise changing.

Ranger Admin username for Ambari
Ranger Admin user's password

Even changing and restarting ambari I can't get in. Could you help me?

Greetings

[#2]

 @Peruvian81 The following method could be used to work this around.

1. Login to the Ranger repository database

2.Run the following DML command to update the Ranger admin's password to 'admin'

update x_portal_user set password = 'ceb4f32325eda6142bd65215f4c0f371' where login_id = 'admin';

The above would reset the password to 'admin'.

3. Login to Ranger UI using the above password 
4. Go to User Profile and change the password
5. Open Ambari UI Ranger Configs
6. Update 'admin_password' in Advanced ranger-env with the newly set password

[#3]

Hello @Scharan 

Thank you for the answer, only one last doubt I have postgres. tell me in which database I must run I understand that will be in ranger.

But before the doubt I ask.

Greetings

[#4 · Accepted solution]

@Peruvian81  You need to update ranger,

You can follow the below steps to reset the password in postgres:

1.Login into postgres

2. postgres=# \connect ranger

3. ranger=# update x_portal_user set password = 'ceb4f32325eda6142bd65215f4c0f371' where login_id = 'admin';

Above would reset the password to 'admin'.

4. Login to Ranger UI using the above password

5. Go to User Profile and change the password

6. Open Ambari UI Ranger Configs

7. Update 'admin_password' in Advanced ranger-env with the newly set password