Hi all,
One thing I noticed about using Mysql for Auth is that by default it's case
insensitive and ignores trailing spaces, so users were getting in with the
following usernames
"usernames" (as they should :)
"usernames "
"UserNames "
So to fix this I found the following from the Mysql lists
AuthSelect select ENCRYPTEDPASSWORD from SUBSCRIBERS where USERNAME REGEXP
'^%n$';
It's doing what I want from the few tests I've done.
Does anyone know of a better way to do this or are there any gotchas with
this method?
Ta
Ray
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
