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.r...@rapsplace.de>, method=PLAIN, rip=::1, lip=::1, mpid=31995, 
secured, session=<ewDrzyNvFoQAAAAAAAAAAAAAAAAAAAAB>
Jun 21 11:48:06 srv-www-01 dovecot: managesieve(m.r...@rapsplace.de): 
Error: sieve: dict storage: Storage does not support write access
Jun 21 11:48:06 srv-www-01 dovecot: managesieve(m.r...@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 = postmas...@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.r...@rapsplace.de
-------------------------