Re: [Dovecot] Dovecot Sieve Vacation Messages
> 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
> > 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=
Re: [Dovecot] Dovecot Sieve Vacation Messages
I do have the dovecot.sieve in the users homedir.
Made the changes mentioned. Mail gets delivered OK but dovecot is not
reading the sieve file. Rather dovecot.sievec is not being created.
Also no additional logging is happening with debug on.
Also the homdir sql lookup returns the following path:
/home/vmail/$domain/$user
Just to provide as much info as possible, here is my Postfix master.conf
entry for dovecot:
dovecot unix - n n - - pipe
flags=DRhu user=vmail:vmail argv=/usr/libexec/dovecot/deliver -f ${sender}
-d ${us...@${nexthop} -a ${recipient}
On Sat, Sep 19, 2009 at 4:58 PM, Pascal Volk <
user+dove...@localhost.localdomain.org
> wrote:
> 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
>
[Dovecot] Dovecot Sieve Vacation Messages
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: postmas...@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'
[Dovecot] Sieve MySQL integration
I have dovecot running with sieve performing vacation autoreply. Can sieve do sql lookups for vacation messages instead of having to do flat files in the users home directory? Thank you in advance. Steve
