Accouting time duratin calculation

[Russell Mike]

Hi,




On Wed, Jun 5, 2013 at 7:43 AM, Miha <miha at softnet.si> wrote:

> Hi,
>
> how does freeradius calculate duration time?


MySQL query grabs the information from "radacct"

i.e.

sqlcounter forevertimecounter {
                counter-name = "Max-All-Session-Time"
                check-name = "Max-All-Session"
                count-attribute = "Acct-Session-Time"
                reply-name = "Session-Timeout"
                sqlmod-inst = "sql"
                key = "User-Name"
                reset = "never"
                cache-size = "5000"
                query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct
WHERE UserName='%{%k}'"
}




> My NAS sends start and stop packet. In mysql table I can see accstarttime
> and accstoptime. Is the duration time automaticly created from start time
> and stop time or should NAS also send duration time?
>

No. Value is stored in "radacct"; rlm_sqlcounter sum the total time.

hope this helps !


> In other words is it possbile that freeradius automaticly calculate
> duration from start and stop packet:)?
>
> tnx!
>
> miha
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/**
> list/users.html <http://www.freeradius.org/list/users.html>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130605/81067006/attachment.html>