> -----Original Message----- > From: Timo Sirainen [mailto:[email protected]] > > On 31.8.2011, at 18.19, Simon Brereton wrote: > > > Aug 30 22:41:45 mail dovecot: auth-worker(default): > sql([email protected],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='[email protected]'.
Well, what do you know - there are two Usernames that at the same! I have no idea how that happened. Simon
