Hi,

Where do I put this piece of code? Can I do this invocation in the authorize block? Or is it something I put in the radiusd.conf? And where do I put the custom procedure itself? Is it in /etc/freeradius/modules?

Sorry about this. I'm confused about the placement. First time to add a custom procedure. Possible to extend this example to show which codes go to which file?

Thanks a lot!

Det

From: Alan DeKok <aland@deployingradius.com>
To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>
Sent: Wednesday, November 9, 2011 9:57 PM
Subject: Re: Simultaneous-Use For Group Using Unlang

det.explorer@yahoo.com wrote:
> I'd like to implement this using unlang but not sure where to start. The part that I am having difficulty is on where to create the procedure and how to call the procedure. The rest of the things like the DB query I can reuse from the existing program. I want to implement this using unlang to avoid having to open a new MySQL connection.
>
> Any example, I can follow?

The SQL module supports string expansion. The input strings are just
SQL statements. The output is just a one-line string containing the
result of the SQL query.

This means you can call SQL procedures directly from unlang:

    if ("%{sql: call procedure with args}" > 2) {
        ... more than 2 people logged in ..
    }

Very simple!

Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html