From owner-freebsd-isp@FreeBSD.ORG  Tue Sep 16 19:24:38 2003
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
Delivered-To: freebsd-isp@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 0127816A4B3
	for <freebsd-isp@freebsd.org>; Tue, 16 Sep 2003 19:24:38 -0700 (PDT)
Received: from mail.lambertfam.org (www.lambertfam.org [216.223.208.55])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 4038B43F85
	for <freebsd-isp@freebsd.org>; Tue, 16 Sep 2003 19:24:37 -0700 (PDT)
	(envelope-from lambert@lambertfam.org)
Received: from laptop.lambertfam.org (laptop.int.lambertfam.org [10.1.0.2])
	by mail.lambertfam.org (Postfix) with ESMTP id 381EA34D37
	for <freebsd-isp@freebsd.org>; Tue, 16 Sep 2003 22:24:35 -0400 (EDT)
Received: by laptop.lambertfam.org (Postfix, from userid 1000)
	id 296BE8926; Tue, 16 Sep 2003 22:24:35 -0400 (EDT)
Date: Tue, 16 Sep 2003 22:24:35 -0400
From: Scott Lambert <lambert@lambertfam.org>
To: freebsd-isp <freebsd-isp@freebsd.org>
Message-ID: <20030917022435.GA14843@laptop.lambertfam.org>
Mail-Followup-To: freebsd-isp <freebsd-isp@freebsd.org>
References: <20030917030343.52426383.freebsd@yazzy.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20030917030343.52426383.freebsd@yazzy.org>
User-Agent: Mutt/1.4.1i
Subject: Re: FreeRadius and md5 hashed passwords
X-BeenThere: freebsd-isp@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 17 Sep 2003 02:24:38 -0000

On Wed, Sep 17, 2003 at 03:03:43AM +0200, Martin Jessa wrote:
> Hi guys.
> 
> I have set up freeradius with authentication agains MySQL.
> I have poptop talking to the radius server and in that way authenticating my users.
> The problem is I cannot make the radius server read md5 encrypted passwords, only plain text.
> Any idea what to do to make it read md5 passwords?
> Example of the password table:
> 
> table 'radcheck' :
> 
> Cleartext (works):
> INSERT INTO radcheck VALUES (2,'test@yazzy.org','User-Password',':=','12233445');
> 
> MD5 (no love):
> INSERT INTO radcheck VALUES (3,'test@yazzy.org','User-Password',':=','bc8bf6f2fd343cab9d387d5dcc777be3');

I think you are missing the salt.

This is an MD5 cryptpassword of your example cleartext password:

$1$HuVWpRMf$dmUeqUO15b9HGbDmmki6W.


-- 
Scott Lambert                    KC5MLE                       Unix SysAdmin
lambert@lambertfam.org