FreeRADIUS 3.0.12: SQL xlat return back-quoted value in response

Matthew Newton mcn4 at
Wed Dec 21 15:35:14 CET 2016

On Wed, Dec 21, 2016 at 02:57:25PM +0100, Alexey Dotsenko wrote:
> But my question relates to runtime attributes and modules expansion (xlat)
> in the sql check/reply tables.
> In FR 2.x this functionality was available. It could be possible to specify
> the attribute (`%{User-Name}` for example) or module (`%{sql:SELECT value
> FROM macfilter WHERE username=\'%{User-Name}\'}}` for example) in 'value'
> column of sql check/reply table. And these values was interpreted at run
> time - exactly the same as ulang rules in config files. Back-ticks in this
> case, provides an indication to xlat.
> In FR 3 this functionality was broken. And was corrected only in the version
> 3.0.12. But not completely - value after the expansion is returned enclosed
> in back-quotes.

If I understand what you are trying to do, you can use the %{xlat: } xlat.


Matthew Newton, Ph.D. <mcn4 at>

Systems Specialist, Infrastructure Services,
I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom

For IT help contact helpdesk extn. 2253, <ithelp at>

More information about the Freeradius-Users mailing list