Sqlcounter fail over

[Emanuele Fia]

Dear Mike,

Exactly, i need to drop the bandwidth when the user reaches the bandwidth quota.

Can you help me to modify authorize section ?


Il giorno 26/set/2014, alle ore 11:26, Russell Mike <radius.sir at gmail.com> ha scritto:

> OK
> 
> You need to do unlang coding for that, you need to modify freeradius reply under authorize section. To be sure, are you saying when a user reaches the bandwidth quota you do not want to deny rather drop the bandwidth to 100K. Right? 
> 
> Thanks
> 
> 
> On Fri, Sep 26, 2014 at 8:56 AM, Emanuele Fia <emanuele.fia at gmail.com> wrote:
> Dear Mike,
> 
> Thank you for your answer.
> 
> >Now happen that when sqlcounter 'Max-Monthly-TrafficIN' reach the value set in radgroupreply return auth reject.
> 
> When the counter 'Max-Monthly-TrafficIN’ reach the value 5000000 freeradius reply with access-reject that is not what i need. I need that when the counter reach the value of 5000000 freeradius reply  with 'offertaA_limited' reply settings.
> 
> The problem is the access-reject that send the sqlcounter.
> 
> (Reply when counter reach the specified value )
> 
> Sending Access-Request of id 23 to 127.0.0.1 port 1812
>         User-Name = "1berrinoma1228721nx"
>         User-Password = "su72ug"
>         NAS-IP-Address = 78.159.220.181
>         NAS-Port = 1812
> rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=23, length=70
>         Reply-Message = "Your maximum monthly usage time has been reached”
> 
> 
> Il giorno 26/set/2014, alle ore 10:45, Russell Mike <radius.sir at gmail.com> ha scritto:
> 
> > Hi
> >
> > this is how it should work as you explained. what is wrong ? what do you want? please explain more. did you check if your counter does reset every month ?
> >
> > Thanks
> >
> >
> > On Thu, Sep 25, 2014 at 12:05 PM, Emanuele Fia <emanuele.fia at gmail.com> wrote:
> > Dear Freeradius Users,
> >
> > I need some help in my freeradius configuration.
> >
> > radusergroup
> > +---------------------+---------------------+----------+
> > | username            | groupname           | priority |
> > +---------------------+---------------------+----------+
> > | 1aaaaaaaaa1228721nx | offertaA_unlimited  |        1 |
> > | 1aaaaaaaaa1228721nx | offertaA_limited    |        2 |
> > +---------------------+---------------------+----------+
> >
> > radgroupcheck
> > +----+---------------------+-----------------------+----+---------+
> > | id | groupname           | attribute             | op | value   |
> > +----+---------------------+-----------------------+----+---------+
> > | 35 | offertaA_unlimited  | Max-Monthly-TrafficIN | := | 5000000 |
> > +----+---------------------+-----------------------+----+---------+
> >
> > radgroupreply
> > +-----+---------------------+---------------------+----+------------+
> > | id  | groupname          | attribute            | op | value      |
> > +-----+---------------------+---------------------+----+------------+
> > | 207 | offertaA_unlimited | Fall-Through         | =  | yes        |
> > | 205 | offertaA_unlimited | Rate-Limit           | =  | 2048k/512k |
> > | 211 | offertaA_limited   | Fall-Through         | =  | yes        |
> > | 209 | offertaA_limited   | Rate-Limit           | =  | 100k/100k  |
> > +-----+---------------------+---------------------+----+------------+
> >
> >
> > My goal is that user '1aaaaaaaaa1228721nx' use the group 'offertaA_unlimited' until the attribute 'Max-Monthly-TrafficIN' ( sqlcounter ) reach the value  and after this radius reply with settings of the group 'offertaA_limited'
> >
> > Now happen that when sqlcounter 'Max-Monthly-TrafficIN' reach the value set in radgroupreply return auth reject.
> >
> > Probably there is something to do in policy.conf, i have done some test without results =(
> >
> > Thank you for help,
> > Emanuele
> >
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140926/29b8b505/attachment-0001.html>