<font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">--- Dict-Definition in dovecot.conf
>>></font>
<br><font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">dict {</font>
<br><font size=2 face="sans-serif"> sieve = pgsql:/etc/dovecot/dict-sieve-sql.conf.ext</font>
<br><font size=2 face="sans-serif">} </font>
<br>
<br><font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">--- Dict-Definition in dict-sieve-sql.conf.ext
>>></font>
<br><font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">connect = host=xxxxx dbname=vbmail user=xxxxx
password=xxxxxx</font>
<br><font size=2 face="sans-serif">map {</font>
<br><font size=2 face="sans-serif"> pattern = priv/sieve/name/$script_name</font>
<br><font size=2 face="sans-serif"> table = user_sieve
_scripts</font>
<br><font size=2 face="sans-serif"> username_field = username</font>
<br><font size=2 face="sans-serif"> value_field = script_id</font>
<br><font size=2 face="sans-serif"> fields {</font>
<br><font size=2 face="sans-serif"> script_name
= $script_name</font>
<br><font size=2 face="sans-serif"> }</font>
<br><font size=2 face="sans-serif"> }</font>
<br><font size=2 face="sans-serif">map {</font>
<br><font size=2 face="sans-serif"> pattern = priv/sieve/data/$id</font>
<br><font size=2 face="sans-serif"> table = user_sieve
_scripts</font>
<br><font size=2 face="sans-serif"> username_field = username</font>
<br><font size=2 face="sans-serif"> value_field = script_sieve</font>
<br><font size=2 face="sans-serif"> fields {</font>
<br><font size=2 face="sans-serif"> script_id = $id</font>
<br><font size=2 face="sans-serif"> }</font>
<br><font size=2 face="sans-serif"> } </font>
<br>
<br><font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">--- Dict-Definition in conf.d/10-master.conf
>>></font>
<br><font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">service dict {</font>
<br><font size=2 face="sans-serif"> unix_listener dict {</font>
<br><font size=2 face="sans-serif"> mode = 0600</font>
<br><font size=2 face="sans-serif"> user = vmail</font>
<br><font size=2 face="sans-serif"> }</font>
<br><font size=2 face="sans-serif">}</font>
<br>
<br><font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">--- Dict-Definition in conf.d/90-sieve.conf
>>></font>
<br><font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">plugin {</font>
<br><font size=2 face="sans-serif"> sieve = dict:proxy::sieve;name=active;bindir=~/.sieve-bin</font>
<br><font size=2 face="sans-serif"> sieve_before = /var/lib/dovecot/sieve/global_before.sieve
</font>
<br><font size=2 face="sans-serif"> # Use vacation-seconds</font>
<br><font size=2 face="sans-serif"> sieve_extensions = +vacation-seconds</font>
<br><font size=2 face="sans-serif"> # Allow sending a vacation response
message for every incoming message</font>
<br><font size=2 face="sans-serif"> sieve_vacation_min_period = 0s
</font>
<br><font size=2 face="sans-serif">}</font>
<br>
<br><font size=2 face="sans-serif">----------</font>
<br><font size=2 face="sans-serif">"dovecot -n":</font>
<br><font size=2 face="sans-serif">----------</font>
<br>
<br><font size=2 face="sans-serif"># 2.2.15.16 (3a698b8c40a1): /etc/dovecot/dovecot.conf</font>
<br><font size=2 face="sans-serif"># OS: Linux 2.6.32-431.20.3.el6.x86
_64
x86_64 Scientific Linux release 6.5 (Carbon) </font>
<br><font size=2 face="sans-serif">auth_master_user_separator = *</font>
<br><font size=2 face="sans-serif">default_client_limit = 8192</font>
<br><font size=2 face="sans-serif">default_process_limit = 1024</font>
<br><font size=2 face="sans-serif">dict {</font>
<br><font size=2 face="sans-serif"> sieve = pgsql:/etc/dovecot/dict-sieve-sql.conf.ext</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">disable_plaintext_auth = no</font>
<br><font size=2 face="sans-serif">mail_debug = yes</font>
<br><font size=2 face="sans-serif">mail_gid = 999</font>
<br><font size=2 face="sans-serif">mail_location = maildir:~/Maildir</font>
<br><font size=2 face="sans-serif">mail_plugins = " quota"</font>
<br><font size=2 face="sans-serif">mail_uid = 999</font>
<br><font size=2 face="sans-serif">maildir_very_dirty_syncs = yes</font>
<br><font size=2 face="sans-serif">mbox_write_locks = fcntl</font>
<br><font size=2 face="sans-serif">namespace inbox {</font>
<br><font size=2 face="sans-serif"> inbox = yes</font>
<br><font size=2 face="sans-serif"> location = </font>
<br><font size=2 face="sans-serif"> prefix = INBOX.</font>
<br><font size=2 face="sans-serif"> separator = .</font>
<br><font size=2 face="sans-serif"> type = private</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">passdb {</font>
<br><font size=2 face="sans-serif"> args = /etc/dovecot/dovecot-sql.conf.ext</font>
<br><font size=2 face="sans-serif"> driver = sql</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">passdb {</font>
<br><font size=2 face="sans-serif"> args = /etc/dovecot/dovecot-sql.conf.ext</font>
<br><font size=2 face="sans-serif"> driver = sql</font>
<br><font size=2 face="sans-serif"> master = yes</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">plugin {</font>
<br><font size=2 face="sans-serif"> autocreate = INBOX.Entw&APw-rfe</font>
<br><font size=2 face="sans-serif"> autocreate2 = INBOX.Gesendet</font>
<br><font size=2 face="sans-serif"> autocreate3 = INBOX.Papierkorb</font>
<br><font size=2 face="sans-serif"> autocreate4 = INBOX.Spam-Reports</font>
<br><font size=2 face="sans-serif"> autocreate5 = INBOX.Vorlagen</font>
<br><font size=2 face="sans-serif"> autocreate6 = INBOX.Vorlagen.Eigene
Vorlagen</font>
<br><font size=2 face="sans-serif"> quota = maildir:User Quota</font>
<br><font size=2 face="sans-serif"> quota_rule = *:storage=1024G</font>
<br><font size=2 face="sans-serif"> sieve = dict:proxy::sieve;name=active;bindir=~/.sieve-bin</font>
<br><font size=2 face="sans-serif"> sieve_before = /var/lib/dovecot/sieve/global_before.sieve</font>
<br><font size=2 face="sans-serif"> sieve_extensions = +vacation-seconds</font>
<br><font size=2 face="sans-serif"> sieve_vacation_min_period = 0s</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">protocols = imap lmtp</font>
<br><font size=2 face="sans-serif">service auth {</font>
<br><font size=2 face="sans-serif"> client_limit = 8192</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">service dict {</font>
<br><font size=2 face="sans-serif"> unix_listener dict {</font>
<br><font size=2 face="sans-serif"> mode = 0600</font>
<br><font size=2 face="sans-serif"> user = vmail</font>
<br><font size=2 face="sans-serif"> }</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">service imap-login {</font>
<br><font size=2 face="sans-serif"> process_min_avail = 64</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">service imap-postlogin {</font>
<br><font size=2 face="sans-serif"> executable = script-login /usr/local/dvag_scripts/dovecot/postlogin</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">service imap {</font>
<br><font size=2 face="sans-serif"> executable = imap imap-postlogin</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">service lmtp {</font>
<br><font size=2 face="sans-serif"> inet_listener lmtp {</font>
<br><font size=2 face="sans-serif"> address = xx.xx.xx.xx</font>
<br><font size=2 face="sans-serif"> port = 24</font>
<br><font size=2 face="sans-serif"> }</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">ssl_cert = </etc/pki/dovecot/certs/dovecot.pem</font>
<br><font size=2 face="sans-serif">ssl_key = </etc/pki/dovecot/private/dovecot.pem</font>
<br><font size=2 face="sans-serif">userdb {</font>
<br><font size=2 face="sans-serif"> args = /etc/dovecot/dovecot-sql.conf.ext</font>
<br><font size=2 face="sans-serif"> driver = sql</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">protocol lmtp {</font>
<br><font size=2 face="sans-serif"> mail_plugins = " quota sieve"</font>
<br><font size=2 face="sans-serif">}</font>
<br><font size=2 face="sans-serif">protocol imap {</font>
<br><font size=2 face="sans-serif"> imap_max_line_length = 16 M</font>
<br><font size=2 face="sans-serif"> mail_max_userip_connections =
100</font>
<br><font size=2 face="sans-serif"> mail_plugins = " quota autocreate
imap_quota fts fts_squat"</font>
<br><font size=2 face="sans-serif">}</font>
<br>
<br><font size=2 face="sans-serif">PS: die veralteten "autocreate"
Einstellungen bauen wir noch um</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">Von:
</font><font size=1 face="sans-serif">Stephan Bosch <stephan@rename-it.nl></font>
<br><font size=1 color=#5f5f5f face="sans-serif">An:
</font><font size=1 face="sans-serif">Alles rund um Dovecot-Server
<dovecot@listen.jpberlin.de>, </font>
<br><font size=1 color=#5f5f5f face="sans-serif">Datum:
</font><font size=1 face="sans-serif">16.04.2015 21:49</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Betreff:
</font><font size=1 face="sans-serif">Re: [Dovecot-de]
Sieveskripte in Datenbank und vaction :mime mit HTML</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Gesendet von:
</font><font size=1 face="sans-serif">"Dovecot"
<dovecot-bounces@listen.jpberlin.de></font>
<br>
<hr noshade>
<br>
<br>
<br><font size=3>On 4/16/2015 2:12 PM, Holger Hoch wrote:</font>
<br><font size=2 face="Consolas">Hallo,</font><font size=3> <br>
</font><font size=2 face="Consolas"><br>
wir sind gerade dabei unsere Mailfilter auf sieve umzustellen. Dabei verwenden
wir <br>
dovecot-ee-pigeonhole-0.4.6-5.el6.x86 _64</font><font size=3> </font><font size=2 face="Consolas"><br>
dovecot-ee-2.2.15.16-1.el6.x86_64</font><font size=3> </font><font size
=2 face="Consolas"><br>
Die User-Skripte liegen in der Datenbank, Konfiguration im Prinzip wie
im Wiki, klappt soweit prima, deshalb erspare ich euch erstmal weitere
Konfigurationsdetails.</font><font size=3> <br>
</font><font size=2 face="Consolas"><br>
Nun das Problem:</font><font size=3> </font><font size=2 face="Consolas"><br>
Die Skripte, die über die dict proxy aus der DB gelesen werden, dürfen
keine Zeilenumbrüche enthalten. Andernfalls wird nur die erste Zeile geliefert.</font>
<br><font size=3><br>
Das ist seltsam. Ich hab' Timo mal gefragt und er sagt das sollte eigentlich
möglich sein. Welcher Art dict Datenbank wird benutzt?<br>
<br>
Kürzlich gab es zwar einen Fehler im dict-file Treiber, aber das ist kein
Datenbank:<br>
</font><font size=3 color=blue><u><br>
</u></font><a href="http://hg.dovecot.org/dovecot-2.2/rev/93dab55ae36e"><font size=3 color=blue><u>http://hg.dovecot.org/dovecot-2.2/rev/93dab55ae36e</u></font></a><font size=3><br>
<br>
Es wäre auch hilfreich mal einen Blick auf deine Konfiguration werfen zu
können.<br>
<br>
Gruß,<br>
<br>
Stephan.<br>
</font><tt><font size=2>________________
_________________________
______<br>
Dovecot Mailingliste<br>
JPBerlin - Politischer Provider<br>
Dovecot@listen.jpberlin.de<br>
</font></tt><a href=https://listen.jpberlin.de/mailman/listinfo/dovecot><tt><font size=2>https://listen.jpberlin.de/mailman/listinfo/dovecot</font></tt></a><tt><font size=2><br>
</font></tt>
<br>
<br><font size="2" face="Arial">---------------------------------------------------------------------<br>Deutsche Vermögensberatung Aktiengesellschaft DVAG<br>Münchener Straße 1<br>60329 Frankfurt am Main<br>Vorstandsvorsitzender: Andreas Pohl<br>Mitglieder des Vorstandes: Dr. h.c. /HLU Udo Corts, Hans-Theo Franken, Christian Glanz, <br>Lars Knackstedt, Dr. Helge Lach, Robert Peil, Dr. Dirk Reiffenrath<br>Aufsichtsratsvorsitzender: Friedrich Bohl<br>Sitz der Gesellschaft: Frankfurt am Main<br>Handelsregister Frankfurt HRB 15511<br>USt-Ident.-Nr.: DE 114 139 839<br>Aufsichtsbehörde nach § 34c GewO: <br>Stadt Frankfurt am Main<br>Ordnungsamt<br>Kleyerstraße 86<br>60326 Frankfurt am Main <br>--------------------------------------------------------------------- </font>