Re: Bind radius authentication with mac address? so radius will check username, password and mac address from radius database

[Alan DeKok]

Yudi Wijaya <[EMAIL PROTECTED]> wrote:
>   I already set up this in sql.conf
>   
>   authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM 
> ${authcheck_table} WHERE STRCMP(Username, '%{SQL-User-Name}') = 0 and 
> (mac='%{Calling-Station-Id}' or isnull(mac) or mac='') ORDER BY id"

  Huh?  You have a field in SQL called "mac"?

  I think you're very confused about what the SQL server is doing.

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