[Dovecot] Dovecot Sieve Vacation Messages

[Steven Murphy]

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.

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

# 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
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
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


##################################################
#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'