RE: Assign IP based on CallingStationID.

2006-11-09 Thread banga
I use dafault table-layout. How I understand you just change username authentication to callingstationid authentication inside sql.conf. Thx, it’s really good idea. I think that I could do the same by myself, but it will take a time. Therefore any examples will be very useful. Can you post it

Re: Assign IP based on CallingStationID.

2006-11-09 Thread Peter Nixon
Hi Banga We have a large system in production that does almost exactly what you state. It can all be done with a few modifications of the sql queries. (Infact we have a rather complex postgresql stored procedure, but one simpler query is possible depending on what you need). If you wish to

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 from

RE: Assign IP based on CallingStationID.

2006-11-09 Thread banga
John , I see the way now. Thx, for help. I’m going to install test radius in nearest future. I’ll try to check this query there. John Longland wrote: Here is the query that I put into sql.conf Maybe use it and build on it for your specific example ?? authorize_check_query =

Re: Assign IP based on CallingStationID.

2006-11-09 Thread banga
Thx Peter, I will try to install 1.1.3 to check sqlippool functions. Peter Nixonn wrote: Hi Banga We have a large system in production that does almost exactly what you state. It can all be done with a few modifications of the sql queries. (Infact we have a rather complex postgresql

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 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-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