MySQL Collation and Multiple Login Possibility Help
d88pak at gmail.com
Mon Jul 11 12:16:49 CEST 2011
This is a chilli+FR implementation and running well.
Today by accident, I found out that multiple login is possible for the
Although Attribute (User-Password) is treated case-sensitive,
'username' is not during authentication.
To further clarify:
Original Account created
username = ABCDE
User-Password := 123456
Simultaneous-Use := 1
but found out that
are all valid login.
OS: CentOS 5.5
DB: MySQL 5.5
FR: 2.1.17 (pacakged with CentOS)
It seems like it has more to do with MySQL query. Quick googling
revealed that query needs explicit COLLATE command to make the search
case-sensitive for non-binary text.
But I don't know where in FR i can modify this query.
Can somebody show me the right direction?
I am not sure if this has been fixed for newer FR versions.
More information about the Freeradius-Users