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

On 17/05/2017 16:15, Adrian Klaver wrote:

> On 05/17/2017 07:26 AM, Martin Goodson wrote:
>> On 16/05/2017 18:46, Adrian Klaver wrote:
>>> Per Tom's suggestion try
>>>
>>> ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2
>>
>> Hello. Apologies for the delay in replying - medical appointment this
>> morning :) Anyway, executed that command as suggested and this is the
>> output I got.
>>
>> pginst@testdemo00:/db_demo/app/postgres/9.6.2-3/lib$ ls -lrt *ldap*
>>
>> -rwxr-xr-x 1 pginst gpginst 354K Mar 13 11:25 libldap-2.4.so.2
>> -rwxr-xr-x 1 pginst gpginst 383K Mar 13 11:25 libldap_r-2.4.so.2
>>
>
>>
>> pginst@testdemo00:/db_demo/app/postgres/9.6.2-3/lib$ ldd
>> libldap_r-2.4.so.2
>>          linux-vdso.so.1 =>  (0x00007ffcd12e4000)
>>          liblber-2.4.so.2 =>
>> /db_demo/app/postgres/9.6.2-3/lib/./liblber-2.4.so.2
>> (0x00007f20ff9a1000)
>>          libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f20ff77d000)
>>          libsasl2.so.3 =>
>> /db_demo/app/postgres/9.6.2-3/lib/./libsasl2.so.3 (0x00007f20ff55b000)
>>          libssl.so.1.0.0 =>
>> /db_demo/app/postgres/9.6.2-3/lib/./libssl.so.1.0.0 (0x00007f20ff2ec000)
>>          libcrypto.so.1.0.0 =>
>> /db_demo/app/postgres/9.6.2-3/lib/./libcrypto.so.1.0.0
>> (0x00007f20feeb5000)
>>          libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f20fec99000)
>>          libc.so.6 => /lib64/libc.so.6 (0x00007f20fe8d7000)
>>          libdl.so.2 => /lib64/libdl.so.2 (0x00007f20fe6d2000)
>>          /lib64/ld-linux-x86-64.so.2 (0x00007f20ffe14000)
>
> So the EDB install is using its own library for liblber
>
> Per Tom's suggestion:
>
> nm -D /db_demo/app/postgres/9.6.2-3/lib/liblber-2.4.so.2
>

Output from that is:

$ nm -D /db_demo/app/postgres/9.6.2-3/lib/liblber-2.4.so.2

                  U __assert_fail
0000000000007dd9 T ber_alloc
0000000000007d48 T ber_alloc_t
00000000000090b2 T ber_bprint
000000000000a76c T ber_bvarray_add
000000000000a611 T ber_bvarray_add_x
000000000000a4df T ber_bvarray_dup_x
000000000000a4c0 T ber_bvarray_free
000000000000a441 T ber_bvarray_free_x
0000000000009ea6 T ber_bvdup
0000000000009d1f T ber_bvecadd
0000000000009bdc T ber_bvecadd_x
0000000000009bbd T ber_bvecfree
0000000000009b3d T ber_bvecfree_x
0000000000009b1e T ber_bvfree
0000000000009acb T ber_bvfree_x
000000000000a417 T ber_bvreplace
000000000000a32a T ber_bvreplace_x
00000000000034ac T ber_decode_oid
000000000000937a T ber_dump
0000000000007df9 T ber_dup
0000000000009e7c T ber_dupbv
0000000000009d49 T ber_dupbv_x
0000000000005e06 T ber_encode_oid
0000000000008cb0 T ber_errno_addr
0000000000008cda T ber_error_print
0000000000004621 T ber_first_element
0000000000008244 T ber_flatten
00000000000080e1 T ber_flatten2
0000000000007b01 T ber_flush
0000000000007b33 T ber_flush2
0000000000007abd T ber_free
0000000000007a3a T ber_free_buf
0000000000004455 T ber_get_bitstringa
00000000000045fc T ber_get_boolean
0000000000003b4b T ber_get_enum
0000000000003a65 T ber_get_int
00000000000083a0 T ber_get_next
00000000000045c1 T ber_get_null
000000000000a798 T ber_get_option
00000000000042ae T ber_get_stringa
0000000000004374 T ber_get_stringal
0000000000004311 T ber_get_stringa_null
0000000000003b70 T ber_get_stringb
000000000000404b T ber_get_stringbv
0000000000004178 T ber_get_stringbv_null
0000000000003800 T ber_get_tag
000000000000801e T ber_init
0000000000007f06 T ber_init2
0000000000007ff9 T ber_init_w_nullc
000000000020fb28 B ber_int_errno_fn
000000000020fb18 B ber_int_log_proc
000000000020fb40 B ber_int_memory_fns
000000000020fb60 B ber_int_options
000000000000b8a6 T ber_int_sb_close
000000000000b93c T ber_int_sb_destroy
000000000000b7ea T ber_int_sb_init
000000000000b9f9 T ber_int_sb_read
000000000000bb03 T ber_int_sb_write
0000000000008c07 T ber_len
0000000000009049 T ber_log_bprint
00000000000092e8 T ber_log_dump
00000000000094c5 T ber_log_sos_dump
000000000000a15a T ber_mem2bv
000000000000a03c T ber_mem2bv_x
00000000000098ed T ber_memalloc
000000000000986e T ber_memalloc_x
00000000000099a8 T ber_memcalloc
000000000000990c T ber_memcalloc_x
00000000000097c0 T ber_memfree
0000000000009730 T ber_memfree_x
0000000000009aa1 T ber_memrealloc
00000000000099d2 T ber_memrealloc_x
000000000000984f T ber_memvfree
00000000000097df T ber_memvfree_x
00000000000046cb T ber_next_element
0000000000003835 T ber_peek_element
00000000000039d3 T ber_peek_tag
0000000000006aa0 T ber_printf
0000000000008c29 T ber_ptrlen
000000000000636a T ber_put_berval
0000000000006444 T ber_put_bitstring
00000000000065d1 T ber_put_boolean
0000000000006218 T ber_put_enum
0000000000006251 T ber_put_int
0000000000006558 T ber_put_null
000000000000628a T ber_put_ostring
0000000000006a6c T ber_put_seq
0000000000006a86 T ber_put_set
00000000000063dc T ber_put_string
000000000020fb20 B ber_pvt_err_file
0000000000008da3 T ber_pvt_log_output
000000000020f9e0 D ber_pvt_log_print
0000000000008f14 T ber_pvt_log_printf
000000000020fba0 B ber_pvt_opt_on
000000000000b41c T ber_pvt_sb_buf_destroy
000000000000b3e3 T ber_pvt_sb_buf_init
000000000000b52c T ber_pvt_sb_copy_out
000000000000b636 T ber_pvt_sb_do_write
000000000000b479 T ber_pvt_sb_grow_buffer
000000000000b796 T ber_pvt_socket_set_nonblock
0000000000007642 T ber_read
0000000000007897 T ber_realloc
0000000000008c8d T ber_remaining
00000000000082f9 T ber_reset
0000000000008c4b T ber_rewind
0000000000004783 T ber_scanf
000000000000aa63 T ber_set_option
000000000000757c T ber_skip_data
000000000000396f T ber_skip_element
0000000000003a0b T ber_skip_tag
000000000000b162 T ber_sockbuf_add_io
000000000000ae08 T ber_sockbuf_alloc
000000000000aec7 T ber_sockbuf_ctrl
000000000000ae43 T ber_sockbuf_free
000000000020fac0 D ber_sockbuf_io_debug
000000000020fa80 D ber_sockbuf_io_fd
000000000020fa40 D ber_sockbuf_io_readahead
000000000020fa00 D ber_sockbuf_io_tcp
000000000000b2c4 T ber_sockbuf_remove_io
00000000000094da T ber_sos_dump
0000000000008bf5 T ber_start
0000000000006822 T ber_start_seq
0000000000006856 T ber_start_set
0000000000009ffd T ber_str2bv
0000000000009eca T ber_str2bv_x
000000000000a211 T ber_strdup
000000000000a199 T ber_strdup_x
000000000000a300 T ber_strndup
000000000000a26e T ber_strndup_x
000000000000a230 T ber_strnlen
0000000000007737 T ber_write
000000000020faf0 A __bss_start
                  U calloc
                  U close
                  U __ctype_b_loc
                  w __cxa_finalize
