Convert remote user directory to local Jira user directory
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This knowledge base article is provided as informational use only and requires direct database modification. Atlassian Support cannot assist with problems resulting from performing these SQL commands
Solution
Problem
It's not possible to login to JIRA because the remote directory no longer exists however you wish to retain the old users and groups from the old remote directory.
Resolution
The following SQL will convert the remote user directory to a local JIRA user directory. Be sure to substitue 10000 with the id of the remote directory you wish to migrate:
1
2
3
update cwd_directory set impl_class = 'com.atlassian.crowd.directory.InternalDirectory', lower_impl_class = 'com.atlassian.crowd.directory.internaldirectory', directory_type = 'INTERNAL' where id = '10000';
delete from cwd_directory_attribute where directory_id = '10000';
insert into cwd_directory_attribute values ('10000', 'user_encryption_method', 'atlassian-security');User passwords will need to be reset before they are able to login after performing migration. If needed the following SQL will update a user's password to 'sphere':
1
update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='XXXX';Was this helpful?