[tpop3d-discuss] MySQL problems

[Chris Lightfoot]

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