Trying to understand expression in SQL module

Kenroy bennettk9999 at gmail.com
Mon Jul 10 13:02:55 CEST 2017


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.


See below for full query expression.


INSERT INTO* ${....acct_table1}* \
(${...column_list}) \
VALUES(\
'%{Acct-Session-Id}', \
'%{Acct-Unique-Session-Id}', \
'%{SQL-User-Name}', \
NULLIF('%{Realm}', ''), \
'%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}}', \
NULLIF('%{%{NAS-Port-ID}:-%{NAS-Port}}', ''), \
'%{NAS-Port-Type}', \
TO_TIMESTAMP(%{integer:Event-Timestamp}), \
TO_TIMESTAMP(%{integer:Event-Timestamp}), \
NULL, \
0, \
'%{Acct-Authentic}', \
'%{Connect-Info}', \
NULL, \
0, \
0, \
'%{Called-Station-Id}', \
'%{Calling-Station-Id}', \
NULL, \
'%{Service-Type}', \
'%{Framed-Protocol}', \
NULLIF('%{Framed-IP-Address}', '')::inet), \
                                        '%{Nomadix-User-Definable-1}', \
                                        '%{Nomadix-User-Definable-2}', \
                                        '%{NAS-Identifier}' "


More information about the Freeradius-Users mailing list