Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: slain on September 22, 2005, 07:38:49 AM

Title: postgres with php on 6.0.1
Post by: slain on September 22, 2005, 07:38:49 AM

Hi people
I have a problem that is driving me nuts,
I am trying to get postgres to play nicely with php
on SME Server 6.0.1-01, (or play  at all for that matter!) I have PHP 4.3.9 and have the php-pgsql module installed as well, I have added the module to the php.ini file via a custom template.  

Despite all this I am stuffed if I can get it to go, a  phpinfo file gives no indication that pgsql is functioning with php. I know postgres is working fine.
and in my messages log I just get  PHP Fatal error:  Call to undefined function:  pg_connect() AKA php cant see postgres...

any ideas that may help?

cheers Jon

Title: postgres with php on 6.0.1
Post by: ergozd on September 22, 2005, 11:19:56 AM

Hi there!

Recently I had to activate it myself so I might have a work around...

Check under /usr/lib of you have

Code: [Select]

lrwxrwxrwx    1 root     root           12 Sep 12 17:57 libpq.so.2 -> libpq.so.2
.2
lrwxrwxrwx    1 root     root           12 Sep 12 17:57 libpq.so.2.0 -> libpq.so
.2.2
-rwxr-xr-x    1 root     root        86098 Nov  4  2003 libpq.so.2.2

They are provided by postgresql-libs-7.2.4-5.73.i386.rpm so I just copied those files WITHOUT installing the RPM, I used Midnight Commander.

You can get all those 3 file (actually 1 file and 2 symbolic links) from

http://ergin.dyndns.org/download/libpostgres2.tar

just untar them in /usr/lib, restart your htrrpd-server (to re-activate php) and try again.

Good luck.

Title: postgres with php on 6.0.1
Post by: slain on September 28, 2005, 06:38:31 AM

Thank you! that worked like a charm!

cheers Jon