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
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
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
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 =
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
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
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
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
8 matches
Mail list logo