homepage Welcome to WebmasterWorld Guest from 50.17.86.12
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Apache Web Server
Forum Library, Charter, Moderators: Ocean10000 & incrediBILL & phranque

Apache Web Server Forum

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



 
Msg#: 4632948 posted 4:51 am on Dec 23, 2013 (gmt 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 ^/(.*) https://%{HTTP_HOST}/apex/f?p=100:1 [NC,R,L]
RewriteRule / https://%{HTTP_HOST}/apex/f?p=100:1 [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

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



 
Msg#: 4632948 posted 9:17 am on Jan 20, 2014 (gmt 0)

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 ^/(.*) https://%{HTTP_HOST}/apex/f?p=100:1 [NC,R,L]
RewriteRule / https://%{HTTP_HOST}/apex/f?p=100:1 [NC,R,L]

with these rulesets you are redirecting all non-port 443 requests to https://%{HTTP_HOST}/apex/f?p=100:1 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



 
Msg#: 4632948 posted 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 https://localhost/.
Now the requirement is to open https://www.test.com/. (We don’t have physical files as apex EPG will store everything in database level.) Is this possible?

Thanks & Regards
Sairam

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Apache Web Server
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved