Hey, Thanks for the tip, though that's FR2-specific solution and I'd like to be able to get this sort out with older deployments running 1.1.7 or earlier (god forbid! :-) ) That patch for rlm_sqlcounter would be ideal I think. I think this should also be already pushed into the formal release, this entire support for data information too. Regards, Liran. On Wed, Nov 12, 2008 at 11:02 AM, Flamur Rogova <flamur@ipko.net> wrote:
liran tal wrote:
Waiting for that traffic limitation patch, Venkatesh. Thanks.
Hi, I was stuck with this problem too, and I came up with this solution, which works in my test environment.
The idea is to store allowed bytes in Tmp-Integer-0, than just use unlang to compare user's allowed and actual traffic bytes.
btw, maximum traffic count is 2^31 bytes, if you do it this way.
if(control:Tmp-Integer-0) { if("%{sql:SELECT SUM(AcctOutputOctets+AcctInputOctets) FROM radacct WHERE UserName='%{User-Name}' }" > "%{control:Tmp-Integer-0}" ) { # traffic bytes limit reached reject } }
Regards, Flamur
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html