Problem with rml_sqlcounter with GigaByte datavolume

[Suman Dash]

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 at 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 at 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 at 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 at lists.freeradius.org
> [mailto:freeradius-users-bounces+nicolas.fourel
> =adipsys.com at 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 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110913/59e78c63/attachment.html>