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

[MRob]

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

In other words, I think it's configured correctly, so I hope someone can 
help me understand why it does not auto-create this folder when logging 
in.

I know it's the weekend, maybe someone sees this on Monday morning. 
Thank you.