Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORDS 24.4 TOMCAT REVERSE PROXY NGINX

Raymond AFeb 26 2025

Hi I am struggling to get this to work.
I have read so many blogs on config of all of them and support/metalink.
I am pretty sure nginx is configured correctly.
This is where I am at.
configure nginx
tomcat standard
ords standard
Login window , login. All ok
The problem starts when I click on a menu option to launch a page.
I get the following error
'https://bstest.fancyvillas.com/ords/r/villa/rentals/1?session=13094285090846' was loaded over HTTPS, but requested an insecure XMLHttpRequest endpoint 'http://bstest.fancyvillas.com/ords/r/villa/rentals/login_desktop?session=18823714261910'. This request has been blocked; the content must be served over HTTPS.

nginx config
location /ords/ {
proxy_pass http://10.0.0.153:8080/ords/;
proxy_set_header Origin "";
proxy_redirect off;
proxy_http_version "1.1";
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
#proxy_set_header X-Forwarded-Host $host:$server_port;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
proxy_connect_timeout 600;
proxy_send_timeout 600;
proxy_read_timeout 600;
send_timeout 600;
}
location /i/ {
proxy_pass http://10.0.0.153:8080/i/;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
}
location / {
rewrite ^/(.*)$ /ords/r/villa/rentals last;
}

So then I thought need to add something to ORDS config as I found an article on Oracle support
<entry key="security.httpsHeaderCheck">X-Forwarded-Proto: https</entry>
<entry key="security.externalSessionTrustedOrigins">https://bstest.fancyvillas.com</entry>

Well that did not help as I get continuesly “Your session has ended” Sign in again to create a new session.

Any help would be greatly appreciated.

Comments

Post Details

Added on Feb 26 2025
7 comments
228 views