dovecot - Jun 2018 - manage/sieve and mysql: Storage does not support write access

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
-------------------------

> On 21 Jun 2018, at 12.53, Markus Raps <m.raps at rapsplace.de> wrote:
> 
> 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.
> 
I think the problem is that the sql-dict-sieve does not support updates.
It's read only.

Sami

ok i read the manual to fast....

i will try the pysived
https://github.com/miracle2k/pysieved

thanks

On 2018-06-21 22:23, Sami Ketola wrote:
>> On 21 Jun 2018, at 12.53, Markus Raps <m.raps at rapsplace.de>
wrote:
>> 
>> 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.
>> 
> 
> I think the problem is that the sql-dict-sieve does not support
> updates. It's read only.
> 
> Sami