On my Solaris 9/sparc box with OpenSSL 0.9.8-beta6, the pgcrypto
regression tests fail the 3des test. I haven't checked against
older versions of OpenSSL; I'll do so when I get a chance.
I haven't dug into the pgcrypto code yet -- is it doing anything
that might be platform-specific? Or is this more likely a problem
with OpenSSL?
regression.diffs attached.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
*** ./expected/3des.out Sun Mar 20 22:24:51 2005
--- ./results/3des.out Tue Jul 5 08:20:26 2005
***************
*** 17,23 ****
select encode( encrypt('', 'foo', '3des'), 'hex');
encode
------------------
! 9b641a6936249eb4
(1 row)
-- 10 bytes key
--- 17,23 ----
select encode( encrypt('', 'foo', '3des'), 'hex');
encode
------------------
! 4d91b5c9cc64e1c9
(1 row)
-- 10 bytes key
***************
*** 24,30 ****
select encode( encrypt('foo', '0123456789', '3des'), 'hex');
encode
------------------
! 6f02b7076a366504
(1 row)
-- 22 bytes key
--- 24,30 ----
select encode( encrypt('foo', '0123456789', '3des'), 'hex');
encode
------------------
! d2fb8baa1717cb02
(1 row)
-- 22 bytes key
***************
*** 37,44 ****
-- decrypt
select decrypt(encrypt('foo', '0123456', '3des'), '0123456', '3des');
decrypt
! ---------
! foo
(1 row)
-- iv
--- 37,44 ----
-- decrypt
select decrypt(encrypt('foo', '0123456', '3des'), '0123456', '3des');
decrypt
! ----------------------------
! \327\007C\202\334|\232\310
(1 row)
-- iv
***************
*** 45,56 ****
select encode(encrypt_iv('foo', '0123456', 'abcd', '3des'), 'hex');
encode
------------------
! df27c264fb24ed7a
(1 row)
select decrypt_iv(decode('df27c264fb24ed7a', 'hex'), '0123456', 'abcd',
'3des');
decrypt_iv
! ------------
! foo
(1 row)
--- 45,56 ----
select encode(encrypt_iv('foo', '0123456', 'abcd', '3des'), 'hex');
encode
------------------
! a1917305c1df08f8
(1 row)
select decrypt_iv(decode('df27c264fb24ed7a', 'hex'), '0123456', 'abcd',
'3des');
decrypt_iv
! -------------------------
! \325c\311\365\223\312E_
(1 row)
======================================================================
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org