Em 27 de março de 2012 11:47, Johnny Hughes <johnny at 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 at 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