Hello everyone,
APEX VERSION NUMBER : 22.1.0
I'm trying to authenticate via LDAP. Here are the information I have :
host : myhost (it's not the real host as it's confidential)
port : 389
base dn : dc=xxx,dc=xx
for users : ou=people,dc=xxx,dc=xx
Does the DN should be :
cn=%LDAP_USER%,ou=people,dc=xxx,dc=xx
or
uid=%LDAP_USER%,ou=people,dc=xxx,dc=xx
?
However I always get this error : ORA-31204: DBMS_LDAP: PL/SQL - Invalid LDAP Session
I found this video (https://www.youtube.com/watch?v=NuP9sAg6dn8), and at 3:37 he talks about ACL.
On the other hand, in the APEX documentation (https://docs.oracle.com/en/database/oracle/apex/22.1/htmig/enabling-network-services-in-Oracle-db11g-or-later.html#GUID-CA19B8DF-B210-46FC-BC3A-F0DC76AE5625), I executed :
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_220100',
principal_type => xs_acl.ptype_db));
END;
/
But when I select this :
SELECT ACL, PRINCIPAL
FROM DBA_NETWORK_ACLS NACL, XDS_ACE ACE
ORDER BY PRINCIPAL ASC
I can't see my APEX_220100 user…
I still get ORA-31204: DBMS_LDAP: PL/SQL - Invalid LDAP Session error.
Does someone have a hint ?