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 <[email protected] > 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 > [email protected], > 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: > [email protected] Max-Input-Octets := > 107374182400 > > > Did I miss a thing ? > > Many thanks > > Nicolas > > -----Message d'origine----- > De : > freeradius-users-bounces+nicolas.fourel=adipsys....@lists.freeradius.org > [mailto:freeradius-users-bounces+nicolas.fourel > [email protected] > .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 > [email protected] > > 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 >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
