How can I tell which LDAP attribute is linked to the external_id field in Confluence cwd_user table?
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
Problem
In the course of debugging LDAP issues, an admin may need to understand which LDAP attribute is tied to the external_id value in cwd_user table in Confluence.
Diagnosis
Environment
Confluence
LDAP
Resolution
First, find the required LDAP Directory ID:
Find the effected LDAP Directory ID
1 2SELECT * FROM cwd_directoryNext, use the Directory ID obtained from the previous step to run the following query"
Find the LDAP attribute tied to external_id in database table cwd_user
1 2 3 4 5SELECT * FROM cwd_directory_attribute WHERE directory_id = '<directory-id-here>' AND attribute_name LIKE '%ldap.external.id%'The output for attribute_value is the LDAP attribute that is tied to the external_id value in cwd_user for the affected directory.
The external_id, can also be located under Confluence Support Zip > auth-cfg > directoryConfigurationSummary.txt under correct directory name by locating attribute "ldap.external.id".
Was this helpful?