ius-community team mailing list archive

[Carl George <carl.george@xxxxxxxxxxxxx>]

It is just showing you the version it was compiled against.  The soname is used to indicate ABI compatibility [0].  Since the library soname is the same, 8.4 and 9.3 should be binary compatible.  Are you having any actual issue using the php55u-pgsql module?  It looks like this is just a cosmetic issue that could be cleaned up by doing your own rebuild from our spec file [1] on your system.


[0] http://en.wikipedia.org/wiki/Soname

[1] https://github.com/iuscommunity-pkg/php55u

?

Carl George
Rackspace RPM Development
________________________________
From: Alex Domoradov <alex.hha@xxxxxxxxx>
Sent: Thursday, April 2, 2015 02:20 AM
To: Carl George
Cc: ius-community@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Ius-community] php55u and postgresql 9.3 on centos 6

> Since you didn't mention where those postgresql RPMs came from, I just checked CentOS and Fedora RPMs to figure out the soname for 8.4 and 9.3.
sorry, forgot about the source. I have installed PosgreSQL from off site - http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm

> Your postgresql RPMs should provide "libpq.so.5()(64bit)", so in theory they should work just fine with php55u-pgsql.
it is

# find /usr -name libpq.so* -print
/usr/pgsql-9.3/lib/libpq.so.5
/usr/pgsql-9.3/lib/libpq.so.5.6

# rpm -qf /usr/pgsql-9.3/lib/libpq.so.5
postgresql93-libs-9.3.6-1PGDG.rhel6.x86_64

As you can see on the screen - http://i.imgur.com/lpfecl9.png

So my question is - why phpinfo show me incorrect posgresql info? Where it takes the info?


On Thu, Apr 2, 2015 at 12:13 AM, Carl George <carl.george@xxxxxxxxxxxxx<mailto:carl.george@xxxxxxxxxxxxx>> wrote:
php55u-pgsql just has a dependency on the soname, not the exact package name.

$ repoquery --requires php55u-pgsql | grep libpq
libpq.so.5()(64bit)

Since you didn't mention where those postgresql RPMs came from, I just checked CentOS and Fedora RPMs to figure out the soname for 8.4 and 9.3.


$ rpm -qp --provides postgresql-libs-8.4.20-2.el6_6.x86_64.rpm |& grep libpq.so.5
libpq.so.5()(64bit)
$ rpm -qp --provides postgresql-libs-9.3.6-1.fc20.x86_64.rpm |& grep libpq.so.5
libpq.so.5()(64bit)


Your postgresql RPMs should provide "libpq.so.5()(64bit)", so in theory they should work just fine with php55u-pgsql.

?
Carl George
Rackspace RPM Development
________________________________
From: Ius-community <ius-community-bounces+carl.george=rackspace.com@xxxxxxxxxxxxxxxxxxx<mailto:rackspace.com@xxxxxxxxxxxxxxxxxxx>> on behalf of Alex Domoradov <alex.hha@xxxxxxxxx<mailto:alex.hha@xxxxxxxxx>>
Sent: Wednesday, April 1, 2015 03:22 PM
To: ius-community@xxxxxxxxxxxxxxxxxxx<mailto:ius-community@xxxxxxxxxxxxxxxxxxx>
Subject: [Ius-community] php55u and postgresql 9.3 on centos 6

Hello

Is it possible to use php55u-pgsql package with the following postgresql packages?

postgresql93-9.3.6-1PGDG.rhel6.x86_64
postgresql93-libs-9.3.6-1PGDG.rhel6.x86_64
postgresql93-server-9.3.6-1PGDG.rhel6.x86_64

As I see in the phpinfo output it show me that php has been linked with older pgsql library

PostgreSQL Support enabled
PostgreSQL(libpq) Version 8.4.20
PostgreSQL(libpq) PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
Multibyte character support enabled
SSL support enabled

# ldd /usr/lib64/php/modules/pgsql.so | grep sql
        libpq.so.5 => /usr/pgsql-9.3/lib/libpq.so.5 (0x00007fad004b2000)

But at the same time

# strings /usr/lib64/php/modules/pgsql.so | grep 8.4
PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
8.4.20

So I'm a little bit confused. Could anyone point me in the right way?

Thanks in advance