How to control users traffic ?

[Neville]

> Message: 2
> Date: Tue, 14 Jul 2009 08:32:18 +0430
> From: Eric <bbahar3 at gmail.com>
> Subject: Re: How to control users traffic ?
> To: freeradius-users at lists.freeradius.org
> Message-ID:
> <38a27c8c0907132102w4d55ebfcmea079116add7b370 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> freeradius-1.1.3-1.4 !!
> Is it the reason of problem ?
>
>
>> I set  reply-name = Session-Octets-Limit in sqlcounter
>> but freeradius sends Seesion-Timeout in reply with value equal to  the
>> deduct of octets used until now from  check-name = Max-Input-Octets.
>> How should change the session-timeout to  Session-Octets-Limit in
>> auth-reply?
>
> That shouldn't happen. What freeradius version? Post the debug from server
> startup and request processiong.
>
> Ivan Kalik
> Kalik Informatika ISP


Hi Ivan,

I have this working, other that I cannot set a Session-Octets-Limit higher 
that 4Gb.

Is there anyway to get around this as I'm allocating 5GB of Usage Per Month?

Max-Traffic-Monthly := 4294970000  (4Gb)

[monthlytraffic]        expand: %{sql:SELECT 
(sum(acctinputoctets)+sum(acctoutputoctets))                 FROM radacct 
WHERE username='test1000' AND                 Month(acctstoptime) 
=(Month(NOW())) AND                 Year(acctstoptime) = Year(NOW())} -> 0
rlm_sqlcounter: Check item is greater than query result
rlm_sqlcounter: Authorized user test1000, check_item=4294967295, counter=0
rlm_sqlcounter: Sent Reply-Item for user test1000, 
Type=Session-Octets-Limit, value=1029889
++[monthlytraffic] returns ok

Sending Access-Accept of id 144 to 193.33.186.190 port 46294
        Idle-Timeout := 1800
        Framed-MTU = 1488
        Framed-Protocol = PPP
        Service-Type = Framed-User
        Acct-Interim-Interval := 300
        Session-Timeout = 3600
        Session-Octets-Limit = 1029889

Session-Octets-Limited is set to 1Mb instead of 4Gb

        Framed-IP-Address = 192.168.0.22



Max-Traffic-Monthly := 4200000000  (3.9Gb)

[monthlytraffic]        expand: %{sql:SELECT 
(sum(acctinputoctets)+sum(acctoutputoctets))                 FROM radacct 
WHERE username='test1000' AND                 Month(acctstoptime) 
=(Month(NOW())) AND                 Year(acctstoptime) = Year(NOW())} -> 0
rlm_sqlcounter: Check item is greater than query result
rlm_sqlcounter: Authorized user test1000, check_item=4200000000, counter=0
rlm_sqlcounter: Sent Reply-Item for user test1000, 
Type=Session-Octets-Limit, value=4201030340
++[monthlytraffic] returns ok

Sending Access-Accept of id 98 to 193.33.186.190 port 34040
        Idle-Timeout := 1800
        Framed-MTU = 1488
        Framed-Protocol = PPP
        Service-Type = Framed-User
        Acct-Interim-Interval := 300
        Session-Timeout = 3600
        Session-Octets-Limit = 4201030340
        Framed-IP-Address = 192.168.0.23

Thx
Nev

> Message: 2
> Date: Tue, 14 Jul 2009 08:32:18 +0430
> From: Eric <bbahar3 at gmail.com>
> Subject: Re: How to control users traffic ?
> To: freeradius-users at lists.freeradius.org
> Message-ID:
> <38a27c8c0907132102w4d55ebfcmea079116add7b370 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> freeradius-1.1.3-1.4 !!
> Is it the reason of problem ?
>
>
>> I set  reply-name = Session-Octets-Limit in sqlcounter
>> but freeradius sends Seesion-Timeout in reply with value equal to  the
>> deduct of octets used until now from  check-name = Max-Input-Octets.
>> How should change the session-timeout to  Session-Octets-Limit in
>> auth-reply?
>
> That shouldn't happen. What freeradius version? Post the debug from server
> startup and request processiong.
>
> Ivan Kalik
> Kalik Informatika ISP
> -------------- next part --------------