FreeRadius and MySql custom attributes

[Aaron Seibert]

I'll also add that the dictionary.slipstream is included in the
dictionary file.  FreeRadius running on freeBSD

On Wed, 2008-11-05 at 12:14 -0500, Aaron Seibert wrote:
> Hello,
> 
> I work in the NOC of an isp.  Currently we have VIRCOM Radius servers
> set up to authenticate against a MySql server cluster, but we'd like to
> switch to FreeRadius. There is a profiles column that contains a few
> different service definitions (slip for SlipStream, newsgroups, a combo
> slip-news, etc.)  What I can't figure out how to do is have the Radius
> server evaluate that column for the authenticated user, and send a reply
> so that the client knows that the user is authenticated for that
> specific service.  Currently, I'm just trying to get the slip service to
> work.  I have created a dictionary.slipstream file with the following:
> 
> VENDOR Slipstream 7000
> ATTRIBUTE SlipStream-Auth True string Slipstream
> 
> However, that will not authenticate the slip client.  If I "hardcode"
> the attribute into the auth_reply query, the client is then
> authenticated. (Query = authorize_reply_query = "SELECT
> '','Slipstream-Auth','true',':-' FROM radius_auth WHERE Username =
> '%{SQL-User-Name}'"
> 
> Any ideas where to go to get this working correctly?
> 
> 
> 
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html