From: | "BELLIARD Francois - FT(dot)BD/FTRD/DRHG/RSCL" <fb001(at)rd(dot)francetelecom(dot)com> |
---|---|
To: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: problem in module Pg with Apache, Perl and SSL |
Date: | 2002-05-15 09:05:40 |
Message-ID: | 3CE224E4.7E57D6DE@rd.francetelecom.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
Thank you for your information. I have tried it outside Apache.
The script works well when it is run by itself and if the user "nobody" has a correct
LD_LIBRARY_PATH.
Apache is started by the "root" user with a correct LD_LIBRARY_PATH and then the child
processes are run as "nobody" as specified in the httpd.conf file :
User nobody
Group nobody
It looks like the child process does not heritate the library path in its environment
when run inside Apache.
A normal perl script without "use Pg;" runs correctly in Apache
When using Pg, the error in Apache log is the following :
_____________
Can't load '/usr/local/perl-5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/Pg/Pg.so' for module Pg: ld.so.1:
/usr/local/perl-5.6.1/bin/perl: fatal: libssl.so.0.9.6: open failed: No such file or directory at
/usr/local/perl-5.6.1/lib/5.6.1/sun4-solaris/DynaLoader.pm line 206.
at /home/www/smada/private/cgi-bin/latestChanges.pl line 2
Compilation failed in require at /home/www/smada/private/cgi-bin/latestChanges.pl line 2.
BEGIN failed--compilation aborted at /home/www/smada/private/cgi-bin/latestChanges.pl line 2
-------------
François BELLIARD
FTR&D/DRHG/RSCL
"Nigel J. Andrews" wrote:
>
> OK, so if you use the Pg module outside of Apache, i.e. just in a normal
> perl
> script, do you get the same error or can the module be found?
>
> [I'm sorry, I see I snipped some of your original posting and I can't
> remember
> if you've already effectively answered this by saying it worked until
> you
> started using SSL]
>
> --
> Nigel J. Andrews
> Director
>
> ---
> Logictree Systems Limited
> Computer Consultants
>
> On Thu, 18 Apr 2002, BELLIARD Francois - FT.BD/FTRD/DRHG/RSCL wrote:
>
> > The web server is not chrooted and when Apache is started, the
> > LD_LIBRARY_PATH variable points to all the directories containing the
> > libraries
> >
> >
> > "Nigel J. Andrews" wrote:
> >
> > On Wed, 17 Apr 2002, Morten Sickel wrote:
> >
> > > BELLIARD Francois wrote:
> > > [Snip]
> > > >When a Perl Cgi script tries to load the "Pg" module (use Pg; in
> > the
> > > script),
> > > >there is the following error in the Apache Error Log :
> > > [Snip]
> > >
> > > I cannot find any 'Pg' module at CPAN, but if you are using the
> > DBD-Pg, you
> > > are not supposed to have any 'use Pg;' in your code, but rather
> > > use DBI;
> >
> >
> > Or of course he could be using the Pg module :)
> >
> >
> > As for the problem of not finding the library file. You say they
> exist,
> > you
> > presumably have checked they exist at the paths in the root filesystem
>
> > the
> > error message mentions. Is your web server/cgi-bin program running in
> a
> > chroot
> > box?
> >
> >
> >
--
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah. | 2002-05-15 13:16:05 | Immortal backend .... (kill -9 ?..) |
Previous Message | Gordon Luk | 2002-05-15 08:27:06 | Problem: upgrade from 7.1.3 to 7.2.1 ( database encode with ENC_TW) |