Deleted user from active directory is not synchronised in Jira Service Management application
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
Deleted user is not synchronised in Jira Service Management with delegated LDAP
- With reference to the KB article new or deleted users and groups from active directory are not synchronised in JIRA applications, manual synchronisation of the directory is must.
- If instance is using delegated directory, there is no way to manually synchronise the directory.
診断
We need to activate this user manually to resolve this issue.
- We cannot manually activate this user as it is from LDAP.
- We have to perform changes in database to activate this user.
ソリューション
- As we need to perform changes in database to activate this user. Here are the queries to be executed to get this fixed.
SELECT u.id from cwd_user u where lower_user_name='USER_NAME';
UPDATE cwd_user u set active=1 where u.id=USER_ID_FROM_FIRST_QUERY;
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
最終更新日 2022 年 9 月 12 日
Powered by Confluence and Scroll Viewport.