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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED]: Non-member submission from
> ["Christian Rautscher" <[EMAIL PROTECTED]>]
> Date: Thu, 18 Jul 2002 04:28:23 -0500
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> >From [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> From: "Christian Rautscher" <[EMAIL PROTECTED]>
> Date: Thu, 18 Jul 2002 11:27:12 +0200
> Message-ID: <[EMAIL PROTECTED]>
> 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 [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
