Auto create & subscribe folder from Userdb [Was: Users with extra mailbox: namespace/mailbox in userdb lookup?]

[Aki Tuomi]

On 14.03.2017 05:57, MRob wrote:
> On 2017-03-13 13:40, Aki Tuomi wrote:
>> On 2017-03-13 19:31, MRob wrote:
>>> On 2017-03-10 23:28, MRob wrote:
>>>> On 2017-03-10 23:22, Christian Kivalo wrote:
>>>>> Am 11. März 2017 08:04:28 MEZ schrieb MRob <mrobti at insiberia.net>:
>>>>>>
>>>>>>>> We have a need for some users to have an additional folder created
>>>>>> and
>>>>>>>> subscribed for them.
>>>>>>>>
>>>>>>>> Is is possible to return an override for the default "namespace
>>>>>> inbox"
>>>>>>>> containing the needed mailbox definitions in the userdb lookup for
>>>>>>>> such users? If so, how would the userdb lookup result be
>>>>>>>> formatted?
>>>>>>>> Presumably as
>>>>>>>
>>>>>>> Yes, see here:
>>>>>>>
>>>>>>> http://wiki2.dovecot.org/UserDatabase/ExtraFields
>>>>>>>
>>>>>>> Each setting ist one "Extra Field"
>>>>>>>
>>>>>>>> just one long string, but how would the setting be named given
>>>>>>>> there
>>>>>>
>>>>>>>> can't be a space in it? Can I replace the space with an
>>>>>>>> underscore,
>>>>>>>> e.g.
>>>>>>>>
>>>>>>>> userdb_namespace_inbox = '{ mailbox Drafts { auto=subscribe
>>>>>>>> special_use = \Drafts } mailbox Trash { auto=subscribe
>>>>>>>> special_use =
>>>>>>
>>>>>>>> \Trash } }'
>>>>>>>
>>>>>>> sort of:
>>>>>>>
>>>>>>> userdb_namespace/inbox/mailbox/Drafts/auto=subscribe
>>>>>>>
>>>>>>> see also:
>>>>>>>
>>>>>>> http://www.dovecot.org/list/dovecot/2016-February/103140.html
>>>>>>
>>>>>> Unfortunately, I'm having trouble with this task.
>>>>>>
>>>>>> Dovecot 2.2.27
>>>>>>
>>>>>> Trying to have an "Important" folder get created and subscribed for
>>>>>> only
>>>>>> some users. When I put this into my dovecot config file it works as
>>>>>> needed (other folders omitted for brevity):
>>>>>>
>>>>>> namespace inbox {
>>>>>>  mailbox Trash {
>>>>>>   auto=subscribe
>>>>>>   special_use = \Trash
>>>>>>  }
>>>>>>  mailbox Important {
>>>>>>   auto=subscribe
>>>>>>  }
>>>>>> }
>>>>>>
>>>>>> But I don't want to do it globally, so put it into the userdb
>>>>>> lookup:
>>>>>>
>>>>>> SELECT .... 'subscribe' AS
>>>>>> 'namespace/inbox/mailbox/Important/auto' ...
>>>>>>
>>>>>> WHERE ...
>>>>>>
>>>>>> I confirmed that the correct query is executing and I know it works
>>>>>> because other userdb fields are populated correctly. But the folder
>>>>>> does
>>>>>> not get created. For passdb lookups:
>>>>>>
>>>>>> SELECT .... 'subscribe' AS
>>>>>> 'userdb_namespace/inbox/mailbox/Important/auto' ... WHERE ...
>>>>>>
>>>>>> I'd appreciate help/tips.
>>>>> Whats the output of doveadm user <username> ?
>>>>
>>>> Oh I did not know this doveadm command, thank you!
>>>>
>>>> Output included all my other userdb fields as well as this:
>>>>
>>>> namespace/inbox/mailbox/Important/auto     subscribe
>>>
>>> Just a polite ping on this problem. Folder auto-creation isn't
>>> working with folders specified as part of the userdb lookup. Help
>>> appreciated.
>>
>> Can you change config to
>>
>> mail_debug=yes
>>
>> and provide logs for a single session?
>
> Sorry to return so much later. I can provide full logs, but it looks
> like this is what you're looking for:
>
> Mar 14 01:26:24 mail dovecot: imap(user at example.com): Debug: Unknown
> userdb setting: plugin/namespace/inbox/mailbox/Important/auto=subscribe
>
> Is it the "plugin/" on front? As you see with my doveadm result above,
> I don't think I caused that to be placed there. Any further guidance?
userdb_namespace/inbox/mailbox=Important
userdb_namespace/inbox/mailbox/Important/name=Important
userdb_namespace/inbox/mailbox/Important/auto=create

Also if you want to create multiple mailboxes, you can use
mailbox=Important,SecondBox,SomeOtherBox and add settings for them. The
important one is the 'name' setting.

Aki