question Re: Ranger Password reset in Support Questions

Ranger Password reset

Peruvian81 — Tue, 22 Oct 2019 13:49:05 GMT

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

Re: Ranger Password reset

Scharan — Tue, 22 Oct 2019 14:18:18 GMT

@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

Re: Ranger Password reset

Peruvian81 — Tue, 22 Oct 2019 15:04:14 GMT

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

Re: Ranger Password reset

Scharan — Tue, 22 Oct 2019 15:16:28 GMT

@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