Clicking Edit in a User directory configuration causes System Error in Confluence
プラットフォームについて: 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 は除く
問題
While trying to configure user repository from the user directory, any changes resulted in 500 error page
The following appears in the atlassian-confluence.log
Caused by: org.springframework.beans.FatalBeanException: Could not copy properties from source to target; nested exception is java.lang.reflect.InvocationTargetException
at org.springframework.beans.BeanUtils.copyProperties(BeanUtils.java:591)
...
Caused by: java.lang.reflect.InvocationTargetException
...
Caused by: java.lang.NumberFormatException: For input string: "636/"
診断
Diagnostic Steps
- The string
For input string: "636/"
looks like a port number Check what is the URL of the LDAP if it contains a backlash:
ldap.url: ldaps://mycompanyLDAP.com:636/
原因
The backlash in the URL caused this problem.
回避策
In your database, run the following query:
select d.id, d.directory_name, m.list_index from cwd_directory d join cwd_app_dir_mapping m on d.id=m.directory_id;
Take note of the id of the problematic directory, and insert it to the following code and run it in your database:
UPDATE cwd_directory_attribute
SET attribute_value = 'ldap://10.60.2.50:10390' <without the backlash>
WHERE directory_id = <directory ID obtained form the previous query>
AND attribute_name = 'ldap.url'
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
Check if the codes above was run successfully by running the following code:
SELECT * FROM cwd_directory_attribute WHERE directory_id = <directory id> AND attribute_name = 'ldap.url';
flush your cache (By going to Confluence Admin > Cache Management > Flush All) and see if this setting works