4 Replies Latest reply: Aug 7, 2014 12:03 AM by roobie RSS

    questions regarding LDAP config

    roobie

      Hi everyone,

       

      Using APEX 4.2, RDBMS 11gR2.

       

      I've been trying to configure for APEX to authenticate users against Active Directory following a number of posts in the forum but have not bee successful. Appreciate if someone can help. Below is my server details (I've substituted my server/domain with example.com):

       

      Domain: example.com

       

      Distinguished Name (DN): CN=First Last,OU=HQ,OU=User Accounts,DC=example,DC=com

       

      sAMAccountName: flast

       

      I have used the DN string above to authenticate using the simple_bind_s function in the DMBS_LDAP package and that works fine in APEX SQL Workshop and SQL Developer.

       

      I've tried in APEX by specifying in the DN field with the following but it does not work:

      cn=%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

       

      Have also tried in APEX the following as well but still doesn't work (as some posts suggest):

      example%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

      example\%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

      example/%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

      cn=example%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

      .. and many more variations

       

      Also tried this

      http://www.grassroots-oracle.com/2013/09/using-ldap-to-authenticate-your-apex.html

       

      and this

      http://ruepprich.wordpress.com/2012/11/02/ldap-authentication-with-apex/

       

      Can anyone advise what else I should try?

       

      Thanks in advance