<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns15="" xmlns:ns14="schemas-accessaccounts-com/lookup">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
p.section1, li.section1, div.section1
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>I am wondering if someone will be able to point me in the
correct direction with a setup I am trying to achieve. Basically we are rolling
out a new offering to our customers where we want to have our LAC’s query
our radius servers which will then proxy requests on to our customer’s
radius servers based on the domain used in the username. I have got all of the
proxy’ing working within radius – nice and easy following the wiki
and instructions - thanks.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>My problem is that the response I send to our LAC has to
contain extra information depending on the domain. Is it possible to query a
local mysql database for this extra information (these are cisco av pairs
needed to establish the tunnels between the LAC and LNS) and add it into the
Access-Accept message that is returned to the LAC from the radius?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>An example would of what I have at the moment is:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Sending Access-Accept of id 6 to xx.xx.xx.xx port 51274<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>
Framed-IP-Address = 192.168.0.1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> Service-Type =
Framed-User<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> Framed-Protocol
= PPP<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>
Framed-IP-Netmask = 255.255.255.255<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>
Tunnel-Server-Endpoint:0 = "yy.yy.yy.yy"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>And I need it contain 3 extra lines that would be stored
locally (in italics):<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Sending Access-Accept of id 6 to xx.xx.xx.xx port 51274<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>
Framed-IP-Address = 192.168.0.1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> Service-Type =
Framed-User<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> Framed-Protocol
= PPP<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>
Framed-IP-Netmask = 255.255.255.255<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> Tunnel-Server-Endpoint:0
= "yy.yy.yy.yy"<o:p></o:p></span></font></p>
<p class=MsoNormal><a name="OLE_LINK2"></a><a name="OLE_LINK1"><i><font size=2
face=Verdana><span style='font-size:10.0pt;font-family:Verdana;font-style:italic'>
</span></font></i></a><i><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;font-style:italic'>Tunnel-Type:0 =
L2TP<o:p></o:p></span></font></i></p>
<p class=MsoNormal><i><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana;font-style:italic'>
Tunnel-ID=DEFGH<o:p></o:p></span></font></i></p>
<p class=MsoNormal><i><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana;font-style:italic'> L2TP-Tunnel-Password=ABCDE"<o:p></o:p></span></font></i></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>This is currently running on FreeRADIUS Version 2.1.7. I
have read the documentation and the mailing lists but cant seem to find anyone
who has had to do a similar thing.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Kind Regards<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Dan Fisher<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#5f5f5f" face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:#5F5F5F'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Technical Manager<o:p></o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><span class=grame><b><i><font
size=1 color="#5f5f5f" face=Verdana><span style='font-size:8.0pt;font-family:
Verdana;color:#5F5F5F;font-weight:bold;font-style:italic'>get</span></font></i></b></span><b><i><font
size=1 color="#5f5f5f" face=Verdana><span style='font-size:8.0pt;font-family:
Verdana;color:#5F5F5F;font-weight:bold;font-style:italic'> your data flowing
…<o:p></o:p></span></font></i></b></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF'><o:p> </o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><b><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF;font-weight:bold'>DDI: </span></font></b><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF'>020 7099 8985<o:p></o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF'><o:p> </o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><b><font size=1
color="#0589bf" face=Verdana><span lang=FR style='font-size:8.0pt;font-family:
Verdana;color:#0589BF;font-weight:bold'>Tel:</span></font></b><font size=1
color="#0589bf" face=Verdana><span lang=FR style='font-size:8.0pt;font-family:
Verdana;color:#0589BF'> 0845 868 7848</span></font><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF'><o:p></o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><b><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF;font-weight:bold'>Fax:</span></font></b><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF'> 0845 868 7858<o:p></o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF'><o:p> </o:p></span></font></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><b><font size=1
color="#0589bf" face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
color:#0589BF;font-weight:bold'><a href="mailto:danfisher@fluidata.co.uk"><font
color="#0589bf" face="Times New Roman"><span style='font-family:"Times New Roman";
color:#0589BF'>danfisher@fluidata.co.uk</span></font></a><o:p></o:p></span></font></b></p>
<p class=section1 style='margin:0cm;margin-bottom:.0001pt'><font size=3
color="#0589bf" face="Times New Roman"><span style='font-size:12.0pt;
color:#0589BF'><a href="http://www.fluidata.co.uk/"
title="http://www.fluidata.co.uk/"><b><font size=1 color="#0589bf"><span
lang=FR style='font-size:8.0pt;color:#0589BF;font-weight:bold'><span
title="http://www.fluidata.co.uk/"><span title="http://www.fluidata.co.uk/"><span
title="http://www.fluidata.co.uk/">www.fluidata.co.uk</span></span></span></font></span></b></a></span></font><b><font
size=1 color="#0589bf"><span lang=FR style='font-size:8.0pt;color:#0589BF;
font-weight:bold'><o:p></o:p></span></font></b></p>
<p class=section1 style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
6.0pt;margin-left:0cm'><font size=1 color="#333333" face=Verdana><span
style='font-size:8.0pt;font-family:Verdana;color:#333333'><o:p> </o:p></span></font></p>
<p class=section1 style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
6.0pt;margin-left:0cm'><font size=1 color=black face=Verdana><span
style='font-size:7.5pt;font-family:Verdana;color:black'>This mes</span></font><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'><ns14:T14
w:insAuthor="Dan Fisher" w:insDate="2009-11-18T11:45:00Z"
w:endInsAuthor="Dan Fisher" w:endInsDate="2009-11-18T11:45:00Z"
ns15:WField="USER_ID" ns15:DField="USER_ID" ns15:Value="'SA'" ns15:User="1"><font
color=black><span style='color:black'>sa</span></font></ns14:T14><font
color=black><span style='color:black'>ge is intended solely for the use of the
individual or organi</span></font><ns14:T14 w:insAuthor="Dan Fisher"
w:insDate="2009-11-18T11:45:00Z" w:endInsAuthor="Dan Fisher"
w:endInsDate="2009-11-18T11:45:00Z" ns15:WField="USER_ID" ns15:DField="USER_ID"
ns15:Value="'SA'" ns15:User="1"><font color=black><span style='color:black'>sa</span></font></ns14:T14><font
color=black><span style='color:black'>tion to <span class=grame>whom</span> it
is </span></font><ns14:T14 w:insAuthor="Dan Fisher"
w:insDate="2009-11-18T11:45:00Z" w:endInsAuthor="Dan Fisher"
w:endInsDate="2009-11-18T11:45:00Z" ns15:WField="USER_ID" ns15:DField="USER_ID"
ns15:Value="'AD'" ns15:User="1"><font color=black><span style='color:black'>ad</span></font></ns14:T14><font
color=black><span style='color:black'>dressed. It may contain privileged or
confidential information. If you have received this mes</span></font><ns14:T14
w:insAuthor="Dan Fisher" w:insDate="2009-11-18T11:45:00Z"
w:endInsAuthor="Dan Fisher" w:endInsDate="2009-11-18T11:45:00Z"
ns15:WField="USER_ID" ns15:DField="USER_ID" ns15:Value="'SA'" ns15:User="1"><font
color=black><span style='color:black'>sa</span></font></ns14:T14><font
color=black><span style='color:black'>ge in error, please notify the originator
immediately. If you are not the intended recipient, you should not use, copy,
alter, or disclose the contents of this mes</span></font><ns14:T14
w:insAuthor="Dan Fisher" w:insDate="2009-11-18T11:45:00Z"
w:endInsAuthor="Dan Fisher" w:endInsDate="2009-11-18T11:45:00Z"
ns15:WField="USER_ID" ns15:DField="USER_ID" ns15:Value="'SA'" ns15:User="1"><font
color=black><span style='color:black'>sa</span></font></ns14:T14><font
color=black><span style='color:black'>ge. All information or opinions expressed
in this mes</span></font><ns14:T14 w:insAuthor="Dan Fisher"
w:insDate="2009-11-18T11:45:00Z" w:endInsAuthor="Dan Fisher"
w:endInsDate="2009-11-18T11:45:00Z" ns15:WField="USER_ID" ns15:DField="USER_ID"
ns15:Value="'SA'" ns15:User="1"><font color=black><span style='color:black'>sa</span></font></ns14:T14><font
color=black><span style='color:black'>ge and/or any attachments are those of
the author and are not neces</span></font><ns14:T14 w:insAuthor="Dan Fisher"
w:insDate="2009-11-18T11:45:00Z" w:endInsAuthor="Dan Fisher"
w:endInsDate="2009-11-18T11:45:00Z" ns15:WField="USER_ID" ns15:DField="USER_ID"
ns15:Value="'SA'" ns15:User="1"><font color=black><span style='color:black'>sa</span></font></ns14:T14><font
color=black><span style='color:black'>rily those of </span></font><span
class=spelle><ns14:T2 w:insAuthor="Dan Fisher" w:insDate="2009-11-18T11:45:00Z"
w:endInsAuthor="Dan Fisher" w:endInsDate="2009-11-18T11:45:00Z"
ns15:WField="SUCODE" ns15:DField="SUCODE" ns15:Value="'FLUIDATA-1'"
ns15:User="1"><ns14:T1 w:insAuthor="Dan Fisher" w:insDate="2009-11-18T11:45:00Z"
w:endInsAuthor="Dan Fisher" w:endInsDate="2009-11-18T11:45:00Z"
ns15:WField="CUCODE" ns15:DField="CUCODE" ns15:Value="'FLU010'" ns15:User="1"><ns14:T14
w:insAuthor="Dan Fisher" w:insDate="2009-11-18T11:45:00Z"
w:endInsAuthor="Dan Fisher" w:endInsDate="2009-11-18T11:45:00Z"
ns15:WField="USER_ID" ns15:DField="USER_ID" ns15:Value="'MSTR'" ns15:User="1"><font
color=black><span style='color:black'>Fluidata</span></font></ns14:T14><font
color=black><span style='color:black'> Ltd</span></font></ns14:T1></ns14:T2></span><font
color=black><span style='color:black'>. <span class=spelle>Fluidata</span> </span></font><ns14:T14
w:insAuthor="Dan Fisher" w:insDate="2009-11-18T11:45:00Z"
w:endInsAuthor="Dan Fisher" w:endInsDate="2009-11-18T11:45:00Z"
ns15:WField="USER_ID" ns15:DField="USER_ID" ns15:Value="'ACC'" ns15:User="1"><font
color=black><span style='color:black'>acc</span></font></ns14:T14><font
color=black><span style='color:black'>epts no responsibility for loss or damage
arising from its use, including damage from virus.</span></font></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</span></div>
</body>
</html>