One more question (sorry) As an example I use --- /bin/echo "Acct-Session-Id='.$sess.'" | /usr/bin/radclient -x 127.0.0.1:3799 disconnect mypassword' --- Within the SQL you suggested --
Tmp-String-0 := "%{sql:<query>}"
-- How can I access the Acct-Session-Id that is sent into freeradius ? ie so I can do something like Tmp-String-0 := "%{sql:<SELECT TOP 1 LNSIPAddress FROM radacct where Acct-Session-Id='x'}" 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 -- Richard Palmer | Director | Merula Limited Company Registered in England and Wales No. 3243995 5 Avro Court, Huntingdon, Cambridgeshire, PE29 6XS Phone 01480 222940 | Support 0845 330 0666 Support Email support@merula.net
--- Original message --- Subject: Re: coa / proxy question From: Arran Cudbard-Bell <a.cudbardb@freeradius.org> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Date: Thursday, 09/01/2014 10:06 AM
On 9 Jan 2014, at 09:03, Richard J Palmer <richard@merula.net> wrote:
OK I now have part one of this done - radacct now holds the LNS IP address thank you.
I just want to clarify one small thing if I may ...
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 ?
Yes, that's the idea.
update control { Tmp-String-0 := "%{sql:<query>}" }
It'll use the value from the first column/row.
You'll have to use the IP address to set the realm to forward to.
-Arran
Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team
FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html