Hello Doug !
If you have used CHAP before the cleartext->md5 conversion, you should
move to PAP.
Janos SUTO
GTS-Datanet
On Thu, 18 Jan 2001, Doug Currey wrote:
> 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>
>
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
