Migrating users from Internal Crowd Directory to JIRA Internal Dir

[Neeta Dubey]

Hi Team,

We need to stop usage of crowd and using SSO authentication.

I'm trying to move all internal users from crowd internal directory to jira internal dir with help of below kb.

https://confluence.atlassian.com/confkb/migrating-from-external-management-to-internal-directory-298979079.html

I'm trying to update only one test user that i have created for testing purpose.

Till step#4 it is all well.

I could update cwd_user table however issue arises when I update cwd_group table, it gets updated but shows group membership as blank.

Attached are the screenshot of group membership before and after update.

Below are the sql query.

UPDATE CWD_USER SET DIRECTORY_ID='1' WHERE user_name ='neeta_dubey'

UPDATE CWD_GROUP SET DIRECTORY_ID='1' WHERE ID='44310'