<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2658.24">
<TITLE>RE: Assign IP based on CallingStationID.</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>The idea is to do IP-assignment based on the</FONT>
<BR><FONT SIZE=2>Calling-Station-ID and disregarding the </FONT>
<BR><FONT SIZE=2>username,password that is passed to radius.</FONT>
</P>
<P><FONT SIZE=2>JOhn</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From:</FONT>
<BR><FONT SIZE=2>freeradius-users-bounces+jlongland=grintek.com@lists.freeradius.org</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:freeradius-users-bounces+jlongland=grintek.com@lists.freeradius">mailto:freeradius-users-bounces+jlongland=grintek.com@lists.freeradius</A>.</FONT>
<BR><FONT SIZE=2>org]On Behalf Of Collen Blijenberg</FONT>
<BR><FONT SIZE=2>Sent: 09 November 2006 15:40</FONT>
<BR><FONT SIZE=2>To: FreeRadius users mailing list</FONT>
<BR><FONT SIZE=2>Subject: Re: Assign IP based on CallingStationID.</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hmm i tried this, but it ain't working.. ?!</FONT>
</P>
<P><FONT SIZE=2>i have:</FONT>
</P>
<P><FONT SIZE=2>id - 1</FONT>
<BR><FONT SIZE=2>username - blah</FONT>
<BR><FONT SIZE=2>attribute - Calling-Stattion-Id</FONT>
<BR><FONT SIZE=2>op - ==</FONT>
<BR><FONT SIZE=2>value - [mac adress]</FONT>
</P>
<P><FONT SIZE=2>still get username ask ?!</FONT>
<BR><FONT SIZE=2>no connection.</FONT>
</P>
<P><FONT SIZE=2>dunno, what's the idea behinf this query ?</FONT>
<BR><FONT SIZE=2>mac = username ?</FONT>
<BR><FONT SIZE=2>no username, auth is done true mac ?</FONT>
</P>
<P><FONT SIZE=2>Cheers</FONT>
</P>
<P><FONT SIZE=2>Collen</FONT>
</P>
<P><FONT SIZE=2>John Longland wrote:</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> authorize_check_query = "select id,UserName,Attribute,Value,op FROM</FONT>
<BR><FONT SIZE=2>> ${authcheck_table} WHERE UserName in</FONT>
<BR><FONT SIZE=2>> (select UserName from ${authcheck_table} WHERE Value = </FONT>
<BR><FONT SIZE=2>> '%{Calling-Station-ID}')</FONT>
<BR><FONT SIZE=2>> ORDER BY id"</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>></FONT>
</P>
<P><FONT SIZE=2>- </FONT>
<BR><FONT SIZE=2>List info/subscribe/unsubscribe? See <A HREF="http://www.freeradius.org/list/users.html" TARGET="_blank">http://www.freeradius.org/list/users.html</A></FONT>
</P>
</BODY>
</HTML>