MAC-Auth + Freeradius + MySQL Database

[David Peterson]

I know of one person doing something similar to what you are looking to do.
If your NAS sends the MAC of the device with the EAP request, you can
extract the MAC from the request using unlang and check that against a
database of MACs.

 

No clue how to do this, I just know it can be done.


David

 

From:
freeradius-users-bounces+david.peterson=acc-corp.net at lists.freeradius.org
[mailto:freeradius-users-bounces+david.peterson=acc-corp.net at lists.freeradiu
s.org] On Behalf Of Russell Mike
Sent: Saturday, February 23, 2013 11:07 AM
To: FreeRadius users mailing list
Subject: MAC-Auth + Freeradius + MySQL Database

 

Greetings Dear Alan D. & List Members,

 

First of all, thank you very much for developing such application. I need
help, i have functional Freeradius server with MySQL backend. i have been
asked to add MAC address authentication support for the servers. i googled
the topic and got many many mail archive results, i tried to read those for
about a day before posting to the maling list. Most of them, administrators
are discussing troubleshoot topics, but i was searching how to.. start
implementation and the REQUIREMENTS. i also came across where guys are
discussing EAP and MAC authentication. i could not conclude, if it is a
better way of doing MAC authentication using EAP.

 

Finally, i came across wiki documentation. almost everything is there and it
is well explained as well, thanks.  i have now understand how it works. But
SQL part is not still a question. 

 

http://wiki.freeradius.org/guide/Mac-Auth#Mac-Auth-authorisation-by-SSID-SQL

 

How to store MACs in MySQL database. Perhaps, i need to create additional
table to store MAC, Honestly, i am not sure how to go about it. Is there any
documentation that i may do NOT know of. and i can follow to finish the
setup. 

 

Grate thanks for attending to this request and thanks for your support ever
since !

 

additional Information: FR_v2.2 With Coova 1.3.0

 

Regards -- RM

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130224/fccbf725/attachment.html>