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