Hello,
I try to login to my apex developer with ldap credentials. A hard one...
using Apex 5.1.2, Oracle 12
First I tried to configure it in the internal worspace -> manage instance -> security -> authentication control -> LDAP directory
host: ldap.server.ip.address
port: 389
No SSQL
DN String : cn=md\%LDAP_USER%,OU=my_company,OU=the_other_company,DC=my,DC=company,DC=domain
use exact DN : Yes
Usename escaping : Standard
I tried a lot of combinations ot the parameters above, and solutions i found on the internet. Nothing worked.
Can someone tell me a way to debug this... or even better... does someone have an explanation for this...
I also tried the function from the docs... nothing... also many combinations of usernames and searchbases.
IF APEX_LDAP.AUTHENTICATE(
p_username =>'md\theuser',
p_password =>'secret',
p_search_base => 'OU=my_company,OU=the_other_company,DC=my,DC=company,DC=domain',
p_host => 'ldap.server.ip.address',
p_port => 389) THEN
dbms_output.put_line('authenticated');
ELSE
dbms_output.put_line('authentication failed');
END IF;
As is said... always failing... Is Apex Developer using this function for the authentication control?
But... authentication with the DBMS_LDAP package works:
l_session := dbms_ldap.init('ldap.server.ip.address',
'389');
l_retval := dbms_ldap.simple_bind_s(l_session,
'theuser',
'secret');
Ok... no search_base... is this the answer?
Any suggestions? Also configured ACL...