coa / proxy question

[Richard J Palmer]

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 at merula.net


> --- Original message ---
> Subject: Re: coa / proxy question
> From: Arran Cudbard-Bell <a.cudbardb at freeradius.org>
> To: FreeRadius users mailing list 
> <freeradius-users at lists.freeradius.org>
> Date: Thursday, 09/01/2014 10:06 AM
>
>
> On 9 Jan 2014, at 09:03, Richard J Palmer <richard at 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 at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140113/b0219467/attachment-0001.html>