This documentation is for Dovecot v1.x, see wiki2 for v2.x documentation.
Differences between revisions 9 and 12 (spanning 3 versions)
Revision 9 as of 2006-10-13 22:38:26
Size: 940
Editor: TimoSirainen
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 18: Line 18:
Note that this is also [ fixed in Dovecot 1.0rc9 and later]. Note that this is also [[|fixed in Dovecot 1.0rc9 and later]].

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)