-----Forwarded Message----- From: jigen <jigen@metalabs.org> To: Timo Sirainen <tss@iki.fi> Subject: Re:Dovecot] Finally PEBKAC was Failed authentication to a mysql database (bug or PEBKAC?) Date: Sat, 20 Aug 2005 18:33:11 +0200

On Fri, 2005-08-19 at 16:56, Timo Sirainen wrote:

Dovecot just passes these values to Mysql library without doing anything to them itself. So if it happens, it's Mysql library bug. It isn't a bug of mysql or dovecot. It's the most simple problem: mysql permissions :P In mysql 127.0.0.1 and localhost are differents things, and if you copy the user (posta in my case), it doesn't copy the password (and so it works without a password). And more: if you put password, you have to flush privileges. Finally PEBKAC :|

...

One more question: how I can specify more different mysql-db conteining different users? I try in the following way: passdb sql { args = /etc/dovecot/dovecot-mysql_debord.conf } passdb sql { args = /etc/dovecot/dovecot-mysql_django.conf }

This should work. After trying to authenticate against the first one it should try the second. Although I'm not sure if I've tried two passdb sqls before, maybe Dovecot has problems with that.. Well, I'll try once I get home. I'm working on this problem, but at the moment it doesn't work. It always connects only to second db. Another PEBKAC? This is my configuration file, maybe there's something wrong. (i've cut out commented lines) ----dovecot.conf---- base_dir = /var/run/dovecot/ protocols = imap imaps pop3 pop3s ssl_disable = yes ssl_cert_file = /etc/ssl/django_posta.pem ssl_key_file = /etc/ssl/private/django_posta.pem verbose_proctitle = yes verbose_ssl = yes first_valid_uid = 507 last_valid_uid = 507 first_valid_gid = 507 last_valid_gid = 507 default_mail_env = maildir:/var/vmail/%d/%n@%d/ mail_full_filesystem_access = yes protocol imap { } protocol pop3 { } auth_verbose = yes auth_debug = yes auth default { mechanisms = plain passdb sql { args = /etc/dovecot/dovecot-mysql_debord.conf } passdb sql { args = /etc/dovecot/dovecot-mysql_django.conf } userdb static { args = uid=507 gid=507 } user = root count = 2 }

ciao jigen