not sure about mysql, but with mssql it's pretty easy...
just do something like this...
select id, lower('%{SQL-User-Name}'), ...
or
select id, upper(%{SQL-User-Name}'), ...
you will find something that works if you look hard enough...
----- Original Message -----
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list" <[email protected]>
Sent: Monday, August 07, 2006 10:14 AM
Subject: Re: sql.conf
fvt3 <[EMAIL PROTECTED]> 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
