MySQL Forums
Forum List  »  Stored Procedures

Re: MySQL reference SQL implementing Key Wrap (RFC3394)
Posted by: Rick James
Date: November 27, 2013 07:24PM

> but I'm unfamilier with how to handle loops in SQL for iterating throught the 8 byte (64bit) blocks of the plaintext key

Can't you pass the entire string to AES_ENCRYPT() to get the desired effect?

AES_ENCRYPT() and AES_DECRYPT() are handy for doing a reversible encryption of data to be stored in a MySQL table. However, it has two security flaws:
* The passphrase must be stored somewhere and used in the calling code. Securing this is critical.
* Plaintext will be flowing between the server and the client, since the encryption and decryption is done in the server.

Options: ReplyQuote

Written By
Re: MySQL reference SQL implementing Key Wrap (RFC3394)
November 27, 2013 07:24PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.