On Wed, Jun 16, 2004 at 12:00:32PM -0700, Kevin Moore wrote: > Does anyone have a step by step procedure for configuring apache, > mod_perl, and DBI for accessing an oracle database they'd be willing to > share?
First make sure you can run any script (Perl or otherwise) from the location you are trying to run the Oracle script. You may need put the script under the cgi-bin directory or enable the execution of scripts in the directory you have it. See Apache docs for more information. If you can run simpler scripts, try adding the following to your httpd.conf: SetEnv ORACLE_HOME /path/to/your/oracle/client/installtion SetEnv TNS_ADMIN /ORACLE_HOME/network/admin and restart Apache (or you can set the environment variables in your Perl script). You also may need to set TWO_TASK and LD_LIBRARY_PATH to appropriate values. > I've got Oracle and a simple perl script using dbi to extract data from > a database running from the command line but am receiving "server Error" > when running the same script from the browser so I know the DBI modules > are communicating with the database. If the above doesn't work, check the server logs for more verbose information on the error and post the error to the list (along with perl, DBI, and DBD::Oracle versions). If all else fails, I may be able to dig up some docs on such an install. dd -- David Dooling
