I'm still unclear on how to do the decrypt syntax,
forgive me I'm new to DB work, my background is
more security and UNIX admin.
I need help with the data extraction/decryption
SELECT userid, password
FROM user_profile AES_DECRYPT("user","password")
??????
What I'm trying to accomplish is I'm using RADIUS to
Authenticate users for Network Access, the user info
is stored via MySQL DB, I have the need to ENCRYPT
the Password Field and Possibly the UserName Field.
I need to DECRYPT so RADIUS can read the Password and
accept users, I thought of MD5 but this is a one way
hash, I'd have to compare the hashes and haven't fiqured
out a way to do that through SQL.
Any help or suggestions
-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 1:31 PM
To: Stout, Jeff; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Syntax Query Help DECRYPT
At 1:08 PM -0600 9/19/03, Stout, Jeff wrote:
> I have added data into MySQL server 4.0.15
>
> INSERT INTO userdata (userid, password)
> VALUES ('user', AES_ENCRYPT ("user","password")
>
>
> I'm having trouble doing the decrypt
>
>
>
> Something this this
>
> Thanks
> Jeff Stout
The syntax for both is the same:
AES_ENCRYPT(string,key_string)
AES_DECRYPT(string,key_string)
See:
http://www.mysql.com/doc/en/Miscellaneous_functions.html
Please note that internals is not for questions of this type.
I've removed it from the cc: list.
Thanks.
--
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]
