new table and query

[Johansson, Daniel (GIS)]

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 at lists.freeradius.org] On Behalf Of Alan DeKok
Sent: den 31 augusti 2017 13:40
To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Subject: Re: new table and query

On Aug 31, 2017, at 2:46 AM, Johansson, Daniel (GIS) <Daniel.Johansson2 at 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