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

[Christian Rautscher]

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

-------------------------------------------------------

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X etc etc

===
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.