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.may...@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 <geovar...@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. >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html