just insert the the value in radacct table, this way i can check and extract data directly form this table to compute stats for groups. Ok, knowing this i can change my query to INSERT INTO ${....acct_table1} \ (${...column_list}) \ VALUES \ ('%{Acct-Session-Id}', \ '%{Acct-Unique-Session-Id}', \ '%{SQL-User-Name}', \ '(SELECT groupname FROM \${....usergroup_table} WHERE username='%{SQL-User-Name}' ORDER BY priority)', \ '%{Realm}', \ ... thanks. Saludos / Regards / Cumprimentos, António silva On 07/21/2017 01:40 PM, Alan DeKok wrote:
On Jul 21, 2017, at 7:29 AM, Antonio Silva <asilva@wirelessmundi.com> wrote:
I've set the account query to include the groupname in radacct table but it expand the %{SQL-Group} to empty... any idea what i'm doing wrong? The SQL-Group is really only for checking users during authorization. It doesn't get copied to the accounting packets.
Perhaps you could explain what you're trying to do...
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html