Missing groupname in radacct table

[Antonio Silva]

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