|
I have converted my Radius system from AuthbyFile
to AuthbySQL.
Have it up and running correctly but I am using
clear text passwords. I would like to convert these to some sort of md5
encryption. I can get mysql to save the password in md5 encryption.
But I can't get radiator to authenticate.
What is the correct way of getting the plain test
password into md5. When I do it in mysql fred =
"570a90bfbf8c7eab5dc5d4e26832d5b1" Same if I use a customized Cold Fusion
tag. And this is not the format section 13.1 shows for encrypted passwords
using md5.
Do I need to include this in the reply attrib or
does authby
Thanks for any help you can give me.
I have included my authby sql section of my config
that I am currently using. Naturally I would uncomment out the encrypted
entry lines when using encryption.
<AuthBy
SQL>
DefaultSimultaneousUse 1 # Adjust DBSource, DBUsername, DBAuth to suit your DB DBSource dbi:mysql:XXXXX
DBUsername XXXXx
DBAuth XXXXX # AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from USERS where USERNAME='%n' AccountingTable %Y_%m_ACCOUNTING AccountingStopsOnly #EncryptedPassword AuthColumnDef 0, User-Password, check #AuthColumnDef 0, Encrypted-Password, check AuthColumnDef 1, GENERIC, check AuthColumnDef 2, GENERIC, reply AcctColumnDef USERNAME,User-Name AcctColumnDef TIME_STAMP,Timestamp,integer AcctColumnDef TRUE_TIME,Timestamp,formatted-date,'%Y-%m-%d %H:%M:%S' AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef
ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-IP-Address AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address </AuthBy> |
