Hi, I am using FreeRADIUS Version 2.1.12, for host i686-pc-linux-gnu, built on Dec 6 2011 at 19:51:34, and I'd like to set up a quota using rlm_sqlcounter. However, the quota I'd like to use is over 4GB and the module will than overflow, not allowing a user who still has quota left.
The user with the attributes: mysql> select * from radcheck; +----+----------+--------------------+----+-------------+ | id | username | attribute | op | value | +----+----------+--------------------+----+-------------+ | 18 | test1 | Max-Octets | := | 29687864955 | | 15 | test1 | Cleartext-Password | := | test | +----+----------+--------------------+----+-------------+ sqlcounter.conf: sqlcounter volumelimitcounter { counter-name = Total-Max-Octets check-name = Max-Octets reply-name = ChilliSpot-Max-Total-Octets sqlmod-inst = sql key = User-Name reset = never error-msg = "Sorry, your bandwidth has exceeded the provided limit" query = "SELECT SUM(AcctOutputOctets+AcctInputOctets) FROM radacct where UserName='%{${key}}'" } radiusd output: [volumelimitcounter] expand: %{sql:SELECT SUM(AcctOutputOctets+AcctInputOctets) FROM radacct where UserName='test1'} -> 25687864955 rlm_sqlcounter: (Check item - counter) is less than zero rlm_sqlcounter: Rejected user test1, check_item=4294967295, counter=4294967295 ++[volumelimitcounter] returns reject full debug log: can be found at http://pastebin.com/fs2ed6pF Any feedback would be greatly appreciated. Kind regards, Ben - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html