Duane Cox duanec at mail.illicom.net
Mon Aug 7 19:05:17 CEST 2006

not sure about mysql, but with mssql it's pretty easy...

just do something like this...

select id, lower('%{SQL-User-Name}'), ...
select id, upper(%{SQL-User-Name}'), ...

you will find something that works if you look hard enough...

----- Original Message ----- 
From: "Alan DeKok" <aland at deployingradius.com>
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Sent: Monday, August 07, 2006 10:14 AM
Subject: Re: sql.conf 

fvt3 <fvt3 at yahoo.com> wrote:
> How do you convert the SQL-User-Name sent to upper
> case? I have my mac address store in upper case but
> the client is sending its mac address in lower case. 

  You can't really.

  Why not do a case-insensitive match in SQL?

  Alan DeKok.
  http://deployingradius.com       - The web site of the book
  http://deployingradius.com/blog/ - The blog
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

More information about the Freeradius-Users mailing list