RE: [mp2] Env Variable / Oracle config problem

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 upan Oracle database connection?

Thanks,

Steve


-----Original Message-----
From: Philippe M. Chiasson [mailto:gozer@ectoplasm.org]
Sent: Friday, November 18, 2005 2:51 PM
To: steved@nmmcc.com
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/foo@bar <mailto:foo/foo@bar>
> 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/foo@bar <mailto:foo/foo@bar> 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/guid...nd_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

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:gozer@ectoplasm.org]
> Sent: Friday, November 18, 2005 2:51 PM
> To: steved@nmmcc.com
> 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/foo@bar <mailto:foo/foo@bar>
> > 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/foo@bar <mailto:foo/foo@bar> 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/guid...nd_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
>
>

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:gozer@ectoplasm.org]
> Sent: Friday, November 18, 2005 2:51 PM
> To: steved@nmmcc.com
> 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/foo@bar <mailto:foo/foo@bar>
> > 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/foo@bar <mailto:foo/foo@bar> 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/guid...nd_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
>
>

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:gozer@ectoplasm.org]
> Sent: Friday, November 18, 2005 2:51 PM
> To: steved@nmmcc.com
> 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/foo@bar <mailto:foo/foo@bar>
> > 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/foo@bar <mailto:foo/foo@bar> 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/guid...nd_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
>
>

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:gozer@ectoplasm.org]
> Sent: Friday, November 18, 2005 2:51 PM
> To: steved@nmmcc.com
> 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/foo@bar <mailto:foo/foo@bar>
> > 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/foo@bar <mailto:foo/foo@bar> 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/guid...nd_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
>
>