Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Authentication issue with 4.1

630131Mar 16 2012 — edited Mar 20 2012
We are using a custom authentication scheme. It calls the authenticatin api to authenticate agains active directory.

It is working in multiple apex aplications in apex version 3.2. We created a new install of 4.1 and imported the apps from 3.2

I can't get this authentication to work in 4.1. Here is the code that works in 3.2 but not in 4.1

This code is in the login process of page 101.

The error msg I get is Invalid Login Credentials

I have created the application at the oracle hosted site. id/wd id guest/Lock01$

Off course for simplicty, all the code does is emualte how I am logging in at the 3.2 install. All other code has not been copied over. This application works on our 3.2 install but not 4.1! Help!

{declare

b_result boolean := false;
c_result boolean := false;
d_result boolean := false;

begin
-- :IS_ADMIN_USER := 0;
-- :IS_IE_USER := 0;

:USERNAME := :P101_USERNAME;
:PASSWORD := :P101_PASSWORD;

-- for security reasons I commented out the server and base domain info. in this call.
b_result := LDAP2.AUTHENTICATE_ADUSER(:P101_USERNAME, :P101_PASSWORD, :P101_DOMAIN, '#####.####.com', 'DC=####,DC=####,DC=com');

if (b_result = true) then
-- I know that session is valid as i displayed a mesg if it was valid to be sure.
If APEX_CUSTOM_AUTH.IS_SESSION_VALID


--this was the old way in 3.2 that worked but doesn't in 4.1
-- wwv_flow_custom_auth_std.post_login(
-- P_UNAME => :USERNAME,
-- P_PASSWORD => :PASSWORD,
-- P_SESSION_ID => v('APP_SESSION'),
-- P_FLOW_PAGE => :APP_ID||':1'
-- );

-- I tried this in 4.1 but still doesn't work
APEX_CUSTOM_AUTH.POST_LOGIN (
p_uname => :USERNAME,
p_session_id => V('APP_SESSION'),
p_app_page => :APP_ID||':1');

End if;
else
owa_util.redirect_url('f?p=&APP_ID.:&LOGIN_PAGE.:&SESSION.');
apex_util.set_session_state('LOGIN_MESSAGE', 'Your ID or PASSWORD is incorrect. Please try again.');
end if;
-- :PASSWORD := null;
end;
Edited by: ashalon on Mar 16, 2012 11:23 AM

Edited by: ashalon on Mar 16, 2012 11:25 AM

Edited by: ashalon on Mar 16, 2012 12:20 PM

Edited by: ashalon on Mar 16, 2012 3:46 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
This post has been answered by Christian Neumueller-Oracle on Mar 20 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2012
Added on Mar 16 2012
12 comments
882 views