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!

APEX and Azure - Callback url changed from https to http

cc13comMar 8 2022 — edited Mar 9 2022

Hello,
I followed the following page to setup my APEX app to use Azure for user authentication. All looks fine until I try to login to my application. I enter my email/password but run then in the following issue:
#############
Sign in
Sorry, but we’re having trouble signing you in.
AADSTS50011: The redirect URI 'http://my_domain/ords/apex_authentication.callback' specified in the request does not match the redirect URIs configured for the application 'yyyy'. Make sure the redirect URI sent in the request matches one added to your application in the Azure portal. Navigate to https://aka.ms/redirectUriMismatchError to learn more about how to fix this.
#############
The difference I can see here is that the callback-url is showing with http. I setup the application in azure with https and my APEX app is running with https too. Why is azure changing the protocol from https to http?

Edit 09.03.2022: The callback URI is now working fine. I added proxyPort and scheme with the right values to the Tomcat configuration. But now I run in the next issue. After entering my login credentials for the Azure cloud I see the following window:
image.pngAfter clicking OK:
AADSTS900561: The endpoint only accepts POST requests. Received a GET request. And in the monitor activity debug log I find the following:

- ora_sqlerrm: ORA-29273: HTTP request failed
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 757
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 735
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 998
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1346
ORA-06512: at "APEX_200200.WWV_FLOW_WEBSERVICES_API", line 608
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION_SOCIAL", line 85
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION_SOCIAL", line 751
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION_NATIVE", line 422
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION_NATIVE", line 1259
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 3213
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 3810
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION", line 1670
- error_backtrace: ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 757
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 735
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 998
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1346
ORA-06512: at "APEX_200200.WWV_FLOW_WEBSERVICES_API", line 608
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION_SOCIAL", line 85
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION_SOCIAL", line 751
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION_NATIVE", line 422
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION_NATIVE", line 1259
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 3213
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 3810
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION", line 1670
ORA-06512: at "APEX_200200.WWV_FLOW", line 2516

Any idea how to solve this?

Comments
Post Details
Added on Mar 8 2022
1 comment
2,157 views