SQL and Huntgroups

Alan DeKok aland at deployingradius.com
Thu Apr 25 14:57:03 CEST 2013


gregoire.leroy at retenodus.net wrote:
> My fault : I've open status instead of default.

  I have no idea what that means.

  All of my help is presuming that you're starting off with the default
configuration.  If you've butchered it, you're on your own.

> For the step 4, I have to :
> 1) Retrieve the huntgroup
> 2) Compare it with what the user sends
> 3) If it matches, give him his specific statement.
> 
> So, if I understand correctly in the authorize section, I have to
> maintain a radipusers table for my IP/users and do something like :
> 
> 1)
> update request {
> Huntgroup-Name := "%{sql:SELECT groupname FROM radhuntgroup WHERE
> nasipaddress='%{NAS-IP-Address}'}"
> }
> 
> 2)
> if Huntgroup-Name == 'one_huntgroup_name' {
> 3)
> Framed-IP-Address = "%{sql:SELECT ip FROM radipusers WHERE
> user='%{username}'}"
> }
> 
> Is there something wrong in what I just said ?

  I'm really not sure.

  All I can say is try it, and see if it works.

  Alan DeKok.


More information about the Freeradius-Users mailing list