Query error in Acct table for Tenant_ID

[Alan Buxey]

hi,

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}'"}
     }
....
sql
...
}

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


alan