difficulty building PostgreSQL with PHP4? - Mailing list pgsql-general

From Phil Glatz
Subject difficulty building PostgreSQL with PHP4?
Date
Msg-id 5.1.0.10.2.20010226170812.03624cf8@flawless.net
Whole thread Raw
Responses Re: difficulty building PostgreSQL with PHP4?  (GH <grasshacker@over-yonder.net>)
Re: difficulty building PostgreSQL with PHP4?  (Chris <csmith@squiz.net>)
Re: difficulty building PostgreSQL with PHP4?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I've just built Apache 1.3.17 on Free BSD, using php-4.0.1pl2 and linking
with the PostgreSQL 7.0.3 as a shared object.  I created a test database,
with proper permissions for the web server.  I can query it with psql, and
I see a socket as "/tmp/.s.PGSQL.5432=".

I also linked in mySQL support, which works correctly.

When I try accessing the posters database by calling
pg_Connect("dbname=test"), my web server doesn't even display a page, other
than "this page cannot be displayed" (in IE) or "page contains no data"
(Netscape).

The error log displays:
(null): Undefined symbol "_PQsetdbLogin" called from
httpd:/com/apache/libexec/libphp4.so at 0x8256498

A friend suggested calling pg_Connect with no arguments - if I do that, the
page displays with the error "Wrong parameter count for
pg_connect()".  This implies the postgres library was able to resolve with
php, and something else may be the problem when I add arguments.

Are there issues with PHP4?
Is there a problem building both postgres and mysql support?
Should I be using a static module build for PHP, rather than a DSO?

thanks.


pgsql-general by date:

Previous
From: Ben Leslie
Date:
Subject: Correct behaviour of "DROP DATABASE"
Next
From: Scott Parish
Date:
Subject: corrupted pg_xlog/0000000000000000