[Dovecot] Dovecot 30.10.2005 CVS Snapshot: cannot connect to MySQL

[Udo Rader]

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