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