Adding protocol (ldap://) to hostname in user directory leads to error

If you add the protocol header (ldap:// or ldaps://) to the server hostname when setting an LDAP user directory, you can no longer edit that user directory.

If you check the entry in DB in the table cwd_directory_attribute the attribute attibute.name has the header repeated ldap://ldap://hostname.

This issue is a clone of EMBCWD-905

Error on the UI when trying to edit the directory :
Request processing failed; nested exception is org.springframework.beans.FatalBeanException: Could not copy properties from source to target; nested exception is java.lang.reflect.InvocationTargetException

Workaround

If this is a new directory configuration:

• remove the existing directory and re-create it
• ensure to not use ldap:// or ldaps:// in the hostname field

If this is an existing configuration that was modified:

• Only use this option if the directory has been in use and contains group information that you'd like to preserver
• Update the attribute value via the database:
  • First locate the directory ID:

    select * from cwd_directory;
    

  • Using the ID for your LDAP directory, locate the attribute:

    select * from cwd_directory_attribute where attribute_name = 'ldap.url';
    

  • You'll notice the results to be something like:

    ldap://ldap://localhost:10389
    

  • Update this to and remove the extra set of ldap://