3 Replies Latest reply on Nov 7, 2016 2:48 PM by jozzh

    LDAP Test: Invalid Session with correct ACLs




      i got a really strange problem after switching from built-in LDAP Directory auth to custom auth (LDAP).

      Most of the time authentication works fine but there are random times when the Connection to the Active Directory is not working anymore in APEX.

      After 1-2 hours the Problem disappears and Login is back to normal. ACL should not have anything to do with this


      When i try the LDAP Test Page in Application Builder during the problem timeslot the result is:


      1 error has occurred

      Authentication failed

      ORA-31204: DBMS_LDAP: PL/SQL - Invalid LDAP Session.


      Running authentication from SQL Developer runs without Errors:


      FOR c1 IN (SELECT workspace_id FROM apex_applications WHERE application_id = 2000)
      apex_util.set_security_group_id(p_security_group_id => c1.workspace_id); 
      END LOOP; 
      apex_authentication.login('MYUSER', 'mypwd'); 



      Did you encounter such problems in your APEX 5 Installation?

      Do you know how i could run the same PL/SQL Code which the Test LDAP Page is running in SQL Developer?