Hi,
I normally use MK for lots of things. The Mikrotik-Xmit-Limit attribute is
recognize for MK as a limitation, so when the limit arrives, the MT cuts the
user account.
You can write a exec program to modify the Mikrotik-Xmit-Limit attribute or
insert a trigger in the DB or use sqlcounter.
You choose what solucion is easier for you.
Santiago
> From: sh...@sme.net.au
> Date: Sat, 27 Nov 2010 20:44:24 +1000
> Subject: Mikrotik-Xmit-Limit - Not enforced on first logon but is on
> subsequent logons...
> To: freeradius-users@lists.freeradius.org
>
> Hi all,
>
> Doing some trials with freeradius 2.x with the intention of moving from
> 1.1.7
>
>
> I have an odd problem with mikrotik nas.
> An account with download limit will not enforce the limit on the first
> logon but will on subsequent logons.
> On the first logon, no limit is imposed in mikrotik and the account can
> use unlimited traffic. If I log off then log on again, the limit is
> enforced... (I have checked in winbox and the "limit bytes in" column is
> not populated on first logon).
>
> It is taking me a while to get use to v2 of freeradius.
>
> Tks
>
>
> Setup details below:
>
> User account has attribute Mikrotik-Xmit-Limit := 10471200 in radcheck
> Do I need to have something in radreply as this is where the shaping is
> done?
>
>
> In: sql/mysql/counter.conf
>
> sqlcounter downloadbytecounter {
> counter-name = Mikrotik-Xmit-Limit
> check-name = Mikrotik-Xmit-Limit
> reply-name = Mikrotik-Xmit-Limit
> sqlmod-inst = sql
> key = User-Name
> reset = never
> query = "SELECT SUM(acctoutputoctets) FROM radacct WHERE
> username='%{%k}'"
> }
>
>
>
> In sites-available/default
>
> authorize {
> downloadbytecounter
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
