Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: (RADIATOR) Radiator - Probs with Authby SQL
christian at run.bz.it
Thu Jul 18 04:27:12 CDT 2002
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,
my NAS was authorized to request Radiator for an incoming PPP.
Than i tried to connect myself with the Example User (user: mikem pass:
and it worked perfectly!!!!
At this point i am sure that my Router Configuration + Radiator Config are
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.
as you see in the above-mentioned SQL-String, i used:
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
In the DOC Reference (Page 149, ref.html, 13.1.1) are some written pieces
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.
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.
More information about the radiator