Reimporting or sync users from ldap - Ranger

[#1]

updateddeleteuser.zipISSUE: Ranger ldap integration was working fine. Customer delete user from ranger UI and was facing issue while re-importing user in Ranger.

ROOT CAUSE: Customer removed the users from ranger UI and expected that the user should be automatically imported from ranger usersync process

Below are sample screenshot -

User named 'testuser' is deleted from Ranger UI.

9442-screen-shot-2016-11-15-at-115653-am.png

9444-screen-shot-2016-11-15-at-115711-am.png

But below you can see the user is still available in database.

9445-screen-shot-2016-11-15-at-115914-am.png

RESOLUTION: There are multiple tables which has the entry for the user. You need to run delete script to delete the user entries from database and re-start ranger usersync process to re-import the user.

Please find attach delete script-

Syntax to run the script -

$ deleteUser.sh -f input.txt -u ranger_user -p password -db ranger [-r <replaceUser>]