Welcome to WebmasterWorld Guest from 54.146.221.231

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)

New User

joined:Dec 23, 2013
posts:2
votes: 0


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 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>


<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
9:17 am on Jan 20, 2014 (gmt 0)

Administrator

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

joined:Aug 10, 2004
posts:10544
votes: 8


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)

New User

joined:Dec 23, 2013
posts:2
votes: 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
Sairam