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

Yudi Wijaya <yudiw@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.