Can't I change the way it's look into MySQL table? Even this comming
with User-Name I can't look for the value in another field? This is a
MySQL query, not the way it came... i hope... :)

    

You have three options:

- fill your database with (useless) data and try to change rlm_sql code
and queries in order to match up requests and data. Don't expect much
help there - if you want to customize the database you should know what
you are doing. It is quite likely that this will render that sql
instance (and possibly whole sql module) useless for any other request
apart form mac auth.

You will need to:

rewrite value of User-Name into Calling-Station-Id

pull new User-Name from the database (WHERE
Attribute='Calling-Sattion-Id' and Value='%{User-Name})

fix code in rlm_sql where this brakes it

or:

- authenticate with a special script (perl or such). Adjust queries for
this type of authentication as much as you like without affecting other
authentication types. You can use multiple queries to match up data and
request. Easier and more sensible than above.

or:

- fill your database with correct data - what you expect to come in
User-Name field should be used as UserName etc. No adjustments needed.
mac auth works together with other authentication types.

Take your pick.

Ivan Kalik
Kalik Informatika ISP

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

  

-- 
Att,

NATANIEL KLUG
nata@cnett.com.br

LEIA O DIA-A-DIA DO NATA
http://nataklug.blogspot.com/

Cyber Nett - Internet Banda Larga
www.cnett.com.br
(42) 3635-2957
Rua Diogo Pinto, 1046, Centro
Laranjeiras do Sul - PR
Brasil - 85301-290

"... também os sábios possuem coração tangível e podem, por vezes, usar da ciência como meio de demonstrar impressões sentimentais de que muitos não os julgam suscetíveis."
Visconde de Taunay