Hi,
i'm fairly new to apex. I have a 21c XE database on a Oracle 8 VM.
I'm testing out the program since 3 month, followed some courses, trying to develop a simple application. Now the simple application is up and running and i'm in the task to enable LDAP authentication for my Workspace.
After learning, searching and looking around i can't pass the LDAP Test stage. Every time i try i get ORA-31204: DBMS_LDAP: PL/SQL - Invalid LDAP Session.
Things i've done: created ACL for the SCHEMA USER (MY_WORKSPACE_SCHEMA), the APEX_220100 schema, APEX_PUBLIC_USER and PUBLIC. Then i have a host ACL that is my DC (we have Active Directory here). If i try the LDAP connection using DBMS_LDAP.simplie_bind_s it seems to work (tried from the Workspace Schema and the SQL Workshop in the Build App and via Oracle SQL Developer, i get connected, if i change credentials, i get the Invalid Credentials error).
But if i try from the Ldap Test schema in the authentication schemas page (i've create a new auth schema for ldap) i keep getting the error above. Is driving me insane.
These are the ACL privileges for the schemas above.
The connection to the DC is made using the DC fqdn (not using ip address), no SSL and using Port 389. The VM has no firewall activated.
These are my test settings:
I've noticed this: if i try to change the host address in the DBMS_LDAP.init procedure during the test, i get the (right) error that there is no ACL for the host. But in the test page, i can set every hostname or ip i want, i get always the same error and not an ACL related error.
Hope someone could help me to figure this out