Pg 9.1.3 pg_crypto question

Started by Aaron Burnettabout 14 years ago4 messagesgeneral
Jump to latest
#1Aaron Burnett
aburnett@bzzagent.com

Hi,

Finally upgrading from 8.2.5 to 9.1.3 (got the latest release as of
3/12/2012)

OS: Ubuntu 11.10

The only issue I am encountering is in the pg_crypto/decrypt_iv/decode
No errors in the log, but here's what I am seeing on both 8.2.5 and 9.1.3,
I am hoping someone can help me out here:

8.2.5#
8.2.5=# select encode(encrypt_iv(text2bytea('Hello There'),
decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
'aes-cbc'), 'base64');
encode
--------------------------
rkMRWpnnbjaFoHyLmCD/bg==
(1 row)

8.2.5=# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
'aes-cbc');
decrypt_iv
-------------
Hello There
(1 row)

So, the 8.2.5 is working as it always has.

9.1.3 is just not decrypting nor throwing errors.

9.1.3#
9.1.3# select encode(encrypt_iv(text2bytea('Hello There'),
decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
'aes-cbc'), 'base64');
encode
--------------------------
rkMRWpnnbjaFoHyLmCD/bg==
(1 row)

9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
'aes-cbc');
decrypt_iv
--------------------------
\x48656c6c6f205468657265
(1 row)

Thanking you in advance,

Aaron

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Aaron Burnett (#1)
Re: Pg 9.1.3 pg_crypto question

Aaron Burnett <aburnett@bzzagent.com> writes:

9.1.3 is just not decrypting nor throwing errors.

9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
'aes-cbc');
decrypt_iv
--------------------------
\x48656c6c6f205468657265
(1 row)

I think this is the same result, it's just being shown in hex.
See the bytea_output configuration parameter.

regards, tom lane

#3Aaron Burnett
aburnett@bzzagent.com
In reply to: Tom Lane (#2)
Re: Pg 9.1.3 pg_crypto question

Thanks, Tom. That was exactly it.

Best Regards

On 4/10/12 2:50 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

Show quoted text

Aaron Burnett <aburnett@bzzagent.com> writes:

9.1.3 is just not decrypting nor throwing errors.

9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
'aes-cbc');
decrypt_iv
--------------------------
\x48656c6c6f205468657265
(1 row)

I think this is the same result, it's just being shown in hex.
See the bytea_output configuration parameter.

regards, tom lane

#4Dick Wieland
dick.wieland@wiline.com
In reply to: Tom Lane (#2)
Re: Pg 9.1.3 pg_crypto question

I had the same problem. I can confirm that changing to

bytea_output = 'escape'

restores the previous behavior.

Regards,
Dick Wieland

Show quoted text

On 04/10/2012 01:50 PM, Tom Lane wrote:

Aaron Burnett<aburnett@bzzagent.com> writes:

9.1.3 is just not decrypting nor throwing errors.
9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
'aes-cbc');
decrypt_iv
--------------------------
\x48656c6c6f205468657265
(1 row)

I think this is the same result, it's just being shown in hex.
See the bytea_output configuration parameter.

regards, tom lane