Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (athena.apache.org: domain of SmithCW@ldschurch.org
 designates 216.49.179.92 as permitted sender)
From: Charlie Smith <SmithCW@ldschurch.org>
To: Bruce Johnson <johnson@Pharmacy.Arizona.EDU>,
        Fred Moyer
	<fred@redhotpenguin.com>
CC: mod_perl list <modperl@perl.apache.org>
Subject: RE: Problem with mod_perl and DBI/DBD::Oracle LD_LIBRARY_PATH is
 not being recognized?
Thread-Topic: Problem with mod_perl and DBI/DBD::Oracle LD_LIBRARY_PATH is
 not being recognized?
Thread-Index: AQHOzob9STl8WvFKM02Mvd6xoHKxVJn/2+QAgAAE7oCAAAFmgIAAEYoA//+eiJA=
Date: Mon, 21 Oct 2013 20:11:54 +0000
Message-ID: <63641EA705A403418BF1F5C9E726CB9537E7FB5A@W12112.ldschurch.org>
References: <488A1B02-DF74-419A-B625-CBF407C2ACB5@pharmacy.arizona.edu>
 <CAHrynWBTdaGkk6WVMsvLC9+zhuhTfHBkrjiXLY-qPimx0rvfUA@mail.gmail.com>
 <76E621CC-01D9-4006-AEAA-C0B6D5520217@pharmacy.arizona.edu>
 <CAHrynWC518Ox_Rm6WxE5jMPgY0eZmo8OZV6F13jqEtWV74tEQw@mail.gmail.com>
 <3FAB7F1A-A81B-4D8D-BA2A-850CC9C04807@pharmacy.arizona.edu>
In-Reply-To: <3FAB7F1A-A81B-4D8D-BA2A-850CC9C04807@pharmacy.arizona.edu>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Try setting perl env inside apache config.

Example:

SetEnv PERL5LIB "/usr/lib/5.10.0: /usr/lib/additionalPerlInstallArea"


You also should have=20

LoadModule perl_module modules/mod_perl.so


grep for mod_perl in the Apache error_log file?  you'll see line indicating=
 that mod_perl resuming normal operations.

Try also
PerlResponseHandler ModPerl::RegistryPrefork

Could also try putting in a ScriptAlias directive in httpd.conf for where y=
ou perl scripts are.

Make sure your perl dir is correct.  There may be some aliases etc. needed =
from /usr/lib/localperl to /usr/lib/perl for example.

64 bit perl?


-----Original Message-----
From: Bruce Johnson [mailto:johnson@Pharmacy.Arizona.EDU]=20
Sent: Monday, October 21, 2013 1:46 PM
To: Fred Moyer
Cc: mod_perl list
Subject: Re: Problem with mod_perl and DBI/DBD::Oracle LD_LIBRARY_PATH is n=
ot being recognized?

Right where it's supposed to:

/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so

Again, if this was missing or the build was broken, it wouldn't work on the=
 command line or as a CGI script, either.

This is what's making me go mad...I can't find anything wrong.


%ENV is right
%INC is right

httpd.conf and perl.conf are right, as far as I can tell


I've found one reference to this online that isn't very encouraging:

<http://stackoverflow.com/questions/17050541/unable-to-use-dbdoracle-from-a=
pache-mod-perl>

"Never got to the bottom of this problem. Built different version of Apache=
 and ModPerl and tried various combinations of Oracle client until the prob=
lem went away. Working combination: Apache/2.2.24 (Unix) mod_perl/2.0.7 Per=
l/v5.10.1"

Our sysadmin would rather we kept to the CentOS repos for all this to make =
life easier for managing updates (this is a vm)

On Oct 21, 2013, at 11:42 AM, Fred Moyer <fred@redhotpenguin.com> wrote:

