Thanks for your responses.<div><br></div><div>I tried SQL XLAT yesterday but I had the next radiusd -X errors:</div><div><div><br></div><div>/usr/local/etc/raddb/sites-enabled/default[598]: Failed to parse &quot;if&quot; subsection.</div>
<div>/usr/local/etc/raddb/sites-enabled/default[485]: Errors parsing post-auth section. </div></div><div><br></div><div>I think it is not possible to that with SQL XLAT. Is it possible to store the return code of a sql query with SQL XLAT?</div>
<div><br></div><div>I&#39;ll try with sql.authorize.</div><div><br></div><div>Thanks.</div><div><br></div><div>Regards,</div><div>David<br><br><div class="gmail_quote">2010/11/23 EasyHorpak.com <span dir="ltr">&lt;<a href="mailto:info@easyhorpak.com">info@easyhorpak.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">


  

<div text="#000000" bgcolor="#ffffff"><div><div></div><div class="h5">
On 22/11/2553 22:41, David Seira wrote:
<blockquote type="cite">Hi Alan.
  <div><br>
  </div>
  <div>Thanks for your time.</div>
  <div><br>
  </div>
  <div>In the authorize section I have the next instructions for
authorize users in a mac file:</div>
  <div><br>
  </div>
  <div>
  <div><span style="white-space:pre-wrap"> </span>if((Service-Type
== &#39;Call-Check&#39;) || (User-Name =~ /^%{Calling-Station-Id}$/i)){</div>
  <div><span style="white-space:pre-wrap"> </span>update
control {</div>
  <div><span style="white-space:pre-wrap"> </span>Auth-Type
= &#39;CSID&#39;</div>
  <div><span style="white-space:pre-wrap"> </span>}</div>
  <div><span style="white-space:pre-wrap"> </span>}</div>
  <div><br>
  </div>
  <div>I don&#39;t know how to call the sql module for read the list users
from mysql. If I put in that section the sql instruction I don&#39;t know
how compare the sql results with the Calling-Station-Id that the NAS
return in the request.</div>
  <div><br>
  </div>
  <div>Another thing is that I don&#39;t know why the authorization is made
in post-auth section.</div>
  <div><br>
  </div>
  <div>Thanks for your help.</div>
  <div><br>
  </div>
  <div>Regards,</div>
  <div>David</div>
  <div><br>
  </div>
  <br>
  <div class="gmail_quote">2010/11/22 Alan DeKok <span dir="ltr">&lt;<a href="mailto:aland@deployingradius.com" target="_blank">aland@deployingradius.com</a>&gt;</span><br>
  <blockquote class="gmail_quote" style="border-left:1px solid rgb(204, 204, 204);margin:0pt 0pt 0pt 0.8ex;padding-left:1ex">
    <div>David Seira wrote:<br>
&gt; I don&#39;t know where put the sql instruction for read macs from
database.<br>
    <br>
    </div>
 Read raddb/sites-available/default.  Look for &quot;sql&quot;.<br>
    <font color="#888888"><br>
 Alan DeKok.<br>
-<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><br>
    </font></blockquote>
  </div>
  <br>
  </div>
  <pre><fieldset></fieldset>
-
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></div>
try <br>
&quot;%{sql: SELECT Value from radcheck WHERE Value=&#39;%{User-Name}&#39; and
Attribute=&#39;Cleartext-Password&#39;&quot;<br>
</div>


<br>-<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><br></blockquote></div><br></div>