[Dovecot] hide sieve folder from imap clients

[Christopher Stolzenberg]

2011/6/27 Thomas Leuxner <tlx at leuxner.net>:
>> new config (hide sieve folder)
>>
>> mail_home = /var/vmail/%d/%n
>> maildir_stat_dirs = yes
>>
>> plugin {
>> sieve_dir = /var/vmail/%d/%n/sieve/
>> sieve = /var/vmail/%d/%n/.dovecot.sieve
>> }
>
> All the examples look a bit overcomplicated. Why not go with the "defaults"?
>
>  mail_location = maildir:~/maildir
>  sieve = ~/.dovecot.sieve
>
> However this relies on home dirs being returned from the user lookups which has not been revealed in the OP's partial config post.

Okay, here is my new config:

mail_home = /var/vmail/%d/%n/
mail_location = maildir:/var/vmail/%d/%n/maildir

plugin {
  sieve_dir = /var/vmail/%d/%n/.sieve
  sieve = /var/vmail/%d/%n/.dovecot.sieve
}

How should I configure mysql?

user_query = SELECT CONCAT('maildir:/var/vmail/',maildir) AS mail,
6000 AS uid, 6000 AS gid FROM mailbox WHERE username = '%u' AND active
= '1'

or

user_query = SELECT maildir, 6000 AS uid, 6000 AS gid FROM mailbox
WHERE username = '%u' AND active = '1'

mysql query return:
maildir: domain.com/user/

Thank you for your help.

--
Christopher