Hello,
At our project we want to access some plsql procedures via mod_plsql and a Apache http server.
We thought we could do that via adding a DAD to dads.conf like:
<Location /X>
SetHandler pls_handler
Order deny,allow
Deny from all
Allow from <ip-1> <ip-2> <ip-3>
PlsqlDatabaseUsername <username>
PlsqlDatabasePassword <password>
PlsqlDatabaseConnectString <server>:<port>:<SID>
</Location>
But there was no dads.conf present, most likely because it was an older version of the http server than expected.
It appeared to be an Oracle 9i Application Server (iAS), used for Oracle EBS 8.0.6. But correct me if I'am wrong.
We tried to spread the configuration over wdbsvr.app by adding:
[DAD_X]
connect_string = <server>:<port>:<sid>
password = <password>
username = <username>
exclusion_list= sys.*
reuse = Yes
pathalias = X
pathaliasproc = /X
nls_lang=dutch_the netherlands.we8mswin1252
;
and adding to plsql.conf:
<Directory /ucm>
Order Deny,Allow
Deny from all
Allow from <ip-1> <ip-2> <ip-3>
</Directory>
The result was that at the expected url <server>:<port>/pls/X/procedure an authentication popup appeared only at the allowed ip-addresses.
So it seemed to have worked. However the required authentication was unexpected.
Does anyone know how to get rid of the required authentication?
If that is not possible: how I can find the required username and password?
Help is appreciated.
Best regards,
Erik
PS. We tried adding things like <Location /pls/X> AuthAuthoritative off </Location> to files like httpd.conf but it did not seem to have any effect.