question Re: is there any way to reset ranger admin UI password ? in Support Questions

is there any way to reset ranger admin UI password ?

KuldeepK — Fri, 20 Nov 2015 20:30:21 GMT

I have forgotten my ranger UI admin password. could you please help ?

Re: is there any way to reset ranger admin UI password ?

nsabharwal — Fri, 20 Nov 2015 20:34:45 GMT

@kkulkarni what's the database flavor ?

Re: is there any way to reset ranger admin UI password ?

KuldeepK — Fri, 20 Nov 2015 22:01:27 GMT

mysql-5.1.73

Re: is there any way to reset ranger admin UI password ?

nsabharwal — Sat, 21 Nov 2015 00:19:53 GMT

@kkulkarni You can reset admin user password in mysql database. reset to admin

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

Re: is there any way to reset ranger admin UI password ?

sneethiraj — Sat, 21 Nov 2015 00:32:29 GMT

If you forget the admin password, you can reset it by executing db sql:

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

This will reset the password to 'admin'. Then, they should change the password via UI.

Re: is there any way to reset ranger admin UI password ?

KuldeepK — Sat, 21 Nov 2015 21:55:44 GMT

Thank you so much @sneethiraj 🙂

Re: is there any way to reset ranger admin UI password ?

KuldeepK — Sat, 21 Nov 2015 21:55:58 GMT

Thank you so much @Neeraj Sabharwal

Re: is there any way to reset ranger admin UI password ?

gbraccialli3 — Tue, 01 Dec 2015 20:32:48 GMT

dont forget to change password in ambari as well, otherwise you will have issues restarting services:

https://community.hortonworks.com/questions/1929/changing-ranger-ui-password-causing-namenode-issue.html

Re: is there any way to reset ranger admin UI password ?

teravaidya — Sun, 21 May 2017 17:57:11 GMT

Hi, is there anyway to change Ranger UI admin password through command line?

Re: is there any way to reset ranger admin UI password ?

miroslaw_kaspro — Wed, 06 Dec 2017 07:17:24 GMT

Ambari Version 2.6.0.0

HDP version 2.6.3.0-235

Oracle Database 12c

Despite the restoration of the password in the database. I could not log into Ranger UI.

Changing the password in the Ranger configuration also did not give anything. I changed the password in the configuration: "Ranger Admin user's password for Ambari" and "admin_password".

What else can I do?

Re: is there any way to reset ranger admin UI password ?

lvazquez — Mon, 17 Sep 2018 01:45:22 GMT

The previous answer gives the response on how to reset the password in Ranger for a fixed user/password combination with the value "admin:admin". But if you want to reset or check the password value on Ranger for any user or password combination you have to use the following.

Passwords in Ranger are saved in the password column of the x_portal_user table as MD5 hashes in the format password{login}. For instance the hash for the amb_ranger_admin account with secret123 as password will be as follows:

$ echo -n 'secret123{amb_ranger_admin}' | md5sum
 md5sum4d9f6af4210833cb982d27c9042d9ac1  -

Of course you may also use this and pgsql/mysql to change the password for any user via command line as requested by another user.

Re: is there any way to reset ranger admin UI password ?

abhilash1 — Sat, 12 Dec 2020 18:06:27 GMT

Thank you you are a savior.. I was looking for this answer since admin/admin wouldnt work. When you update admin ambari, its the password size to be minimum 8 characters long.

Re: is there any way to reset ranger admin UI password ?

JeffG — Sun, 24 Jan 2021 09:41:30 GMT

I was just able to confirm that the update command listed is Postgresql database flavor.