Hi,

i've been using dovecot2 on our server for handling virtual mailboxes and postfix is also using it to examine if a mail has to be delivered locally or not. Recently i upgraded to 2.0.7 (freebsd ports), but it stopped working, says the error in the subject line.

Details: [root@postfixjail /usr/local/etc/dovecot]# dovecot --version 2.0.7

[root@postfixjail /usr/local/etc/dovecot]# grep -hv '^ *\(#.*\)\?$' dovecot.conf conf.d/* protocols = imap pop3 lmtp sieve listen = * dict { quota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext quota_rule2 = Trash:bytes=+100M } mail_location = maildir:~/Maildir passdb { driver = sql args = /usr/local/etc/dovecot/dovecot-sql.conf.ext } userdb { driver = prefetch } userdb { driver = sql args = /usr/local/etc/dovecot/dovecot-sql.conf.ext } ssl = yes ssl_cert =

[root@postfixjail /usr/local/etc/dovecot]# grep -hv '^ *\(#.*\)\?$' dovecot-dict-sql.conf.ext connect = host=127.0.0.3 dbname=mailsql user=mailsql password=somepassword map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages }

[root@postfixjail /usr/local/etc/dovecot]# grep -hv '^ *\(#.*\)\?$' dovecot-sql.conf.ext driver = mysql connect = host=127.0.0.3 dbname=mailsql user=mailsql password=somepassword default_pass_scheme = PLAIN-MD5 user_query =
SELECT maildir AS home, 'vmail' AS uid, 'vmail' AS gid,
CONCAT('*:bytes=', quota) AS quota_rule
FROM mailbox WHERE username = '%u' AND active = 1 password_query =
SELECT username AS user, password,
maildir AS userdb_home,
'vmail' AS userdb_uid, 'vmail' AS userdb_gid,
CONCAT('*:bytes=', quota) AS userdb_quota_rule
FROM mailbox WHERE username = '%u' AND active = 1 iterate_query = SELECT username AS user FROM mailbox

[root@postfixjail /usr/local/etc/dovecot]# uname -a FreeBSD postfixjail.mymachine.com 8.2-PRERELEASE FreeBSD 8.2-PRERELEASE #4: Sat Jan 1 23:33:01 CET 2011 root@new.mymachine.com:/usr/obj/usr/src/sys/MYKERNEL amd64

The filesystem is ZFS (is that really needed?)

Any help on that? I'm helpless, went to the irc channel, but people told that my configs are right.

Cheers, Laszlo