SQL-User-Name in %{sql:..} expansion

Phil Mayers p.mayers at imperial.ac.uk
Wed May 18 13:05:37 CEST 2016

On 18/05/16 11:51, Jakob Hirsch wrote:
> Hi,
> I am currently in the process of migrating our 2.2.9 setup to 3.0.11
> and, naturally, stumbled over a few things (i.e. more messages will follow).
> It seems that SQL-User-Name is not usable in expansions any more, only
> when calling the module (we use authorize_check_query and
> authorize_reply_query).

Yeah, we ran into that. Annoying.

I did this at the top-level of radiusd.conf:

sqlusername = "%{%{Stripped-User-Name}:-%{User-Name}}"

...and then did this everywhere:

update {
   blah = "${sqlusername}"

...to save on typing.

More information about the Freeradius-Users mailing list