Re: Problem with rml_sqlcounter with GigaByte datavolume

13 Sep 2011

      SELECT SUM(AcctInputOctets) FROM radacct WHERE  UserName='username'

Run the above query in mysql and post the result

then post the freeradius log specific to this section.

On Tue, Sep 13, 2011 at 10:00 PM, Nicolas FOUREL <nicolas.fourel@adipsys.com
...
wrote:
...
Hi Arran,
I have get version 3.0.0 with 64 bit counters support from Git and
installed
it. Unfortunatly, I still have the same problem with my sql counter which
has always "check_item=0" when I put a value bigger than 2^32. On
Access-Request in debug mode, I have the following lines :
Tue Sep 13 18:20:47 2011 : Debug: rlm_sqlcounter: (Check item - counter) is
less than zero
Tue Sep 13 18:20:47 2011 : Debug: rlm_sqlcounter: Rejected user
foo@bar.com,
check_item=0, counter=68882
Here is my counter definition :
sqlcounter totalinputoctets {
       counter-name = Total-Max-Input-Octets
       check-name = Max-Input-Octets
       reply-name = ChilliSpot-Max-Input-Octets
       sqlmod-inst = sql
       key = User-Name
       reset = never
       query = "SELECT SUM(AcctInputOctets) FROM radacct WHERE
UserName='%{%k}'"
}
I have added "Max-Input-Octets" in the dictionary file like that :
ATTRIBUTE       Max-Input-Octets        3001    integer64
In radcheck table:
foo@bar.com                     Max-Input-Octets                :=
107374182400
Did I miss a thing ?
Many thanks
Nicolas
-----Message d'origine-----
De :
freeradius-users-bounces+nicolas.fourel=adipsys.com@lists.freeradius.org
[mailto:freeradius-users-bounces+nicolas.fourel
=adipsys.com@lists.freeradius
.org] De la part de Arran Cudbard-Bell
Envoyé : lundi 12 septembre 2011 11:46
À : FreeRadius users mailing list
Objet : Re: Problem with rml_sqlcounter with GigaByte datavolume
On 12 Sep 2011, at 10:20, nfourel wrote:
...
Thanks for your reply but I can't find any version 3.x.x of freeRADIUS.
Where
can I find it ?
http://git.freeradius.org/
3.x.x is currently in development on the master branch.
-Arran
Arran Cudbard-Bell
a.cudbardb@freeradius.org
RADIUS - Waging war on ignorance and apathy one Access-Challenge at a time.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html

Re: Problem with rml_sqlcounter with GigaByte datavolume

Suman Dash