Query error in Acct table for Tenant_ID

Alan Buxey alan.buxey at gmail.com
Wed Mar 21 19:16:42 CET 2018


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


> 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.


More information about the Freeradius-Users mailing list