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:
1. the id of the django_mailman3_maildomain entry
2. the mail_domain in the django_mailman3_maildomain entry
3. the site_id the django_mailman3_maildomain entry
4. the id of the django-site entry
5. the domain name in the django-site entry
6. 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
_______________________________________________
Mailman-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at:
https://lists.mailman3.org/archives/list/[email protected]/message/J6WTSX65SFH2HMZQEMKCVMMKDZSWAMQO/
This message sent to [email protected]
