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