huntgroups and mysql

[Dennis Skinner]

simon at 434canada.com wrote:
> I set up an entry in the huntgroups file something like this:
> 
> groupname1	NAS-IP-Address == 192.168.2.3
> 		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
http://www.bluefrog.com