Thread: 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:

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