Hello Ray -
At 15:27 +1100 20/12/00, Raymond Brighenti wrote:
>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?
>
You can also use RewriteUsername.
regards
Hugh
--
NB: I am travelling this week, so there may be delays in our correspondence.
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.
