Re: aes encryption bug

[Paul DuBois]

Please reply to the list, not to me directly, so that others can
follow this discussion.  Thanks.
At 14:54 -0800 11/6/03, Herb Rubin wrote:
Paul,

Yes, I get the same, now try and decrypt it, it will turn out to be NULL.
So, you cannot insert this into a NOT NULL column. It will reject it.
Your message (below) appears to be reporting a problem with AES_ENCRYPT().
It states that you get a NULL return value from that function.
You now appear to be saying something else.

I don't understand what problem you're trying to report.

My result from decryption:

mysql> select AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561');
+--------------------------------------------------------------+
| AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561') |
+--------------------------------------------------------------+
| k\ÎúVÀàÿxû÷Ò                                              |
+--------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select 
AES_DECRYPT(AES_ENCRYPT('551850040', 
'0bf251c9aaf007deaf1143ca1492b561'),
    -> '0bf251c9aaf007deaf1143ca1492b561');
+---------------------------------------------------------------------------------------------------------------+
| AES_DECRYPT(AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561'),
'0bf251c9aaf007deaf1143ca1492b561') |
+---------------------------------------------------------------------------------------------------------------+
| 551850040 
|
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.07 sec)

Are you reporting that you get NULL only in the context of inserting
and retrieving the value from the id column?
If so, please try using TINYBLOB rather than VARCHAR and see what happens.


we are on 4.0.14
Herb

 At 14:03 -0800 11/6/03, Herb Rubin wrote:
Hi,

I am trying to use aes_encrypt and I get a NULL value with a specific
string:
INSERT INTO test SET
`id` = AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561');
my field 'id' is VARCHAR(16) NOT NULL

If I change the value or the encryption string it works. But this
combination turns out to be null and it refuses to insert.
 With MySQL 4.0.14, 4.0.16, and 4.1.1, I get:

 mysql> select AES_ENCRYPT('551850040',
 '0bf251c9aaf007deaf1143ca1492b561');
 +--------------------------------------------------------------+
 | AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561') |
 +--------------------------------------------------------------+
 | k\ÎúVÀàÿxû÷Ò                                              |
 +--------------------------------------------------------------+
 What version are you using?


Help!

 >>Herb


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]