how to log username in uppercase in radacct

Nicolas Baradakis nbk at
Fri Feb 3 15:51:23 CET 2006

baynaa at wrote:

> Can anyone tell me how I can configure radius so that Username field is
> logged in uppercase for all records in RadAcct table.

Please no HTML to the list.

You could change the queries in /etc/raddb/sql.conf to use the UPPER()

For example:

accounting_start_query = "INSERT into radacct (UserName, ... ) values (UPPER('%{SQL-User-Name}'), ... );"

Nicolas Baradakis

More information about the Freeradius-Users mailing list