Problem with rml_sqlcounter with GigaByte datavolume

Suman Dash sumandash at gmail.com
Wed Sep 14 09:41:53 CEST 2011


check_item=0 , See why Max-Input-Octets is returned as 0 .

On Wed, Sep 14, 2011 at 12:55 PM, nfourel <nicolas.fourel at adipsys.com>wrote:

> Hi,****
>
> ** **
>
> Here is the result of the SQL Query :****
>
> ** **
>
> SELECT SUM(AcctInputOctets) FROM radacct WHERE  [hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=0>
> ';****
>
> ** **
>
> SUM(AcctInputOctets)****
>
> 68882****
>
> ** **
>
> And freeradius log for the counter section :****
>
> ** **
>
> Wed Sep 14 09:17:45 2011 : Debug: rlm_sqlcounter: Entering module authorize
> code****
>
> Wed Sep 14 09:17:45 2011 : Debug: WARNING: Please replace '%k' with
> '${key}'****
>
> Wed Sep 14 09:17:45 2011 : Debug: sqlcounter_expand:  'SELECT
> SUM(AcctInputOctets) FROM radacct WHERE UserName='%{User-Name}''****
>
> Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets :  expand: SELECT
> SUM(AcctInputOctets) FROM radacct WHERE UserName='%{User-Name}' -> SELECT
> SUM(AcctInputOctets) FROM radacct WHERE [hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=1>
> '****
>
> Wed Sep 14 09:17:45 2011 : Debug: WARNING: Please replace '%S' with
> '${sqlmod-inst}'****
>
> Wed Sep 14 09:17:45 2011 : Debug: sqlcounter_expand:  '%{sql:SELECT
> SUM(AcctInputOctets) FROM radacct WHERE [hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=2>
> '}'****
>
> Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets : sql_xlat****
>
> Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets :  expand:
> %{User-Name} -> [hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=3>
> ****
>
> Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets : sql_set_user
> escaped user --> '[hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=4>
> '****
>
> Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets :  expand: SELECT
> SUM(AcctInputOctets) FROM radacct WHERE [hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=5>'
> -> SELECT SUM(AcctInputOctets) FROM radacct WHERE [hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=6>
> '****
>
> Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets:  expand:
> /usr/local/var/log/radius/sqltrace.sql ->
> /usr/local/var/log/radius/sqltrace.sql****
>
> Wed Sep 14 09:17:45 2011 : Debug: rlm_sql (sql): Reserving sql socket id: 0
> ****
>
> Wed Sep 14 09:17:45 2011 : Debug: rlm_sql_mysql: query:  SELECT
> SUM(AcctInputOctets) FROM radacct WHERE [hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=7>
> '****
>
> Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets: sql_xlat finished**
> **
>
> Wed Sep 14 09:17:45 2011 : Debug: rlm_sql (sql): Released sql socket id: 0
> ****
>
> Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets :  expand:
> %{sql:SELECT SUM(AcctInputOctets) FROM radacct WHERE [hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=8>'}
> -> 68882****
>
> Wed Sep 14 09:17:45 2011 : Debug: rlm_sqlcounter: (Check item - counter) is
> less than zero****
>
> Wed Sep 14 09:17:45 2011 : Debug: rlm_sqlcounter: Rejected user [hidden
> email] <http://user/SendEmail.jtp?type=node&node=4801856&i=9>,
> check_item=0, counter=68882****
>
> ** **
>
> Any idea ?****
>
> ** **
>
> Thanks for your help****
>
> ** **
>
> Nicolas****
>
> ** **
>
> *De :* Suman Dash [via FreeRadius] [mailto:[hidden email]<http://user/SendEmail.jtp?type=node&node=4801856&i=10>]
>
> *Envoyé :* mardi 13 septembre 2011 19:44
> *À :* nfourel
>
> *Objet :* Re: Problem with rml_sqlcounter with GigaByte datavolume****
>
> ** **
>
> 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 <[hidden email]<http://user/SendEmail.jtp?type=node&node=4799383&i=0>>
> 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 [hidden
> email] <http://user/SendEmail.jtp?type=node&node=4799383&i=1>,
>
> 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:
> [hidden email] <http://user/SendEmail.jtp?type=node&node=4799383&i=2>
>                 Max-Input-Octets                :=
>
> 107374182400
>
>
> Did I miss a thing ?
>
> Many thanks
>
> Nicolas
>
> -----Message d'origine-----
> De :
> freeradius-users-bounces+nicolas.fourel=[hidden email]<http://user/SendEmail.jtp?type=node&node=4799383&i=3>
> [mailto:[hidden email]<http://user/SendEmail.jtp?type=node&node=4799383&i=4>
> =[hidden email] <http://user/SendEmail.jtp?type=node&node=4799383&i=5>
>
> .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 ?
> >
>
> click here. ****
>
> ------------------------------
> View this message in context: RE: Problem with rml_sqlcounter with
> GigaByte datavolume<http://freeradius.1045715.n5.nabble.com/Problem-with-rml-sqlcounter-with-GigaByte-datavolume-tp4455164p4801856.html>
>
> Sent from the FreeRadius - User mailing list archive<http://freeradius.1045715.n5.nabble.com/FreeRadius-User-f2740693.html>at Nabble.com.
>
> -
> 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/20110914/35540121/attachment.html>


More information about the Freeradius-Users mailing list