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

[sairamapex]

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

Here is details
Oracle XE (10g) database
EPG
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 [e-mail]
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>


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

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

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

ProxyPass /i [localhost:8080...]
ProxyPassReverse /i [localhost:8080...]
ProxyPass / [localhost:8080...]
ProxyPassReverse / [localhost:8080...]
</IfModule>
</VirtualHost>

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

I have followed below links -
[davidghedini.blogspot.fi...]
i tried this one too
[liberidu.com...]

Can any one help on this.
Thanks & Regards
Sairam

[phranque]

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.

[sairamapex]

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
Sairam