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

> On 1 Dec 2025, at 07:54, marco(dot)lebahn(at)kfw(dot)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