question Re: Reset Ambari admin password in Archives of Support Questions (Read Only)

Reset Ambari admin password

Sanaz_janbakhsh — Fri, 24 Feb 2017 13:51:36 GMT

Hi,

I've launched HDP 2.5 on an AWS instance, for some reason i cannot login to admin. I wanted to reset the admin ambari password, i tried "ambari-admin-password-reset" but looks like it is for sandbox and it cannot found on the server.

Please advise how can I reset the password.

Thanks,

Re: Reset Ambari admin password

jsensharma — Fri, 24 Feb 2017 13:53:09 GMT

@Sanaz Janbakhsh

On ambari Database you can run the folllowing command:

update ambari.users set user_password='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' where user_name='admin';

This will reset ambari user "admin" password as "admin".

Re: Reset Ambari admin password

rguruvannagari — Fri, 24 Feb 2017 13:56:45 GMT

@Sanaz Janbakhsh

In sandbox ambari-admin-password-reset should work. You can also reset password from DB.

-->From Ambari server host 'psql -U ambari ambari' (password 'bigdata')

--> In psql:

update ambari.users set user_password='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' where user_name='admin'

-->Quit psql

-->Run 'ambari-server restart'

Re: Reset Ambari admin password

Sanaz_janbakhsh — Fri, 24 Feb 2017 14:02:56 GMT

Thanks,

I applied it and it gave me an server error , when i looked at the log i can find below. Any advice?

24 Feb 2017 01:01:41,275 WARN [ambari-client-thread-28] ServletHandler:561 - Error Processing URI: /api/v1/users/admin - (java.lang.IllegalArgumentException) Hex-encoded string must have an even number of characters 24 Feb 2017 01:01:41,275 WARN [ambari-client-thread-28] ServletHandler:561 - Error Processing URI: /api/v1/users/admin - (java.lang.IllegalArgumentException) Hex-encoded string must have an even number of characters

Re: Reset Ambari admin password

rguruvannagari — Fri, 24 Feb 2017 14:09:03 GMT

It looks that user_password is not set correctly. Can you make sure that there is no special characters included in password. Or set it again, dont copy paste from above, instead copy to notepad and make sure no specail characters included in the command before executing it on sandbox.

Re: Reset Ambari admin password

jsensharma — Fri, 24 Feb 2017 14:11:20 GMT

@Sanaz Janbakhsh

Looks like you have missed few characters in the admin password. Can you please share the output of the following query?

Select user_name, user_password from ambari.users where user_name='admin';

Resulted password should be exactly

538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00

Re: Reset Ambari admin password

Sanaz_janbakhsh — Fri, 24 Feb 2017 14:14:45 GMT

looks like it is set correctly but i cannot login !!!

user_name | user_password -----------+--------------- admin | admin (1 row)

Re: Reset Ambari admin password

Sanaz_janbakhsh — Fri, 24 Feb 2017 14:21:16 GMT

as you can see the password stored as "admin" and not 538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00"

Re: Reset Ambari admin password

jsensharma — Mon, 19 Aug 2019 10:16:30 GMT

@Sanaz Janbakhsh

The password i see in your output is not encrypted. Ambari uses Spring Security mechanism. And the password "admin" is stored in the database in encrypted manner. So in your database the password should be in encoded format.

So once you have the above mentioned entry in your ambari DB (users) table then after restarting ambari server you should be able to login to ambari UI using

username: admin

password: admin

Re: Reset Ambari admin password

Sanaz_janbakhsh — Fri, 24 Feb 2017 14:23:37 GMT

I Just ran the same query that you sent me, not sure what steps did i miss?

Re: Reset Ambari admin password

Sanaz_janbakhsh — Fri, 24 Feb 2017 14:27:34 GMT

I missed to commit the query, i did it this time and now i can see the expected password. And i can login too.

Thanks alot Jay SenSharma

Re: Reset Ambari admin password

jsensharma — Fri, 24 Feb 2017 16:02:01 GMT

@Sanaz Janbakhsh Can you please accept the answer and close the thread.