Hi,
I'll try to make Mac Authentication with MySQL backend. But I always rejected. Mac Authentication only works if I add like the following lines into the /etc/raddb/users.
90:4 C: E5: 6C: 7E: B6 Auth-Type: = Accept
I use OpenBSD 4.6, FreeRadius 2.1.3 and MySQL 5.0.83. What should I do, to make it work with MySQL ?
very easy. just set the username to the MAC address and set the value of the clear text password to be the MAC address to. i dont know WHY you've set the value to 'testpwd' - when you use MAC authentication, then the password is the MAC. ie
Database changed mysql> select * from radcheck; +----+-------------------+-----------+----+---------+ | id | username | attribute | op | value | +----+-------------------+-----------+----+---------+ | 2 | 90:4C:E5:6C:7E:B6 | Password | == | testpwd | +----+-------------------+-----------+----+---------+
nope. use this id username attribute op value 10 90:4C:E5:6C:7E:B6 Cleartext-Password := 90:4C:E5:6C:7E:B6
Tue Mar 16 00:40:41 2010 : Debug: WARNING: Are you sure you don't mean Cleartext-Password?
see that hint? if your kit doesnt transmit the correct details in the RADIUS - ie it doesnt transmit the MAC as the password, then you'll have to set the Accept..but that can also be done in the SQL! eg id username attribute op value 11 90:4C:E5:6C:7E:B6 Auth-Type := Accept alan