ius-community team mailing list archive

[Alex Domoradov <alex.hha@xxxxxxxxx>]

> Are you having any actual issue using the php55u-pgsql module?
No, I don't. I'm just preparing the server and paid attention about pgsql
version

> 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.
it would be very uncomfortable rebuild the whole php after each update.

On Thu, Apr 2, 2015 at 4:20 PM, Carl George <carl.george@xxxxxxxxxxxxx>
wrote:

>  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>
> 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> on behalf of Alex Domoradov <
>> alex.hha@xxxxxxxxx>
>> *Sent:* Wednesday, April 1, 2015 03:22 PM
>> *To:* 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
>>
>
>