[Dovecot] Dovecot Sieve Vacation Messages

[Pascal Volk]

On 09/19/2009 10:45 PM Steven Murphy wrote:
> I'm using a Postfix, Dovecot, MySQL setup with virtual domains. I have mail
> being delivered through Dovecot LDA working 100%. I'm trying to use sieve to
> handle vacation messages but dovecot is not reading the .dovecot.sieve file
> in the users maildir. I have a hunch it has to do with my dovecot-sql query
> but have had no success with what I found in the forums from Googling.

The .dovecot.sieve script should be located in the users home directory,
not in the Maildir.

> Any help would be greatly appreciated. I've included my configs below:

Add 'mail_debug = yes' to the protocol lda {…} section and see what will
be logged.

> # 1.2.4: /etc/dovecot/dovecot.conf
> # OS: Linux 2.6.29-gentoo-r5 x86_64 Gentoo Base System release 1.12.11.1
> ext3
> protocols: imap imaps pop3 pop3s
> listen: *, [::]
> ssl_cert_file: /etc/ssl/dovecot/server.pem
> ssl_key_file: /etc/ssl/dovecot/server.key
> disable_plaintext_auth: no
> login_dir: /var/run/dovecot/login
> login_executable(default): /usr/libexec/dovecot/imap-login
> login_executable(imap): /usr/libexec/dovecot/imap-login
> login_executable(pop3): /usr/libexec/dovecot/pop3-login
> login_user: postfix
> mail_privileged_group: vmail
> mail_location: maildir:/home/vmail/%d/%n/.maildir

Replaces this with: mail_location: maildir:~/.maildir
Because your user_query seems to return a home.

> mail_executable(default): /usr/libexec/dovecot/imap
> mail_executable(imap): /usr/libexec/dovecot/imap
> mail_executable(pop3): /usr/libexec/dovecot/pop3
> mail_plugins(default): quota imap_quota
> mail_plugins(imap): quota imap_quota
> mail_plugins(pop3): quota
> mail_plugin_dir(default): /usr/lib64/dovecot/imap
> mail_plugin_dir(imap): /usr/lib64/dovecot/imap
> mail_plugin_dir(pop3): /usr/lib64/dovecot/pop3
> imap_client_workarounds(default): outlook-idle delay-newmail
> imap_client_workarounds(imap): outlook-idle delay-newmail
> imap_client_workarounds(pop3):
> pop3_client_workarounds(default):
> pop3_client_workarounds(imap):
> pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
> lda:
>   postmaster_address: postmaster at example.com
>   mail_plugins: quota sieve
+   mail_debug = yes
> auth default:
>   mechanisms: plain login
>   user: vmail
>   passdb:
>     driver: sql
>     args: /etc/dovecot/dovecot-sql.conf
>   userdb:
>     driver: prefetch
>   userdb:
>     driver: sql
>     args: /etc/dovecot/dovecot-sql.conf
>   socket:
>     type: listen
>     client:
>       path: /var/spool/postfix/private/auth
>       mode: 432
>       user: postfix
>       group: postfix
>     master:
>       path: /var/run/dovecot/auth-master
>       mode: 384
>       user: vmail
>       group: vmail
> plugin:
>   quota: maildir
>   sieve: /home/vmail/%d/%n/.dovecot.sieve

replace it with: sieve = ~/.dovecot.sieve


> ##################################################
> #dovecot-sql.conf
> 
> driver = mysql
> connect = host=localhost dbname=mail user=mailuser password=[password]
> default_pass_scheme = PLAIN-MD5
> user_query = SELECT homedir AS home, sieve, CONCAT('*:storage=', quota) AS
> quota_rule FROM users WHERE username = '%u'
> password_query = SELECT crypt AS password, CONCAT('*:storage=', quota) AS
> userdb_quota_rule FROM users WHERE username = '%u'


Regards,
Pascal
-- 
The trapper recommends today: decade.0926222 at localdomain.org