Обсуждение: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"

> On 7 Feb 2024, at 15:09, Marco Aurelio <marcoprodata@gmail.com> wrote:

> When I run ./configure I see in config.log that it is always using the base version of Freebsd.

You can use the --with-libraries and --with-includes arguments to ./configure
in order to point it to the version you want to build against.

--
Daniel Gustafsson

Marco Aurelio <marcoprodata@gmail.com> writes:
> I added the include and libraries folders:
> --with-libraries=/usr/local/lib --with-includes=/usr/local/include
> but configure keeps finding the old version of openssl

> configure:14133: checking for openssl
> configure:14151: found /usr/bin/openssl
> configure:14163: result: /usr/bin/openssl
> configure:14183: using openssl: OpenSSL 1.1.1t-freebsd 7 Feb 2023

You can ignore that particular result, because it doesn't matter
as long as we're using the right headers and libraries.  (We knew
when that check was put in that it would give some false positives.)
Alternatively, change your PATH to put /usr/local/bin in front
of /usr/bin.

            regards, tom lane

> On 7 Feb 2024, at 18:53, Marco Aurelio <marcoprodata@gmail.com> wrote:
>
> I changed the path and now the correct version of openssl appears in the config.log, even so, after recompiling and
reinstallingboth postgresql and the pgcrypto contrib, when trying to create the extension in a database I continue to
receivethe same error, any further suggestions ? 

the _bf functions relate to the Blowfish cipher which was obsoleted in OpenSSL
3 so you need to load the legacy provider in your openssl configuration in
order to use it.

--
Daniel Gustafsson