Re: [Dovecot] Dovecot Sieve Vacation Messages

2009-09-20 Thread Steven Murphy 
 Are there additional transport_maps configured in your main.cf?


I thought I had it commented out, but sure enough I had a transport map to
my MySQL lookups and it was defaulted to virtual.

Pascal,
Thank you for your patience and help.


Steve

Re: [Dovecot] Dovecot Sieve Vacation Messages

2009-09-19 Thread 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: 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

Re: [Dovecot] Dovecot Sieve Vacation Messages

2009-09-19 Thread Steven Murphy 
  There should be something logged, similar to the following lines:
  Loading modules from directory: /usr/lib/dovecot/modules/lda
  Module loaded: /usr/lib/dovecot/modules/lda/lib90_sieve_plugin.so
  auth input: home=/path/to/users/home
  auth input: uid=1234
  auth input: gid=5678
  auth input: mail=maildir:~/.maildir
  maildir: data=~/.maildir
  maildir++: root=/path/to/users/home/.maildir, index=, control=,
 inbox=/path/to/users/home/.maildir
  sieve: local script path /path/to/users/home/.dovecot.sieve doesn't exist
 (using global script path in stead)
  sieve: user has no valid personal script
  sieve: no scripts to execute: reverting to default delivery.


 It is not loading the module, here is what I get:

ILoading modules from directory: /usr/lib64/dovecot/imap
IModule loaded: /usr/lib64/dovecot/imap/lib10_quota_plugin.so
IModule loaded: /usr/lib64/dovecot/imap/lib11_imap_quota_plugin.so
IEffective uid=65534, gid=65534, home=/tmp
IQuota root: name= backend=maildir args=