huntgroups and mysql

Dennis Skinner dskinner at
Wed Aug 2 18:27:32 CEST 2006

simon at wrote:
> I set up an entry in the huntgroups file something like this:
> groupname1	NAS-IP-Address ==
> 		Group = firstgroup

Close, I think you want SQL-Group instead of Group.

> Then, in my database, I would need the following entries in the following tables:
> -- radcheck --
> id  	UserName	Attribute	Value 		Op
> 1	test		Password	testp		==
> 2	test		Huntgroup-Name	groupname1	==

You don't need that second entry.  The usergroup table takes care of that.

> -- usergroup --
> id	UserName	GroupName
> 1	test		firstgroup

When someone tries to login, the preprocess section will run the
huntgroups file and if the NAS-IP-Address matches, it will set the
SQL-Group and force a lookup in the usergroup table.

Dennis Skinner
Systems Administrator
BlueFrog Internet

More information about the Freeradius-Users mailing list