<div dir="ltr"><div>Well, not quite understand your explanation.</div><div>I am not an expert in FreeRadius.</div><div>Let me explain my scenario:</div><div><br></div><div>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.</div>
<div> </div><div>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.</div><div><br></div><div>3 - After that the room number is entered in the table radgroupreply groupname.</div>
<div><br></div><div>4 - the next step the host name is entered in the username field radusergroup table and room number on the field groupname.</div><div><br></div><div>5 - After these operations is done in a select radacct table to collect accounting data.</div>
<div><br></div><div>6 - My software generates a ticket to the billing.</div><div><br></div><div>7 - To generate the ticket must cross the fields username (to identify the host) and groupname (to identify the room) table radacct.</div>
<div><br></div><div>8 - The problem is that the field groupname table radacct always comes empty.</div><div><br></div><div>Until now I had no idea to cross the information through the radacct table.</div><div><br></div><div>
Thank you for your attention. <br></div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><img src="http://img138.imageshack.us/img138/2822/assinaturageoemail.png"><img><br><br></div></div>
<br><br><div class="gmail_quote">2013/4/4 Phil Mayers <span dir="ltr"><<a href="mailto:p.mayers@imperial.ac.uk" target="_blank">p.mayers@imperial.ac.uk</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>That's not how it works.<br>
<br>
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.<br>
<br>
What you *can* do is copy a matching group to an attribute that is recorded in accounting, such as "Class". For example<br>
<br>
authorize {<br>
...<br>
if (SQL-Group == foo) {<br>
update reply {<br>
Class := "sqlgroup=foo"<br>
}<br>
}<br>
...<br>
}<br><br><div class="gmail_quote">Geovanny Varela <<a href="mailto:geovarela@gmail.com" target="_blank">geovarela@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div><div class="h5">
<div dir="ltr"><div>Hi. I need the <span style="background-color:yellow">groupname</span> field <span style="background-color:yellow">radacct</span> table is informed. Configured in Section Accounting_stat_query in File <span style="background-color:yellow">dialup</span>.<span style="background-color:yellow">conf</span> the <span style="background-color:yellow">groupname</span> field and value '% {<span style="background-color:yellow">SQL</span>-Group}' according to information obtained on the <span style="background-color:yellow">internet</span> but got no success. I can appreciate a solution because of the success of my project depends on this configuration. </div>
<div>Thank you.<br></div><div><br></div><div>Greetings from Brazil<br></div><br clear="all"><div><div dir="ltr"><img><img><br><br></div></div>
</div>
<p style="margin-top:2.5em;margin-bottom:1em;border-bottom:1px solid #000"></p></div></div><pre style="white-space:pre-wrap;word-wrap:break-word;font-family:sans-serif;margin-top:0px">-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a></pre>
</blockquote></div><span class="HOEnZb"><font color="#888888"><br>
-- <br>
Sent from my mobile device, please excuse brevity and typos.</font></span></div></div></blockquote></div><br></div>