I tried the case sensitive attributes in the sql.conf but that didn't help.
Looks as if it's going to be in MySql that I'll have to have set.
That is not going to be fun at all.
Nick Marino wrote:
This is what I have and it works.
Also there are some options in the sql.conf that relate to this make
sure you have the right lines uncommented in there.
Open sql.conf and search for lower.
Are you sure their is not something in your realms section overriding
this?
# This is as close as we can get to case insensitivity. It is
# the admin's job to ensure that the username on the auth
# db side is *also* lowercase to make this work
#
# Default is 'no' (don't lowercase values)
# Valid values = "before" / "after" / "no"
#
lower_user = before
lower_pass = before
Nick Marino - IT Solutions
----- Original Message ----- From: "Radius" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
<freeradius-users@lists.freeradius.org>
Sent: Saturday, July 02, 2005 12:42 PM
Subject: Re: [radius] Freeradius/MySql problem
OK, let me try this way, when our wholesale provider receives a
realm, they know where
to send the request.
If the user sends [EMAIL PROTECTED] or [EMAIL PROTECTED]
our radius regardless if I have lower_user before/after/no
They will be authenticated either way.
If we force it lower on our end, does not force lower on their end.
It's a mess. They said only this month they were going to issue credits
and that I needed to get my end to deny UPPER case logins.
I set the lower_user lower and lower_pass to no and a user will
all [EMAIL PROTECTED] will be authenticated. I guess mysql
doesn't care if it's upper or lower.
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" <[EMAIL PROTECTED]>
To: <freeradius-users@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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
