Query error in Acct table for Tenant_ID

Alan Buxey alan.buxey at gmail.com
Wed Mar 21 13:24:54 CET 2018


stop rewind.

the setting of the variable would go into the main virtual_server file
- not in the SQL config - as i said, read the unlang manual and sql
module guide to see how these
things work.

to the SQL query in the eg accounting section BEFORE the call to sql
in the accounting section eg

accounting {


update request {
      tenant_list = %{sql:"SELECT tenant_id FROM ${client_table} WHERE
realipaddr = '%{NAS-IP-Address}'"}

then use that variable in your UPDATE command in the SQL module


More information about the Freeradius-Users mailing list