Lost LDAP sychro password in Confluence

17 Oct, 2022

I lost the password used in Confluence for the LDAP synchronisation. Nothing to be worrying about, it is stored the database as plain text value. Used the below query to recover it.

select attribute_name, attribute_value
from cwd_directory_attribute da, cwd_directory d
where da.directory_id = d.id
  and da.attribute_name in ('ldap.password','ldap.userdn')
  and d.active='T'
  and d.directory_type = 'CONNECTOR';

There is an RSS feed for this blog.

#work