Query error in Acct table for Tenant_ID

[Alan Buxey]

hi,


> accounting {
>
> #
> #  See "Accounting queries" in sql.conf
>
> update request {
>               tenant_list = %{sql:"SELECT tenant_id FROM ${client_table}
> WHERE realipaddr = '%{NAS-IP-Address}'"}
>         }

okay.....

> Unknown attribute "tenant_list"

so did you add that value to the dictionary?


no, you didnt.

you then went on to add something completely different and irrelevant
"Tenant-Id-List"  - seen in your next email.

worse, you then went and did something random, sticking stuff back
into queries.conf

...and you've got syntax errors in your insert statement - "VALUES
(%{Tenant-Id-List}', %{Acct-Session-Id}',
'%{Acct-Session-Id}', '%{Acct-Unique-Session-Id...."  - you're missing
a load of apostrophes for those initial elements. basic SQL 101.

alan