Обсуждение: 7.4RC2: pg_crypto not working?
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
Murthy Kambhampaty <murthy.kambhampaty@goeci.com> 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
On Wed, 2003-11-12 at 14:14, Murthy Kambhampaty wrote:
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.
compbio@csb-dev=# select encode( digest('AAA','md5'), 'hex' );
encode
----------------------------------
e1faffb3e614e6c2fba74296962386b7
(1 row)
compbio@csb-dev=# 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
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.
compbio@csb-dev=# select encode( digest('AAA','md5'), 'hex' );
encode
----------------------------------
e1faffb3e614e6c2fba74296962386b7
(1 row)
compbio@csb-dev=# 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 |