FW: FreeRadius

tnt at kalik.net tnt at kalik.net
Wed Oct 1 22:10:17 CEST 2008


>>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?

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list