Sqlcounter fail over

[Emanuele Fia]

Dear Mike,

Thank you for your reply.

What i don’t understand is how to write skip group “offertaA_unlimited” and use “offertaA_limited” in the update reply

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

> No, i would not help all, i want you to learn so that you can troubleshoot as needed. Defiantly, i would give fare idea how that would be done. it is so easy, anyways. 
> 
> In "/etc/freeradius/sites-available/default" , in your case chillispot_max_byte_monthly.  Do like this
> 
> 
> access-period
> expiration
> more entries....
> 
> chillispot_max_byte_monthly{
>         reject = 1
>     }
>     if(reject){
>             update reply {
>                     WISPr-Bandwidth-Max-Down := 100k
>             }
>             ok = reject
>     }
> 
> This is not a solution, understand from my example how it is going to work. Please do not copy paste, it would not work.
> 
> Thanks / Regards
> RM --
>  
> 
> 
> 
> On Fri, Sep 26, 2014 at 9:59 AM, Emanuele Fia <emanuele.fia at gmail.com> wrote:
> 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
> 
> 
> -
> 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/6c622faa/attachment.html>