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

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

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?

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