Re: [tpop3d-discuss] MySQL problems

[Chris Elsworth]

On Sun, Nov 25, 2001 at 04:01:08PM +0000, Chris Lightfoot wrote:
> 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?

Sure.. here you go, for 3 of them in the previous mail:

mysql> SELECT CONCAT(pop3_mbox.MailPath, '/', pop3_mbox.UserName), 
pop3_mbox.Password, pop3_mbox.UserName, 'bsd' FROM pop3_mbox,domain WHERE 
pop3_mbox.UserName = 'test' AND domain.DomainName = 'dmeon.net' AND 
pop3_mbox.DomainID = domain.DomainID;
+-----------------------------------------------------+---------------------------------------+----------+-----+
| CONCAT(pop3_mbox.MailPath, '/', pop3_mbox.UserName) | Password                
              | UserName | bsd |
+-----------------------------------------------------+---------------------------------------+----------+-----+
| /var/mail/dmeon.net/test                            | 
{crypt_md5}$1$$whuM5Zj.HMFoaTaZRRtkO0 | test     | bsd |
+-----------------------------------------------------+---------------------------------------+----------+-----+
1 row in set (0.00 sec)

mysql> SELECT CONCAT(pop3_mbox.MailPath, '/', pop3_mbox.UserName), 
pop3_mbox.Password, pop3_mbox.UserName, 'bsd' FROM pop3_mbox,domain WHERE 
pop3_mbox.UserName = 'chris' AND domain.DomainName = 'black-sun.co.uk' AND 
pop3_mbox.DomainID = domain.DomainID;
+-----------------------------------------------------+-----------------------------------------+----------+-----+
| CONCAT(pop3_mbox.MailPath, '/', pop3_mbox.UserName) | Password                
                | UserName | bsd |
+-----------------------------------------------------+-----------------------------------------+----------+-----+
| /var/mail/black-sun.co.uk/chris                     | 
{crypt_md5}$1$QE$8Yp1xmp3dQ4tPr8clFD8I/ | chris    | bsd |
+-----------------------------------------------------+-----------------------------------------+----------+-----+
1 row in set (0.00 sec)

mysql> SELECT CONCAT(pop3_mbox.MailPath, '/', pop3_mbox.UserName), 
pop3_mbox.Password, pop3_mbox.UserName, 'bsd' FROM pop3_mbox,domain WHERE 
pop3_mbox.UserName = 'alex' AND domain.DomainName = 'black-sun.co.uk' AND 
pop3_mbox.DomainID = domain.DomainID;
+-----------------------------------------------------+-----------------------------------------+----------+-----+
| CONCAT(pop3_mbox.MailPath, '/', pop3_mbox.UserName) | Password                
                | UserName | bsd |
+-----------------------------------------------------+-----------------------------------------+----------+-----+
| /var/mail/black-sun.co.uk/alex                      | 
{crypt_md5}$1$eW$Hps1Wuny1Hu2Jp8xSpZTp/ | alex     | bsd |
+-----------------------------------------------------+-----------------------------------------+----------+-----+
1 row in set (0.00 sec)

Apologies about the long lines, but it seems the only way to keep it
all looking sane.

(password hashes slightly modified to protect the innocent, before
anyone gets any ideas)

-- 
Chris Elsworth  -  Software & Systems Developer  /  Systems Administrator