-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday 13 February 2004 19:03, sarky wrote: > Hello all > Well i have asked this question before now i have edited sql.conf and > hashed the lines below in the other way 2 and the system still doesnt check > case sensitive anyone know any solution to double login?
What version of mysql are you using? Read http://www.mysql.com/doc/en/String_comparison_functions.html If MySQL 4, I would change your strcmp command to be: STRCMP(Username, BINARY '%{SQL-User-Name}') This should force users to login with the exact case of the username you've entered into your database tables. If you're still stuck, run the query in the mysql command line and tweak it until it works. Reading documentation is also recommended. Kevin Bonner -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAL/HJ/9i/ml3OBYMRAmeOAJ9ImP/eEqiJhpPEBirTQZ33A/Y/hwCeKSvu YC5AjKINn4aLdJ817QXQzJs= =prBw -----END PGP SIGNATURE----- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
