Em 27 de março de 2012 11:47, Johnny Hughes johnny@centos.org escreveu:
The problem you are having with pgsql not talking to php is not related the error you see with the php-embeded install. The script that is running is running after the install of php-embedded is calling the command "ldconfig". The purpose is to rebuild the linker cache so that CentOS knows where shared libraries are.
You need to look in /etc//ld.so.conf.d/ at all the files and find the ones concerning pgsql ... and see what they have to say about the file in question (/opt/PostgreSQL/psqlODBC/lib/libpq.so.5) and fix it if there is a problem with that file. This is an issue (and you need to fix it), but it does not have anything to do with pgsql not recognizing your PHP.
You also are going to need to install a php-pgsql.rpm in order to get php to work with pgsql. However, that rpm (php-pgsql-<version>.x86_64.rpm) from the CentOS distribution is probably not going to work. It expects to find the shared library libpq.so.5 in /usr/lib64/libpq.so.5 and was built against the 8.4.9 libraries included in CentOS. You are going to need to rebuild the php RPM with it instead pointing at the new libraries and headers from the new postgresql that you want to use.
I would suspect that you are going to need to rebuild any of these packages (if you want to use them) against the new development libraries for the new version of postgresql that you want to use: apr-util-pgsql.x86_64 dovecot-pgsql.x86_64 libdbi-dbd-pgsql.x86_64 mod_auth_pgsql.x86_64 php-pgsql.x86_64 rsyslog-pgsql.x86_64 uuid-pgsql.x86_64
Remember, this stuff (CentOS) is all built to work together and if you want to go outside of that, you have to not only rebuild the specific package in question, but also any packages that link against that package and use its shared libraries.
You can try to install the distro version of php-pgsql, it is possible it will work. You will need to remove any of the centos pgsql items though and make sure the new libraries are in the ldcache.
Thanks, Johnny Hughes
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Thanks Johnny!
you rocks!
ldconfig was mapping /opt/postgresql by ldconfig of pgsqlODBC (I wont need this) Once commented ld.so.conf.d/psqlODBC.conf runs ldconfig and restarted postgresql and httpd and now all its fine!
Thanks