Hi and thanks for your answers.
I do this now and it works fine.
post-auth { sql %{sql:INSERT INTO authorizedmacs (macaddress) VALUES ('%{Calling-Station-Id}')} }
I will read the CREATE PROCEDURE and CREATE FUNCTION for mysql I haven’t worked with those before but they look handy.
Maybe there could be a sql.runMyFunction ? I like to invent things :)
Thanks again /Daniel
-----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+daniel.johansson2= sony.com@lists.freeradius.org] On Behalf Of Alan DeKok Sent: den 31 augusti 2017 13:40 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: new table and query
On Aug 31, 2017, at 2:46 AM, Johansson, Daniel (GIS) < Daniel.Johansson2@sony.com> wrote:
I use FreeRADIUS Version 2.2.6 I want to make a custom table and query for freeradius. sql is enabled in sites-enabled/default for 'post-auth {sql}' and postauth_query is populating radpostauth However my 'macuseradd_query ' is not run can anyone tell me why?
Why not just add a stored procedure to do multiple things? And then call the stored procedure from the postauth_query.
And yes, you can't just invent things in the configuration file and expect them to do something. The documentation explains what those queries are, and when they're run.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
Thanks, i will add the if() statement it's not good as it is now. I just wanted to get something working and will make it nice now when it is working. /Daniel -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+daniel.johansson2=sony.com@lists.freeradius.org] On Behalf Of Alan Buxey Sent: den 31 augusti 2017 14:11 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: RE: new table and query Not to confuse things but there is a way of doing that. Well out of scope and for those who are adventurous ;) However, I would advise that you wrap your SQL: unlang with an if() wrapper checking for presence of a calling-station-id - that would avoid any stage corner cases and not lead to weirdness alan On 31 Aug 2017 1:07 pm, "Johansson, Daniel (GIS)" < Daniel.Johansson2@sony.com> wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html