<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<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>Yes, I have just done it.</FONT>
</P>
<P><FONT SIZE=2>You need to change the sql-statement in /etc/raddb/sql.conf</FONT>
</P>
<P><FONT SIZE=2>That is the </FONT>
<BR><FONT SIZE=2>autorize_check_query.Depending on how you use your tables, the query</FONT>
<BR><FONT SIZE=2>that I am using may or may not work. If you want I can give you the</FONT>
<BR><FONT SIZE=2>one that works for me if you supply your table-layout.</FONT>
</P>
<P><FONT SIZE=2>JOhn</FONT>
<BR><FONT SIZE=2>P.S> The statement I use does NOT check username/password !!!</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 banga</FONT>
<BR><FONT SIZE=2>Sent: 08 November 2006 11:37</FONT>
<BR><FONT SIZE=2>To: freeradius-users@lists.freeradius.org</FONT>
<BR><FONT SIZE=2>Subject: Assign IP based on CallingStationID.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Hello all.</FONT>
<BR><FONT SIZE=2>I use freeradius ver. 1.1.1 + mysql.</FONT>
<BR><FONT SIZE=2>I use same login/password for couple of users but they has different</FONT>
<BR><FONT SIZE=2>callingstationid. </FONT>
<BR><FONT SIZE=2>Is it possible to check callingstationid and asiighn IP based on it? </FONT>
<BR><FONT SIZE=2>Do I need to create some additional tables in mysql for that?</FONT>
</P>
<P><FONT SIZE=2>Thx.</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>View this message in context: <A HREF="http://www.nabble.com/Assign-IP-based-on-CallingStationID.-tf2594146.html#a7235317" TARGET="_blank">http://www.nabble.com/Assign-IP-based-on-CallingStationID.-tf2594146.html#a7235317</A></FONT>
<BR><FONT SIZE=2>Sent from the FreeRadius - User mailing list archive at Nabble.com.</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>