0000000000007de9 T der_alloc
000000000020faf0 A _edata
000000000020fba8 A _end
                  U __errno_location
                  U fcntl
                  U fflush
000000000000c9a8 T _fini
                  U fputs
                  U free
                  w __gmon_start__
0000000000002d80 T _init
                  w _Jv_RegisterClasses
0000000000009518 T lutil_debug
00000000000094e4 T lutil_debug_file
                  U malloc
                  U memchr
                  U memcpy
                  U memmove
                  U memset
                  U read
                  U realloc
                  U shutdown
                  U sprintf
                  U stderr
                  U strcpy
                  U strlen
                  U strtoul
                  U time
                  U vsnprintf
                  U write
                  U __xpg_strerror_r

>
> What has me confused is this:
>
> /lib64/libldap_r-2.4.so.2: undefined reference to `ber_sockbuf_io_udp'
>
> It is referring to a library path outside the EDB install.
>
> Not sure why it is picking that up?
>
> To get a handle on this:
>
> whereis libldap_r

Output was:
$ whereis libldap_r
libldap_r: /usr/lib64/libldap_r.so

>
> and then
>
> ls -al whatever files are found above
>
> ldd  whatever files are found above

The output of those two commands was:

$ ls -al /usr/lib64/libldap_r.so

lrwxrwxrwx 1 root root 23 May 16 17:06 /usr/lib64/libldap_r.so ->
libldap_r-2.4.so.2.10.3

$ ldd /usr/lib64/libldap_r.so
         linux-vdso.so.1 =>  (0x00007ffd7674e000)
         liblber-2.4.so.2 (0x00007fb86c7c3000)
         libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fb86c59f000)
         libsasl2.so.3 (0x00007fb86c37d000)
         libssl3.so => /lib64/libssl3.so (0x00007fb86c13a000)
         libsmime3.so => /lib64/libsmime3.so (0x00007fb86bf12000)
         libnss3.so => /lib64/libnss3.so (0x00007fb86bbec000)
         libnssutil3.so => /lib64/libnssutil3.so (0x00007fb86b9c0000)
         libplds4.so => /lib64/libplds4.so (0x00007fb86b7bb000)
         libplc4.so => /lib64/libplc4.so (0x00007fb86b5b6000)
         libnspr4.so => /lib64/libnspr4.so (0x00007fb86b378000)
         libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb86b15b000)
         libdl.so.2 => /lib64/libdl.so.2 (0x00007fb86af57000)
         libc.so.6 => /lib64/libc.so.6 (0x00007fb86ab95000)
         libz.so.1 (0x00007fb86a978000)
         librt.so.1 => /lib64/librt.so.1 (0x00007fb86a770000)
         /lib64/ld-linux-x86-64.so.2 (0x00007fb86cc30000)

Hope that's helpful.

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."