[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss] MySQL problems
From: |
Chris Lightfoot |
Subject: |
Re: [tpop3d-discuss] MySQL problems |
Date: |
Sun, 25 Nov 2001 16:01:08 +0000 |
User-agent: |
Mutt/1.2.5i |
On Sun, Nov 25, 2001 at 03:39:36PM +0000, Chris Elsworth wrote:
> Hiya,
>
> Just tinkering with 1.4.1pre1, and I'm experiencing strange
> intermittent MySQL failures.
>
> One user can authenticate, but most others can't.
[...]
> The query, though you can probably work it out from the above:
>
> auth-mysql-pass-query: SELECT CONCAT(pop3_mbox.MailPath, '/',
> pop3_mbox.UserName), pop3_mbox.Password, pop3_mbox.UserName, 'bsd' FROM
> pop3_mbox,domain WHERE pop3_mbox.UserName = '$(local_part)' AND
> domain.DomainName = '$(domain)' AND pop3_mbox.DomainID = domain.DomainID
I don't understand this. Can you try doing the queries in
the mysql interactive monitor program and tell me what
they report?
--
THIS ARTICLE DOES NOT INCLUDE A SCHEDULE 3 INTERLINER