[Dovecot] strange behaviour: connecting to mysql, but no queries after upgrade on ubuntu...

Don Strayer dstrayer at sadt.com
Sat Jun 17 06:01:32 EEST 2006


On Sat, Jun 17, 2006 at 01:53:41AM +0200, Marcus Rueckert wrote:
> On 2006-06-16 17:07:11 -0400, Don Strayer wrote:
> > Jun 16 06:25:57 server dovecot: auth(default): client in: AUTH^I1^IPLAIN^Iservice=IMAP^Ilip=192.168.1.2^Irip=192.168.1.3^Iresp=AGd1ZXN0QHNhZHQuY29tAGZvbw==
> > Jun 16 06:25:57 server dovecot: child 4951 (auth-worker) killed with signal 11
> > Jun 16 06:25:57 server dovecot: auth(default): client out: FAIL^I1^Iuser=foo at sample.com^Itemp
> > Jun 16 06:25:57 server dovecot: imap-login: Aborted login: user=<foo at sample.com>, method=PLAIN, rip=192.168.1.2, lip=192.168.1.3
> ^I are normally tabs ... why do you have tabs in your stuff?
> 
> darix

I don't know. I haven't tinkered with login_log_format_elements or anything
related in dovecot.conf.

By the way, that appears in the log as two characters, "^" and "I", not
Control-I.

Here's my /etc/dovecot/dovecot.conf with all the comments stripped out:

--------------
protocols = imap imaps
ssl_disable = yes
disable_plaintext_auth = no
log_timestamp = "%Y-%m-%d %H:%M:%S "
mail_extra_groups = mail
default_mail_env = maildir:/var/mail/%d/%n

protocol imap {
}

protocol pop3 {
}

auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes

auth default {
  mechanisms = plain login

  passdb sql {
    args = /etc/dovecot/dovecot-mysql.conf
  }

  userdb static {
    args = uid=5000 gid=5000 home=/var/mail/%d/%n
  }

  user = root
}

plugin {
}
--------------

Here's my /etc/dovecot/dovecot-mysql.conf:

--------------
driver = mysql
connect = host=localhost port=3306 user=dovecot password=xxxx dbname=maildb
default_pass_scheme = PLAIN
password_query = SELECT password FROM users WHERE id = '%u'
--------------


More information about the dovecot mailing list