This documentation is for Dovecot v1.x, see wiki2 for v2.x documentation.
Differences between revisions 11 and 12
Revision 11 as of 2011-08-05 19:58:07
Size: 1102
Editor: 116
Comment:
Revision 12 as of 2011-08-23 19:32:20
Size: 942
Editor: TimoSirainen
Comment: Although possibly useful info, it has nothing to do with this page
Deletions are marked like this. Additions are marked like this.
Line 19: Line 19:

Also, see also [[http://www.runmapglobal.com/blog/howto-set-up-a-mysql-cluster-for-two-servers-three-servers-required-for-true-redundancy/ | MySQL Servers]]

MySQL Problems

If you use MySQL version older than 4.1.18, or in 5.x series older than 5.0.19, there's a problem with conflicting symbols. Either the linking fails completely, or Dovecot can't log in:

dovecot: Oct 14 01:02:22 Error: auth-worker(default): mysql: Connect failed to localhost (db): Access denied for user 'user'@'localhost' (using password: YES) - waiting for 1 seconds before retry

They both have the same root reason: Conflicing sha1_result symbol. Either upgrade to newer MySQL library, or modify Dovecot sources:

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

Another solution to "access denied" is to use OLD_PASSWORD() function to set the password in MySQL. This works because it doesn't use the SHA1 functions.

Note that this is also fixed in Dovecot 1.0rc9 and later.

None: MysqlProblems (last edited 2011-08-23 19:32:20 by TimoSirainen)