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