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: postmas...@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.0926...@localdomain.org