Thread

Re: BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big

Daniel Gustafsson <daniel@yesql.se> — 2025-12-01T09:03:05Z

> On 1 Dec 2025, at 07:54, marco.lebahn@kfw.de wrote:
> 
> Hi Tom, hi Daniel,
> 
> many thanks for your help.
> 
> That's the point
> 
> with 16.10
> 
> ldd /usr/pgsql-16/lib/pgcrypto.so
> [...]
>        libcrypto.so.1.1 => /usr/lib64/libcrypto.so.1.1 (0x00007f9337e00000)
> [...]
> ~> rpm -qf /usr/lib64/libcrypto.so.1.1
> libopenssl1_1-1.1.1w-150700.11.6.1.x86_64
> 
> 
> with 16.11
> 
> ldd /usr/pgsql-16/lib/pgcrypto.so
> [...]
>        libcrypto.so.3 => /usr/lib64/libcrypto.so.3 (0x00007ff33a400000)
> [...]
> ~> rpm -qf /usr/lib64/libcrypto.so.3
> libopenssl3-3.2.3-150700.5.21.1.x86_64
> 
> that's the trigger

Your surprise is quite warranted, that's an unconventional change in a minor
revision of a package.

> uncomment legacy in opensslconfig + restart  = it works.

Thanks for confirming, I'm glad we could help.

> Be that as it may, we will avoid legacy in the future.

There is that, at least you are now using a non-EOL version of OpenSSL, which
is a silverlining here.

--
Daniel Gustafsson