[Dovecot] [Fwd: Re:Dovecot] Finally PEBKAC was Failed authentication to a mysql database (bug or PEBKAC?)]

[jigen]

-----Forwarded Message-----
From: jigen <jigen at metalabs.org>
To: Timo Sirainen <tss at 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