<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=TIS-620" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
On 22/11/2553 22:41, David Seira wrote:
<blockquote
cite="mid:AANLkTinH9acDDpHsm4jmGu0tq3EB11xr8EGJh-nC_3_4@mail.gmail.com"
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 class="Apple-tab-span" style="white-space: pre;"> </span>if((Service-Type
== 'Call-Check') || (User-Name =~ /^%{Calling-Station-Id}$/i)){</div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>update
control {</div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>Auth-Type
= 'CSID'</div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div><br>
</div>
<div>I don'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'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'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"><<a
moz-do-not-send="true" href="mailto:aland@deployingradius.com">aland@deployingradius.com</a>></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 class="im">David Seira wrote:<br>
> I don't know where put the sql instruction for read macs from
database.<br>
<br>
</div>
Read raddb/sites-available/default. Look for "sql".<br>
<font color="#888888"><br>
Alan DeKok.<br>
-<br>
List info/subscribe/unsubscribe? See <a moz-do-not-send="true"
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 wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></pre>
</blockquote>
try <br>
"%{sql: SELECT Value from radcheck WHERE Value='%{User-Name}' and
Attribute='Cleartext-Password'"<br>
</body>
</html>