FW: FreeRadius

[Marcel Grandemange]

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

>What is "GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)" doing in
>data (octet) counter?

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

But advice is welcome!


>Ivan Kalik
>Kalik Informatika ISP