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>, yves(dot)guerin(at)muhc(dot)mcgill(dot)ca |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: problem in module Pg with Apache, Perl and SSL |
Date: | 2002-05-16 14:19:09 |
Message-ID: | 3CE3BFDD.9E9C0387@rd.francetelecom.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I think my problem is resolved
In the httpd.conf file, i put the following directives :
PassEnv PATH
PassEnv LD_LIBRARY_PATH
and the error has disappeared.
The "mod_env" module must be loaded in Apache for it works.
Thank you for your help.
Francois
"BELLIARD Francois - FT.BD/FTRD/DRHG/RSCL" wrote:
>
> 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?
> > >
> > >
> > >
>
> --
--
François BELLIARD
FTR&D/DRHG/RSCL - (33) (0)2 96 05 22 51
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Buchmann | 2002-05-16 15:54:22 | Re: Immortal backend .... (kill -9 ?..) |
Previous Message | Rajesh Kumar Mallah. | 2002-05-16 03:25:02 | Re: Immortal backend .... (kill -9 ?..) |