Topic: php-pgsql problem

[Frej]

Hi,

just a little question : my postgres server seems to work just fine, so does my web server, and so does php !

I tried different versions of the stuff, but I couldn't get it to work. Here's what I get :
--
[root@server php411]# rpm -Uvh php-pgsql-4.1.1-2.i686.rpm
Preparing...                ########################################### [100%]
   1:php-pgsql              ########################################### [100%]
[root@server php411]# service httpd restart
Stopping httpd:                                            [   OK   ]
Starting httpd: PHP Warning:  Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so: cannot open shared object file: No such file or directory in Unknown on line 0
--

Can anyone tell what I have to do ? I really can't figure out what the problem is.
thx in advance to all of you for helping.

Frej.

[Dan Brown]

Well, I guess the first step is to see if you can find libpq.so on your machine.  As I don't use postgres, I don't know where it would be, but that seems to be what PHP's looking for.  What PostgreSQL RPM did you use?

[Frej]

I've tried different versions, an I'm now running :
php-4.1.1-2.i686.rpm
php-imap-4.1.1-2.i686.rpm
php-ldap-4.1.1-2.i686.rpm
php-mysql-4.1.1-2.i686.rpm
php-pgsql-4.1.1-2.i686.rpm

All except pgsql work fine, in this versionas in other versions I tried.
The file pqsql.so is present as /usr/lib/php4/pgsql.so

[Frej]

Another thing I noticed (maybe it is nomal, but I'm not a unix expert, so...) is that the file libpq.so doesn't exist. Or at least the command :

find / -iname libpq.so -print

doesn't give any answer.
Is that normal ?
Thx for helping

Frej

[Frej]

I guess my first two messages pertty come back to your advice... In fact, I just didn't read very well, as I read php instated of postgres... sorry, I'm pretty tired those days, so....
I currently have installed :
postgresql-7.1.3-1PGDG
postgresql-libs-7.1.3-1PGDG
postgresql-server-7.1.3-1PGDG

I installed all other postgres rpm I found. Installing
postgresql-devel-7.1.3-1PGDG.i386.rpm

just installed libpq.so

... and it now works GREAT.

thx Dan for the advice... even if it could have seamed pretty obvious