- Mailman-users - lists.mailman3.org

moving from sqlite3 to postgresql
by Michael Richardson April 18, 2025

April 18, 2025

Hi, I installed mailman3 a few years ago on lists.sandelman.ca aka lists.tcpdump.org. My upgrade was in part a response to the HTTP based attacks that used the signup form on mailman2 to attack people via SMTP with DOS. I know the IETF mailman2 install {now gone} had some kind of delay implemented in the web form before you could submit. I didn't understand why. I installed via debian packages, and I'd really prefer to stay with that. (Not what many maintainers would say, I know. Essential that it work if mailman3 is going to take over) There were problems, probably with the hyperkitty integration with subsequent updates seemed to solve. I installed with sqlite3, since it seemed if all work was going to go through the mailman3 daemon, that it would handle all the concurrency issues. This has not been the case. I get weekly complaints about the database being locked. Sometimes this goes way on it's own, but sometimes it does not. A good way to tickle this is to go the web interface, go to a list with 200 held messages, and then having told it to show me 100+ messages per page, to then tell it to discard them all. So slow. Before I realized what was going on, I'd open multiple tabs to try to make this concurrent. So I tried to switch last week from sqlite3 to postgresql. I used pgloader with a configuration file attached below. This seemed easier than a sqlite3 dump/psql, as the SQL requires some massaging that seeemed to require more brainpower than I had at the time. I then edited /etc/mailman3/mailman.cfg to suit. I had set up the postgresql database under the "list" owner, so unix-domain socket permissions, and restarted. I then saw some errors: lists not found! I visited the web interface. NO LISTS. DAMN. I put it back. I haven't figured out what went wrong yet. I will clone the VM and try again. I will report whatever I find here. === load database from '/var/lib/mailman3/mailman.db' into postgresql:///mailman3 with include drop, create tables, create indexes, reset sequences set work_mem to '16MB', maintenance_work_mem to '512 MB'; === ps: I'd pay some $$ money for email support consulting.

3 2

Do you struggle with message rejected. AUP#CDRBL while using mailman with your ISP email relay?
by Michael Richardson April 18, 2025

April 18, 2025

I'm impressed by Philip Bondi's use of mailman[23] for home financial automation. ("Take off Eh!") ... It seems like a ticketing system would be a better system for such a use... maybe the IETF SML WG will further help with this.. (I find most Canadian financial institutions are so far behind the curve) I think that your email is hosted by hostedemail.com? I'm guessing that "eshop" is the mailbox you use for these common notices, and maybe you retrieve that into your mailman3 with fetchmail or something? Or does your ISP turn around and SMTP to you directly? Is it your MTA, their MTA, or mailman that is doing the rejection? My problem, on lists.sandelman.ca aka lists.tcpdump.org, is messages that appear to have been processed by my MTA (according to postfix logs), but which are never delivered, nor held. Lost somewhere in mailman3 queue. Sometimes they show up after a host reboot.

3 2

Setup Question: Disk-Layout (Migrating from Mailman 2.1)
by christian.schneider＠tu-dortmund.de April 18, 2025

April 18, 2025

Hello, actually I am running the latest available Mailman-2 Version on Ubuntu 20.04! Now it is really time to move on! :-) I want to set up a new server (Ubuntu-24.04) and install Mailman-3 with the Virtualenv setup method: https://docs.mailman3.org/en/latest/install/virtualenv.html As I know from my old Mailman-2.1 the archives could get quite big... ;-) So it seems very important to provide enough (expandable) disk space at the right place. (I plan to use a seperate partition with LVM for the path in question) But I could find no information about the location where hyperkitty stores the archives on an Ubuntu-/Linux-system. I assume the archives are stored underneath "/var/..." this is only a guess. But is this guess right? Another question is: How much space do I have to plan (roughly) for the "/opt"-partition for the mailman install if the archives are stored under "/var/..."? Any guidance ist very much appreciated! Thank you very much Chris

6 13

Do you struggle with message rejected. AUP#CDRBL while using mailman with your ISP email relay?
by Philip Bondi April 17, 2025

April 17, 2025

Hello to all: mailman3 is phenomenal upgrade from mailman2. Very nice. Thank you to the team. In our family, we use mailman to provide redundancy on important financial emails. In this manner, emails from banks, government, ecommerce or other important providers are distributed to multiple family members. And we can ask family members if they paid the credit card bill, received their delivery, saw their tax liability or refund notification, etc. Does anyone else use mailman for such a purpose? Do you struggle with "message rejected. AUP#CDRBL" while using mailman with your ISP email relay? For example, when receiving email from a Bank or the Government of Canada on a mailman2 list, sometimes my ISP would not relay the email and I would get message rejected. AUP#CDRBL On mailman2, I mitigated by stripping headers, wrapping message and DKIM signing. Here is a mailman2 message that is stripped, wrapped and signed. https://freeimage.host/i/30O5EXe Do you have this problem with your ISP with certain senders? What are your mitigation strategies on mailman3?

3 3

makemigrations --merge error after Debian upgrade
by Chupin Maxime April 16, 2025

April 16, 2025

Hi, I upgraded my debian version, and since, it seems that I have a problem. I tried `mailman-web migrate` (and `mailman-web collectstatic` etc.) and I get the error message: ``` CommandError: Conflicting migrations detected; multiple leaf nodes in the migration graph: (0010_auto_20220618_2315, 0014_schedule_cluster in django_q; 0014_auto_20220618_2315, 0018_alter_emailtemplate_language in postorius). To fix them run 'python manage.py makemigrations --merge' ``` So I tried `mailman-web makemigrations --merge` that ended with ``` PermissionError: [Errno 13] Permission denied: '/usr/lib/python3/dist-packages/postorius/migrations/0019_merge_20240930_1159.py' ``` There is no such a file in the migration directory. Any idea ? Thanks in advance, All the best Maxime Chupin

