Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"

From: Marco Aurelio <marcoprodata(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"
Date: 2024-02-07 14:09:18
Message-ID: CA+bywzNtW=TgvAydODSSowy1rV8rd7MRXJ7+oKB59ezwa_+GaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Friends,

I have a Freebsd 13.2 server where I installed postgresql 16.1 via source
code, I installed the pgcrypto extension with the gmake install command
without error messages, but when trying to create the extension in a
database I receive the following message:
ERROR: could not load library "/usr/local/pgsql16/lib/pgcrypto.so":
/usr/local/pgsql16/lib/pgcrypto.so: Undefined symbol "EVP_bf_ecb"

Freebsd 13.2 has 2 versions of openssl installed, one base and the other
via pkg, the base version is:
OpenSSL 1.1.1t-freebsd 7 Feb 2023

while the version installed via pkg is:
OpenSSL 3.0.12 24 Oct 2023 (Library: OpenSSL 3.0.12 24 Oct 2023)

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

How to resolve this?

Marco Aurélio Ventura da Silva
Analista de Sistemas / Desenvolvedor
marcoprodata(at)gmail(dot)com
Prodata Informática e Cadastro LTDA
(33) 3322-6363

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Gustafsson 2024-02-07 14:17:44 Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"
Previous Message David Rowley 2024-02-07 12:18:58 Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY