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

[Alan DeKok]

Yudi Wijaya <yudiw at centrin.net.id> 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.