<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Danke, Markus, Christian. Entschuldigt die späte Rückmeldung. Hab's hinbekommen. Ich mußte einen Eintrag in /etc/postfix/virtualUsers hinzufügen:<br class=""><br class=""><a href="mailto:smtp@mydomain.org" class="">smtp@mydomain.org</a> kuku<br class=""><br class="">Muß ich danach die Datenbank neu erzeugen (virtualUsers.db)? Es hatte nicht den Anschein. <div class=""><br class=""><blockquote type="cite" class="">Am 20.08.2025 um 17:58 schrieb Christian Boltz <<a href="mailto:dovecot-jpb@cboltz.de" class="">dovecot-jpb@cboltz.de</a>>:<br class=""><br class="">Hallo Christoph, hallo zusammen,<br class=""><br class="">Am Mittwoch, 20. August 2025, 11:01 schrieb Christoph Kukulies via <br class="">Dovecot:<br class=""><blockquote type="cite" class="">Ich habe mit dem vmail_admin.sh script einen alias user<br class="">'<a href="mailto:smtp@mydomain.tld" class="">smtp@mydomain.tld</a>" angelegt. <br class=""></blockquote>[...]<br class=""><blockquote type="cite" class="">Nein, ich muß sagen, das wolte ich, aber das Skript funktioniert nicht <br class="">für die Verwaltung von aliases (weil die column-Namen andere sind).<br class=""></blockquote>[...]<br class=""><blockquote type="cite" class="">Habe aleo den Alias per MySQL-Befehle von Hand eingetragen. Der wird<br class="">auch mit "SELECT * FROM alias" gelistet.<br class=""><br class="">Meine Datenbank hat folgende Struktur:<br class=""></blockquote><br class="">Diese Datenbankstruktur sieht nach PostfixAdmin aus :-)<br class=""><br class="">Bei PostfixAdmin gibt es auch postfixadmin-cli für die Kommandozeile. <br class=""></blockquote><div class=""><br class=""></div><div class=""><br class=""></div>Hatte postfixadmin nicht installiert (Ubuntu 22.04) und wollte es gerade nachholen, hänge aber gerade an der Frage:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; background-color: rgb(161, 0, 163); min-height: 11px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; background-color: rgb(161, 0, 163); min-height: 11px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; background-color: rgb(161, 0, 163); min-height: 11px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; background-color: rgb(161, 0, 163); min-height: 11px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">┌─────────────────────────────────────────────────────────────────────────────────────────┤ </span><span style="font-variant-ligatures: no-common-ligatures; color: #850002" class="">Configuring postfixadmin</span><span style="font-variant-ligatures: no-common-ligatures" class=""> ├─────────────────────────────────────────────────────────────────────────────────────────┐</span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ The postfixadmin package must have a database installed and configured before it can be used. This can be optionally handled with dbconfig-common. │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ If you are an advanced database administrator and know that you want to perform this configuration manually, or if your database has already been installed and configured, you should refuse this option. │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ Details on what needs to be done should most likely be provided in /usr/share/doc/postfixadmin. │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ Otherwise, you should probably choose this option. │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ Configure database for postfixadmin with dbconfig-common? │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ </span><span style="font-variant-ligatures: no-common-ligatures; color: #b2b2b2; background-color: #850002" class=""><Yes></span><span style="font-variant-ligatures: no-common-ligatures" class=""> <No> │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">│ │</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0); background-color: rgb(178, 178, 178);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class="">└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘</span><span style="font-variant-ligatures: no-common-ligatures; color: #dfdfdf; background-color: #000000" class=""> </span></div><p style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; color: rgb(223, 223, 223); background-color: rgb(0, 0, 0); min-height: 11px;" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #ffffff; background-color: #a100a3" class=""> </span><span style="font-variant-ligatures: no-common-ligatures" class=""> </span><br class="webkit-block-placeholder"></p><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; background-color: rgb(161, 0, 163); min-height: 11px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; font-size: 10px; line-height: normal; font-family: Menlo; background-color: rgb(161, 0, 163); min-height: 11px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><span class=""><div class=""><span class=""><br class=""></span></div><div class=""><span class=""><br class=""></span></div>Kann ich mir da was kaputt machen?<br class=""></span><span class=""><br class=""></span><span class=""><br class=""></span><blockquote type="cite" class="">Spricht irgendwas dagegen, das zu benutzen?<br class="">Im Vergleich zu einem nur halb funktionierenden Script sollte das eine <br class="">deutliche Verbesserung sein ;-) (und es füllt auch garantiert alle <br class="">Spalten richtig)<br class=""><br class=""><br class="">Ansonsten schließe ich mich Markus an - mit mehr Infos besteht auch eine <br class="">Chance, dass Dir jemand beim eigentlichen Problem helfen kann.<br class=""><br class="">SELECT * FROM alias WHERE address = '<a href="mailto:smtp@mydomain.tld" class="">smtp@mydomain.tld</a>';<br class=""></blockquote><br class=""><font face="Menlo" size="1" class="">mysql> select * from alias where address="<a href="mailto:smtp@mydomain.org" class="">smtp@mydomain.org</a>";<br class="">+-------------------+-------------------+--------------+---------------------+---------------------+--------+<br class="">| address | goto | domain | created | modified | active |<br class="">+-------------------+-------------------+--------------+---------------------+---------------------+--------+<br class="">| <a href="mailto:smtp@mydomain.org" class="">smtp@mydomain.org</a> | <a href="mailto:kuku@mydomain.org" class="">kuku@mydomain.org</a> | <a href="http://mydomain.org" class="">mydomain.org</a> | 2025-08-20 00:00:00 | 2025-08-20 00:00:00 | 1 |<br class="">+-------------------+-------------------+--------------+---------------------+---------------------+--------+<br class="">1 row in set (0.00 sec)</font><br class=""><br class=""><blockquote type="cite" class="">wäre auch noch interessant (ggf. anonymisiert, solange Du "sinnvoll" <br class="">anonymisierst).<br class=""><br class=""></blockquote>Grüße</div><div class="">--</div><div class="">Christoph</div><div class=""><br class=""></div></body></html>