[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

apache->php->postgresql on obsd2.7 problem



I'm having a heck of a time getting php to access postgresql via
the apache server. I've compiled php 4.0.2 with pqsql support and
installed it into apache. When I try to connect to a database with
the php function $db = pg_connect( "database=bfc user=edge" ) 

apache complains with:

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

PQconnectdb is in the pgsql/lib/libpq.so which appears to be noticed by
ld.so

s:~/php-4.0.2 [88] ldconfig -r | grep libpq
      45:-lpq++.3.0 => /usr/local/pgsql/lib/libpq++.so.3.0
      56:-lpq.2.0 => /usr/local/pgsql/lib/libpq.so.2.0

I can write a small c program using libpq and do the connect so PQconnectdb is
finding it when linked directly.

phpinfo() tells me that pgsql support is turned on, php is obviously
running in apache. It appears to be a dlopen problem, but I sure can't
seem to find the answer. Anyone have to solve this one already?

edge

- 
Brian Edginton                        
edge_(_at_)_edginton_(_dot_)_net




Visit your host, monkey.org