hi! I am having an issue with MySQL AES_DECRYPT, i have no problems to use this method from mysql console directly to the server, and via MySQL workbench, however over ODBC/ADO it just does not work, i think it has something to do with the key size.. however I discovered this chilcat mysql AES decrypt, and want to give it a try, downloaded a trial and changed the demo to match my encrypted string + key but i did only get garbaged string out.. anyoe can help me to make it work ? here is a small code i tried
|
I would recommend first testing with a more simple password. For example, see the test vectors at this example: http://www.example-code.com/delphiDll/mysql_aes_encrypt.asp Check to see if you can reproduce these results in MySQL workbench. |
i tried with mysql a smaller key earlier over ADO, and this works, it seems the key is too long, now i heard i need to make a cipher of this key, but i dont know how to do this, encryption is ery dificult to me, if I only know how to read this as text, all would be fine |
would be nice anyway to know why the long 93 char password did not work tho 1
I don't know why the longer password wouldn't work. The MySQL algorithm to transform the password string to a 128-bit AES secret key is simple and there is no limitation on the password length. You might check to see if it's somehow not the length that causes the problem, but specific chars within that 93-char password. In other words, try a long password with A-Za-z0-9 chars only and see if that works.
(Apr 12 '13 at 08:30)
chilkat ♦♦
|