FreeRADIUS 2.1.12 rlm_sqlcounter bug‏

ben beneke benekeben at gmail.com
Thu Dec 15 16:40:19 CET 2011


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



More information about the Freeradius-Users mailing list