Using username at and plain username

Kriston me at
Tue Sep 18 23:22:11 CEST 2012

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

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

I'm open to any and all comments.

Thank you.

More information about the Freeradius-Users mailing list