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@deployingradius.com> wrote:
On Jun 26, 2016, at 7:42 AM, liran kessel <lirankessel@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