Move one user back to Internal directory from Delegated

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?

Regards,

Vidar

4 answers

1 accepted

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

This worked for us :-) But had to restart the Jira service to get it applied.

Vidar

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?

thanks,

-markus

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 :-)

Vidar

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

47 views 0 4
Read article

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you