On 10/10/25 3:46 PM, Flo via Mailman-users wrote:
I found it, it's in a different directory:
/var/lib/mailman3/web# sqlite3 mailman3web.db SQLite version 3.46.1 2024-08-13 09:16:08 Enter ".help" for usage hints. sqlite> SELECT * from django_mailman3_maildomain JOIN django_site ON site_id = django_site.id; ... ... 8|lists.example.com|7|7|Lists of Example|lists.example.com sqlite>
The two working domains are first (...) . The problematic domain (renamed to lists.example.com) appears when I create it in Postorius.
For me the only conspicuous is that the numbers are 8|.|7|7 while at the other two entries they are the same for the whole line: 2|.|2|2 and 4|.| 4|4 .
The fields in order are:
- the id of the django_mailman3_maildomain entry
- the mail_domain in the django_mailman3_maildomain entry
- the site_id the django_mailman3_maildomain entry
- the id of the django-site entry
- the domain name in the django-site entry
- the display name in the django-site entry
The important things are 2. and 5. which are the mail host and the web host that you see in the Postorius domains view. 3. and 4. are what we joined on so they will always be the same. They aren't related to 1. which is just sequentially assigned when entries are created. 1., 3. and 4. being equal in some cases is a coincidence.
The question is what are the other 2 entries. In particular are all 3 values for 2. different and all 3 values for 5. different or are some the same?
If 2 of those entries have the same value for 5. and different values for 2., that explains the issue when accessing Postorius at 5. because that web host does not have a unique mail host.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan