Welcome to WebmasterWorld Guest from

Forum Moderators: Ocean10000 & incrediBILL & phranque

Message Too Old, No Replies

How to configure Oracle XE with Apache reverse proxy and SSL?

How to configure Oracle XE with Apache reverse proxy and SSL?



4:51 am on Dec 23, 2013 (gmt 0)

We are developing apex application and we want to configure SSL.

Here is details
Oracle XE (10g) database
APEX 4.2

Downloaded and Installed Apache2 (OpenSSL)
Generated key for Open SSL
Generated Certificate
Modified the httpd.conf and SSL.conf

When we type ‘mydomain.com’, the URL is redirecting to ‘https://mydomine/apex/f?p=100:1’. But the page is not loading (Unable to connect).

Here is my modification to HTTPD.conf --

<VirtualHost *:80>
ServerAdmin admin@domine.com
DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs"
ServerName apex-win.domine.com
ErrorLog logs/error_log

<IfModule !mod_rewrite.c>
LoadModule rewrite_module modules/mod_rewrite.so

<IfModule mod_rewrite.c>
RewriteEngine on
ReWriteCond %{SERVER_PORT} !^443$
RewriteRule ^/(.*) [%{HTTP_HOST}...] [NC,R,L]
RewriteRule / [%{HTTP_HOST}...] [NC,R,L]

<IfModule !proxy_module.c>
LoadModule proxy_module modules/mod_proxy.so

<IfModule proxy_module.c>
ProxyRequests Off
<Proxy *>
Order deny,allow
Allow from all

ProxyPass /i [localhost:8080...]
ProxyPassReverse /i [localhost:8080...]
ProxyPass / [localhost:8080...]
ProxyPassReverse / [localhost:8080...]

I have also included KEY and Certificate in SSL.conf.

I have followed below links -
i tried this one too

Can any one help on this.
Thanks & Regards


9:17 am on Jan 20, 2014 (gmt 0)

WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

welcome to WebmasterWorld, Sairam!

But the page is not loading (Unable to connect).

you don't have any virtual servers configured to listen to the secure port.

ReWriteCond %{SERVER_PORT} !^443$
RewriteRule ^/(.*) [%{HTTP_HOST}...] [NC,R,L]
RewriteRule / [%{HTTP_HOST}...] [NC,R,L]

with these rulesets you are redirecting all non-port 443 requests to [%{HTTP_HOST}...] with a 302 status code.
first you should describe how secure urls are distinguished from non-secure urls.
among other issues you should specify the canonical secure hostname in the redirect target instead of %{HTTP_HOST}.
you should also specify a 301 status code by using the R=301 flag.


10:46 am on Jan 20, 2014 (gmt 0)

Hi phranque,
Thank you for you reply.
What i am trying to do is --
I have apex url www.test.com (port 8080)
I have download and installed Apache OpenSSL Apache on Port 80 and OpenSSL on 443. i am able to open [localhost...]
Now the requirement is to open [test.com...] (We don’t have physical files as apex EPG will store everything in database level.) Is this possible?

Thanks & Regards

Featured Threads

Hot Threads This Week

Hot Threads This Month