Mac Auth with MySQL

[Alan Buxey]

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