Trying to understand expression in SQL module

Kenroy bennettk9999 at
Mon Jul 10 14:21:00 CEST 2017

Hi Alan,
  I know is an expressions that executes when the server starts  .
I am just trying to get familiar with the expressions and haven't see
anything that  explains the ellipsis in the wiki.

I wanted to know whats the purpose of the  ellipsis (*....*)  in front of
the  variable  *acct_table1   *for the expression ${*....*acct_table1}*  . *
Looking at the queries.conf file I would assume  the dots  is a means of
 referencing a variable in a parent block.

See my understanding so far in the following example. I just want to know
if I am on the right track with this.
blocks,a,b and c are just example blocks  to demonstrate my understanding
of creating expressions in unlang and not used in  freeradius.


a {

     b {



        c {

            #assign var1  from block a to newdata

           #assign varx  from block a to newdatax



On Mon, Jul 10, 2017 at 7:28 AM, Alan DeKok <aland at>

> > On Jul 10, 2017, at 7:02 AM, Kenroy <bennettk9999 at> wrote:
> >
> > Hello everyone,
> >    I am  reading the  sql model query config trying to understand it. I
> > came across the following an expression  *${....acct_table1}*  . What is
> > the purpose of the the ellipsis (....)  in front of the  variable
> > acct_table1.
>   It's a macro expansion, done when the server starts.  See
> raddb/radiusd.conf.  There are lots of examples
> > See below for full query expression.
>   We already know what the queries look like.  Please don't post them to
> the list.
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See
> list/users.html

More information about the Freeradius-Users mailing list