Changes in Django admin interface are not syncing to postorius gui /database
Hello, I have the lasted version of mailman3 in an fresh venv installation and I am testing it for our upcoming migration from v2.1.
When I add a new list in the django admin interface this list will never appear in postorius (vice versa it works). The new list is also not in both databases: SELECT * FROM mailman.mailinglist; SELECT * FROM mailmanweb.hyperkitty_mailinglist; (Why two databases are needed with redundant data?)
The same when changing for example the description of an existing list in the django admin interface it doesn't change the description of the list in postorius. Vice versa it works. Changes made in postorius are also seen in django.
Could please someone help me or explain this behavior? I hope it is a problem with my configuration.
Thank you and regards, Ulf
On Sat, Nov 9, 2024 at 4:58 PM <ulf.rapphahn@offis.de> wrote:
Hello, I have the lasted version of mailman3 in an fresh venv installation and I am testing it for our upcoming migration from v2.1.
When I add a new list in the django admin interface this list will never appear in postorius (vice versa it works). The new list is also not in both databases: SELECT * FROM mailman.mailinglist; SELECT * FROM mailmanweb.hyperkitty_mailinglist; (Why two databases are needed with redundant data?)
The same when changing for example the description of an existing list in the django admin interface it doesn't change the description of the list in postorius. Vice versa it works. Changes made in postorius are also seen in django.
Could please someone help me or explain this behavior? I hope it is a problem with my configuration.
Interesting.
I looked at Django Admin and Postorius and I see all my MLs in both. What I am sure about is that I did NOT create my MLs using Django admin UI. I either created them using the CLI or Postorius. Having said that, I did run two tests:
- Create a ML in Postorius and check whether it appears in Django admin - The list was visible in Django Admin
- Create a ML in Django admin and check whether it appears in Postorius - The list was NOT visible in Postrorius
- Create a ML in CLI and check if it appears in both Django admin and Postorius - List is visible in Postorius, but not in Django admin
MariaDB [mailmansuite]> select list_name, list_id from mailinglist where
list_name like 'ulf%';
+-----------+-------------------------------+
| list_name | list_id |
+-----------+-------------------------------+
| ulftest2 | ulftest2.lists.kictanet.or.ke |
| ulftest3 | ulftest3.lists.kictanet.or.ke |
+-----------+-------------------------------+
The list that I created using Django admin is NOT listed here!
MariaDB [mailmansuite]> select list_id, name from hyperkitty_mailinglist
where list_id like 'ulf%';
+-------------------------------+-------------------------------+
| list_id | name |
+-------------------------------+-------------------------------+
| ulftest1@lists.kictanet.or.ke | ulftest1@lists.kictanet.or.ke |
| ulftest2.lists.kictanet.or.ke | ulftest2@lists.kictanet.or.ke |
+-------------------------------+-------------------------------+
The list I created using Django admin and the one I created using Postorius are both listed, but the one I created from CLI is not listed.
So there must be some logic behind this. However, I don't know what it is.
What appears to me is that there is NO problem with your configuration :-)
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
On 11/9/24 06:52, Odhiambo Washington via Mailman-users wrote:
I looked at Django Admin and Postorius and I see all my MLs in both.
What you see in Django admin is in the HYPERKITTY section and corresponds to hyperkitty_* tables in the mailmanweb database.
What I am sure about is that I did NOT create my MLs using Django admin UI. I either created them using the CLI or Postorius. Having said that, I did run two tests:
- Create a ML in Postorius and check whether it appears in Django admin - The list was visible in Django Admin
Because the list you created had the hyperkitty archiver enabled.
- Create a ML in Django admin and check whether it appears in Postorius - The list was NOT visible in Postrorius
Because it's only in HyperKitty.
- Create a ML in CLI and check if it appears in both Django admin and Postorius - List is visible in Postorius, but not in Django admin
Becayse this list did not have the hyperkitty archiver enabled.
MariaDB [mailmansuite]> select list_name, list_id from mailinglist where list_name like 'ulf%'; +-----------+-------------------------------+ | list_name | list_id | +-----------+-------------------------------+ | ulftest2 | ulftest2.lists.kictanet.or.ke | | ulftest3 | ulftest3.lists.kictanet.or.ke | +-----------+-------------------------------+
These are only Mailman lists.
The list that I created using Django admin is NOT listed here!
Because it's only in HyperKitty.
MariaDB [mailmansuite]> select list_id, name from hyperkitty_mailinglist where list_id like 'ulf%'; +-------------------------------+-------------------------------+ | list_id | name | +-------------------------------+-------------------------------+ | ulftest1@lists.kictanet.or.ke | ulftest1@lists.kictanet.or.ke | | ulftest2.lists.kictanet.or.ke | ulftest2@lists.kictanet.or.ke | +-------------------------------+-------------------------------+
The list I created using Django admin and the one I created using Postorius are both listed, but the one I created from CLI is not listed.
Because for some reason, the CLI created list does not create the
HyperKitty archive until there is a post or until the
new_lists_from_mailman
job runs even though hyperkitty is enabled.
So there must be some logic behind this. However, I don't know what it is.
The bottom line is you can have lists in HyperKitty that are not in Mailman and vice versa. The only thing you can't do is create a list in HyperKitty via the HyperKitty web UI, but you can use hyperkitty_import to import a mbox for a list which is not in Mailman and will be only in HyperKitty.
Also, while you can create a list in Mailman that isn't in HyperKitty,
if the list has hyperkitty enabled it will be created in HyperKitty when
the new_lists_from_mailman
job runs.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
On 11/9/24 05:32, ulf.rapphahn@offis.de wrote:
Hello, I have the lasted version of mailman3 in an fresh venv installation and I am testing it for our upcoming migration from v2.1.
When I add a new list in the django admin interface this list will never appear in postorius (vice versa it works).
Because the mailing lists in the Django admin interface are HyperKitty Lists, not Mailman lists. When you create a list in Postorius or Mailman core, this is a Mailman list. A corresponding HyperKitty list will also be created if hyperkitty is one of the active archivers for the list so you see it in Django.
When you create a list in Django, it is only a HyperKitty list and will be visible in HyperKitty, but no Mailman list is created so the list is not in Mailman/Postorius.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mark Sapiro wrote:
Lists, not Mailman lists. When you create a list in Postorius or Mailman core, this is a Mailman list. A corresponding HyperKitty list will also be created if hyperkitty is one of the active archivers for the list so you see it in Django. When you create a list in Django, it is only a HyperKitty list and will be visible in HyperKitty, but no Mailman list is created so the list is not in Mailman/Postorius. Thank you (also for Odhiambo) Now remains one question: We have a (internal) Active Directory (AD) Authentication for Mailman3. So everyone who wants to work as an owner nor moderator must be an AD-User. In hyperkitty I am able to assign these list rights directly to AD-Loginnames. With the logic above I have to assign these rights in postorius too by assining the mail address of the users AD-Account? (I see no AD-Data here). Or would it works to assing the mail address of the users AD-Account first an then the allocation will automaticly synced to hyperkitty - maybe using the mail address as key? What would be the best practice for owner/moderator user management? Thank you!
Thank you (also for Odhiambo) Now remains one question: We have a (internal) Active Directory (AD) Authentication for Mailman3. So everyone who wants to work as an owner nor moderator must be an AD-User. In hyperkitty I am able to assign these list rights directly to AD-Loginnames. With the logic above I have to assign these rights in postorius too by assining the mail address of the users AD-Account? (I see no AD-Data here). Or would it works to assing the mail address of the users AD-Account first an then the allocation will automaticly synced to hyperkitty - maybe using the mail address as key? What would be the best practice for owner/moderator user management? Thank you!
On Mon, Nov 11, 2024 at 3:17 PM Ulf R. <ulf.rapphahn@offis.de> wrote:
Thank you (also for Odhiambo) Now remains one question: We have a (internal) Active Directory (AD) Authentication for Mailman3. So everyone who wants to work as an owner nor moderator must be an AD-User. In hyperkitty I am able to assign these list rights directly to AD-Loginnames. With the logic above I have to assign these rights in postorius too by assining the mail address of the users AD-Account? (I see no AD-Data here). Or would it works to assing the mail address of the users AD-Account first an then the allocation will automaticly synced to hyperkitty - maybe using the mail address as key? What would be the best practice for owner/moderator user management? Thank you!
Hi,
TBH, I am clueless about MM3 integration with LDAP/AD. Google leads me to a feature request: https://gitlab.com/mailman/django-mailman3/-/issues/27 But the Devs have the final say on the available possibilities.
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
On 11/11/24 04:17, Ulf R. wrote:
Now remains one question: We have a (internal) Active Directory (AD) Authentication for Mailman3. So everyone who wants to work as an owner nor moderator must be an AD-User. In hyperkitty I am able to assign these list rights directly to AD-Loginnames. With the logic above I have to assign these rights in postorius too by assining the mail address of the users AD-Account? (I see no AD-Data here).
You are conflating Postorius, which is simply a web management UI for Mailman core, with Mailman core itself. I suppose it's not really important, but when you think of access rights in Postorius, these are actually in mailman core.
Or would it works to assing the mail address of the users AD-Account first an then the allocation will automaticly synced to hyperkitty - maybe using the mail address as key? What would be the best practice for owner/moderator user management?
Just ensure that list owners and moderators are using the email address of their AD-Account. This will propagate to HyperKitty. You shouldn't need to manipulate HyperKitty access rights directly at all.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (4)
-
Mark Sapiro
-
Odhiambo Washington
-
Ulf R.
-
ulf.rapphahn@offis.de