Re: [Dovecot] Password query returned multiple matches

[Arne K. Haaje]

Wednesday 31. August 2011 11.44.03 skrev Simon Brereton :
> > -Original Message-
> > From: Timo Sirainen [mailto:t...@iki.fi]
> > 
> > On 31.8.2011, at 18.19, Simon Brereton wrote:
> > > Aug 30 22:41:45 mail dovecot: auth-worker(default):
> > sql(sbrere...@domain.co.uk,64.88.168.84): Password query returned
> > multiple matches
> > ..
> > 
> > > password_query = SELECT EmailAdd AS user, Password AS password,
> > 
> > concat('/var/spool/mail/virtual/',MailDirLoc) as userdb_home, 999 as
> > userdb_uid, 115 as userdb_gid FROM MailAccounts WHERE Username='%u'
> > AND active = '1';
> > 
> > > Since the EmailAdd is unique I don't see how it can return multiple
> > 
> > matches.
> > 
> > You're querying with Username, not with EmailAdd, and apparently
> > there are multiple rows where Username='sbrere...@domain.co.uk'.
> 
> Well, what do you know - there are two Usernames that at the same!  I have
> no idea how that happened.

You could change or add the index for Username column to UNIQUE. That will 
ensure it does not happen again :)

Arne

-- 
Arne K. Haaje - Dr Linux
http://www.drlinux.no/  ::: a...@drlinux.no
LinkedIn: http://no.linkedin.com/pub/arne-haaje/27/189/bb

Re: [Dovecot] Password query returned multiple matches

[Simon Brereton]

> -Original Message-
> From: Timo Sirainen [mailto:t...@iki.fi]
> 
> On 31.8.2011, at 18.19, Simon Brereton wrote:
> 
> > Aug 30 22:41:45 mail dovecot: auth-worker(default):
> sql(sbrere...@domain.co.uk,64.88.168.84): Password query returned
> multiple matches
> ..
> > password_query = SELECT EmailAdd AS user, Password AS password,
> concat('/var/spool/mail/virtual/',MailDirLoc) as userdb_home, 999 as
> userdb_uid, 115 as userdb_gid FROM MailAccounts WHERE Username='%u'
> AND active = '1';
> >
> > Since the EmailAdd is unique I don't see how it can return multiple
> matches.
> 
> You're querying with Username, not with EmailAdd, and apparently
> there are multiple rows where Username='sbrere...@domain.co.uk'.


Well, what do you know - there are two Usernames that at the same!  I have no 
idea how that happened.


Simon


 

Re: [Dovecot] Password query returned multiple matches

[Timo Sirainen]

On 31.8.2011, at 18.19, Simon Brereton wrote:

> Aug 30 22:41:45 mail dovecot: auth-worker(default): 
> sql(sbrere...@domain.co.uk,64.88.168.84): Password query returned multiple 
> matches
..
> password_query = SELECT EmailAdd AS user, Password AS password,  
> concat('/var/spool/mail/virtual/',MailDirLoc) as userdb_home, 999 as 
> userdb_uid, 115 as userdb_gid FROM MailAccounts WHERE Username='%u' AND 
> active = '1';
> 
> Since the EmailAdd is unique I don't see how it can return multiple matches.

You're querying with Username, not with EmailAdd, and apparently there are 
multiple rows where Username='sbrere...@domain.co.uk'.

[Dovecot] Password query returned multiple matches

[Simon Brereton]

Hi

After successfully setting up dovecot, I see this error in the logs.


Aug 30 22:41:45 mail dovecot: auth-worker(default): 
sql(sbrere...@domain.co.uk,64.88.168.84): Password query returned multiple 
matches
Aug 30 22:41:52 mail dovecot: pop3-login: Aborted login (auth failed, 1 
attempts): user=, method=PLAIN, rip=64.88.168.84, 
lip=127.0.0.1, TLS

Can you tell me what it means or what I should look for?  

In my dovecot-sql.conf I have this query:

password_query = SELECT EmailAdd AS user, Password AS password,  
concat('/var/spool/mail/virtual/',MailDirLoc) as userdb_home, 999 as 
userdb_uid, 115 as userdb_gid FROM MailAccounts WHERE Username='%u' AND active 
= '1';

Since the EmailAdd is unique I don't see how it can return multiple matches.

Thanks.

Simon