As far as FreeBSD goes, LD_LIBRARY_PATH is not searched for setuid programs (aka, Apache). This isn't a problem for CGIs since they don't do a setuid (and are forked off), but Apache does, and mod_perl is in Apache. I think thats right anyway :) You could solve this globaly by running ldconfig (I assume Linux has it, FreeBSD does). You'd be looking for: ldconfig -m <your directory here> Hope that helps. Yann Richard Chen wrote: > > This is a redhat linux 6.2 box with perl 5.005_03, Apache 1.3.12, > mod_perl 1.24, DBD::Oracle 1.06, DBI 1.14 and oracle 8.1.6. > For some odd reason, in order to use DBI, I have to set > LD_LIBRARY_PATH first. I don't think I needed to do this when I > used oracle 7. This is fine on the command line because > I can set it in the shell environment. For cgi scripts, > the problem is also solved by using apache SetEnv directive. However, > this trick does not work under modperl. I had tried PerlSetEnv > to no avail. The message is the same as if the LD_LIBRARY_PATH is not set: > > install_driver(Oracle) failed: Can't load > '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/Oracle/Oracle.so' for module >DBD::Oracle: > libclntsh.so.8.0: cannot open shared object file: No such file or directory at > /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 27) line 3 >Perhaps a required shared > library or dll isn't installed where expected at /usr/local/apache/perl/tmp.pl line >11 > > Here is the section defining LD_LIBRARY_PATH under Apache::Registry: > > PerlModule Apache::Registry > Alias /perl/ /usr/local/apache/perl/ > <Location /perl> > PerlSetEnv LD_LIBRARY_PATH /u01/app/oracle/product/8.1.6/lib > SetHandler perl-script > PerlHandler Apache::Registry > Options ExecCGI > PerlSendHeader On > allow from all > </Location> > > Does anyone know why PerlSetEnv does not work in this case? > How come SetEnv works for cgi scripts? What is the work around? > > Thanks for any info. > > Richard -- -------------------------------------------------------------------- Yann Ramin [EMAIL PROTECTED] Atrus Trivalie Productions www.redshift.com/~yramin Monterey High IT www.montereyhigh.com ICQ 46805627 AIM oddatrus Marina, CA IRM Developer Network Toaster Developer SNTS Developer KLevel Developer (yes, this .signature is way too big) "All cats die. Socrates is dead. Therefore Socrates is a cat." - The Logician THE STORY OF CREATION In the beginning there was data. The data was without form and null, and darkness was upon the face of the console; and the Spirit of IBM was moving over the face of the market. And DEC said, "Let there be registers"; and there were registers. And DEC saw that they carried; and DEC seperated the data from the instructions. DEC called the data Stack, and the instructions they called Code. And there was evening and there was a maorning, one interrupt... -- Rico Tudor William Safire's Rules for Writers: Remembe