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 groupname.

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 empty.

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@imperial.ac.uk>
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@gmail.com> 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 http://www.freeradius.org/list/users.html

--
Sent from my mobile device, please excuse brevity and typos.