topic Re: Oracle HTTP Server URL Redirection in Operating System - HP-UX

Oracle HTTP Server URL Redirection

Sundar_7 — Tue, 20 Apr 2004 12:58:45 GMT

I am asked to setup a Oracle HTTP server in one of my development server. We are going to primarily use the mod_plsql module to execute the SQL procedures on a database instance.

I configured Database Access Descriptor (DAD) and managed to get everything working

Now the user has to try

http:///pls//
http://somewebserver.comp.com/pls/database1/helloworld

But since this server is going to be used for executing the procedure only on one database I would like the user to be able to use

http:///

http://somewebserver.comp.com/helloworld.

I am very new to apache and tried rewriting URL rules - any help will be appreciated

-- Sundar.

Re: Oracle HTTP Server URL Redirection

Steven E. Protter — Tue, 20 Apr 2004 13:11:56 GMT

Oracle http server is an apache port.

All redirection that works with apache will work with oracle. That includes web pages and httpd.conf directives.

httpd syntax check should show some potential problems.

SEP

Re: Oracle HTTP Server URL Redirection

Ganesh Babu — Tue, 20 Apr 2004 13:46:41 GMT

can u post what u rewrote for the URL rules and which files??

Ganesh

Re: Oracle HTTP Server URL Redirection

Sundar_7 — Tue, 20 Apr 2004 15:20:48 GMT

RewriteEnginer on
RewriteRule ^/(.+)$ /pls/database1/$1

Re: Oracle HTTP Server URL Redirection

Ganesh Babu — Tue, 20 Apr 2004 15:46:05 GMT

Can u try this

RewriteEngine on
RewriteCond %{HTTP_PHOST} ^(.)+$
RewriteRule ^/(.+)$ pls/database1/$1 [R]

Ganesh

Re: Oracle HTTP Server URL Redirection

Sundar_7 — Tue, 20 Apr 2004 17:48:17 GMT

Ganesh, it did nt help

Re: Oracle HTTP Server URL Redirection

Ganesh Babu — Tue, 20 Apr 2004 18:09:52 GMT

Sundar,

this line

RewriteCond %{HTTP_PHOST} ^(.)+$

is not HTTP_PHOST it has to be HTTP_HOST..

sorry i missed it..

Ganesh

Re: Oracle HTTP Server URL Redirection

Sundar_7 — Tue, 20 Apr 2004 18:45:21 GMT

The result is same Ganesh