[cobalt-users] php & postgres

[Brian Kosick <briank@xxxxxxxx>]

Hello all,

I'm having a problem using the postgres capabilities of PHP.  I recently 
restored my Raq3 using the OS4 restore CD, worked great, I basically have 
the vanilla system, with all the updates from cobalt installed.  The 
restore CD, installed PHP 4.0.3pl1, when I try to connect to postgres I get 
an error

Fatal error: Call to undefined function: pg_connect() in 
/home/sites/home/web/phpPgAdmin/lib.inc.php on line 130

I created a test page that looked like
<?
	phpinfo();
?>

Here's the results

./configure' '--prefix=/usr' '--with-apxs=/usr/sbin/apxs' '--with-gd'
'--with-gettext=/usr' '--enable-safe-mode' '--with-config-file-path=/etc/httpd'
'--with-exec-dir=/usr/bin' '--with-zlib' '--enable-magic-quotes'
'--with-regex=system' '--with-ttf=/usr/lib/libttf.so' '--enable-track-vars'
'--enable-xml' '--disable-debug' '--with-db3' '--with-interbase=shared'
'--with-pgsql=shared' '--with-ldap' '--with-imap'

As you can see, it has pgsql compiled in as a shared module.

an rpm -ql php to see where the libs are located turns up

/usr/lib/apache/libphp4.so
/usr/lib/apache/php
/usr/lib/apache/php/interbase.so
/usr/lib/apache/php/pgsql.so

Is this a known problem with cobalts pkg/rpm of PHP?  Is there a pkg 
available, that would fix this?  Or is it perhaps looking in the wrong 
place for the libs?  (If so, where would I point it to look for the right 
ones?)

Thanks in advance
Brian Kosick
Web Programmer
New Age Consulting Service, Inc.
216-619-2000
briank@xxxxxxxx