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@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@rapsplace.de): Error: sieve: dict storage: Storage does not support write access Jun 21 11:48:06 srv-www-01 dovecot: managesieve(m.raps@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@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@rapsplace.de