Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6])
	by hub.org (8.9.2/8.9.1) with ESMTP id OAA06816
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 14 Feb 1999 14:55:12 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id OAA10667;
	Sun, 14 Feb 1999 14:54:29 -0500 (EST)
To: woho@ieee.org
cc: PostgreSQL Interface List <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Pg from CGI in Apache 
In-reply-to: Your message of Sun, 14 Feb 1999 20:44:55 +0100
	<36C727B7.8FA10E0B@w3plus.de>
Date: Sun, 14 Feb 1999 14:54:29 -0500
Message-ID: <10665.919022069@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Wolfgang Hottgenroth <whottgen@w3plus.de> writes:
> I tryed to use some functions from the Pg-module from a CGI-script,
> started on a Apache-server. I always get only an error-message, that
> Dynaloader can not resolve the symbols from Pg, althrough I am able to
> start the scripts directly from the shell without problems.
> Did anyone knows problems like that?

Lack of an appropriate environment variable setting in the CGI context
is probably the problem --- LD_LIBRARY_PATH (or your platform's
equivalent) is the first thing I'd check for.  You may also find that
your scripts are depending on other things in your shell environment,
like PGHOST, PGPASSWORD, etc...

			regards, tom lane