Tenant_list the "tenant_list " Freeradius service does not work if you do not capitalize the initials. I did great with your knowledge. Currently the service worked I added the attribute as follows. The tenant_id number of data coming from the captive portal to the Radacct table is ' 0 '. Actually, it was worth 1. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ PhpMyAdmin Tenant_List Acct-Session-Id Acct-Unique-Session-Id {SQL-User-Nam 2509 0 1a4670265078e308 d95e03d919d03623407adbe4ebe55239 emrah 192.168.22.188 2012 Ethernet 2018-03-22 08:35:31 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- start { # # Insert a new record into the sessions table # query = "\ INSERT INTO ${....acct_table1} \ (${...column_list}) \ VALUES \ ('%{Tenant_List}', \ '%{Acct-Session-Id}', \ '%{Acct-Unique-Session-Id}', \ '%{SQL-User-Name}', \ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- #ATTRIBUTE My-Local-String 3000 string #ATTRIBUTE My-Local-IPAddr 3001 ipaddr #ATTRIBUTE My-Local-Integer 3002 integer ATTRIBUTE Tenant_List 3000 string ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- # Log traffic to an SQL database. # # See "Accounting queries" in sql.conf update request { Tenant_List = %{sql:"SELECT tenant_id FROM nas WHERE realipaddr = '%{NAS-IP-Address}'"} } sql -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2018-03-21 21:16 GMT+03:00 Alan Buxey <alan.buxey@gmail.com>:
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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html