[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', 'mhash', 'openssl'
cryptolib = openssl # builtin

# either 'builtin', 'system'
cryptsrc = system # builtin  problem; revert to 'builtin'

# Random source, preferred order:
# 'dev'  - read from random device
#
# 'openssl'  - use openssl PRNG.
#  Note that currently pgcrypto does not do any
#  entropy feeding to it
#  This works ofcouse only with cryptolib = openssl
#
# 'silly'- use libc random() - very weak
random = openssl # silly

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[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] LOG:  statement: CREATE OR REPLACE
FUNCTION digest(text, text)
2003-11-12 16:56:14.287484500   RETURNS bytea
2003-11-12 16:56:14.287485500   AS '$libdir/pgcrypto', 'pg_digest'
2003-11-12 16:56:14.287487500   LANGUAGE 'C';
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


Is this from user error or is pgcrypto not working yet in RC2?

Thanks,
   Murthy

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

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 creation script succeeds; don't know how
to test the functions).  Maybe you have a ldconfig search-path problem?

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

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'
 LANGUAGE c STRICT;

Note that I don't have '$libdir/' in this function definition. I can't remember why.

[EMAIL PROTECTED] select encode( digest('AAA','md5'), 'hex' );
 encode
--
 e1faffb3e614e6c2fba74296962386b7
(1 row)
 
[EMAIL PROTECTED] select version();
 version
--
 PostgreSQL 7.4RC2 on i686-pc-linux-gnu, compiled by GCC 2.96


I just discovered that md5 is now built in to the 7.4 backend, so I don't need pgcrypto anymore.


-Reece




-- 
Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0 0xD178AAF9