Accounting interim data delta
lirankessel at gmail.com
Tue Jul 5 17:07:02 CEST 2016
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.
> 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
More information about the Freeradius-Users