ORDS, SODA & JSON in the Database

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!

How to log X-FORWARDED-FOR instead of REMOTE_ADDR in apex_workspace_sessions

SashaFeb 1 2025 — edited Feb 1 2025

Hi, guys!

After moving proxing from ajp to http (as ajp is not supported officially by ORDS) we got an IP of proxy not real client in apex_workspace_sessions.remote_addr as APEX seems to get OWA_UTIL.GET_CGI_ENV('REMOTE_ADDR')) but not
OWA_UTIL.GET_CGI_ENV('X-FORWARDED-FOR').

I guess ORDS's settings can change it to log real clients ip (X-FORWARDED-FOR)

Appreciate for Your ideas.

This post has been answered by jariola on Feb 3 2025

Jump to Answer

Added on Feb 1 2025

7 comments

636 views