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