[Dovecot] INBOX protected foldername?

[Hajo Locke]

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