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.