Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i Apache mod_plsql problems

Re: Oracle 8i Apache mod_plsql problems

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 17 Jul 2002 19:49:21 +0400
Message-ID: <ah43on$48n$1@babylon.agtel.net>


To administer your DADs through the web gateway admin pages, at least one DAD should exist and you need to access admin pages this way:

/pls/DAD/admin_/gateway.htm

If you have at least one DAD still defined, you can use the above path to access the gateway admin interface and set this DAD to be default so that mod_plsql automatically uses it for you when none is given in path.

I would also recommend protecting your admin pages by adding the following section to httpd.conf or plsql.conf:

<LocationMatch "^(*.)/admin_/(*.)">
Order deny,allow
Deny from all
Allow from your.ip.address.here
... more optional Allow directives to permit access from other hosts </LocationMatch>

This way access will be granted only for hosts whose IPs match those in Allow directives. You can also extend this basic protection by adding

AuthType Basic
AuthName "PL/SQL Gateway Administration" AuthGroupFile /path/to/your/group/file
AuthUserFile /path/to/your/user/file
Require valid user

and creating user file using htpasswd utility and group file using any text editor (group file is simple text file with group definitions one per line in the form
groupname: user user user .....

For more information on configuring Apache security, see http://httpd.apache.org/docs/howto/auth.html

hth.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Wed Jul 17 2002 - 10:49:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US