I am using MySQL 4.0.15 on Win2K (not by choice, vendor chose this platform)
I user the Database to store user information to Allow RADIUS to authenticate
users against the tables. I have to encrypt the password fields, If I use
MD5 it is a one way algorithm, enable for me to user MD5 I have to compare
the hashes if hashes match then I'm golden and user is granted access,
however the flavor of RADIUS the Vendor has chosen to use can not by it's self
do a hash comparison thus all Hash encrypted passwords can't be read by
Radius and users are denied access.
Has any one had experience with this and know of a way to fix this ????
My other thought was to use:
INSERT INTO user_profile (userid, password)
VALUES ('sam', AES_ENCRYPT("sam","password"));
this will allow me to encrypt the password field, but I still need to get RADIUS to
do the AES_DECRYPT any thoughts.
ugh !!!!!!!!
Jeff Stout
CSG Systems, Inc.
303-200-3204
