Help pls: How to strip REALM but insert it from a username at MAC onto an MySQL DB

[Lucio Godoy]

 Guys;

 

I really need some ideas here pls.

 

Many thanks

 

Lucio


From: luciocfgodoy at hotmail.com
To: freeradius-users at lists.freeradius.org
Subject: How to strip REALM but insert it from a username at MAC onto an MySQL DB
Date: Fri, 22 Jan 2010 14:28:50 +0000



Hi All;
 
I have been running a FreeRADIUS Server Version 2.1.6 setup to work with MySQL 5 to authenticate VPN Dial-up users with no problems at all.
 
My next step is to try to log the users realms, which is their MAC addresses, the authentication today is CHAP with a combination of username + password check on the mysql db.
 
I would like to continue with the same authentication method by when the user is authenticating they will include their MAC address as such:
 
username @ MAC_ADDRESS
 
Freeradius is to strip the MAC_ADDRESS, then insert onto the field "Realm" on the table "radacct" and then authenticate the user normally via the username+password combination.
 
I have researched and have not found a way to implement this.
 
Have any of you got any ideas how to implement this pls?
 
Any help appreciated.
 
Many thanks
 
Lucio
 
PS: Have not included any conf files as my FR is pretty much out of the box setup, but will happily do so.
 
 



Got a cool Hotmail story? Tell us now 		 	   		  
_________________________________________________________________
Got a cool Hotmail story? Tell us now
http://clk.atdmt.com/UKM/go/195013117/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100124/509d0de8/attachment.html>