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

[Phil Mayers]

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.