7 28

how should I implement multiple domains for receiving emails to a list
by Philip Bondi April 16, 2025

April 16, 2025

Hello to all: I think I have resolved almost all of my issues. Thank you for your coaching. You are all super heroes. I have two domains: systemdatabase.ca, systemdatabase.homelinux.com All my lists should be on both domains. So h(a)systemdatabase.ca is the same list as h(a)systemdatabase.homelinux.com. I found this was the mailman2 behaviour on my old CentOS 7 installation and I am accustomed to it. I edited /opt/mailman/venv_mm/var/data/postfix_lmtp directly. Duplicated and edited all the lines. And compiled with postmap /opt/mailman/venv_mm/var/data/postfix_lmtp I sent a test email. This appears to work. Is this the best method to achieve this goal? What would you recommend?

2 2

Unable to ban users via mailman-shell
by Mihai Moldovan April 13, 2025

April 13, 2025

Hi I can't seem to be able to add bans via mailman-shell: # mailman-wrapper shell Welcome to the GNU Mailman shell >>> from mailman.testing.documentation import dump_json >>> from mailman.interfaces.mailinglist import IMailingList >>> from zope.component import getUtility >>> list_manager = getUtility(IListManager) >>> mlist = list_manager.get('x2go-commits(a)lists.x2go.org') >>> bans = IBanManager(mlist) >>> new_bans = ["really", "long", "list", "with", "addresses", "I'd", "like", "to", "ban"] >>> for new_ban in new_bans: ... bans.ban(new_ban) ... >>> for ban in bans: ... print('{0}: {1}'.format(ban.list_id,ban.email)) ... [long list of bans] >>> exit() # mailman-wrapper shell Welcome to the GNU Mailman shell >>> from mailman.testing.documentation import dump_json >>> from mailman.interfaces.mailinglist import IMailingList >>> from zope.component import getUtility >>> list_manager = getUtility(IListManager) >>> mlist = list_manager.get('x2go-commits(a)lists.x2go.org') >>> bans = IBanManager(mlist) >>> for ban in bans: ... print('{0}: {1}'.format(ban.list_id,ban.email)) ... >>> exit() GNU Mailman 3.3.8 (Tom Sawyer), installed on Ubuntu 24.04 via distro packages (yes, they are completely broken; yes, I had to backport fixes from your Gitlab instance to even get this properly installed and working; yes, I think I can handle this) What could possibly be the cause of this? I don't even see any calls to the REST API for each bans.ban() call. Should I see those? Or is bans.ban() directly modifying the database? I skimmed the source code and it looks like as if IBanManager and the concrete BanManager model seem to work directly on a DB connection, so I assume that it's not going through REST. If that is the case (I'm using sqlite3, nothing fancy), why doesn't it stick? Do I have to commit changes somehow? Mihai

3 5

CSS Hyperkitty ERROR
by Johan Alsina April 12, 2025

April 12, 2025

Hi, i installed mailman3 with virtualenv, all is working fine, the admin site works fine, the mailman(postorious) site works fine, but when im in hyperkitty the site shows without the css style.. in my web browser dev tool it shows like they loaded ok.. Here you can see what i see when loading hyperkitty https://freeimage.host/i/3n6kXKQ and mailman(postorius) https://freeimage.host/i/mailman.3n6kVix When i run my server with verbosity it shows like all is loading ok: https://freeimage.host/i/3n6SViG Any ideas? :/ My static files are loading from /static/CACHE/css/output.a0f71925131b.css and /static/hyperkitty/libs/fonts/font-awesome/css/font-awesome.min.css It seems like the real error are in the /static/CACHE files, because hyperkitty is the only one who load files from this directory.. postorius uses /static/postorius and all the css files are working fine. I checked permissions for the directory, cleared cache, etc.. i dont know what to do. This is my config for staticfiles: STATIC_URL = 'static/' STATIC_ROOT = os.path.join(BASE_DIR, 'staticfiles') STATICFILES_DIRS = [ os.path.join(BASE_DIR, 'static'), '/opt/mailman/projectes/mailman3web/static/CACHE', Thank you so much in advance.

5 9

Can't post to my own list from HyperKitty
by megabrutal＠gmail.com April 11, 2025

April 11, 2025

Hi Everyone, I've recently installed Mailman3 and still testing it. I tried to reply to a topic on my own list while also being a superuser from HyperKitty, but I got this error message: "This list is moderated, please subscribe to it before posting." Then why I even see the archive of the private list? What might be wrong? One thing that might confuse the system is that I added a secondary e-mail to my account. I thought it would allow me to post from any of my addresses, but it seems like it's not the case, looks like I can only subscribe with one of the addresses. It also looks like HyperKitty has trouble matching up the addresses, as it lists 4 participants for the conversation, while 2 of them is my account, the other 2 is my test address. In reality, it should list 2 posters. Best regards, MegaBrutal

4 19

Missing styling on select pages
by grodriguez＠usra.edu April 9, 2025

April 9, 2025

Hello all, I installed mailman3 on Rocky Linux 9 via the Virtualenv Installation installation guide. I configured Apache httpd to proxy gunicorn. For the most part, everything is looking good except for some select pages that do not contain the styling like all other pages. When a user sees the "Verify Your Email Address" screen, it's without any of the styling. /accounts/confirm-email/ Same for when a user tries to reset their password. The initial screen looks good (with styling), but after entering the email address and clicking "Reset My Password", the following screen is bare. /accounts/password/reset/done/ I have Mailman 3.3.10, Postorius Version 1.3.13, and HyperKitty version 1.3.12. Any suggestions?

2 2