<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<BR> Guys;<BR>
<BR>
I really need some ideas here pls.<BR>
<BR>
Many thanks<BR>
<BR>
Lucio<BR>
<HR id=stopSpelling>
From: luciocfgodoy@hotmail.com<BR>To: freeradius-users@lists.freeradius.org<BR>Subject: How to strip REALM but insert it from a username@MAC onto an MySQL DB<BR>Date: Fri, 22 Jan 2010 14:28:50 +0000<BR><BR>
<STYLE>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Verdana;}
</STYLE>
Hi All;<BR> <BR>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.<BR> <BR>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.<BR> <BR>I would like to continue with the same authentication method by when the user is authenticating they will include their MAC address as such:<BR> <BR>username @ MAC_ADDRESS<BR> <BR>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.<BR> <BR>I have researched and have not found a way to implement this.<BR> <BR>Have any of you got any ideas how to implement this pls?<BR> <BR>Any help appreciated.<BR> <BR>Many thanks<BR> <BR>Lucio<BR> <BR>PS: Have not included any conf files as my FR is pretty much out of the box setup, but will happily do so.<BR> <BR> <BR><BR>
<HR>
Got a cool Hotmail story? <A href="http://clk.atdmt.com/UKM/go/195013117/direct/01/">Tell us now</A> <br /><hr />Got a cool Hotmail story? <a href='http://clk.atdmt.com/UKM/go/195013117/direct/01/' target='_new'>Tell us now</a></body>
</html>