FW: FreeRadius

[tnt at kalik.net]

>No idea to be honest, im a novice.
>Many web-sites seem to advice using that and it works for the "most part"
>
>Eg.... http://cakeforge.org/forum/forum.php?forum_id=631
>

OK. It's wrong. That part of the expression counts time not octets. It
handles sessions that started in one counting period and continue into
next one. Data is counted properly without such additions. Delete it.

query = "SELECT SUM(AcctInputOctets + AcctOutputOctets) FROM radacct
WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '%b'"

Remove "+ AcctSessionTime" if you don't want sessions that started in
one counting period and continuing into the next one to count in the new
one.

And tell Dirk and others where you found that information not to mix time
and data counters.

Ivan Kalik
Kalik Informatika ISP