Hi I have been trying to get a accounting_update_query accounting_stop_query that will work with MySQL and record over the 4gig for data transfers. Can anyone help? We are needing to record AcctInputOctets and AcctOutputOctets over the 4 gig amount therefore we need to use the Acct-Input-Gigawords and Acct-Output-Gigawords in to account. We are receiving them from our suppliers. We need this because these days we are seeing very long session times for ADSL links and high speed. We can record up to the 4gig mark. I have tried: AcctInputOctets = '%{Acct-Input-Octets}+(%{Acct-Input-Gigawords}*4294967296)' Doesn't seem to work. Any pointing in the right direction would br greatly appreciated. Freeradius 1.1.0 MySQL 4.0.26 Regards Daniel
"Daniel" <bart@istnet.net.au> wrote:
I have tried:
AcctInputOctets = '%{Acct-Input-Octets}+(%{Acct-Input-Gigawords}*4294967296)'
Doesn't seem to work. Any pointing in the right direction would br greatly appreciated.
Does MySQL have 64-bit support for fields? Alan DeKok.
Alan DeKok wrote:
Does MySQL have 64-bit support for fields?
If you need to store it as a number (ie do math on it within MySQL), it can handle up to 63 bits (which may be enough for this purpose - you have some big problems if users are transferring over 9.2 Exabytes of data in 1 session). You can always store numbers as text. http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html Look for BIGINT. You may be able to go higher with a DOUBLE, but it may return it to you in scientific notation. I haven't played with that. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com
participants (3)
-
Alan DeKok -
Daniel -
Dennis Skinner