[radius] Freeradius/MySql problem

[Radius]

Forcing to lower case is not the problem.

When a user logs in over our wholesale providers network
we need to deny UPPER case logins.

MySql does not care if it's upper or lower and they get authenticated

I want to just deny UPPER letter logins will be the easiest.

I have looked at the MySql table settings, and how they
say to change this, but it also says you do one thing wrong
you will corrupt the database. Don't want that.


Nick Marino wrote:

> Let me look at my files and find the exact entry.
>
> Nick Marino - IT Solutions
> ----- Original Message ----- From: "Radius" <radius at kingmanaz.net>
> To: "FreeRadius users mailing list" 
> <freeradius-users at lists.freeradius.org>
> Sent: Saturday, July 02, 2005 12:36 PM
> Subject: Re: [radius] Freeradius/MySql problem
>
>
>> In the radius.conf under lower_user & lower_pass
>>
>> I tried all three. before/after/no and they will still authenticate
>> all UPPER CASE.
>>
>> What other config file are you talking about?
>>
>> Thanks
>>
>> Nick Marino wrote:
>>
>>> In the config file you can set it to force all lower case.
>>>
>>> I had this problem and solved it by changing it in the config.
>>>
>>> Nick Marino - IT Solutions
>>> ----- Original Message ----- From: "Radius" <radius at kingmanaz.net>
>>> To: <freeradius-users at lists.freeradius.org>
>>> Sent: Saturday, July 02, 2005 12:10 PM
>>> Subject: [radius] Freeradius/MySql problem
>>>
>>>
>>>> I currently run ver.0.9.3
>>>>
>>>> I have MySql database that is used with FreeRadius.
>>>>
>>>> What were are having a problem with is that if the
>>>> user logs in with UPPER-NAME or lower-name
>>>> either one works.
>>>>
>>>> I have tried lower_user & lower_pass before/after/no
>>>> and the radius system still authenticates all UPPER-CASE.
>>>>
>>>> With this we are getting double billed by our wholesale
>>>> provider because they run unix based also and it sees
>>>> both as valid log ins because we authenticated them.
>>>>
>>>> When we built our MySql we use with the setup in FreeRadius.
>>>>
>>>> Has anyone else had this and how did you fix this to keep
>>>> everyone lower case.
>>>>
>>>> Thanks
>>>> Bob Ross
>>>>
>>>> - List info/subscribe/unsubscribe? See 
>>>> http://www.freeradius.org/list/users.html
>>>>
>>>>
>>>> -- 
>>>> No virus found in this incoming message.
>>>> Checked by AVG Anti-Virus.
>>>> Version: 7.0.323 / Virus Database: 267.8.8/37 - Release Date: 7/1/2005
>>>>
>>>>
>>>
>>>
>>>
>>
>> - List info/subscribe/unsubscribe? See 
>> http://www.freeradius.org/list/users.html
>>
>>
>> -- 
>> No virus found in this incoming message.
>> Checked by AVG Anti-Virus.
>> Version: 7.0.323 / Virus Database: 267.8.8/37 - Release Date: 7/1/2005
>>
>
>
>