Using username at and plain username

Arran Cudbard-Bell a.cudbardb at
Tue Sep 18 23:34:46 CEST 2012

On 18 Sep 2012, at 22:22, "Kriston" <me at> wrote:

> I have users who log in as "username at" and just as "username".
> How do I append only to those users who don't have
> already?  I have a fairly generic FreeRADIUS 2.1.10 installation that
> connects to a MySQL server.
> I've tried a number of different things in dialup.conf but none have worked.
> Example 1:
> sql_user_name = "{%{Stripped-User-Name}:-%{User-Name}}@{%{Realm}}"
> This results in a string in the SQL queries for User-Name that looks like
> "".

Look at all those lonely lonely left hand curly braces, don't you think they might appreciate another character to snuggle up to? What do you think that character might be?

> Example 2:
> I have also tried regular expressions like this:
>    if ( %{User-Name} !~ /.example\.com/i) {
>        sql_user_name = "%{User-Name}"
>    }
> But this one results in a blank string for in the SQL queries that use
> sql_user_name.
> I'm open to any and all comments.

Read man unlang, stop inventing syntax.


More information about the Freeradius-Users mailing list