Hello,
I would like to ask for advice on the following things:
I have sieve scripts stored in mysql, work for LDA and imapd correctly.
When I try to connect using the client managesieve (Roungcube plugin managesieve with Thunderbird addon sieve), i receive the following error:
Oct 3 19:04:50 mail dovecot: managesieve(11044167): Debug: sieve: include: sieve_global_dir is not set; it is currently not possible to include `:global' scripts.
Oct 3 19:04:50 mail dovecot: managesieve(11044167): Error: sieve-storage: Cannot open non-file script location for active script `dict:proxy::sieve;name=active;bindir=/var/vmail/sieve-scripts/11044167'
Oct 3 19:04:50 mail dovecot: managesieve(11044167): Fatal: Failed to open Sieve storage.
If i change settings sieve to:
sieve = ~/.dovecot.sieve
sieve_dir = ~/sieve
it works fine.
can someone please advise configuring dovecot-managesieved with saving scripts in the database.
Thank you very much
Petr Bitzan
# 2.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 3.2.0-4-amd64 x86_64 Debian 7.6 ext4
auth_debug = yes
auth_mechanisms = plain login
auth_verbose = yes
dict {
acl = mysql:/etc/dovecot/dovecot-acl-shared-dict.conf.ext
sieve = mysql:/etc/dovecot/dict-sieve-sql.conf.ext
}
first_valid_gid = 1002
first_valid_uid = 1002
last_valid_gid = 1002
last_valid_uid = 1002
mail_debug = yes
mail_location = maildir:/var/vmail/%n/Maildir
mail_plugins = " mail_log notify acl"
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave
namespace {
list = children
location = maildir:%%h/Maildir:INDEX=~/shared/%%u/
prefix = shared/%%u/
separator = /
subscriptions = yes
type = shared
}
namespace inbox {
hidden = no
inbox = yes
list = yes
location =
mailbox Drafts {
special_use = \Drafts}
mailbox HAM {
auto = subscribe}
mailbox Junk {
special_use = \Junk}
mailbox SPAM {
auto = subscribe}
mailbox Sent {
special_use = \Sent}
mailbox "Sent Messages" {
special_use = \Sent}
mailbox Trash {
special_use = \Trash}
prefix =
separator = /
subscriptions = yes
type = private
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
acl = vfile
acl_shared_dict = proxy::acl
quota = maildir:User quota
quota_warning = storage=95%% quota-warning 95 %u
sieve = dict:proxy::sieve;name=active;bindir=/var/vmail/sieve-scripts/%u
sieve_dir = dict:proxy::sieve;name=active;bindir=~/.sieve-bin
}
protocols = " imap lmtp sieve pop3"
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix}
}
service dict {
unix_listener dict {
group = vmail
mode = 0600
user = vmail}
}
service lmtp {
inet_listener lmtp {
address = 127.0.0.1
port = 24}
user = vmail
}
service managesieve-login {
inet_listener sieve {
address = xxxxxxx
port = 4190}
}
service quota-warning {
executable = script /usr/local/bin/quota-warning.sh
unix_listener quota-warning {
user = vmail}
user = dovecot
}
ssl_cert =
ssl_key =
userdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
protocol lmtp {
mail_plugins = " mail_log notify acl quota sieve"
}
protocol lda {
mail_plugins = " mail_log notify acl quota sieve acl"
}
protocol imap {
mail_plugins = " mail_log notify acl quota imap_quota acl imap_acl"
}
protocol pop3 {
mail_plugins = " mail_log notify acl quota"
}
dict-sieve-sql.conf.ext:
connect = host=xxxxxxxxxxxxx dbname=xxxxxxxx user=xxxxxxxx password=xxxxxxxxxxxxxx
map {
pattern = priv/sieve/name/$script_name
table = user_sieve_scripts
username_field = username
value_field = id
fields {
script_name = $script_name}
}
map {
pattern = priv/sieve/data/$id
table = user_sieve_scripts
username_field = username
value_field = script_data
fields {
id = $id}
}
CREATE TABLE IF NOT EXISTS user_sieve_scripts (
id int(11) NOT NULL DEFAULT '0',
username varchar(40) DEFAULT NULL,
script_name varchar(255) DEFAULT NULL,
script_data varchar(10240) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY username (username,script_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;