Did anyone get this? ---------- Forwarded message ---------- From: Jed Gainer <jedgai...@gmail.com> Date: Fri, Feb 22, 2013 at 12:24 PM Subject: stack allowances To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>
freeradius 2.2.0-3 sqlcounter counterChilliSpotMaxTotalOctetsDaily { counter-name = ChilliSpot-Max-Total-Octets-Daily check-name = CS-Total-Octets-Daily counter-type = data reply-name = ChilliSpot-Max-Total-Octets sqlmod-inst = sql key = User-Name reset = daily query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" } sqlcounter counterChilliSpotMaxTotalOctetsAll { counter-name = ChilliSpot-Max-Total-Octets check-name = CS-Total-Octets counter-type = data reply-name = ChilliSpot-Max-Total-Octets sqlmod-inst = sql key = User-Name reset = never query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" } I use CS-Total-Octets-Daily to give staff a daily limit and CS-Total-Octets to give guests a "jump start". Guests can buy more bandwidth via PayPal and it is appended to their CS-Total-Octets which works great. Problem is when a staff member buys more they all of a sudden have CS-Total-Octets and CS-Total-Octets-Daily in their radcheck which locks them out because their bandwidth usage is over CS-Total-Octets. Does anyone see a solution to my problem other than staff using 2 accounts?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html