Re: problem with DBD::Oracle

On 05/25/2005 04:46 AM, Malka Cymbalista said:

Our web server is running Apache 2.0.48 with mod_perl 1.99_12 on a Sun
machine running Solaris 9. We are running perl 5.8.1, DBI 1.39 and
DBD-Oracle 1.16. We are trying to connect from our web server to an
Oracle database that is on a different machine. The script that we
wrote to do this runs perfectly well when we run it from the command
line as a plain user. However, when we try running it from the web, we
cannot connect to the database.

As I said at the start, the script works perfectly well from the
command line even when it is run from the same userid that the web runs
under. 

Any suggestions to get this working from the web will be greatly
appreciated.  Thanks in advance.

After environment variables, I'd check the access rights to Oracle.so and the files in $ORACLE_HOME/lib.

--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
.