> Where does Oracle.so live on your filesystem?
>=20
>=20
> On Mon, Oct 21, 2013 at 11:37 AM, Bruce Johnson <johnson@pharmacy.arizona=
.edu> wrote:
>=20
> On Oct 21, 2013, at 11:20 AM, Fred Moyer <fred@redhotpenguin.com> wrote:
>=20
> > This is annoying but it happens on 64 bit architectures.
> >
> > > The path is correct, the script works fine on the command line, and i=
f I comment out the handler directives in the perl.conf script, put in a Sc=
riptAlias and process the script as a normal CGI script, it also works.
> >
> > Sounds like some environment variable is not getting passed correctly t=
o mod_perl. Maybe dump out %ENV from the command line and see if there are =
additional vars you need to pass?
>=20
> Nope, good idea but the vars I need are present, even with the modperl=20
> handler in place. The only ones you need for DBD::Oracle to work are=20
> ORACLE_HOME and LD_LIBRARY_PATH
>=20
> DBD::Oracle was properly compiled, else it wouldn't work on the command l=
ine, either.
>=20
> >
> > I'd dump out %INC from the command line and mod_perl also to make sure =
that you are loading the needed modules. You could try to install DBD::Orac=
le in /usr/lib instead of /usr/local/lib also - my guess is that it's looki=
ng for the Oracle.so in /usr/local/lib but it is located somewhere else.
>=20
> With mod_perl there is just one more, /etc/httpd
>=20
> command line:
>=20
> INC-> /usr/local/lib64/perl5
> INC-> /usr/local/share/perl5
> INC-> /usr/lib64/perl5/vendor_perl
> INC-> /usr/share/perl5/vendor_perl
> INC-> /usr/lib64/perl5
> INC-> /usr/share/perl5
> INC-> .
>=20
> server:
>=20
> INC-> /usr/local/lib64/perl5
> INC-> /usr/local/share/perl5
> INC-> /usr/lib64/perl5/vendor_perl
> INC-> /usr/share/perl5/vendor_perl
> INC-> /usr/lib64/perl5
> INC-> /usr/share/perl5
> INC-> .
> INC-> /etc/httpd
>=20
>=20
> >
> >
> > On Mon, Oct 21, 2013 at 10:57 AM, Bruce Johnson <johnson@pharmacy.arizo=
na.edu> wrote:
> > We've set a Directory directive for some perl scripts, setting a mod_pe=
rl handler:
> >
> > Alias /card_access /home/allwebfiles/perl/catcard
> >
> >  <Directory /home/allwebfiles/perl/catcard>
> >      SetHandler perl-script
> >      PerlResponseHandler ModPerl::Registry
> >      PerlOptions +ParseHeaders
> >      Options +ExecCGI
> >      PerlSetEnv LD_LIBRARY_PATH /usr/lib/oracle/11.2/client64/lib
> >      PerlSetEnv ORACLE_HOME /usr/lib/oracle/11.2/client64=20=20
> > </Directory>
> >
> > The %ENV variable is there, if I print the %ENV values:
> >
> > LD_LIBRARY_PATH --> /usr/lib/oracle/11.2/client64/lib MOD_PERL -->=20
> > mod_perl/2.0.4 MOD_PERL_API_VERSION --> 2 ORACLE_HOME -->=20
> > /usr/lib/oracle/11.2/client64 PATH --> /sbin:/usr/sbin:/bin:/usr/bin
> >
> > But trying to initialize a DBI database connection results in the follo=
wing error:
> >
> > [Mon Oct 21 10:10:37 2013] [error] install_driver(Oracle) failed:=20
> > Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for=20
> > module DBD::Oracle: libocci.so.11.1: cannot open shared object file:=20
> > No such file or directory at /usr/lib64/perl5/DynaLoader.pm line=20
> > 200.\n at (eval 11) line 3\nCompilation failed in require at (eval=20
> > 11) line 3.\nPerhaps a required shared library or dll isn't=20
> > installed where expected\n at=20
> > /home/allwebfiles/perl/catcard/oratest.pl line 9\n
> >
> > Which is precisely the error you get when LD_LIBRARY_PATH is unset or i=
ncorrect.
> >
> > libocci.so.11.1 is where it's supposed to be.
> >
> > [root@merthiolate catcard]# ls -l /usr/lib/oracle/11.2/client64/lib=20
> > total 185016
> > -rw-r--r-- 1 root root       368 Sep 17  2011 glogin.sql
> > lrwxrwxrwx 1 root root        17 May 20 12:07 libclntsh.so -> libclntsh=
.so.11.1
> > -rw-r--r-- 1 root root  52761218 Sep 17  2011 libclntsh.so.11.1
> > -rw-r--r-- 1 root root   7955322 Sep 17  2011 libnnz11.so
> > lrwxrwxrwx 1 root root        15 May 20 12:07 libocci.so -> libocci.so.=
11.1
> > -rw-r--r-- 1 root root   1971762 Sep 17  2011 libocci.so.11.1
> > -rw-r--r-- 1 root root 118408281 Sep 17  2011 libociei.so
> > -rw-r--r-- 1 root root    164836 Sep 17  2011 libocijdbc11.so
> > -rw-r--r-- 1 root root   1503303 Sep 17  2011 libsqlplusic.so
> > -rw-r--r-- 1 root root   1477446 Sep 17  2011 libsqlplus.so
> > -rw-r--r-- 1 root root   2095661 Sep 17  2011 ojdbc5.jar
> > -rw-r--r-- 1 root root   2714016 Sep 17  2011 ojdbc6.jar
> > -rw-r--r-- 1 root root    300666 Sep 17  2011 ottclasses.zip
> > -rw-r--r-- 1 root root     66779 Sep 17  2011 xstreams.jar
> >
> > The path is correct, the script works fine on the command line, and if =
I comment out the handler directives in the perl.conf script, put in a Scri=
ptAlias and process the script as a normal CGI script, it also works.
> >
> > I'm confident the issue doesn't have anything to do with DBI or DBD::Or=
acle.
> >
> > It ONLY fails when the script is executed as a mod_perl handler.
> >
> > The script itself is very simple; all I do is create a database handle =
and if no error is thrown, print 'It works'.
> >
> > #!/usr/bin/perl
> > use DBI;
> > use strict;
> >
> > my $login=3D"xxxxxx";
> > my $dbpass=3D'xxxxxxxx';
> > my $dbname=3D"host=3Dxxx.xxx.xxx.xx;sid=3Dxxx";
> > my $dbh =3D DBI->connect("dbi:Oracle:$dbname", $login, $dbpass,=20
> > {RaiseError =3D>1});
> >
> > print "Content-type: text/html\n\n"; print "It Works"; exit;
> >
> > (and this is just a test , any script using DBI fails with this=20
> > error.)
> >
> > What am I missing?
> >
> > --
> > Bruce Johnson
> > University of Arizona
> > College of Pharmacy
> > Information Technology Group
> >
> > Institutions do not have opinions, merely customs
> >
> >
> >
>=20
> --
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
>=20
> Institutions do not have opinions, merely customs
>=20
>=20
>=20

--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs


 NOTICE: This email message is for the sole use of the intended recipient(s=
) and may contain confidential and privileged information. Any unauthorized=
 review, use, disclosure or distribution is prohibited. If you are not the =
intended recipient, please contact the sender by reply email and destroy al=
l copies of the original message.