I have setup freeradius 2.x with mysql as Billing system and Mikrotik as NAS (pppoe server).
I have managed to configure few modules like time limit, expiration etc. but unable to configure volume QUOTA limit , e.g 100MB for user.
I tried to take various examples from the google/forum but none of it worked. can some one please post some working examples of the counters and tips please?
Re: quota limit with freeradius
Try following: [I have used it in Ubuntu Freeradius 2.x with Mikrotik 5.x]configure volume QUOTA limit , e.g 100MB for user.
I tried to take various examples from the google/forum but none of it worked. can some one please post some working examples of the counters and tips please?
QUOTA LIMIT FOR USER with CUSTOM MEANINGFUL REJECT REPLY MESSAGE
To limit user data volume limit (either daily, weekly or monthly, set this in reset section) use below code.
edit the file /etc/freeradius/sites-enabled/default
and add following under “authorize {“ section
Code: Select all
totalbytecounter{
reject = 1
}
if(reject){
update reply {
Reply-Message := "ZAIB-RADIUS-REPLY - You have reached your bandwidth limit"
}
reject
}Add Following
Save and Exit.sqlcounter totalbytecounter {
counter-name = Mikrotik-Total-Limit
check-name = Mikrotik-Total-Limit
reply-name = Mikrotik-Total-Limit
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT ((SUM(AcctInputOctets)+SUM(AcctOutputOctets))) FROM radacct WHERE UserName='%{%k}'"
}
Now add user attribute in radchceck table (Following is 1 MB total data limit example, which can be used in parts as well )
Note: Value is in bytes, so use it accordingly
Code: Select all
INSERT INTO radcheck ( id , UserName , Attribute , op , Value ) VALUES (NULL , 'zaib', 'Mikrotik-Total-Limit', '=', '1000000');You do not have the required permissions to view the files attached to this post.