(RADIATOR) Radiator - Probs with Authby SQL

[neil d. quiogue]

Hello Christian,

For MySQL:
Trye the MD5 function instead of the PASSWORD function.

For Perl:
For this, you would need to play around with Digest::MD5.  Or if you want a
quick way to do the creation, there's a Perl module from CPAN called
Crypt::PasswdMD5 that provides an MD5-based crypt() function.

Saluti,

Neil D. Quiogue

"Information and attachments herein are intended for the named recipients
only.  It may contain attorney-client privileged or confidential matter.
If you have received this message in error, please notify the sender
immediately, and destroy the original message.  Do not disclose the
contents to anyone.  Thank you."


----- Original Message -----
From: "Mike McCauley" <mikem at open.com.au>
To: <radiator at open.com.au>
Sent: Thursday, July 18, 2002 5:44 PM
Subject: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re:
Antwort: Re: (RADIATOR) Radiator - Probs with Authby SQL


>
>
> ----------  Forwarded Message  ----------
>
> Subject: BOUNCE radiator at open.com.au:    Non-member submission from
> ["Christian Rautscher" <christian at run.bz.it>]
> Date: Thu, 18 Jul 2002 04:28:23 -0500
> From: owner-radiator at open.com.au
> To: radiator-approval at open.com.au
>
> >From mikem at server1.open.com.au Thu Jul 18 04:28:22 2002
> Received: from mail.raiffeisen.it (mail.raiffeisen.net [195.254.224.24])
> by server1.open.com.au (8.11.0/8.11.0) with ESMTP id g6I9SL316539;
> Thu, 18 Jul 2002 04:28:22 -0500
> Sensitivity:
> Subject: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re:
>  Antwort: Re: (RADIATOR) Radiator - Probs with Authby SQL
> To: Hugh Irvine <hugh at open.com.au>
> Cc: radiator at open.com.au
> From: "Christian Rautscher" <christian at run.bz.it>
> Date: Thu, 18 Jul 2002 11:27:12 +0200
> Message-ID: <OF51D7484A.758E6C15-ONC1256BFA.003082F3 at raiffeisen.it>
> X-MIMETrack: Serialize by Router on RIS3/RAIFF(Release 5.0.10 |March 22,
>  2002) at 18.07.2002 11:27:23
> MIME-Version: 1.0
> Content-type: text/plain; charset=us-ascii
>
>
> 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.
>

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