would you recommend doing it within the dialup.conf configuration? how would i configure it to do 3 steps: Select Update radacct insert new table? Thanks
On 26 Jun 2016, at 2:26 PM, Alan DeKok <aland@deployingradius.com> wrote:
On Jun 26, 2016, at 7:14 AM, liran kessel <lirankessel@gmail.com> 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 http://www.freeradius.org/list/users.html