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