Cisco-AVPair SQL accounting (attr. not duplicated)

[Nicolas Baradakis]

James Wakefield wrote:

> I've got an AS5300 that sends a few attributes, with accounting stop, 
> encapsulated in Cisco-AVPair eg: Cisco-AVPair = "nas-tx-speed=53300" and 
> the VSA hack doesn't appear to let me refer to that value in my SQL 
> statements with either the %{nas-tx-speed} or %{Cisco-AVPair[index]} 
> syntaxes I've seen suggested for Cisco VSAs in various places.  rlm_sql 
> complains of an unknown xlat function or non-existent attribute.
> 
> Has anyone managed to do this?  If so, what is the correct syntax to use 
> these in SQL accounting statements?

The syntax %{Cisco-AVPair[n]} isn't supported in versions 1.0.x of
FreeRADIUS. I'd suggest to get and try the CVS version which is about
to be 1.1.0 very soon.

$ cvs -d :pserver:anoncvs at cvs.freeradius.org:/source login
CVS password: anoncvs
$ cvs -d :pserver:anoncvs at cvs.freeradius.org:/source checkout -r branch_1_1 radiusd

-- 
Nicolas Baradakis