Hello Jira Community,
A week back we got some help to move all our users from Internal to Delegated authentication. Now it seems that we have one user gandalfx which has the wrong name (should be gandalfy) for LDAP authentication. He is registered in the Delegated directory but cannot be looked up since his short name (userid) is wrong. He cannot set his password since he is delegated. And since we cannot change his username in Jira (id field) and cannot change his username in AD we are stuck. How can we move this one user back to the internal directory so he doesn't lose all his issues and history? Looked at some suggested sql query scripts on the comments in JRA-24213 but it seemed a bit risky. Any other suggestions?
I think this would help other users as well.
UPDATE cwd_user SET directory_id = 1, credential = 'uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name = 'gandalfx';
After that, login with the password "sphere". Might need to reassign the internal JIRA groups to this user though
What version of JIRA did you execute the above SQL on?
I have JIRA 4.3.4, and looking in the tables "cwd_user_attributes" and "cwd_membership", I see that they, and others, also have a column named "directory_id". Does this column in these tables need to also be updated at the same time when the table "cwd_user" is updated?
We did this on Jira 5.1. And we only needed to change the directory_id column in the cwd_user. But afterwards the user lost the group memberships and we had to reapply this. Maybe because of the columns you are referring to but easier just to add the groups to the user afterwards :-)
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot