From owner-freebsd-isp@FreeBSD.ORG Fri Jul 24 22:34:03 2009 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id A18D2106564A for ; Fri, 24 Jul 2009 22:34:03 +0000 (UTC) (envelope-from spork@bway.net) Received: from xena.bway.net (xena.bway.net [216.220.96.26]) by mx1.freebsd.org (Postfix) with ESMTP id 43C448FC0A for ; Fri, 24 Jul 2009 22:34:03 +0000 (UTC) (envelope-from spork@bway.net) Received: (qmail 73429 invoked by uid 0); 24 Jul 2009 22:07:21 -0000 Received: from unknown (HELO office-dhcp-35.bway.net) (spork@216.220.107.35) by smtp.bway.net with (DHE-RSA-AES256-SHA encrypted) SMTP; 24 Jul 2009 22:07:21 -0000 Date: Fri, 24 Jul 2009 18:07:21 -0400 (EDT) From: Charles Sprickman X-X-Sender: spork@hotlap.local To: freebsd-isp@freebsd.org Message-ID: User-Agent: Alpine 2.00 (OSX 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII Subject: Radius server suggestions X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 24 Jul 2009 22:34:03 -0000 Hi all, I'm in the middle of redesigning a number of things here. Our main db of users will likely be changing format (vpopmal to postfix+dovecot). There will be additional columns in the database for dial access, usenet access and possibly pppoe access. Our current vpopmail setup stores these values in one column as a bitmask, which hurts my head, so I'm moving to something easier (ie: if "dialup" column = "1", they can have dialup). I'm out of touch on what radius implementations are popular. I need something that meets two basic requirements: -auth from mysql or pgsql -set the sql query based on which radius client the request comes from Any pointers on that? Thanks, Charles ___ Charles Sprickman NetEng/SysAdmin Bway.net - New York's Best Internet - www.bway.net spork@bway.net - 212.655.9344