Accounting interim data delta

[liran kessel]

In continuation to your recommendations I have tried to set up another dialup.conf file that inserts data into a different table in addition to the regular dialup.conf that updates the radacct table.
however I have 2 problems.
1. when I run it I get an error regarding my sql command but running radiusd -X doesn’t display the full query, it gets cut in the middle. is there any way to make it show the whole output?
2. Is it possible instead of the way I did it, to rather get both commands into the same dialup.conf file? I saw on the forum that 1 person did this with a stored procedure instead.

Thanks.

Liran

> On 27 Jun 2016, at 4:18 PM, Alan DeKok <aland at deployingradius.com> wrote:
> 
> On Jun 26, 2016, at 7:42 AM, liran kessel <lirankessel at gmail.com> wrote:
>> 
>> Thanks for your help, it is very much appreciated, and I am sure I like many others ask questions which feel “dumb” and I apologise.
>> I am not trying to be spoon-fed everything , and i understand and know how to do things in the DB.
> 
>  That's good.
> 
>> from my understanding freeradius doesn’t just insert, it inserts, or updates depending on if its a new session or an existing one, and thats why I asked if there was a way to do it before insert rather than within the DB.
> 
>   And does any of that subtract one number from another?  Did you *read* the SQL queries for those inserts / updates to see what they did?
> 
>  This is one of my biggest frustrations on the list.  I would prefer for people to read the existing docs and/or configuration files.  Instead, many people ask questions which are answered there.
> 
>  Well... *read* the config files to see what the inserts / updates do.  If you know SQL, it should take you 5 minutes to see that they *don't* do subtraction.  Doing so is faster than asking a question on the list.  And, you get to learn more about how the server works, which is good.
> 
>  Asking simple questions just comes across as you want me to do work, and that you're not willing to do it.  That's a large part of why many of my responses here are "think for yourself, and read the docs / config files".
> 
>  Alan DeKok.
> 
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html