[Dovecot] Password query returned multiple matches

Timo Sirainen tss at iki.fi
Wed Aug 31 18:22:22 EEST 2011

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, 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'.

More information about the dovecot mailing list