(RADIATOR) Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: (RADIATOR) Radiator - Probs with Authby SQL

[Hugh Irvine]

Hello Christian -

If you want to do both CHAP and PAP authentication, your passwords 
*must* be stored in clear text in the database.

If you want to store  encrypted passwords (and only use PAP) you must 
use an external program to do the encryption and then take the 
resulting string and put that into the database.

regards

Hugh


At 11:27 +0200 18/7/02, Christian Rautscher wrote:
>Hello Hugh, hello every1,
>is me again with the SQL Problem using MYSQL and Radiator.
>As last-way-out i tried the following:
>
>I reinstalled everything (OS/Radiator/Mysql) and updated the sql Database,
>so that
>my NAS was authorized to request Radiator for an incoming PPP.
>
>Than i tried to connect myself with the Example User (user: mikem pass:
>fred)
>and it worked perfectly!!!!
>At this point i am sure that my Router Configuration + Radiator Config are
>okay.
>--------------
>
>Than i did create a new user in the DB:
>
>insert into SUBSCRIBERS ( USERNAME, PASSWORD, ENCRYPTEDPASSWORD, CHECKATTR,
>REPLYATTR, TIMELEFT ) values ( 'dialin', 'dialin', password
>('dialin'),'Service-Type = Framed-User', 'Framed-Protocol = PPP', '100');
>
>Than again i got the same error as before.
>That's why i am quite sure that the problem must be the encrypted Password.
>And
>as you see in the above-mentioned SQL-String, i used:
>
>password('dialin')
>
>but nevertheless i did try using:
>
>crypt('dialin') or md5('dialin') too.
>
>If i do believe the Radiator-manual than Radiator is using as default a
>Unix crypt(3) standart
>encryption.
>In the DOC Reference (Page 149, ref.html, 13.1.1) are some written pieces
>of examples
>but i don't understand them correctly.
>
>That's why my question:
>Can anybody tell me the right syntax to insert a new User in the mysql,
>using the same encrytion as
>there had been used with the EXAMPLE mikem?
>Or to give me a hint, or if it's possible an Example?
>
>Thankyou just in advance.
>Kind regards,
>Christian

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.