manage/sieve and mysql: Storage does not support write access

[Markus Raps]

Hi there,

i want to set up sieve to store the scripts in the mysql database.

through mysql logging i can see that the incoming mail triggers a search 
in the script database
so the mysql connection basically works.

But i cant create any script through roundcube or telnet via managesieve

Jun 21 11:48:06 srv-www-01 dovecot: managesieve-login: Login: 
user=<m.raps at rapsplace.de>, method=PLAIN, rip=::1, lip=::1, mpid=31995, 
secured, session=<ewDrzyNvFoQAAAAAAAAAAAAAAAAAAAAB>
Jun 21 11:48:06 srv-www-01 dovecot: managesieve(m.raps at rapsplace.de): 
Error: sieve: dict storage: Storage does not support write access
Jun 21 11:48:06 srv-www-01 dovecot: managesieve(m.raps at rapsplace.de): 
Fatal: Failed to open Sieve storage.



# 2.2.27 (c0f36b0): /etc/dovecot/dovecot.conf
# Pigeonhole version 0.4.16 (fed8554)
# OS: Linux 4.9.0-6-amd64 x86_64 Debian 9.4 ext4
auth_mechanisms = plain login
dict {
   sievedb = mysql:/etc/dovecot/dovecot-sieve-sql.conf.ext
}
first_valid_uid = 150
last_valid_uid = 150
mail_gid = mail
mail_location = maildir:/var/vmail/%d/%n
mail_uid = vmail
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 index ihave duplicate mime foreverypart 
extracttext
namespace inbox {
   inbox = yes
   location =
   mailbox Drafts {
     special_use = \Drafts
   }
   mailbox Junk {
     special_use = \Junk
   }
   mailbox Sent {
     special_use = \Sent
   }
   mailbox "Sent Messages" {
     special_use = \Sent
   }
   mailbox Trash {
     special_use = \Trash
   }
   prefix =
}
passdb {
   args = /etc/dovecot/dovecot-sql.conf.ext
   driver = sql
}
plugin {
   sieve = dict:proxy::sievedb;name=active;bindir=~/.sieve-bin
   sieve_global = /var/vmail/sieve
}
postmaster_address = postmaster at rapsplace.de
protocols = " imap sieve"
service auth {
   unix_listener /var/spool/postfix/private/auth {
     group = postfix
     mode = 0660
     user = postfix
   }
   unix_listener auth-userdb {
     group = mail
     mode = 0600
     user = vmail
   }
}
service dict {
   unix_listener dict {
     group = mail
     mode = 0660
     user = dovecot
   }
}
service managesieve-login {
   inet_listener sieve {
     port = 4190
   }
   service_count = 0
}
ssl_ca = </etc/letsencrypt/live/rapsplace.de/fullchain.pem
ssl_cert = </etc/letsencrypt/live/rapsplace.de/cert.pem
ssl_key =  # hidden, use -P to show it
userdb {
   args = /etc/dovecot/dovecot-sql.conf.ext
   driver = sql
}
protocol lda {
   mail_plugins = " sieve"
}
protocol sieve {
   mail_max_userip_connections = 10
   managesieve_logout_format = bytes=%i/%o
   managesieve_max_line_length = 65536
}


-- 
Mit freundlichen Grüßen / best regards
Markus Raps

-------------------------
Web: rapsplace.de
Mail: m.raps at rapsplace.de
-------------------------