From owner-freebsd-isp Mon Dec 8 18:39:04 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id SAA16137 for isp-outgoing; Mon, 8 Dec 1997 18:39:04 -0800 (PST) (envelope-from owner-freebsd-isp) Received: from nijntje.NL.net (nijntje.NL.net [193.79.248.236]) by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id SAA16121 for ; Mon, 8 Dec 1997 18:38:59 -0800 (PST) (envelope-from brendan@nijntje.NL.net) Received: from nijntje.NL.net (localhost [127.0.0.1]) by nijntje.NL.net (8.8.8/8.8.7) with ESMTP id DAA07585; Tue, 9 Dec 1997 03:37:27 +0100 (MET) Message-Id: <199712090237.DAA07585@nijntje.NL.net> X-Organization: NLnet BV X-Address: Postbus 12954, 1100 AZ Amsterdam, The Netherlands X-Phone: +31 20 4952727 Fax: +31 20 6655311 X-Mailer: MH 6.8.4 From: Brendan Bank To: "J. W. Brinkerhoff" Cc: freebsd-isp@FreeBSD.ORG Subject: Re: radiusd using a UNIX based SQL server In-reply-to: Your message of "Mon, 08 Dec 1997 15:38:46 EST." Date: Tue, 09 Dec 1997 03:37:26 +0100 Sender: owner-freebsd-isp@FreeBSD.ORG X-Loop: FreeBSD.org Precedence: bulk [Quoting "J. W. Brinkerhoff", on Dec 8 1997 at 15:38 "radiusd us ..."] > -----BEGIN PGP SIGNED MESSAGE----- > > Anyone ever set up any varient of radiusd to get user information > (including password, ips, and routes) from an SQL database residing in an > SQL server on a UNIX based machine? > > Jim Brinkerhoff > jwb@tbe.net Hi, Check leo@tunix.kun.nl, he ported mSql into radius. I think he only only stored the user/pw pairs. I hacked DB into the limited edition of the Merrit Radius. But I did that partly in the boss his time so... :). The problem is if you have only 1 radius server or 2 quering 1 sql server you are not realy redudant. We server over 60K dialin accounts and you do not whant to depend on 1 sql server to run 24 hours 365 days a year. So we use more than 1 and copy the db(m) files around the radius servers. -- Brendan