From owner-freebsd-isp Thu Dec 14 0: 7:21 2000 From owner-freebsd-isp@FreeBSD.ORG Thu Dec 14 00:07:19 2000 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from icon.icon.bg (icon.bg [62.176.80.58]) by hub.freebsd.org (Postfix) with SMTP id 857F437B400 for ; Thu, 14 Dec 2000 00:07:17 -0800 (PST) Received: (qmail 16223 invoked by uid 1144); 14 Dec 2000 08:11:03 -0000 Date: Thu, 14 Dec 2000 10:11:03 +0200 From: Victor Ivanov To: freebsd-isp@freebsd.org Cc: Tim McCullagh Subject: Re: Merit radius and Mysql Message-ID: <20001214101103.A15877@icon.icon.bg> References: <072f01c065a0$7a89d540$6500a8c0@halenet.com.au> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-md5; protocol="application/pgp-signature"; boundary="gBBFr7Ir9EOA20Yy" Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <072f01c065a0$7a89d540$6500a8c0@halenet.com.au>; from timbo@halenet.com.au on Thu, Dec 14, 2000 at 05:35:47PM +1000 Sender: v0rbiz@icon.icon.bg Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org --gBBFr7Ir9EOA20Yy Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Dec 14, 2000 at 05:35:47PM +1000, Tim McCullagh wrote: > Hi >=20 > Is anyone using merit radius and exporting the radius records directly to= a > mysql or postgres database. If so can you point me in the direction to a= ny > documentation on how to do it You can add an an AATV for the authentication, this part is quite easy, although I don't know what type of AATV should be used. I'm using AATV_DIRE= CT, which blocks the daemon while you're checking passwords and etc. The AATV cookbook is the documentation you need, and looking at the source of course. For accounting purposes I guess you should hack the FSM table, but don't kn= ow a working solution. Currently I'm intercepting calls to the original functi= on and doing my stuff there (don't need that text detail files anyway). I know there is working solution with MySQL which puts *all* configuration files in tables. It's not ported to the freebsd ports collection yet, but y= ou can find it at freshmeat searching for radiusd-sql (and probably compile it with minor fixes). The other modification of radius which was recommended to me was ICRADIUS, it's not ported to the collection too, but it is ported to FreeBSD. It uses mysql and has nice web interface. Haven't tried that also :). Hope this helps a bit... --=20 Players win and Winners play Have a lucky day --gBBFr7Ir9EOA20Yy Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.1i iQCVAwUBOjiAlfD9M5lef5W3AQFxvQQArjjpss4AUUAy+gBbf33DIsxqogB9F13H 9/0pj0PKEm0oblj0Tsg4o97CFl67htrBFEgKIN/MEvPTK6r+p/1srLGSXeBpJ4h5 ytjYx1Arhd0g5TPOwPUOfVV4g1YB1rReE9o2ZCba3wzluo3ysxLYYkgRU9qsVq4g tUGKc23YiqA= =JuB7 -----END PGP SIGNATURE----- --gBBFr7Ir9EOA20Yy-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message