<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Change sql_user_name = %{User-Name} to sql_user_name =
%{Stripped-User-Name} in dialup.conf<br>
<br>
Le 02.12.2008 06:37, Luca Adamo a écrit :
<blockquote cite="mid:B10C2756-F817-4BBE-91BB-89F609ADB946@hotmail.com"
type="cite">
<div><br>
</div>
<div>
<div style="">Thank you for the quick reply.
<div><br>
</div>
<div>I've tried this solution but the results are not what I
expected. </div>
<div><br>
</div>
<div>In fact i defined the following <i>realm </i>module:</div>
<div><br>
</div>
<div>
<div>realm wimax_decorator { </div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>format
= prefix </div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>delimiter
= "}" </div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>ignore_default
= no </div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>ignore_null
= no </div>
<div>}<span class="Apple-tab-span" style="white-space: pre;"> </span><br>
</div>
<div><br>
</div>
<div>and i make FR to call it during authorize phase.</div>
<div><br>
</div>
<div>The client show up with this NAI {<a moz-do-not-send="true"
href="mailto:am=1%7DutenteA@nap.com">am=1}utenteA@nap.com</a> and the
module output (from radiusd -X) is the following.</div>
<div><br>
</div>
<div>..</div>
<div>..</div>
<div>
<div>[wimax_decorator] Looking up realm "{am=1" for User-Name = "<a
moz-do-not-send="true" href="mailto:%7Bam=1%7DutenteA@nap.com">{am=1}utenteA@nap.com</a>";</div>
<div>[wimax_decorator] Found realm "DEFAULT"</div>
<div>[wimax_decorator] Adding Stripped-User-Name = "<a
moz-do-not-send="true" href="mailto:utenteA@nap.com">utenteA@nap.com</a>";</div>
<div>[wimax_decorator] Adding Realm = "DEFAULT"</div>
<div>[wimax_decorator] Authentication realm is LOCAL.</div>
<div>..</div>
<div>..</div>
<div><br>
</div>
<div><br>
</div>
<div>The problem is that all my subsequent queries suppose the
Attribute User-Name to be <i><a moz-do-not-send="true"
href="mailto:utenteA@nap.com">utenteA@nap.com</a> </i>instead of <i><a
moz-do-not-send="true" href="mailto:%7Bam=1%7DutenteA@nap.com">{am=1}utenteA@nap.com</a> </i>so
I keep getting <i>null </i>result set from the Oracle DB since there
aren't entries for {<span class="Apple-style-span"
style="font-style: italic;"><a moz-do-not-send="true"
href="mailto:am=1%7DutenteA@nap.com">am=1}utenteA@nap.com</a> </span>in
the DB. A possible solution could be making the sql module to use
Stripped-User-Name instead of the User-Name for the queries but I was
looking for a solution that doesn't involve the code.</div>
<div><br>
</div>
<div>Am i making any mistake above? Any other ideas?</div>
<div><br>
</div>
<div>Thank you,</div>
<div><br>
</div>
<div>Lu</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
<div>
<div>Il giorno 02/dic/08, alle ore 16:28, <a moz-do-not-send="true"
href="mailto:A.L.M.Buxey@lboro.ac.uk">A.L.M.Buxey@lboro.ac.uk</a> ha
scritto:</div>
<blockquote type="cite"><span class="Apple-style-span"
style="color: rgb(0, 0, 0);">1) set 'prefix' to be }<br>
<br>
with this, anything before and including }<br>
(which may never appear as a realm or username)<br>
would be treated like a NT domain and be stripped<br>
off logically</span></blockquote>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
<pre wrap="">
<hr size="4" width="90%">
-
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>
</body>
</html>