Changing radgroup with a sqlcounter ?

18 Nov 2010

      Hello,

I am working on a radius config for a hotspot. I already configured a script
that kick the user when the quota exceed thanks to some very useful posts in
the coova forum.

I used this counter :

sqlcounter noresetBytecounter {
            counter-name = Total-Max-Octets
            check-name = Max-Octets
            reply-name = ChilliSpot-Max-Total-Octets
            sqlmod-inst = sql
            key = User-Name
            reset = never
            query = "SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets))
FROM radacct WHERE UserName='%{%k}'"
      }

My goal is that a user belongs to a standard group with a 512kbps bandwith
and a quota of 100mo. Then when he exceeds his quota, he is switched to a
128 kbps group.

I know how to setup groups that limits bandwidth and volume. What I don't
know is how to set up a counter that instead of kicking the user out of the
network when he exceeds his quota switch him to another radgroup.

Any clue how i can do it ?

Thank you very much,
-- 
View this message in context: http://freeradius.1045715.n5.nabble.com/Changing-radgroup-with-a-sqlcounter-...
Sent from the FreeRadius - User mailing list archive at Nabble.com.

Changing radgroup with a sqlcounter ?

Arrgghh