Cisco-AVPair SQL accounting (attr. not duplicated)

James Wakefield (Sunet Sysadmin) sysadmin at sunet.com.au
Thu Dec 15 07:21:32 CET 2005


G'day,

Sorry if this has been covered already, as I imagine it's a common 
issue, but I haven't been able to rustle any working answers up after a 
long time googling and grepping $FR/src.

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?

Cheers,

-- 
James Wakefield
Systems Administrator
+61 03 5227 6888

We have now moved head office to 8-12 Pakington Street,
Geelong West.




More information about the Freeradius-Users mailing list