Re: problem in module Pg with Apache, Perl and SSL

Lists: pgsql-admin
From: Morten Sickel <Morten(dot)Sickel(at)nrpa(dot)no>
To: "'BELLIARD Francois - FT(dot)BD/FTRD/DRHG/RSCL'" <fb001(at)rd(dot)francetelecom(dot)com>
Cc: "Pgsql-Admin (E-post)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: problem in module Pg with Apache, Perl and SSL
Date: 2002-04-17 15:46:01
Message-ID: 54DE9A561AD20C4D9FF88B116965420E02A016@postix.nrpa.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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;

and afterwards
$dbh = DBI->connect("dbi:Pg:dbname=$dbname", $dbuser, $dbpass)

(If you are using any other module, please have me excused, I am not using
Solaris so I am not able to try to reproduce your error messages.)

Best regards

Morten

--
Morten Sickel
Norwegian Radiation Protection Authority

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: "Pgsql-Admin (E-post)" <pgsql-admin(at)postgresql(dot)org>
Cc: "'BELLIARD Francois - FT(dot)BD/FTRD/DRHG/RSCL'" <fb001(at)rd(dot)francetelecom(dot)com>
Subject: Re: problem in module Pg with Apache, Perl and SSL
Date: 2002-04-17 16:02:33
Message-ID: Pine.LNX.4.21.0204171658100.20382-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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?

--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants

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>
Cc: "Pgsql-Admin (E-post)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: problem in module Pg with Apache, Perl and SSL
Date: 2002-04-18 14:38:00
Message-ID: 3CBEDA48.517244A2@rd.francetelecom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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?

--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants

---------------------------(end of broadcast)---------------------------

TIP 6: Have you searched our list archives?

http://archives.postgresql.org <http://archives.postgresql.org>

--

François BELLIARD

FTR&D/DRHG/RSCL - (33) (0)2 96 05 22 51