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.

Ranger Password reset

Solved Go to solution

Ranger Password reset

Explorer

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Ranger Password reset

Expert Contributor

@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

3 REPLIES 3
Highlighted

Re: Ranger Password reset

Expert Contributor

 @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

Explorer

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.

 

Ranger.JPG

But before the doubt I ask.

 

Greetings

Re: Ranger Password reset

Expert Contributor

@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

Don't have an account?
Coming from Hortonworks? Activate your account here