On Wed, 10 Jul 2002 09:43:05 -0400 "Kong, Alan" <[EMAIL PROTECTED]> wrote:
> I have a problem with perl5.6.1, DBI1.21, DBD::Oracle1.12 and > apache1.3.26. > > My perl script works fine in command line, but not working when I call it > through browser. The followings are the error message from the apache > error_log: > > install_driver(Oracle) failed: Can't load > '/opt/perl5/lib/site_perl/5.6.1/PA-RISC2.0-thread-multi/auto/DBD/Oracle/O > rac > le.sl' for module DBD::Oracle: No such file or directory at > /opt/perl5/lib/5.6.1/PA-RISC2.0-thread-multi/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at /opt/apache/cgi-bin/alan1.pl line 11 This usually means the process the webserver runs under either doesn't have permission to execute the necessary shared libraries or some environment variable needed to find them isn't set. Make sure ORACLE_HOME is set to an Oracle tree of the same version as DBD::Oracle was built against. You may also need to add $ORACLE_HOME/lib to LD_LIBRARY_PATH or something similar. Also make sure the webserver's account has sufficient permisions (at least execute and possibly read) on Oracle.sl and the files in $ORACLE_HOME/lib. If the script works from the command line and not from the webserver, it's a webserver/CGI problem, not a DBI one. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.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.
