The idea is to do IP-assignment based on the Calling-Station-ID and disregarding the username,password that is passed to radius. JOhn -----Original Message----- From: freeradius-users-bounces+jlongland=grintek.com@lists.freeradius.org [mailto:freeradius-users-bounces+jlongland=grintek.com@lists.freeradius. org]On Behalf Of Collen Blijenberg Sent: 09 November 2006 15:40 To: FreeRadius users mailing list Subject: Re: Assign IP based on CallingStationID. Hmm i tried this, but it ain't working.. ?! i have: id - 1 username - blah attribute - Calling-Stattion-Id op - == value - [mac adress] still get username ask ?! no connection. dunno, what's the idea behinf this query ? mac = username ? no username, auth is done true mac ? Cheers Collen John Longland wrote:
authorize_check_query = "select id,UserName,Attribute,Value,op FROM ${authcheck_table} WHERE UserName in (select UserName from ${authcheck_table} WHERE Value = '%{Calling-Station-ID}') ORDER BY id"
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html