← Revision 12 as of 2011-08-23 19:32:20
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 [http://www.dovecot.org/list/dovecot-cvs/2006-October/006519.html fixed in Dovecot 1.0rc9 and later].||Note that this is also [[http://www.dovecot.org/list/dovecot-cvs/2006-October/006519.html|fixed in Dovecot 1.0rc9 and later]].|
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.