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

[Aki Tuomi]

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?

Aki

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus