<html>
<head>
<style>
.sw_message P{margin:0px;padding:0px;}
.sw_message {FONT-SIZE: 12pt;FONT-FAMILY:Tahoma,Arial,Helvetica,sans-serif;background:white;}
.sw_message blockquote{margin-left:5px;padding-left:5px;border-left:2px solid #144fae;color: #144fae;}
.sw_message blockquote blockquote{border-left:2px solid #006312;color: #006312;}
.sw_message blockquote blockquote blockquote{border-left:2px solid #8e5656;color: #8e5656;}
.sw_message blockquote blockquote blockquote blockquote{border-left:2px solid #888;color: #888;}
</style>
</head>
<body class="sw_message">
<div>One more question (sorry)</div><div><br></div><div>As an example I use</div><div><br></div><div><br></div><div>---</div><div>/bin/echo "Acct-Session-Id='.$sess.'" | /usr/bin/radclient -x 127.0.0.1:3799 disconnect mypassword' </div><div>---</div><div> </div><div>Within the SQL you suggested</div><div><br></div><div>--</div><div><blockquote type="cite">Tmp-String-0 := "%{sql:<query>}"</blockquote><div>--</div><div>How can I access the <span style="font-size: 12pt;">Acct-Session-Id that is sent into freeradius ?</span></div><div><span style="font-size: 12pt;"><br></span></div><div><span style="font-size: 12pt;">ie so I can do something like </span></div><div><span style="font-size: 12pt;"><br></span></div><div><span style="font-size: 12pt;">Tmp-String-0 := "%{sql:<</span><span style="font-size: 12pt;">SELECT TOP 1 LNSIPAddress FROM radacct where </span><span style="font-size: 12pt;">Acct-Session-Id='x'</span><span style="font-size: 12pt;">}"</span></div><div><span style="font-size: 12pt;"><br></span></div><div><span style="font-size: 12pt;">Once I know this I think I can do the rest - If I am missing something obvious please point me in the right direction - the help so far has been very much appriciated</span></div><blockquote type="cite"></blockquote></div><div id="editor_signature"><div>-- </div><div>Richard Palmer | Director | Merula Limited</div><div><i>Company Registered in England and Wales No. 3243995</i></div><div>5 Avro Court, Huntingdon, Cambridgeshire, PE29 6XS</div><div>Phone 01480 222940 | Support 0845 330 0666</div><div>Support Email support@merula.net</div><br></div><div> </div><blockquote type="cite">--- Original message --- <br><b>Subject:</b> Re: coa / proxy question <br><b>From:</b> Arran Cudbard-Bell <a.cudbardb@freeradius.org> <br><b>To:</b> FreeRadius users mailing list <freeradius-users@lists.freeradius.org> <br><b>Date:</b> Thursday, 09/01/2014 10:06 AM<br><br><br>On 9 Jan 2014, at 09:03, Richard J Palmer <richard@merula.net> wrote:<br><br><blockquote type="cite"> OK I now have part one of this done - radacct now holds the LNS IP address thank you.<br> <br> I just want to clarify one small thing if I may ...<br> <br> With the CoA I currently have one CoA server enabled on port 3799 on the radius server. How should I forward the CoA to the LNS ? Do I setup 2 CoA servers either on different ports or IPs within FreeRadius and each send to a different LNS, or Can FreeRadius itself do a SQL query based on the AcctUniqueId and use that to get the IP to forward to ?<br></blockquote><br>Yes, that's the idea.<br><br>update control {<br> Tmp-String-0 := "%{sql:<query>}"<br>}<br><br>It'll use the value from the first column/row.<br><br>You'll have to use the IP address to set the realm to forward to.<br><br>-Arran<br><br>Arran Cudbard-Bell <a.cudbardb@freeradius.org><br>FreeRADIUS Development Team<br><br>FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2<br><br><br>-<br>List info/subscribe/unsubscribe? See <a target="_blank" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a><br></blockquote><br>
</body></html>