Re: library version problem, 7.3.2, php, redhat linux

On Fri, 2003-09-12 at 08:06, Richard Welty wrote:
> On Fri, 12 Sep 2003 07:21:19 +0100 (BST) "Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk> wrote:
>
> > On Thu, 11 Sep 2003, Richard Welty wrote:
> >
> > > [Thu Sep 11 16:17:25 2003] [notice] caught SIGTERM, shutting down
> > > PHP Warning: Unable to load dynamic library '/usr/lib/php4/pgsql.so'
> > > - libpq.so.2: cannot open shared object file: No such file or
> > directory
> > > in Unknown on line 0
> >
> > > this seems to clearly be a library versioning problem, as
> > > "ls -l /usr/lib/libpq*" gives me
>
> > > -rw-r--r-- 1 root root 113800 Feb 5 2003 /usr/lib/libpq.a
> > > lrwxrwxrwx 1 root root 12 Jun 26 14:19 /usr/lib/libpq.so ->
> > libpq.so.3.0
> > > lrwxrwxrwx 1 root root 12 Aug 1 08:09 /usr/lib/libpq.so.3 ->
> > libpq.so.3.0
> > > -rwxr-xr-x 1 root root 552967 Jul 28 18:30 /usr/lib/libpq.so.3.0
> > > [root(at)skipper lib]#
>
> > Well not quite. The complaint is that the PHP interface to PostgreSQL
> > isn't
> > found.
>
> i don't think so.
>
> /usr/lib/php4/pqsql.so is there, and is generating the message. pqsql.so is
> complaining that it can't find /usr/lib/libpq.so.2
>

correct. libpq comes from postgresql, not php

> if you look at the ls -l, you clearly see that /usr/lib/libpq.so.2 is not
> there. this change in library versions happened when i upgraded to 7.3.2, i
> had to recompile some stuff, but on the 7.1 machine i didn't have to make
> any changes to php, and on the 8.0 machine, clearly there's an issue. since
> in installing 7.3.2 i stepped out of the normal rh release cycle, it's not
> obvious how to go forward from here.

chances are on your colo box they installed 7.2 at some point which gave
you libpq.so.2 (or someone symlinked the 2 files so as to hack there way
out of this problem). i think your choices now are to install 7.2
pgsql-libs rpm on the 8.0 box or to recompile apache/php so it links
against libpq.so.3

Robert Treat

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL