Bind radius authentication with mac address?

[Yudi Wijaya]

Hello freeradius-users,

  so radius will check username, password and mac address from radius database

  as subject..
  I can't find any idea of this.. :(

  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"

  postauth_query = "UPDATE ${authcheck_table} set mac='%{Calling-Station-Id}'  WHERE Username = '%{SQL-User-Name}' and (mac='' or isnull(mac))"

  then add this to radreply table in radius database:
  UserName           Attribute          op           value
  hendy         Calling-Station-Id      =       00:0D:87:C7:13:81

  i use MikroTik and PPPoE


  then i try reconnect from different mac address with username: hendy
  but still connected :(

-- 
Best regards,
 Yudi