Hello,
Since 2.1.17 fixes a lot of bugs of 2.1.7, I would propose you to open a
bug report on the dovecot package in bugs.debian.org and list some of the
bugs which have been fixed in the meantime. The >> easiest way to do so
is to use the "reportbug" tool in Debian.
hmm, upgrading should fix some older errors but in my case i got new ones.
i went to 2.1.17 from http://xi.rename-it.nl/debian/ and did my changes to
source debs and compiled my packages.
At the moment i update from 2.1.7 to 2.1.17 my userdb-settings in mysql-db
are not working any more.
passdb and userdb directives are like this:
passdb {
args = /etc/dovecot/dovecot-sql.conf
driver = sql
}
userdb {
driver = prefetch
}
namespace is this:
namespace inbox {
inbox = yes
}
PasswordQuery with prefetching userdb is this:
password_query = SELECT `inbox` as `user`, `password`, `home` as
userdb_home, `uid` AS userdb_uid, `gid` AS userdb_gid, `userdb_import` AS
userdb_userdb_import FROM `mail_users` WHERE `login` = '%u' AND `active`='Y'
I tested also without prefetching -> same result.
In mysql in field userdb_import i have my TAB-separated XLIST Settings:
namespace/inbox/mailbox=Sent namespace/inbox/mailbox/Sent/name=Sent
namespace/inbox/mailbox/Sent/auto=subscribe
namespace/inbox/mailbox/Sent/special_use=\Sent
namespace/inbox/mailbox=Drafts namespace/inbox/mailbox/Drafts/name=Drafts
namespace/inbox/mailbox/Drafts/auto=subscribe
namespace/inbox/mailbox/Drafts/special_use=\Drafts
namespace/inbox/mailbox=Trash namespace/inbox/mailbox/Trash/name=Trash
namespace/inbox/mailbox/Trash/auto=subscribe
namespace/inbox/mailbox/Trash/special_use=\Trash
namespace/inbox/mailbox=Spam namespace/inbox/mailbox/Spam/name=Spam
namespace/inbox/mailbox/Spam/auto=subscribe
namespace/inbox/mailbox/Spam/special_use=\Junk
The 2.1.7 correct works:
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox=Drafts
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox=Sent
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox=Spam
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox=Trash
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Drafts/auto=subscribe
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Drafts/name=Entwürfe
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Drafts/special_use=\Drafts
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Sent/auto=subscribe
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Sent/name=Gesendet
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Sent/special_use=\Sent
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Spam/auto=subscribe
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Spam/name=Spam
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Spam/special_use=\Junk
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Trash/auto=subscribe
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Trash/name=Papierkorb
Aug 15 15:26:25 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Trash/special_use=\Trash
After upgrading to 2.1.17 the debuglog says:
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox=Spam
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Drafts/auto=subscribe
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Drafts/name=Entwürfe
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Drafts/special_use=\Drafts
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Sent/auto=subscribe
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Sent/name=Gesendet
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Sent/special_use=\Sent
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Spam/auto=subscribe
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Spam/name=Spam
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Added userdb setting:
namespace/inbox/mailbox/Spam/special_use=\Junk
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Trash/auto=subscribe
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Trash/name=Papierkorb
Aug 15 15:24:47 myhostname dovecot: imap: Debug: Unknown userdb setting:
plugin/namespace/inbox/mailbox/Trash/special_use=\Trash
just as i use more then one setting in userdb_import field, then the most of
the setting are not understood. downgrade to 2.1.7 -> it works;
upgrade to 2.1.7 with same mysql and same conf and it fails.
I can remember that some patches are made from timo to make this userdb work
in former versions. (the beginning:
http://dovecot.org/list/dovecot/2013-March/089209.html)
i cant find any configproblem on my side. Are still some patches needed? The
patches i used for 2.1.7 dont fit for 2.1.17
What to do now?
Thanks,
Hajo
