Re: pgcrypto sha256/384/512 don't work on Redhat. Please help! - Mailing list pgsql-general

From Marko Kreen
Subject Re: pgcrypto sha256/384/512 don't work on Redhat. Please help!
Date
Msg-id e51f66da0605090359q365a2b99o8ed75178b457bf58@mail.gmail.com
Whole thread Raw
In response to pgcrypto sha256/384/512 don't work on Redhat. Please help!  ("Joe Kramer" <cckramer@gmail.com>)
Responses Re: pgcrypto sha256/384/512 don't work on Redhat. Please help!  ("Joe Kramer" <cckramer@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: Arguments Pro/Contra Software Raid
Next
From: "Joe Kramer"
Date:
Subject: Re: pgcrypto sha256/384/512 don't work on Redhat. Please help!