Thread: [HACKERS] pg_connect error
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
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 >
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, > > what am I missing? > > > > Thanks, > > edge > >
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
Larry Rosenman <ler@lerctr.org> wrote: > And, is the postmaster started with -i? Yup
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. > 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 <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: > 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. > > > Travis > > > Brian Edginton (edge@aros.ne