Des Key File - How To/Example
Hi,
I am testing out using a key file rather than sending passwords in SQL strings for a client.
Blowed if I can get it to work. I have an existing table with a set of records with encrypted fields which I can read back using :
SELECT des_decrypt(<field>,<password>) from telephonehdr
I then created a file called des.txt stored in the MySQL program file directory along side the my.ini and added a line to my.ini to pick it up.
MySQLd-NT --verbose --help lists the parameter for the key file correctly so it must be picking it up.
Is there a command to SHOW the parameter from the console or display the keys so I can see what it thinks it has for the passwords.
I have tried several formats for entering the lines in the des file:
0 <password>
0<password>
0 '<password>'
0'<password>'
Each change I FLUSH the des key file (even stopped and started the service to be sure) and try the following:
SELECT des_decrypt(<field>) from telephonehdr
Then :
SELECT des_decrypt(<field>,0) from telephonehdr
Neither works, only returns NULLs.
Any help greatly appreciated.
Subject
Views
Written By
Posted
Des Key File - How To/Example
6926
December 10, 2007 05:18AM
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.