[SOLVED] RE: [ADMIN] 7.4RC2: pg_crypto not working?

2003-11-13 Thread Murthy Kambhampaty
Thanks Tom and Reece for replying. It turns out that the cryptolib/cryptsrc/random source combination I specified -- openssl/system/openssl -- was the problem; changing the combination to openssl/builtin/openssl, solved the problem. ~/contrib/pgcrypto/Makefile snippet: # either 'builtin',

[ADMIN] 7.4RC2: pg_crypto not working?

2003-11-12 Thread Murthy Kambhampaty
After having initdb'd and started the server (gmake check said it passed all 93 tests), and doing a make; make install in pgcrypto, I tried creating the pgcrytpo functions with # psql -d template1 -f pgcrypto.sql This produced a series of errors as follows: 2003-11-12 16:56:14.287480500 [9781]

Re: [ADMIN] 7.4RC2: pg_crypto not working?

2003-11-12 Thread Tom Lane
Murthy Kambhampaty [EMAIL PROTECTED] writes: # psql -d template1 -f pgcrypto.sql 2003-11-12 16:56:14.293247500 [9781] ERROR: could not load library /usr/local/pgsql-7.4/lib/pgcrypto.so: /usr/local/pgsql-7.4/lib/pgcrypto.so: undefined symbol: px_find_digest Works for me (at least, the

Re: [ADMIN] 7.4RC2: pg_crypto not working?

2003-11-12 Thread Reece Hart
On Wed, 2003-11-12 at 14:14, Murthy Kambhampaty wrote: Is this from user error or is pgcrypto not working yet in RC2? It works for me (x86, redhat 7.3, linux 2.4.18). I did make install in pgcrypto/, then: CREATE FUNCTION digest (text, text) RETURNS bytea AS 'pgcrypto', 'pg_digest'