[Dovecot] Password query returned multiple matches

[Simon Brereton]

> -----Original Message-----
> From: Timo Sirainen [mailto:tss at iki.fi]
> 
> On 31.8.2011, at 18.19, Simon Brereton wrote:
> 
> > Aug 30 22:41:45 mail dovecot: auth-worker(default):
> sql(sbrereton at 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='sbrereton at domain.co.uk'.


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


Simon