Groupname is not written in the table radacct

Geovanny Varela geovarela at
Fri Apr 5 14:47:22 CEST 2013

Well, not quite understand your explanation.
I am not an expert in FreeRadius.
Let me explain my scenario:

1 - I set up a hotspot with Mikrotik in a hotel where user authentication
is done by FreeRadius. Users are registered directly in the MySQL database
Freeradius by software I developed.

2 - When the guest checks in your name is entered in the username field and
room number if it is entered as hosts in the table radcheck password.

3 - After that the room number is entered in the table radgroupreply

4 - the next step the host name is entered in the username field
radusergroup table and room number on the field groupname.

5 - After these operations is done in a select radacct table to collect
accounting data.

6 - My software generates a ticket to the billing.

7 - To generate the ticket must cross the fields username (to identify the
host) and groupname (to identify the room) table radacct.

8 - The problem is that the field groupname table radacct always comes

Until now I had no idea to cross the information through the radacct table.

Thank you for your attention.

2013/4/4 Phil Mayers <p.mayers at>

> That's not how it works.
> Sql-group is a virtual attribute that only exists when you're checking it,
> and is multi-valued. You can't record it in accounting packets - that
> doesn't make sense.
> What you *can* do is copy a matching group to an attribute that is
> recorded in accounting, such as "Class". For example
> authorize {
> ...
> if (SQL-Group == foo) {
> update reply {
> Class := "sqlgroup=foo"
> }
> }
> ...
> }
> Geovanny Varela <geovarela at> wrote:
>>  Hi. I need the groupname field radacct table is informed. Configured in
>> Section Accounting_stat_query in File dialup.conf the groupname field
>> and value '% {SQL-Group}' according to information obtained on the
>> internet but got no success. I can appreciate a solution because of the
>> success of my project depends on this configuration.
>> Thank you.
>> Greetings from Brazil
>>  -
>> List info/subscribe/unsubscribe? See
> --
> Sent from my mobile device, please excuse brevity and typos.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the Freeradius-Users mailing list