RE: Mikrotik-Xmit-Limit - Not enforced on first logon but is on subsequent logons...
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
Mikrotik-Xmit-Limit - Not enforced on first logon but is on subsequent logons...
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
Mikrotik-Xmit-Limit - Not enforced on first logon but is on subsequent logons...
Sorry, forgot to mention it is a routeros hotspot setup. Ok I have added “Mikrotik-Xmit-Limit” for the account to radreply as well and can confirm the download megabyte limit is now enforced on first logon. Is this the best way to do it? Am I doing something wrong? Tks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
