Use stripped username in SQL

Matthew Newton mcn4 at
Sat May 28 21:59:59 CEST 2016

On Sat, May 28, 2016 at 09:50:29PM +0200, Tornoci Laszlo wrote:
> I am using ldap for authentication, and sql for adding dynamic VLAN IDs. For
> ldap, the domain is stripped, and the Stripped-User-Name is used for the
> lookup. However, when the the SQL-User-Name is generated, the domain is
> added back. I'd like to use the Stripped-User-Name for the SQL lookups as
> well (in the radusergroup table). How should I do that? I have 3.0.11.

See raddb/mods-config/sql/main/*/queries.conf option
"sql_user_name". There's a comment with the example you want.


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