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@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 =
-- Mit freundlichen Grüßen / best regards Markus Raps
Web: rapsplace.de Mail: m.raps@rapsplace.de
On 21 Jun 2018, at 12.53, Markus Raps m.raps@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@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.
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@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@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.
I think the problem is that the sql-dict-sieve does not support updates. It's read only.
Sami
participants (2)
-
Markus Raps
-
Sami Ketola