This documentation is for Dovecot v1.x, see wiki2 for v2.x documentation.

MySQL Problems

Multiple definition of sha1_result

Quick solution: Change all sha1_result functions in Dovecot source tree to dovecot_sha1_result or something. For example:

zsh
cd dovecot
perl -i -pe 's/sha1_result/dovecot_sha1_result/' `find . -name '*.[ch]'`

More permanent solution: It's a [http://bugs.mysql.com/bug.php?id=13944 MySQL bug]. Upgrade to MySQL 4.1.18 / 5.0.19 when they're out.

Access denied

If Dovecot can't connect to MySQL but your password is correct, store the password to MySQL with OLD_PASSWORD() function instead of PASSWORD().

[http://www.dovecot.org/list/dovecot/2005-November/010000.html More information here.]