{1 - 24} GreyGrey
{25 - 49} GreenGreen
{50 - 499} BlueBlue
{500 - 4999} OrangeOrange
{5000 - 24999} RedRed
{25000+} BlackBlack

Please confirm that you would like to report this for an admin to review.


Oracle: APEX_LDAP.AUTHENTICATE – using Microsoft Active Directory

Oracle Consultant needs help regarding

“APEX_LDAP.AUTHENTICATE – using Microsoft Active Directory”





Application Express 4.1.1.00.23
Internet Explorer – 8
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

Hi very new to Apex and trying to get the authenticaqtion to work against our active directory. I have setup an authentication scheme for my application chossing the schema type as LDAP Directory…my settings are as follows:

Host : ****
Port : 389
Use SSL: No SSL
Distinguished Name (DN) String : domain\%LDAP_USER%
Use Exact Distinguished Name (DN) : Yes

This works perfectly and authenticates the user against active directory. The problem is when I try do the following in the database as I really want to setup a custom authentication scheme, it just does not work.

Begin
IF apex_ldap.authenticate(
p_username => ‘testusername’,
p_password => ‘testpassword’,
p_search_base => ‘domain\%LDAP_USER%’,
p_host => ‘*****’,
p_port => 389) THEN

dbms_output.put_line(‘True’);

Else
dbms_output.put_line(‘False’);
End If;
End;

No matter what I do this always returns false. I have created a function based on same code and created a custom authentication scheme that calls the function but I always get a false. Not sure why it works one way and not the other. Also would really appreciate if someone could help me get the code above to work or help correct it.

I have looked through the forum and tried many different search base strings but nothing seems to work.

Regards
Ash


What do you suggest for

APEX_LDAP.AUTHENTICATE – using Microsoft Active Directory

Kindly answer!

Oracle Discussion Forums : Thread List – Oracle Database



Confirm that you would like to Remove Email Alerts for your question. You cant undo this and you will not be able to re-subscribe.


Tags

No Answers

You must be Logged In to Answer this Question

Already a Member, Log In
Not a member yet? Sign Up

Categories

Sponsors


oracle forum