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