Re: How to control users traffic ?

19 Aug 2009

      ...
Message: 2
Date: Tue, 14 Jul 2009 08:32:18 +0430
From: Eric <bbahar3@gmail.com>
Subject: Re: How to control users traffic ?
To: freeradius-users@lists.freeradius.org
Message-ID:
<38a27c8c0907132102w4d55ebfcmea079116add7b370@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@gmail.com>
Subject: Re: How to control users traffic ?
To: freeradius-users@lists.freeradius.org
Message-ID:
<38a27c8c0907132102w4d55ebfcmea079116add7b370@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

Re: How to control users traffic ?

Neville