[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss] Case problems during checikng mailbox
From: |
Chris Lightfoot |
Subject: |
Re: [tpop3d-discuss] Case problems during checikng mailbox |
Date: |
Wed, 8 Jan 2003 17:55:07 +0000 |
User-agent: |
Mutt/1.3.24i |
On Wed, Jan 08, 2003 at 06:42:31PM +0100, Wiktor Zgodziñski wrote:
> I'm using tpop3d 1.4.2 with auth_mysql and with my own db. All is fine,
> but today I notice following problem.
>
> If user give his account name in different case ex:
> address@hidden (spool dir for him is called
> /var/spool/mail/domain.com/john.simith) tpop3d log him in, but saying
> that there is no message for user. Of course there are few message and
> if user logs as address@hidden he gets his messages.
>
> What should I fix to resolve this problem. May be I didn't read
> documentation carefully. ? Just tell me that.
Your database is doing a case-insensitive compare. Cf.
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
Two obvious fixes: either do a case-sensitive compare on
username, or cast the results through lcase(). See the
MySQL manual for more on this.
--
``Fog In Channel: Continent Cut Off'' (newspaper headline, c. 1905)