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

    LDAP Test: Invalid Session with correct ACLs

    jozzh

      Hallo

       

      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:

       

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

       

       

      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?

       

      Thanks,

      Jochen