library version problem, 7.3.2, php, redhat linux

From: Richard Welty <rwelty(at)averillpark(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: library version problem, 7.3.2, php, redhat linux
Date: 2003-09-12 00:07:56
Message-ID: Mahogany-0.65.0-9481-20030911-200756.00@averillpark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-12 00:17:16 Re: Picture with Postgres and Delphi
Previous Message Network Administrator 2003-09-12 00:05:38 Re: Picture with Postgres and Delphi