Am Sonntag, den 30.10.2005, 15:46 +0200 schrieb Alexander Shikoff:
Hello,
I've compiled nightly CVS snapshot and set it up to work with MySQL database: [...] auth default { mechanisms = plain user = root
passdb sql { args = /usr/local/dovecot/etc/sql.conf } userdb sql { args = /usr/local/dovecot/etc/sql.conf }}
sql.conf contains next line: connect = host=localhost dbname=exim user=exim password=xxx
After the start dovecot cannot connect to MySQL database: Oct 30 15:44:15 crow dovecot: Dovecot v1.0.alpha4 starting up Oct 30 15:44:17 crow dovecot: auth-worker(default): mysql: Connect failed to localhost (exim): Access denied for user 'exim'@'localhost' (using password: YES) - waiting for 1 seconds before retry Oct 30 15:44:17 crow dovecot: auth-worker(default): mysql: Connect failed to localhost (exim): Access denied for user 'exim'@'localhost' (using password: YES) - waiting for 5 seconds before retry
But I can connect with the same password: # mysql -u exim -p exim Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
I am no dovecot expert, but could you also try it with
% mysql -uexim -pexim -hlocalhost
if you specify no -hlocalhost, the mysql client uses the hostname as the host to connect.
cheers
Udo Rader
-- BestSolution.at EDV Systemhaus GmbH http://www.bestsolution.at