library version problem, 7.3.2, php, redhat linux - Mailing list pgsql-general

From Richard Welty
Subject library version problem, 7.3.2, php, redhat linux
Date
Msg-id Mahogany-0.65.0-9481-20030911-200756.00@averillpark.net
Whole thread Raw
Responses Re: library version problem, 7.3.2, php, redhat linux
List pgsql-general
ok, i'm confused.

i have two systems. one is redhat 7.1 (a server in colo, reasonably
current), the other is 8.0 (my laptop). the server in colo is running
postgresql 7.3.2 along with redhat's updated versions of apache and php for
7.1 (the php version is 4.1.2) on this server, php can access postgres
without difficulty.

my laptop is also running 7.3.2 along with the apache and php that go with
RH 8.0. i found a need to bring up apache so i could test some php against
postgresql, and was suprised to find that is failing (it'd been a while
since i'd run the web server on this system). reviewing
/var/log/httpd/error_log showed the following:

[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@skipper lib]#

i remember having problems with libpq.so.2 disappearing when i installed
7.3.2, and i had to recompile the exim MTA because i have it using
postgresql, but i don't remember php having these issues.

so why would php->postgresql access be working on the 7.1 system but not
the 8.0 system?

thanks,
  richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

pgsql-general by date:

Previous
From: Network Administrator
Date:
Subject: Re: Picture with Postgres and Delphi
Next
From: Tom Lane
Date:
Subject: Re: Picture with Postgres and Delphi