Sqlcounter fail over

[Emanuele Fia]

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