pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPg from CGI in Apache
5+ messages / 5 participants
[nested] [flat]
* Pg from CGI in Apache
@ 1999-02-14 19:44 Wolfgang Hottgenroth <whottgen@w3plus.de>
1999-02-14 19:54 ` Re: [INTERFACES] Pg from CGI in Apache Tom Lane <tgl@sss.pgh.pa.us>
1999-02-14 19:54 ` Re: [INTERFACES] Pg from CGI in Apache Matthew Hagerty <matthew@venux.net>
0 siblings, 2 replies; 5+ messages in thread
From: Wolfgang Hottgenroth @ 1999-02-14 19:44 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
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?
Wolfgang Hottgenroth
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Pg from CGI in Apache
1999-02-14 19:44 Pg from CGI in Apache Wolfgang Hottgenroth <whottgen@w3plus.de>
@ 1999-02-14 19:54 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 1999-02-14 19:54 UTC (permalink / raw)
To: woho@ieee.org; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Pg from CGI in Apache
1999-02-14 19:44 Pg from CGI in Apache Wolfgang Hottgenroth <whottgen@w3plus.de>
@ 1999-02-14 19:54 ` Matthew Hagerty <matthew@venux.net>
1999-02-14 21:32 ` Re: [INTERFACES] Pg from CGI in Apache Bryan Mattern <bm@datapace.com>
1 sibling, 1 reply; 5+ messages in thread
From: Matthew Hagerty @ 1999-02-14 19:54 UTC (permalink / raw)
To: pgsql-interfaces
Try adding these two lines to your apache httpd.conf file:
SetEnv LD_LIBRARY_PATH /usr/local/pgsql/lib
PassEnv LD_LIBRARY_PATH
Change "/usr/local/pgsql/lib" to where ever your postgres lib directory is.
Matthew
At 08:44 PM 2/14/99 +0100, Wolfgang Hottgenroth wrote:
>Hi,
>
>
>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?
>
>
>Wolfgang Hottgenroth
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Pg from CGI in Apache
1999-02-14 19:44 Pg from CGI in Apache Wolfgang Hottgenroth <whottgen@w3plus.de>
1999-02-14 19:54 ` Re: [INTERFACES] Pg from CGI in Apache Matthew Hagerty <matthew@venux.net>
@ 1999-02-14 21:32 ` Bryan Mattern <bm@datapace.com>
0 siblings, 0 replies; 5+ messages in thread
From: Bryan Mattern @ 1999-02-14 21:32 UTC (permalink / raw)
To: pgsql-interfaces; woho@ieee.org
> At 08:44 PM 2/14/99 +0100, Wolfgang Hottgenroth wrote:
> >
> >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?
Hi Wolfgang,
I had the same error messages some time ago, are you running RedHat 5.2,
too?
If so, go to
http://www.redhat.com/support/docs/rhl/rh52-errata-general.html#perl and
download the updated perl RPM. The new RPM fixes issues that perl had
with some CGI scripts.
After upgrading, I created a link in /usr/lib/perl5/i386-linux/5.00405
-> /usr/lib/perl5/i386-linux/5.00404 and everything works properly.
--bryan
--
Bryan R. Mattern
bm@datapace.com http://www.datapace.com
-- Failure is not an option. It comes bundled with your Microsoft
product.
--------
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Pg from CGI in Apache
@ 1999-02-14 23:53 Bryan Mattern <bm@cc.gatech.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Bryan Mattern @ 1999-02-14 23:53 UTC (permalink / raw)
To: pgsql-interfaces
> At 08:44 PM 2/14/99 +0100, Wolfgang Hottgenroth wrote:
> >
> >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?
Hi Wolfgang,
I had the same error messages some time ago, are you running RedHat 5.2,
too?
If so, go to
http://www.redhat.com/support/docs/rhl/rh52-errata-general.html#perl and
download the updated perl RPM. The new RPM fixes issues that perl had
with some CGI scripts.
After upgrading, I created a link in /usr/lib/perl5/i386-linux/5.00405
-> /usr/lib/perl5/i386-linux/5.00404 and everything works properly.
--bryan
--
Bryan R. Mattern
bm@datapace.com http://www.datapace.com
-- Failure is not an option. It comes bundled with your Microsoft
product.
--------
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-02-14 23:53 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-14 19:44 Pg from CGI in Apache Wolfgang Hottgenroth <whottgen@w3plus.de>
1999-02-14 19:54 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-02-14 19:54 ` Matthew Hagerty <matthew@venux.net>
1999-02-14 21:32 ` Bryan Mattern <bm@datapace.com>
1999-02-14 23:53 Re: [INTERFACES] Pg from CGI in Apache Bryan Mattern <bm@cc.gatech.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox