RE: Assign IP based on CallingStationID.

2006-11-09 Thread John Longland
Title: RE: Assign IP based on CallingStationID. 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]. org]On Behalf Of Collen

Re: Assign IP based on CallingStationID.

2006-11-09 Thread Collen Blijenberg
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

Re: Assign IP based on CallingStationID.

2006-11-09 Thread banga
e query >> > that I am using may or may not work. If you want I can give you the >> > one that works for me if you supply your table-layout. >> > >> > JOhn >> > P.S> The statement I use does NOT check username/password !!! >> > >> >

RE: Assign IP based on CallingStationID.

2006-11-09 Thread banga
; From: > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > org]On Behalf Of banga > Sent: 08 November 2006 15:14 > To: freeradius-users@lists.freeradius.org > Subject: Assign IP based on CallingStationID. > > > > I use dafault table-layout. > How I understand y

RE: Assign IP based on CallingStationID.

2006-11-09 Thread John Longland
Title: RE: Assign IP based on CallingStationID. Here is the query that I put into sql.conf Maybe use it and build on it for your specific example ?? authorize_check_query = "select id,UserName,Attribute,Value,op FROM ${authcheck_table} WHERE UserName in (select UserName

Re: Assign IP based on CallingStationID.

2006-11-09 Thread Peter Nixon
the > > one that works for me if you supply your table-layout. > > > > JOhn > > P.S> The statement I use does NOT check username/password !!! > > > > -Original Message- > > From: > > [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > or

RE: Assign IP based on CallingStationID.

2006-11-09 Thread banga
JOhn > P.S> The statement I use does NOT check username/password !!! > > -Original Message- > From: > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > org]On Behalf Of banga > Sent: 08 November 2006 11:37 > To: freeradius-users@lists.freeradius.org > Subjec

Assign IP based on CallingStationID.

2006-11-08 Thread banga
> P.S> The statement I use does NOT check username/password !!! > > -Original Message- > From: > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > org]On Behalf Of banga > Sent: 08 November 2006 11:37 > To: freeradius-users@lists.freeradius.org > Subject: Assign I

RE: Assign IP based on CallingStationID.

2006-11-08 Thread John Longland
Title: RE: Assign IP based on CallingStationID. Yes, I have just done it. You need to change the sql-statement in /etc/raddb/sql.conf That is the autorize_check_query.Depending on how you use your tables, the query that I am using may or may not work. If you want I can give you the one

Assign IP based on CallingStationID.

2006-11-08 Thread banga
in context: http://www.nabble.com/Assign-IP-based-on-CallingStationID.-tf2594146.html#a7235317 Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html