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_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
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@example.com mail_plugins: quota 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@localdomain.org