Hi Bruce
On Fri, Oct 18, 2013 at 07:56:52PM +0000, Bruce Johnson wrote:
> First thing I checked, and they're set correctly;
>
> >From %ENV on the broken system:
>
>
> ORACLE_HOME --> /usr/lib/oracle/12.1/client64
> LD_LIBRARY_PATH --> /usr/lib/oracle/12.1/client64/lib
>
but the original error is
Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so'
The error under the web server environment is saying Oracle.so is not in
/usr/local/lib64/perl5/auto/DBD/Oracle which is where it is looking for it.
I'm assuming Oracle.so is installed on your system somewhere because the script
works on the command line but not from within Apache.
Perhaps check and compare the %ENV in Apache with the command-line %ENV? And
note Apache is looking for the /usr/local/lib64 directory - not anything in
/usr/lib or /usr/lib64.
Kind regards
Lesley
>
> This is the only thing I can think of that could cause this error. I've
> compared permissions, etc with a working server and I see nothing wrong. The
> only main difference is that the problem system is running version 12 of the
> Instant Client and the working one is running 11.2, but that would cause the
> program to fail on the command line as well.
>
> On Oct 18, 2013, at 12:30 PM, "Furst, Carl" <carl.fu...@mlb.com>
> wrote:
>
> > Ld_library_path is getting set in apache configs or wrapper scripts?
> >
> > Have you tried setting
> > SetEnv LD_LIBRARY_PATH
> >
> > In httpd.conf?
> >
> > Or have it set when you call apachectl??
> >
> >
> >
> > Carl Furst
> >
> >
> >
> >
> > On 10/18/13 3:10 PM, "Bruce Johnson" <john...@pharmacy.arizona.edu> wrote:
> >
> >> I'm getting the following error on a newly set-up server:
> >>
> >> [Fri Oct 18 12:02:06 2013] [error] install_driver(Oracle) failed: Can't
> >> load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module
> >> DBD::Oracle: libocci.so.12.1: cannot open shared object file: No such
> >> file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.\n at (eval
> >> 11) line 3\nCompilation failed in require at (eval 11) line 3.\nPerhaps a
> >> required shared library or dll isn't installed where expected\n at
> >> /home/webfiles/apply/perl/oratest.pl line 7\n
> >>
> >>
> >> It's a really simple script that just connects to the database:
> >>
> >> #!/usr/bin/perl
> >> use DBI;
> >> use strict;
> >> my $login="xxxxxx";
> >> my $dbpass='xxxxxx';
> >> my $dbname="host=xxxxx.xxxx.xxxxx.xxxx;sid=xxxxxx";
> >> my $lda = DBI->connect("dbi:Oracle:$dbname", $login, $dbpass, {RaiseError
> >> =>1});
> >> print "Content-type: text/html\n\n";
> >> print "It Works";
> >> exit;
> >>
> >>
> >> I've confirmed that Apache has the correct LD_LIBRARY_PATH and
> >> ORACLE_HOME vars set yet whenever we run the script on the web server we
> >> get the error.
> >>
> >> On the command line it's:
> >>
> >> [root@xxxx perl]# perl oratest.pl
> >> Content-type: text/html
> >>
> >> It Works
> >>
> >>
> >> Any ideas?
> >>
> >> --
> >> Bruce Johnson
> >> University of Arizona
> >> College of Pharmacy
> >> Information Technology Group
> >>
> >> Institutions do not have opinions, merely customs
> >>
> >>
> >
> >
> >
> >
> >
> >
> > **********************************************************
> >
> > MLB.com: Where Baseball is Always On
>
> --
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
>
> Institutions do not have opinions, merely customs
>
>
