Postgres

[asmo69]

For a company project I am attempting to web based system using php and postgres (Postgres was chosen because it is the database already used).

I can compile the apache module with mysql support fine (this was done a long time ago). However when I try to compile in postgres support as well I get the following error when I run httpd:

Syntax error on line 99 of
/usr/local/apache/conf/httpd.conf:
Cannot load
/usr/local/apache/libexec/libphp4.so into server:
/usr/local/apache/libexec/libphp4.so:
undefined symbol: PQoidValue

I am using the following versions of sotware:

Apache 1.3.12
php 4.0.6
postgresql 7.1.3

and am compiling php using:

./configure --with-apxs=/usr/local/apache/bin/apxs --enable-debug=no --enable-safe-mode --with-mysql --with-pgsql --with-system-regex

the configure runs fine, as does the "make" and the4 "make install". If i remove the reference to pgsql then it all compiles and runs without fault.

Can someone please me on this?

[toma42]

Try specifying the path to the pgsql install in your configure

[php4hosting]

Check /etc/ld.so.conf and make sure the path is set to the PG files and then run ldconfig

i.e.
/usr/local/pgsql/lib

Regards
Darren
http://www.php4hosting.com

[gid__]

I'd try Tom Anderson's advice.

use --with-pqsql=/usr/src/whereveryouinstalled_postgres

If you don't specify that directory, then php uses it's own internal postgres library which may or may not be compatible with your version of postgres, you likewise, should do the same thing with mysql

[asmo69]

I have tried setting the --with-pgsql=/usr/local/pgsql and I still get the same thing.