[HACKERS] pg_connect error

When you compiles php, did you ./configure with --with-pgsql? If you did
not compile php explicitly telling it to includ pgsql support, it probably
didn't.

Travis

Brian Edginton (edge@aros.net) wrote:

I don't think that is it. It has been a while, but I thought if you didn't
compile php with psql, it returned an "undefined function" error.

By the way... I just found out a little bit ago that the pgsql-php list is
still alive. :)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Travis Bauer" <trbauer@indiana.edu>
To: "Brian Edginton" <edge@aros.net>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, October 18, 2000 2:28 PM
Subject: Re: [GENERAL] [HACKERS] pg_connect error

When you compiles php, did you ./configure with --with-pgsql? If you did
not compile php explicitly telling it to includ pgsql support, it probably
didn't.

Travis

Brian Edginton (edge@aros.net) wrote:

I'm trying to use the php/postgresql interface via my apache server.
When I try and load a page containing:

<?php $db = pg_connect( "database=mydb owner=me" )
or die ( "could not connect" ) ?>

(both the database and owner are valid and tested via psql)

apache complains:
/usr/libexec/ld.so: Undefined symbol "_PQconnectdb" called from

httpd:/usr/lib/apache/modules/libphp4.so at 0x4030a394

I have verified through ldconfig that libpq.so.2.0 is being loaded into

hints,

And, is the postmaster started with -i?
* Travis Bauer <trbauer@indiana.edu> [001018 13:49]:

When you compiles php, did you ./configure with --with-pgsql? If you did
not compile php explicitly telling it to includ pgsql support, it probably
didn't.

Travis

Brian Edginton (edge@aros.net) wrote:

I'm trying to use the php/postgresql interface via my apache server.
When I try and load a page containing:

<?php $db = pg_connect( "database=mydb owner=me" )
or die ( "could not connect" ) ?>

(both the database and owner are valid and tested via psql)

apache complains:
/usr/libexec/ld.so: Undefined symbol "_PQconnectdb" called from httpd:/usr/lib/apache/modules/libphp4.so at 0x4030a394

I have verified through ldconfig that libpq.so.2.0 is being loaded into hints,
what am I missing?

Thanks,
edge

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Travis Bauer <trbauer@indiana.edu> wrote:

When you compiles php, did you ./configure with --with-pgsql? If you did
not compile php explicitly telling it to includ pgsql support, it probably
didn't.

Yes I did, and postgresql is installed in the default location. Notice that
the pg_connect from the pgsql module (ext/pgsql) is being executed, it's
just not finding the PQconnectdb function from the libpq.so library.

Larry Rosenman <ler@lerctr.org> wrote:

And, is the postmaster started with -i?

Yup.

Larry Rosenman <ler@lerctr.org> wrote:

And, is the postmaster started with -i?

Yup

I noticed that when I was compiling my copy that if I did not specify
the pgsql installation properly, that the ./configure script gave one
error in the middle of the ./configure output that was easy to
miss. At the end, then it gave a warning that did not mention pgsql at all.
Are you sure that you correctly specified the install directory of the pgsql
server?

--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

Brian Edginton (edge@shell.aros.net) wrote: