Accounting interim data delta

liran kessel lirankessel at
Sun Jun 26 13:30:39 CEST 2016

would you recommend doing it within the dialup.conf configuration? 

how would i configure it to do 3 steps:
Update radacct
insert new table?


> On 26 Jun 2016, at 2:26 PM, Alan DeKok <aland at> wrote:
> On Jun 26, 2016, at 7:14 AM, liran kessel <lirankessel at> wrote:
>> What we need is to be able to know what was the delta of acctinputoctets and  acctoutputoctets that was received in this event , in comparison to the data that was already in the DB from the previous notifications.
>> Can I somehow enter this delta into a different table that will show me the usage for each notification?
>  You need to calculate the delta first.  Write a SELECT statement which grabs the current value from the DB, and then subtract it from the current value of the attribute.  Put the result into the SQL table.
>  Alan DeKok.
> -
> List info/subscribe/unsubscribe? See

More information about the Freeradius-Users mailing list