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

[Yudi Wijaya]

Hello FreeRadius,

  as subject..
  I don't find any clue of this.. even with google :(

  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                          mailto:yudiw at centrin.net.id