Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round4 - compilation issues on RHEL 7.2 - Mailing list pgsql-general

On 16/05/2017 14:42, Adrian Klaver wrote:

> On 05/16/2017 04:36 AM, Martin Goodson wrote:
>> On 15/05/2017 00:17, Martin Goodson wrote:
>>
>>>
>>> Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :)
>>>
>>> Thank you so much, everybody, for your help! It's been invaluable!
>>>
>>> Regards,
>>>
>>> Martin.
>>>
>>
>> *Sigh*. And things were going so well. With Adrian and Devrim's help
>> I was able to get repmgr compiled on my little ubuntu box at home,
>> and I cheerfully went into work on Monday all ready to get things
>> compiled nicely.
>>
>> I forwarded Devrim's list of redhat/CentOS packages needed to my Unix
>> support colleagues, who installed the libraries listed. I've now got
>> nothing telling me such and such is missing. I now have this instead:
>
> That list would be:
> systemd
> libxslt-devel
> pam-devel
> openssl-devel
> readline-devel
> libmemcached-devel
> libicu-devel
>
> Did you also install?:
>
> krb5-devel
> libedit-devel

Hi.

This is what I see:

$ rpm -qa | grep -i -e "systemd" -e "devel"

systemd-sysv-219-19.el7_2.20.x86_64
keyutils-libs-devel-1.5.8-3.el7.x86_64
krb5-devel-1.13.2-12.el7_2.x86_64
readline-devel-6.2-9.el7.x86_64
libicu-devel-50.1.2-15.el7.x86_64
libgpg-error-devel-1.12-3.el7.x86_64
libxslt-devel-1.1.28-5.el7.x86_64
systemd-libs-219-19.el7_2.20.x86_64
libedit-devel-3.0-12.20121213cvs.el7.x86_64
pam-devel-1.1.8-12.el7_1.1.x86_64
pcre-devel-8.32-15.el7_2.1.x86_64
libsepol-devel-2.1.9-3.el7.x86_64
libverto-devel-0.2.5-4.el7.x86_64
zlib-devel-1.2.7-15.el7.x86_64
ncurses-devel-5.9-13.20130511.el7.x86_64
libgcrypt-devel-1.5.3-12.el7_1.1.x86_64
libxml2-devel-2.9.1-6.el7_2.3.x86_64
libmemcached-devel-1.0.16-5.el7.x86_64
systemd-219-19.el7_2.20.x86_64
libcom_err-devel-1.42.9-7.el7.x86_64
libselinux-devel-2.2.2-6.el7.x86_64
openssl-devel-1.0.1e-51.el7_2.7.x86_64
glibc-devel-2.17-106.el7_2.8.x86_64
xz-devel-5.1.2-12alpha.el7.x86_64cyrus-sasl-devel-2.1.26-20.el7_2.x86_64

So it looks like I've got pretty much everything covered in that respect? :)

> What does
>
> ldd /db_demo/app/postgres/9.6.2-3/lib/libpq.so show?

I get the following:

         linux-vdso.so.1 =>  (0x00007ffd631ae000)
         libssl.so.1.0.0 =>
/db_demo/app/postgres/9.6.2-3/lib/libssl.so.1.0.0 (0x00007f1002aa1000)
         libcrypto.so.1.0.0 =>
/db_demo/app/postgres/9.6.2-3/lib/libcrypto.so.1.0.0 (0x00007f100266a000)
         libgssapi_krb5.so.2 =>
/db_demo/app/postgres/9.6.2-3/lib/libgssapi_krb5.so.2 (0x00007f1002410000)
         libldap_r-2.4.so.2 =>
/db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 (0x00007f10021ae000)
         libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f1001f88000)
         libc.so.6 => /lib64/libc.so.6 (0x00007f1001bc6000)
         libdl.so.2 => /lib64/libdl.so.2 (0x00007f10019c2000)
         libkrb5.so.3 => /db_demo/app/postgres/9.6.2-3/lib/libkrb5.so.3
(0x00007f10016cc000)
         libk5crypto.so.3 =>
/db_demo/app/postgres/9.6.2-3/lib/libk5crypto.so.3 (0x00007f1001486000)
         libcom_err.so.3 =>
/db_demo/app/postgres/9.6.2-3/lib/libcom_err.so.3 (0x00007f1001283000)
         libkrb5support.so.0 =>
/db_demo/app/postgres/9.6.2-3/lib/libkrb5support.so.0 (0x00007f1001075000)
         libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f1000e5b000)
         liblber-2.4.so.2 =>
/db_demo/app/postgres/9.6.2-3/lib/liblber-2.4.so.2 (0x00007f1000c4b000)
         libsasl2.so.3 =>
/db_demo/app/postgres/9.6.2-3/lib/libsasl2.so.3 (0x00007f1000a28000)
         /lib64/ld-linux-x86-64.so.2 (0x00007f1002f3f000)

> whereis libssl.so

For that I get the following:

libssl: /usr/lib64/libssl3.so /usr/lib64/libssl.so
>
>>
>> /lib64/libldap_r-2.4.so.2: undefined reference to `ber_sockbuf_io_udp'
>>
>
> Is that the end of the messages or are there more after the above?

Ah, sorry. A bit got truncated. Here you go:

/bin/ld: warning: libssl.so.1.0.0, needed by
/db_demo/app/postgres/9.6.2-3/lib/libpq.so, may conflict with libssl.so.10
/lib64/libldap_r-2.4.so.2: undefined reference to `ber_sockbuf_io_udp'
collect2: error: ld returned 1 exit status
make: *** [repmgrd] Error 1


>
> So above when you said your colleagues installed the packages for you,
> was that on the host or the virtual machine?
>

All installed on the virtual machine I'm building this on. See the rpm
list above. At my level of visibility it's just 'another server' - I
just mentioned it was a virtual one rather than an actual bit of tin in
case it were to somehow make a difference.

Regards,

Martin.
--
Martin Goodson

"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."