Problem with rml_sqlcounter with GigaByte datavolume

[nfourel]

I have the same result with integer rather than integer64. I tried on a 32 bit server, and indeed, if I put a value bigger than 2^32 octets in Max-Input-Octets check-item, it wraps to 4294967295 octets and not to zero. So the problem seems to be with 64bit architecture and value bigger than 2^32 octets (like 100GB). Very strange behavior.

 

Nicolas

 

De : Suman Dash [via FreeRadius] [mailto:ml-node+s1045715n4802642h20 at n5.nabble.com] 
Envoyé : mercredi 14 septembre 2011 14:53
À : nfourel
Objet : Re: Problem with rml_sqlcounter with GigaByte datavolume

 

I have a working setup which takes Check-Item over 100GB But being a 32Bit counter is wraps in 2GB limit. I have not tried Integer64. Can you check what happens when you change it to 32bit in dictionary instead of declaring it as 64bit ?




On Wed, Sep 14, 2011 at 5:53 PM, nfourel <[hidden email]> wrote:

The « check_item=0 » is reason why I posted my messages on this ML. If I put a value lesser than 2^32 (for example 1000000) for “Max-Input-Octets” in radcheck for username ‘[hidden email] <http://user/SendEmail.jtp?type=node&node=4802561&i=0> ’, everything is ok, check_item has the good value. If I put value bigger than 2^32, check_item is always equal to 0.

 

Any idea ?

 

Thanks

 

Nicolas

 

De : Suman Dash [via FreeRadius] [mailto:[hidden email] <http://user/SendEmail.jtp?type=node&node=4802561&i=1> ] 
Envoyé : mercredi 14 septembre 2011 09:43


À : nfourel
Objet : Re: Problem with rml_sqlcounter with GigaByte datavolume

 

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

On Wed, Sep 14, 2011 at 12:55 PM, nfourel <[hidden email] <http://user/SendEmail.jtp?type=node&node=4801896&i=0> > wrote:

Hi,

 

Here is the result of the SQL Query :

 

SELECT SUM(AcctInputOctets) FROM radacct WHERE  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-tp4455164p4802561.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



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html 

  _____  

If you reply to this email, your message will be added to the discussion below:

http://freeradius.1045715.n5.nabble.com/Problem-with-rml-sqlcounter-with-GigaByte-datavolume-tp4455164p4802642.html 

To unsubscribe from Problem with rml_sqlcounter with GigaByte datavolume, click here <http://freeradius.1045715.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4455164&code=bmljb2xhcy5mb3VyZWxAYWRpcHN5cy5jb218NDQ1NTE2NHwtNTg2MjUyMTkw> . 



--
View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-with-rml-sqlcounter-with-GigaByte-datavolume-tp4455164p4802672.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110914/b7abf5b4/attachment.html>