On 10/11/25 04:45, Mark Sapiro wrote:
On 10/10/25 3:46 PM, Flo via Mailman-users wrote:
/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 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
For me it looks like that 5 is the display name and 6 the domain name
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.
For each of the lines mail_domain (field 2) is the same as the domain name (field 6, if I am right). Any domain name (and mail_domain, which has the same value) differs from the ones in any other line.
So they are unique.
Flo