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: shane@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