<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Ich komme noch mal zurück auf ein Teilproblem, das geblieben ist.<div class="">Neue Nutzer und auch neue Domain konnte ich mittels des Skripts vmail-admin.sh anlegen und da die ursprünglichen</div><span class="">dovecot-sql.conf.ext für eine Domain festverdrahtet war, konnte ich das Repariern durch Verwenden von %d , dank Markus Hilfe:<br class=""></span><span class=""><br class="">[...]<br class="">password_query = \<br class=""> SELECT username, domain, password \<br class=""> FROM users WHERE username = '%n' AND domain = '<a href="http://kukulies.org" class="">kukulies.org</a>'<br class="">[...]<br class=""><br class=""><br class=""> FROM users WHERE username = '%n' AND domain = '%d'</span><div class=""><span class=""><br class=""></span></div><div class=""><span class=""><br class=""></span></div><div class=""><span class="">Was aber noch nicht funktioniert, ist das Benutzen der Domain zum Betrieb des Mail-Empfangs (und Senden).</span></div><div class="">Im Apple mail.app client ist das Konto immer noch mit einem /!\ versehen und ich bekomme dieses Bild, wenn ich auf die Info klicke:</div><div class=""><br class=""></div><div class=""><img apple-inline="yes" id="9085ADED-270C-46C3-9E38-1EDA3A3674FC" width="302" height="182" src="cid:DFA79FFF-4479-47CB-8253-53D51A9D21FF" class=""></div><div class=""><br class=""></div><div class="">Mittels MXTOOLBOX habe ich die Domain getestet (<a href="http://imap.normalfilter.de" class="">imap.normalfilter.de</a>).</div><div class="">und bekomme das keine Fehler angezeigt. :</div><div class=""><br class=""></div><div class=""><img apple-inline="yes" id="B23347D8-887F-4C6E-A859-3BF2200466BB" width="241" height="260" src="cid:9780D6E9-5B77-4D9E-B991-B0C0C7A8B1DF" class=""></div><div class=""><br class=""></div><div class="">Könnte vielleicht ein Zertifikats- oder DNS-Problem sein?</div><div class=""><br class=""></div><div class="">Ich danke für Hilfe im voraus.</div><div class=""><br class=""></div><div class="">Grüße</div><div class=""><br class=""></div><div class="">Christoph</div><div class=""><br class=""></div><div class=""><span class=""><br class=""><blockquote type="cite" class="">Am 24.06.2024 um 12:34 schrieb Christoph Kukulies via Dovecot <<a href="mailto:dovecot@listen.jpberlin.de" class="">dovecot@listen.jpberlin.de</a>>:<br class=""><br class=""><br class=""><br class=""><blockquote type="cite" class="">Am 24.06.2024 um 12:08 schrieb Markus Winkler via Dovecot <<a href="mailto:dovecot@listen.jpberlin.de" class="">dovecot@listen.jpberlin.de</a>>:<br class=""><br class="">Hallo Christoph,<br class=""><br class="">danke für die Configs. Bist Du Dir sicher, dass die Ausgabe von 'doveconf -n' komplett war?<br class=""></blockquote><br class="">Ja, habe es eben noch mal verglichen.<br class=""><br class="">postconf -M >/tmp/postconf-M<br class="">doveconf -n >/tmp/doveconf-n<br class=""><br class="">und die hatte ich geschickt.<br class=""><br class=""><blockquote type="cite" class=""><br class="">Und: Welchen Inhalt haben diese Files (DB-PWs natürlich nicht mitschicken):<br class=""><br class="">- /etc/postfix/virtual/mysql-aliases.cf<br class=""></blockquote><br class="">user = vmail<br class="">password = geheim<br class="">hosts = 127.0.0.1<br class="">dbname = vmail<br class="">query = SELECT destination FROM aliases WHERE source='%s'<br class=""><br class=""><br class=""><blockquote type="cite" class="">- /etc/postfix/virtual/mysql-domains.cf<br class=""></blockquote><br class="">user = vmail<br class="">password = geheim<br class="">hosts = 127.0.0.1<br class="">dbname = vmail<br class="">query = SELECT * FROM domains WHERE domain='%s'<br class=""><br class=""><blockquote type="cite" class="">- /etc/postfix/virtual/mysql-maps.cf<br class=""></blockquote><br class="">user = vmail<br class="">password = geheim<br class="">hosts = 127.0.0.1<br class="">dbname = vmail<br class="">query = SELECT * FROM users WHERE username='%u' AND domain='%d'<br class=""><br class=""><blockquote type="cite" class="">- /etc/dovecot/conf.d/auth-sql.conf.ext<br class=""></blockquote><br class=""># Authentication for SQL users. Included from 10-auth.conf.<br class="">#<br class=""># <doc/wiki/AuthDatabase.SQL.txt><br class=""><br class="">passdb {<br class=""> driver = sql<br class=""><br class=""> # Path for SQL configuration file, see example-config/dovecot-sql.conf.ext<br class=""> args = /etc/dovecot/dovecot-sql.conf.ext<br class="">}<br class=""><br class=""># "prefetch" user database means that the passdb already provided the<br class=""># needed information and there's no need to do a separate userdb lookup.<br class=""># <doc/wiki/UserDatabase.Prefetch.txt><br class="">#userdb {<br class=""># driver = prefetch<br class="">#}<br class=""><br class="">userdb {<br class=""> driver = sql<br class=""> args = /etc/dovecot/dovecot-sql.conf.ext<br class="">}<br class=""><br class=""># If you don't have any user-specific settings, you can avoid the user_query<br class=""># by using userdb static instead of userdb sql, for example:<br class=""># <doc/wiki/UserDatabase.Static.txt><br class="">#userdb {<br class=""> #driver = static<br class=""> #args = uid=vmail gid=vmail home=/var/vmail/%u<br class="">#}<br class=""><br class=""><br class=""><br class="">Grüße<br class="">Christoph<br class=""><br class=""></blockquote><br class=""></span></div></body></html>