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