Yes, ranger DB has no field for password.  So where is it stored?

I am unable to use the python script as it requires a current password. 
Furthermore, it requires that the current password and new password to be 
different.  So, unless there is some other way to change the password my only 
option is to delete the databases and re-run setup.sh.

From: Vipin Rathor <v.rat...@gmail.com>
Sent: Tuesday, June 4, 2024 6:56 PM
To: user@ranger.apache.org
Subject: Re: Usersync

EXTERNAL
You won’t find them in AD / LDAP. They are in your Ranger DB. These passwords 
get set when you install Ranger.

Earlier there used to be a sql stmt to update them directly in the DB, but not 
possible anymore. Hence the Python script which I shared earlier.

Regards,
VR


On Jun 4, 2024, at 19:34, Marc Hoppins 
<marc.hopp...@eset.com<mailto:marc.hopp...@eset.com>> wrote:

Hi, Vipin,

Not sure how that is going to help.

I only have the one password to LDAP search (given by windows team). I cannot 
change it as it is active directory and to change it would be (yet another) 
ticket.

Where is the password stored? I tried looking in our MYSQL table (x_user) but 
see nothing for password.

From: Vipin Rathor <v.rat...@gmail.com<mailto:v.rat...@gmail.com>>
Sent: Tuesday, June 4, 2024 3:29 PM
To: user@ranger.apache.org<mailto:user@ranger.apache.org>
Subject: Re: Usersync

EXTERNAL
Looks like what Jesús pointed out is right. It’s the rangerusersync user which 
is failing with “bad credentials” against Ranger Admin.



Maybe you can try resetting the password for this user?
Take a look at : 
https://github.com/apache/ranger/blob/master/security-admin/scripts/changepasswordutil.py

Regards,
VR



On Jun 4, 2024, at 17:51, Marc Hoppins 
<marc.hopp...@eset.com<mailto:marc.hopp...@eset.com>> wrote:
Jesús

Reply via email to