@dmharshit To resolve this issue, you will have to update Ranger’s backend database directly to reset the password you will need to write access to Ranger’s backend database. Using MySQL you know how to log into MySQL from either the command line The users who can access Ranger’s Admin Web UI, also call Portal, are stored in a table called “x_portal_user“. mysql> show tables; +------------------------------+ | Tables_in_ranger | +------------------------------+ | vx_trx_log | | x_access_type_def | .... | x_portal_user | | x_portal_user_role | ... +------------------------------+ 67 rows in set (0.00 sec) Query this table to confirm your Admin user is present in the table: mysql> SELECT id, first_name, last_name, login_id, password, status \ FROM x_portal_user WHERE login_id = 'admin'; +----+------------+-----------+----------+----------------------------------+--------+ | id | first_name | last_name | login_id | password | status | +----+------------+-----------+----------+----------------------------------+--------+ | 1 | Admin | | admin | fdea9c9f5fabb9c4120b9834684f0ff0 | 1 | +----+------------+-----------+----------+----------------------------------+--------+ 1 row in set (0.00 sec) The password corresponds to the hashed value of “fdea9c9f5fabb9c4120b9834684f0ff0”, reset it to default value of “admin”, which has the hash value of “ceb4f32325eda6142bd65215f4c0f371”. Please run the below query: UPDATE x_portal_user SET password = 'ceb4f32325eda6142bd65215f4c0f371' WHERE login_id = 'admin'; After that, just log into Ranger Web UI using “admin” as username and “admin” as password, then update the password IMMEDIATELY through web UI. Hope that helps Geoffrey
... View more
