<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class=""><div class="">Hi Sami,</div><div class=""><br class=""></div><div class="">thank you for your answer.</div><div class=""><br class=""></div><div class="">I use GlusterFS because the dovecot replication does not work with the mailcrypt plugin. </div><div class="">I will wait and see how reliable it works for me. </div><div class="">I have only a very small personal mail server. So it is not really critical if something does not work. </div></div><div class=""><br class=""></div><div class="">The dovecot-sql.conf has the following content:</div><div class=""><br class=""></div><div class=""><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039);"><span class="" style="font-variant-ligatures: no-common-ligatures;">driver=mysql</span></div><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039);"><span class="" style="font-variant-ligatures: no-common-ligatures;">connect = "host=192.168.20.24 dbname=vmail user=*** password=***"</span></div><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039);"><span class="" style="font-variant-ligatures: no-common-ligatures;">default_pass_scheme = SHA512-CRYPT</span></div><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039); min-height: 14px;"><span class="" style="font-variant-ligatures: no-common-ligatures;"></span><br class=""></div><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039);"><span class="" style="font-variant-ligatures: no-common-ligatures;">password_query = SELECT username AS user, domain, password, '%w' AS userdb_mail_crypt_private_password, 'yes' AS proxy, 'any-cert' AS 'ssl', 'any-cert' AS starttls, 'Y' as nopassword FROM accounts WHERE username = '%n' AND domain = '%d' and enabled = true;</span></div><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039);"><span class="" style="font-variant-ligatures: no-common-ligatures;">user_query = SELECT concat('*:storage=', quota, 'M') AS quota_rule FROM accounts WHERE username = '%n' AND domain = '%d' AND sendonly = false;</span></div><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039); min-height: 14px;"><br class=""><span class="" style="font-variant-ligatures: no-common-ligatures;"></span></div><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039); min-height: 14px;"><span class="" style="font-variant-ligatures: no-common-ligatures;"></span></div><div class="" style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Andale Mono"; color: rgb(47, 255, 18); background-color: rgba(0, 0, 0, 0.498039);"><span class="" style="font-variant-ligatures: no-common-ligatures;">iterate_query = SELECT username, domain FROM accounts where sendonly = false;</span></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div class="">Best regards</div><div class=""><br class=""></div><div class="">Daniel</div></div><div style=""><br class=""><blockquote type="cite" class=""><div class="">Am 28.01.2020 um 07:54 schrieb Sami Ketola <<a href="mailto:sami.ketola@dovecot.fi" class="">sami.ketola@dovecot.fi</a>>:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div class=""><br class=""><blockquote type="cite" class=""><div class="">On 27 Jan 2020, at 11.56, Daniel Niewerth <<a href="mailto:daniel@niewerth.it" class="">daniel@niewerth.it</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class="">Hi everybody,</div><div class=""><br class=""></div><div class="">I run two redundant Dovecot servers with a shared Maildir on a GlusterFS volume and a SQL authentication backend based on a mirrored MariaDB database.</div><div class="">Because of the splitbrain situation I would like to add two Dovecot Director as proxies. </div></div></div></blockquote><div class=""><br class=""></div><div class=""><br class=""></div>I would not run on GlusterFS because of bad experiences and index corruptions on the past experiments.</div><div class=""><br class=""><blockquote type="cite" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class=""><br class=""></div><div class="">Can someone explain me how to solve this problem?</div><div class=""><br class=""></div><span class="">### Proxy Config ###<br class=""></span><span class="">####################<br class=""></span><div class=""><span style="caret-color: rgb(46, 139, 87); color: rgb(46, 139, 87); font-family: Monaco, "Andale Mono", "Courier New", Courier, monospace; font-size: 11.699999809265137px; white-space: pre; background-color: rgb(255, 255, 255);" class="">
passdb {
args = /etc/dovecot/dovecot-sql.conf
driver = sql
}
</span></div></div></blockquote><div class=""><br class=""></div>please show contents of this file.</div><div class=""><br class=""><blockquote type="cite" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class=""><span style="caret-color: rgb(46, 139, 87); color: rgb(46, 139, 87); font-family: Monaco, "Andale Mono", "Courier New", Courier, monospace; font-size: 11.699999809265137px; white-space: pre; background-color: rgb(255, 255, 255);" class="">passdb {
driver = pam
}
</span></div></div></blockquote><div class=""><br class=""></div>please remove this if you are using sql as auth db.</div><div class=""><br class=""></div><div class="">Sami</div><br class=""></div><pre class="">--
This email was Malware checked by vsrv-dus6-fwl01</pre>
</div></blockquote></div><br class=""></body></html>