On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend