Did you try setting the env vars in your modperl startup script? (That solved it for me a few months ago)
Enno On Fri, 18 Nov 2005, Steve Duran wrote: > > Thanks, but it did not work. I tried adding the PerlSetEnv lines before > and after this line: > > LoadModule perl_module modules/mod_perl.so > > As well as inside the Directory element. > > Do you know where I can find a sample config/test script for setting up an > Oracle database connection? > > Thanks, > > Steve > > > -----Original Message----- > From: Philippe M. Chiasson [mailto:[EMAIL PROTECTED] > Sent: Friday, November 18, 2005 2:51 PM > To: [EMAIL PROTECTED] > Cc: modperl@perl.apache.org > Subject: Re: [mp2] Env Variable / Oracle config problem > > > Steve Duran wrote: > > > > > > Hello, > > > > > > > > I'm trying to get a basic web app running under mod_perl2, using an > > Oracle database connection. After I define the environment variables > > listed below, the test script works fine from the command line, but > > fails with the following error when I try to run it via the web > > server. If I do not define the environment variables, I get the same > > error on the command line as I do from the web server. > > > > > > > > I have tried different ways of defining the enviroment variables for > > the script, but nothing seems to work. > > > > > > > > This is the error that I get from the web server (Apache 2) > > > > > > > > [Fri Nov 18 14:15:54 2005] [error] Can't load > > '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracl > > e/Oracle.so' > > for module DBD::Oracle: libclntsh.so.9.0: > > cannot open shared object file: No such file or directory at > > /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. > > at /web/cgi-bin/test/test.pl line 6 > > Compilation failed in require at /web/cgi-bin/test/test.pl line 6. > > BEGIN failed--compilation aborted at /web/cgi-bin/test/test.pl line 6. > > > > > > > > > > > > This is and excerpt from httpd.conf: > > > > > > SetEnv ORACLE_HOME /u01/app/oracle/product/9.2.0.4 > > SetEnv ORACLE_USERID foo/[EMAIL PROTECTED] <mailto:foo/[EMAIL PROTECTED]> > > SetEnv ASSUME_KERNEL 2.4.19 > > SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/9.2.0.4/lib > > Try this: > > PerlSetEnv ORACLE_HOME /u01/app/oracle/product/9.2.0.4 PerlSetEnv > ORACLE_USERID foo/[EMAIL PROTECTED] <mailto:foo/[EMAIL PROTECTED]> PerlSetEnv > ASSUME_KERNEL 2.4.19 PerlSetEnv LD_LIBRARY_PATH > /u01/app/oracle/product/9.2.0.4/lib > > More details here: > http://perl.apache.org/docs/1.0/guide/config.html#PerlSetEnv_and_PerlPassEnv > > -------------------------------------------------------------------------------- > Philippe M. Chiasson m/gozer\@(apache|cpan|ectoplasm)\.org/ GPG KeyID : > 88C3A5A5 > http://gozer.ectoplasm.org/ F9BF E0C2 480E 7680 1AE5 3631 CB32 A107 > 88C3A5A5 > >