Обсуждение: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication

On 12/19/20 2:54 AM, Rambabu V wrote:
> Hi Team,
> 
> i have installed postgresql 13 using packages/tried same using lower 
> versions as well, but replication not working, getting below error.

What OS and version?

Where did you get packages?

Do you have other versions of Postgres running on this machine?

> 
> 2020-12-19 02:48:22.346 PST [3574] FATAL:  could not load library 
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5: 
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in 
> file libcrypto.so.10 with link time reference
> 2020-12-19 02:48:22.350 PST [3575] FATAL:  could not load library 
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5: 
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in 
> file libcrypto.so.10 with link time reference
> 2020-12-19 02:48:27.362 PST [3576] FATAL:  could not load library 
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5: 
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in 
> file libcrypto.so.10 with link time reference
> 2020-12-19 02:48:32.366 PST [3580] FATAL:  could not load library 
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5: 
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in 
> file libcrypto.so.10 with link time reference
> 
> even though i have exported LD_LIBRARY_PATH and created link also.
> 
> [root@localhost log]# which libpqwalreceiver.so
> /usr/bin/libpqwalreceiver.so
> [root@localhost log]# which libpq.so.5
> /usr/bin/libpq.so.5
> 
> [postgres@localhost ~]$ export LD_LIBRARY_PATH=$PATH:/usr/pgsql-13/lib/
> [postgres@localhost ~]$ echo $LD_LIBRARY_PATH
>
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/postgres/.local/bin:/home/postgres/bin:/usr/pgsql-13/lib/
> 
> every version has the same issue with packages, please help me to 
> resolve this issue.


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Rambabu V <ram.wissen@gmail.com> writes:
> i have installed postgresql 13 using packages/tried same using lower
> versions as well, but replication not working, getting below error.

> 2020-12-19 02:48:22.346 PST [3574] FATAL:  could not load library
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5:
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file
> libcrypto.so.10 with link time reference

Apparently this copy of libpq was built against a newer version of
OpenSSL than what you have installed locally.  The man page for
X509_get_signature_nid says it was added in OpenSSL 1.0.2, in case that
helps.  You need to find or build a version of Postgres that's intended
for your specific platform version.  Alternatively, maybe you would be
better off moving to a newer platform version, or at least installing
a newer OpenSSL version.  Anything older than 1.0.1 is considered
outright insecure these days.

            regards, tom lane

On 12/19/20 4:53 PM, Rambabu V wrote:
> Hi Team,
> 
> below are the os versions details. standalone machine running without 
> any issues, coming to replication not working, even i tried from 
> postgresql 10 onwards as well, no other versions running in the server now.
> 
> [root@node2 ~]# openssl version
> OpenSSL 1.0.1e-fips 11 Feb 2013
> [root@node2 ~]# uname -a
> Linux node2 3.10.0-327.el7.x86_64 #1 SMP Thu Oct 29 17:29:29 EDT 2015 
> x86_64 x86_64 x86_64 GNU/Linux
> [root@node2 ~]# cat /etc/redhat-release
> Red Hat Enterprise Linux Server release 7.2 (Maipo)
> [root@node2 ~]#
> 

Where are you getting the packages?


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 12/19/20 5:05 PM, Rambabu V wrote:
> Hi Team,
> 
> below is the link im getting packages.
> 
> https://www.postgresql.org/download/linux/redhat/ 
> <https://www.postgresql.org/download/linux/redhat/>

This was fixed here:

https://redmine.postgresql.org/issues/4509

You will need community account to see issue.

Relevant parts:

2019-07-24
"After some analysis we found that the issue was the addition of 
`X509_get_signature_nid` function calls in PG11, and the fact that the 
customer was still on openssl-libs 1.0.1e, which doesn't have that 
function implemented, and not the latest 1.0.2k available.

For that reason the postgresql11-libs should have a dependency so 
openssl-libs 1.0.2 or better is installed."

...

2019-08-30

"I updated PostgreSQL 10+ spec files:

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commit;h=86f8778e077d250e9b3c0e695d5cc297057c511a

These changes will appear in next minor updates.
"


Have you looked at this announcement?:

https://yum.postgresql.org/news/new-repo-rpms-released/

> 
> On Sun, Dec 20, 2020 at 6:33 AM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 12/19/20 4:53 PM, Rambabu V wrote:
>      > Hi Team,
>      >
>      > below are the os versions details. standalone machine running
>     without
>      > any issues, coming to replication not working, even i tried from
>      > postgresql 10 onwards as well, no other versions running in the
>     server now.
>      >
>      > [root@node2 ~]# openssl version
>      > OpenSSL 1.0.1e-fips 11 Feb 2013
>      > [root@node2 ~]# uname -a
>      > Linux node2 3.10.0-327.el7.x86_64 #1 SMP Thu Oct 29 17:29:29 EDT
>     2015
>      > x86_64 x86_64 x86_64 GNU/Linux
>      > [root@node2 ~]# cat /etc/redhat-release
>      > Red Hat Enterprise Linux Server release 7.2 (Maipo)
>      > [root@node2 ~]#
>      >
> 
>     Where are you getting the packages?
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Hi,

On Sun, 2020-12-20 at 06:23 +0530, Rambabu V wrote:
> [root@node2 ~]# cat /etc/redhat-release
> Red Hat Enterprise Linux Server release 7.2 (Maipo)

IIRC RHEL 7 RPMs support RHEL 7.6+. Please update.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR