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

Thu, 22 Dec 2005 05:48:53 -0800 

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:[EMAIL PROTECTED]
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to