Re: pgcrypto sha256/384/512 don't work on Redhat. Please help!

On 5/9/06, Joe Kramer <cckramer@gmail.com> wrote:
> Fedora core has OpenSSL 0.9.7 installed by default. And it's not possible to
> install 0.9.8 because of glibc conflict.
>
> I suspect pgcrypto looks for SHA256 in OpeSSL lib when it should use
> built-in.
> SHA256 is working fine on Windows but on Redhat it fails. Maybe because
> windows pgcrypto DLL is compiled statically with OpenSSL?

OpenSSL vs. builtin is a compile-time decision, so the builtin code
cannot be fallback at runtime.

Windows code is using either builtin code or newer OpenSSL.

> How to make pgcrypto use built-in sha256?

You need to recompile PostgreSQL.  Don't try to use non-OpenSSL
pgcrypto with OpenSSL PostgreSQL, it will crash due to symbol
conflict.

Another variant is to try to compile separate OpenSSL 0.9.8 and
compile PostgreSQL against that.  So you don't need to upgrade
system OpenSSL.

--
marko