- Mailman-users - lists.mailman3.org

Internal Server Error: /mailman3/postorius/lists/.../held_messages - humanize: where to put?
by Flo Sept. 15, 2025

Sept. 15, 2025

Hi, I have setup in Debian Trixie mailman3-full and came that far, that I have created a mailing list. I can sent emails to the members. However when I send from an email which is non-member the message is held. If I want to accept this message as list admin, I get: `An error occurred while processing your request.` And I get an email: `Internal Server Error: /mailman3/postorius/.../held_messages TemplateSyntaxError at /postorius/lists/.../held_messages 'humanize' is not a registered tag library. Must be one of: account admin_list admin_modify admin_urls allauth bootstrap_tags cache compress d_gravatar date_helpers debugger_tags decorate gravatar highlight highlighting hk_generic hk_haystack i18n indent_text l10n log markdown membership_helpers more_like_this nav_helpers p_gravatar pagination postorius_helpers rest_framework socialaccount static syntax_color tz widont Request Method: GET Request URL: https://.../mailman3/postorius/lists/.../held_messages Django Version: 4.2.23 Python Executable: /usr/bin/uwsgi-core Python Version: 3.13.5 Python Path: ['.', '', '/usr/lib/python313.zip', '/usr/lib/python3.13', '/usr/lib/python3.13/lib-dynload', '/usr/local/lib/python3.13/dist-packages', '/usr/lib/python3/dist-packages', '/usr/lib/python3/dist-packages/setuptools/_vendor'] . . .` humanize is in the INSTALLED_APPS section in /usr/share/mailman3-web/settings.py. In this file I I configured Django. However it's not in the Python path as written in the error email above. So maybe I have to find a different settings file. Can anyone advise me where I can find the error I have in my configuration? Thanks in advance. Flo

4 6

Postgres upgrade from 13 to 16?
by Dave McGuire Sept. 14, 2025

Sept. 14, 2025

Hi folks, we're running a decent-sized MM3 server backed by a Postgres database server that is also used by a number of other applications. It's currently running Postgres 13, and we are looking at upgrading to 16. Can anyone tell me what the implications of such an upgrade be in the context of Mailman3? Any gotchas? Thanks, -Dave -- Dave McGuire, AK4HZ New Kensington, PA

3 3

Problems with SPOOFED_UNAUTH
by M.Ede Sept. 14, 2025

Sept. 14, 2025

Hello everyone, I use mailman together with mailcow and have configured my mailing list as follows: - Anonymous list: Yes - DMARC mitigation action: Replace From: with list address - DMARC Mitigate unconditionally: Yes My problem is that my emails are not being accepted by mailcow (rspamd) with the error SPOOFED_UNAUTH (50.00) In the out-queue of mailman the headers look like this: [QUOTE] Authentication-Results: <my.mailserv.er>; dkim=none; spf=pass (<my.mailserv.er>: domain of sender(a)t-online.de designates 194.25.134.81 as permitted sender) smtp.mailfrom=sender(a)t-online.de; dmarc=pass (policy=none) header.from=t-online.de ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=lists.<list.domain>; s=dkim; t=1757400255; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=zmDaIaGeCj1IT8TuP4aJmXRbfyNHV3LqjIfHveVMS0M=; b=Im4F/mpchty4CJvvcW4ZqxMl0BRNnybjcmkPboUSuodopd7nOXaesj3w6kgIwZkLHn1uHY FOiSSjyfZ8Zu0/w4l4Du5uoij2qDCEYHvGFhEugFizE9HJ71i7x0SzoEVSZ9uve6sqnWaE X8+GqtCE+vf0TLLeKhXKHJaBdltbMSqO+QT0BOlbmOdvmUCy6MIqysocTod9io5/+CQOgd SSvsSdDq00CG1IBUsg0Tm2rSf/L2bpGD3bl7QEBKS2id7NeLFM/Zme/3mkHo0N/u7m47xy XSLS9R0C3Kg/YxHY8ctPt7Yas6fwYfzGAOXRvVJz1eeXSrl8B5vWfzJ8+WrE5Q== ARC-Authentication-Results: i=1; <my.mailserv.er>; dkim=none; spf=pass (<my.mailserv.er>: domain of sender(a)t-online.de designates 194.25.134.81 as permitted sender) smtp.mailfrom=sender(a)t-online.de; dmarc=pass (policy=none) header.from=t-online.de ARC-Seal: i=1; s=dkim; d=lists.<list.domain>; t=1757400255; a=rsa-sha256; cv=none; b=yrD6cRE7c/L/v8D76U5Ohn57/MJ7/VsObkzQdAHbFny5DbyEO8pZvM0VCVYA5hUGXqoqoU nnKpEW6/CqvNIZmsS9hKzQQEdO5yIzNnyYjARcW5w5MpAlkMjmH3dQ68mLIS9SUyXUsoXj m1zAeYmdTjZWQOiYanaNJLRuxCWSFQHOpAljZe/lZt+4llNNA01YqirqGBRe6uMaJoebe6 2ubsHTr6VlfTrBrdFqLLSWyRBls+e0JwOd2jGahaQ6/ZIf4l1dOqdaUHSq31RjEDAiofmK IGeKC97iu3r9LiFsjICyi+/yedMGbwSeyyFMzz+cAV7wM84eWfSx2S2kPP1c9Q== [END QUOTE] When the email arrives at rspamd for verification, the DKIM header is added, but there is also the entry: arc=reject ("signature check failed: fail, {[1] = sig:lists.list.domain:reject}"): [QUOTE] DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lists.list.domain; s=dkim; t=1757413251; h=from:reply-to:subject:date:message-id:to:mime-version:content-type: content-transfer-encoding:content-language:list-id:list-help: list-owner:list-unsubscribe:list-subscribe:list-post; bh=jH/b69qzW7O+s5h3yE2MxKTwFLElX7b39ILc9yHGhkc=; b=AApU4mb2iuN9u1lYTrIKIcPnB4jzXDX+8vC+2/WwHC8JvCukiR2Std5k3E10cuAyYFhPVk zn6AWY+s6c6HKslDn0RiO3i9QYRLAY5MESxvj0tKO1dKDMz+A8RdcOf4kdO4hDr0DQBf7v yQLLnLjgK8QpZdW8MrlfxcQpQ9XrlyP2GX+ntFh5vDl7frNPXQfnBMoo+l0DIs6SWQuaFX ikrOiISYKugL8TmWXnGohXiAM84W/JT0lvP/Lmt3NjxlyNsAWpHQz736LphydY4r5/JjHI of99pRcbTvEmkZogthHFaXMOG2sDGxGwlIc3+oIUHoXqyY+VLsBQs8FzjR+eaw== Authentication-Results: <my.mailserv.er>; arc=reject ("signature check failed: fail, {[1] = sig:lists.list.domain:reject}") ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=lists.list.domain; s=dkim; t=1757413249; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=QSqNoTMweT1jo6F77TLHa+Nh7a0n/g9qDOsUTT8KpQ4=; b=rDgMC26uNsyTPgmddqQOiUsJh25KUa69TeMJfekVn5sFOnvhQdoa9LCogRMMKzJomA0wu6 CCdi6jGJpjtJdzB7PQ8UhQbeFiOUy9JNswFxQ+Qk1GXBxgN892C6KL/DiB/VW1j1nL0xOk Tc0BNC1zH1/MG2hB332t6u/rjWO+PtxIznAdcCP29AhO39RWWY/J0c/CHCOoqFYKCEf1ZH J4Wqeu9ANF44cPwopuJzJioWts6JKRvAM5TjnInZ+HaSv5QmuHvdI0fWvh272O3vGfvEPc iG1QsJS9XWpzkymRjYWo6h1c4/eY7eZd4FEzSR/TtW6Ud9b04A5lUmPpEvTxlQ== ARC-Authentication-Results: i=1; <my.mailserv.er>; dkim=none; dmarc=pass (policy=none) header.from=t-online.de; spf=pass (<my.mailserv.er>: domain of sender(a)t-online.de designates 194.25.134.20 as permitted sender) smtp.mailfrom=sender(a)t-online.de [END QUOTE] What am I still doing wrong? Can you help me, which setting is still missing? What informations are you still missing? Thanks for your help, Matthias

5 19

2.1 -> 3 migration without mboxes?
by David Romerstein Sept. 12, 2025

Sept. 12, 2025

Hey, folks. I've searched the list archive but haven't found a relevant thread yet. Any pointers would be helpful. I have a handful of lists in a 2.1 instance for which I have web archives but not original .mbox files. Is there a way to migrate those lists, including the years of archives, to 3?

2 1

Issues sending to gmail and yahoo e-mails
by jkoral＠luc.edu Sept. 12, 2025

Sept. 12, 2025

Has anyone experienced recent issues with Mailman3 not being able to send to gmail and yahoo e-mail addresses. I am trying to figure out if Google has our server blocked or not. When I send a manual e-mail from the server, the my yahoo e-mail gets delivered, but the gmail one does not. Here is the message I get in the logs when trying to send to the gmail address from the command line, but I do not get anything when it tries to send from Mailman. 2025-09-09T18:57:09.344493-05:00 lstprdls01 postfix/smtp[3544622]: BE67F1C09AF: to=<jmjk(a)gmail.com>, relay=gmail-smtp-in.l.google.com[173.194.194.26]:25, delay=0.55, delays=0.01/0/0.27/0.27, dsn=5.7.26, status=bounced (host gmail-smtp-in.l.google.com[173.194.194.26] said: 550-5.7.26 Your email has been blocked because the sender is unauthenticated. 550-5.7.26 Gmail requires all senders to authenticate with either SPF or DKIM. 550-5.7.26 550-5.7.26 Authentication results: 550-5.7.26 DKIM = did not pass 550-5.7.26 SPF [lstprdls01.xxx.xxx.edu] with ip: [xxx.xxx.10.33] = did not pass 550-5.7.26 550-5.7.26 For instructions on setting up authentication, go to 550 5.7.26 https://support.google.com/mail/answer/81126#authentication 8926c6da1cb9f-50d8f268ab7si36484097173.142 - gsmtp (in reply to end of DATA command)) I added DMARC mitigation to this list with "Replace From: with list address" and "DMARC Mitigate unconditinally - Yes" The DMARC Address I have in there is ^.*(a)gmail\.com$ Do I have to do anything else? Restart any services or anything?

5 11

Hyperkitty Text/Markdown/HTML
by Sam Darwin Sept. 11, 2025

Sept. 11, 2025

How about a feature to include "HTML" in the current Hyperkitty choices of (Text or Markdown) rendering? A sanitizer must be used to prevent malicious attacks. https://github.com/messense/nh3 . lxml is another package that processes html. A sanitizer would be helpful for more aspects. Permit a limited set of markdown so that messages still appear professional. Gitlab/Github don't allow arbitrary fonts or font sizes, right? Mostly remove these tags. A way that code blocks could be presented: determine an established list of known codeblock styles. Configure the sanitizer to permit this range of fonts or styling elements. By allowing them through the filter, a code styling is rendered. (It is permitted/allowed to be rendered.) Even better, when the sanitizer recognizes the fonts, it replaces them with an "official" set of codeblock fonts. Otherwise, if other font tags are entirely removed, if they are missing, the email client or web ui will decide the font selection, and it will appear "standard". In order for both email clients and Hyperkitty to view the same result, the sanitizer should ideally be applied to outgoing emails as well as rendering in the UI. That means this feature would affect more than just Hyperkitty. (i.e. mailman-core). Although, that could be implemented as a separate step, until which time emails would get a full range of HTML, without sanitizing. In this scheme, ensure outgoing emails are multi-part MIME with plain text and html versions. Some of our users are really in favor of more formatting. Others prefer plain text. Those who prefer plain text have various arguments that HTML messages will be rendered badly, and won't be legible. Questions: 1. Would "multi-part MIME with plain text and html versions both" solve the problem for users who prefer plain text? 2. What percentage of email clients that support HTML formatting when sending will also include a plain text rendering of the same content in the outgoing message? 3. Is it usually the responsibility of a receiving mail client to be able to convert HTML to plain text if the user requests it? 4. When mailman-core receives and then sends out a message, can it receive HTML, generate a plain-text version, and then send both? Thoughts?

3 10

After moving to a another server, mail footers show only this smart text "Cache content lost"
by Wikinaut Sept. 10, 2025

Sept. 10, 2025

After moving to a another server, mail footer shows only text "Cache content lost". I moved the two databases (mailman3, mailmanweb) to another server, but now my Mailinglist shows this in the footer, uh, what did I forget to move?

2 1

Contribution: A small script for presetting member preferences and reset bounce_scores of all members
by Wikinaut Sept. 10, 2025

Sept. 10, 2025

In case you need this, I do. Of course, the shown preferences need to be adapted according to your needs. def reset_bounce_scores(): # reset bounce scores and setting certain standard member preferences to all members in all mailinglists # 20250910 from zope.component import getUtility from mailman.interfaces.listmanager import IListManager from mailman.interfaces.member import DeliveryMode, DeliveryStatus RED = "\033[31m\033[1m" X = "\033[0m" hide_address = False delivery_status = DeliveryStatus.enabled lm = getUtility(IListManager) for mlist in lm.mailing_lists: # print(f"... checking bounce status and setting standard preferences of members in {mlist.fqdn_listname}") print(f"... resetting bounce status of members in {mlist.fqdn_listname}") for member in mlist.members.members: prefs = member.preferences prefs.acknowledge_posts = True prefs.hide_address = hide_address # prefs.preferred_language = 'de' prefs.receive_list_copy = True prefs.receive_own_postings = True prefs.delivery_mode = DeliveryMode.regular prefs.delivery_status = delivery_status bs = member.bounce_score if bs > 0: print(f"reset bounce score of: {member.address.email} {mlist.fqdn_listname} {RED}{bs}{X}") member.bounce_score = 0

1 0

Internal Server Error: /archives/api/mailman/archive OperationalError at /archives/api/mailman/archive (1366, "Incorrect string value: '\\xF0\\x9F\\x98\\x8A\\x0A\\x0A...' for column `mailman3web`.`hyperkitty_email`.`content` at row 1")
by Wikinaut Sept. 10, 2025

Sept. 10, 2025

Someone sent a short E-Mail with an Emoition in it. Is there something known about problems? The mails was sent via mailman3, but not archived due to the error. I can bring more details, please let me know, if this is requested. Internal Server Error: /archives/api/mailman/archive OperationalError at /archives/api/mailman/archive (1366, "Incorrect string value: '\\xF0\\x9F\\x98\\x8A\\x0A\\x0A...' for column `mailman3web`.`hyperkitty_email`.`content` at row 1") Hyperkitty 1.3.12 GNU Mailman 3.3.10 (Tom Sawyer) Python 3.11.2 (main, Apr 28 2025, 14:11:48) [GCC 12.2.0] Now, every new mail triggers again this error.

2 7

Errors while importing mm2 list archives
by Odhiambo Washington Sept. 9, 2025

Sept. 9, 2025

MM3-3.3.7, Hyperkitty-1.3.6 While importing, I encountered several of this error: <CUT> MySQLdb.OperationalError: (1366, "Incorrect string value: '\\xF0\\x9F\\x98\\x8A, ...' for column 'content' at row 1") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/management/commands/hyperkitty_import.py", line 232, in from_mbox add_to_list(self.list_address, message) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/lib/incoming.py", line 153, in add_to_list email.save() File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/base.py", line 812, in save self.save_base( File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/base.py", line 863, in save_base updated = self._save_table( File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/base.py", line 1006, in _save_table results = self._do_insert( File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/base.py", line 1047, in _do_insert return manager._insert( File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1791, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1660, in execute_sql cursor.execute(sql, params) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers( File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers return executor(sql, params, many, context) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/utils.py", line 91, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 75, in execute return self.cursor.execute(query, args) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query db.query(q) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query _mysql.connection.query(self, query) django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xF0\\x9F\\x98\\x8A, ...' for column 'content' at row 1") </CUT> That occurred several times, but the import process went all the way, to 99% then came to the point below. Message 253d9d44-cc3e-fed1-144b-34da88c52b39(a)emailplus.org failed to import, skipping Computing thread structure Synchronizing properties with Mailman 904 emails left to refresh, checked 0 764 emails left to refresh, checked 0 Warming up cache Traceback (most recent call last): File "/opt/mailman/mm/venv/bin/django-admin", line 8, in <module> sys.exit(execute_from_command_line()) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line utility.execute() File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 440, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/core/management/base.py", line 402, in run_from_argv self.execute(*args, **cmd_options) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/core/management/base.py", line 448, in execute output = self.handle(*args, **options) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/management/commands/hyperkitty_import.py", line 411, in handle call_command("hyperkitty_warm_up_cache", list_address) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 198, in call_command return command.execute(*args, **defaults) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/core/management/base.py", line 448, in execute output = self.handle(*args, **options) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/management/commands/hyperkitty_warm_up_cache.py", line 53, in handle self.warm_up_mlist(mlist, options) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/management/commands/hyperkitty_warm_up_cache.py", line 61, in warm_up_mlist for thread in mlist.recent_threads: File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/models/mailinglist.py", line 162, in recent_threads return self.cached_values["recent_threads"]() File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/models/common.py", line 58, in __call__ return self.get_or_set(*args, **kwargs) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/models/mailinglist.py", line 317, in get_or_set return [Thread.objects.get(pk=pk) for pk in thread_ids] File "/opt/mailman/mm/venv/lib/python3.9/site-packages/hyperkitty/models/mailinglist.py", line 317, in <listcomp> return [Thread.objects.get(pk=pk) for pk in thread_ids] File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/opt/mailman/mm/venv/lib/python3.9/site-packages/django/db/models/query.py", line 650, in get raise self.model.DoesNotExist( hyperkitty.models.thread.Thread.DoesNotExist: Thread matching query does not exist. (venv) [mailman@gw ~/mm]$ Should I take it that the import was successful, or what should I do next? PS: This is the 1st run after installing MM3 on this server and the MM3 list hasn't gone live. So if anything, I am okay with doing what needs to be done and rerun the import. TIA -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

4 14

after last upgrade I've got a CSRF failed verification
by Guillermo Hernandez (Oldno7) Sept. 5, 2025

Sept. 5, 2025

I did upgrade one of my mailman3 server after Abhilasj announcement: "I am pleased to announce several new releases for GNU Mailman project. 1. Mailman Core 3.3.6 1 <https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/NEWS.…> 2. Postorius 1.3.7 2 <https://docs.mailman3.org/projects/postorius/en/latest/news.html#section-2> 3. Hyperkitty 1.3.6 [3] 4. Mailmanclient 3.3.4 [4] 5. Django-mailman3 1.3.8 [5]" I did it via pip and all seems to be working, but when I try to discard or accept any message via postorius it shows a Forbidden 403 error CSRF verification failed. In my settings.py I have commented out these variables: # Other security settings # SECURE_SSL_REDIRECT = True # If you set SECURE_SSL_REDIRECT to True, make sure the SECURE_REDIRECT_EXEMPT # contains at least this line: # SECURE_REDIRECT_EXEMPT = [ # "archives/api/mailman/.*", # Request from Mailman. # ] # SESSION_COOKIE_SECURE = True # SECURE_CONTENT_TYPE_NOSNIFF = True # SECURE_BROWSER_XSS_FILTER = True # CSRF_COOKIE_SECURE = True # CSRF_COOKIE_HTTPONLY = True # X_FRAME_OPTIONS = 'DENY' I've been messing with them whith no results. It's like it lacked some value in some template... Can someone, please, point me in the right direction? Thanks in advance -- ___________________________________________ Mailman's content filtering has removed the following MIME parts from this message. Content-Type: image/png Name: firma-GHP-emails.png Replaced multipart/alternative part with first alternative.

3 8

mailman-web migrate fails with sqlite3.IntegrityError: UNIQUE constraint failed: account_emailaddress.email
by Stefan Bauer Sept. 5, 2025

Sept. 5, 2025

Dear Users, trying to update mailman3 to lastest version, we fail during mailman-web migrate with: Operations to perform: Apply all migrations: account, admin, auth, contenttypes, django_mailman3, django_q, hyperkitty, postorius, sessions, sites, socialaccount Running migrations: Applying account.0006_emailaddress_lower...Traceback (most recent call last): File "/opt/mailman/venv/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/opt/mailman/venv/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute return super().execute(query, params) sqlite3.IntegrityError: UNIQUE constraint failed: account_emailaddress.email We found a workaround to fake the migration with migrate --fake Operations to perform: Apply all migrations: account, admin, auth, contenttypes, django_mailman3, django_q, hyperkitty, postorius, sessions, sites, socialaccount Running migrations: Applying account.0006_emailaddress_lower... FAKED Applying account.0007_emailaddress_idx_email... FAKED Applying account.0008_emailaddress_unique_primary_email_fixup... FAKED Applying account.0009_emailaddress_unique_primary_email... FAKED Applying django_q.0015_alter_schedule_schedule_type... FAKED Applying django_q.0016_schedule_intended_date_kwarg... FAKED Applying django_q.0017_task_cluster_alter... FAKED Applying django_q.0018_task_success_index... FAKED Applying postorius.0019_alter_emailtemplate_data... FAKED And mailman 3 is still processing mails. I'm unsure if i should recover from snapshot or keep it going? Could this be some duplicate users with same mail-address? I have at least spotted one user and delete him. thank you. Stefan

3 4

Dependency nntplib not found
by qno-mailman＠qno.de Sept. 5, 2025

Sept. 5, 2025

Hi all, next problem. I got a proper configuration (so i thought, but when starting, mailman3 exits. The output of journalctl -xeu mailman3.service ends with: Sep 05 17:33:23 bywater mailman[223227]: File "/opt/mailman/venv/lib/python3.13/site-packages/mailman/commands/cli_ga> Sep 05 17:33:23 bywater mailman[223227]: import nntplib Sep 05 17:33:23 bywater mailman[223227]: ModuleNotFoundError: No module named 'nntplib' Sep 05 17:33:23 bywater systemd[1]: mailman3.service: Control process exited, code=exited, status=1/FAILURE ░░ Subject: Unit process exited ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ An ExecStart= process belonging to unit mailman3.service has exited. ░░ ░░ The process' exit code is 'exited' and its exit status is 1. Sep 05 17:33:23 bywater systemd[1]: mailman3.service: Failed with result 'exit-code'. ░░ Subject: Unit failed ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ The unit mailman3.service has entered the 'failed' state with result 'exit-code'. Sep 05 17:33:23 bywater systemd[1]: Failed to start mailman3.service - GNU Mailing List Manager. ░░ Subject: A start job for unit mailman3.service has failed ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ A start job for unit mailman3.service has finished with a failure. I googled and found that module nntplib is no more part of python since python-3.13. How can i fullfill (or avoid?) this dependency? TIA QNo

2 2

After server upgrade debian 11→12 and reinstalling everything in (venv), I got this error when accessing → mailman3/lists
by Wikinaut Sept. 5, 2025

Sept. 5, 2025

File "/opt/mailman/venv/lib/python3.11/site-packages/mailmanclient/restbase/connection.py", line 160, in call raise HTTPError(params.get('url'), response.status_code, urllib.error.HTTPError: HTTP Error 500: {"title": "500 Internal Server Error"} ERROR 2025-08-16 19:26:03,720 6588 django.request Internal Server Error: /mailman3/lists/mylist.myserver.tld Can anyone help? Other things do work, including archives, users, domains etc.

4 19

Mailman3 virtualenv installation: missing data
by qno-mailman＠qno.de Sept. 5, 2025

Sept. 5, 2025

Hi all, i tried to install Mailman3 according to https://docs.mailman3.org/en/latest/install/virtualenv.html#virtualenv-inst…. I’m using Mariadb instead of PostgreSQL, but that is no problem until now. Where i fail: I have to make an entry var_dir: /opt/mailman/mm/var in /etc/mailman3/mailman.cfg. But there is no directory /opt/mailman/mm, and there are no subdirectories. No $var_dir, no postfix_lmtp, no postfix_transports. Where do i get those files from? TIA QNo

2 2

Question: as Admin, I disabled the self-registration via settings.py. What is the correct method to register a few new users now?
by Wikinaut Sept. 2, 2025

Sept. 2, 2025

Disabled by line ACCOUNT_ADAPTER = 'django_mailman3.views.user_adapter.DisableSignupAdapter' (via https://gitlab.com/mailman/django-mailman3/-/merge_requests/129 ) When I want to register a few new users, I need to comment this line and restart mailmanweb. Question: is there a better method for admins to register a few new persons to Hyperkitty/Postorius so that they can act as owners and moderators of some of the lists?

3 3

[Django] ERROR (EXTERNAL IP): Internal Server Error: /mailman3/lists/test2.***/settings/message_acceptance MultipleObjectsReturned .. get() returned more than one EmailAddress -- it returned 2!
by Wikinaut Sept. 2, 2025

Sept. 2, 2025

[Django] ERROR (EXTERNAL IP): Internal Server Error: /mailman3/lists/test2.av-huette.de/settings/message_acceptance Full error stack (redacted) see https://dpaste.com/CEFXPNP67.txt Internal Server Error: /mailman3/lists/test2.*****/settings/message_acceptance As far as I remember, I removed every member of that test2 list. I think, my bug report could be of interest to fix a (probably) lurking bug. Everything works here, but last week I had this error

5 5

Mailing lists as the main collaboration centre at SME
by Rodrigo Camacho Aug. 31, 2025

Aug. 31, 2025

Hello all, I own and run a small company (lanao.org) I am looking for companies which have put mailing lists not only as a form of general announcement but especially as the main way to collaborate. I am thinking of moving my team to a model like that and would love to read about some best practices or strong opposition to the idea. I am hopeful that out there there are companies which have resisted the Microsoft Teams virus. If your company uses mailing lists to run, please reach out. We are currently using Gitlab issues to collaborate which has been quite successful. I would be very interested to trade tips. Best wishes, Rodrigo

3 5

Stalwart plugin
by info＠joergschulz.de Aug. 30, 2025

Aug. 30, 2025

Hi all, I'm just reviewing Stalwart as a many-in-one mailing system. Did anybody yet succeed in plugging mailman into stalwart (the incoming bit seems to be difficult)?

3 2

New subscribed (by invitation) user: no password received in invitation/welcome e-mail. Postorius sign up / password reset broken
by ^m'e Aug. 30, 2025

Aug. 30, 2025

Hi there, I migrated form MM2.1 to MM3.3.10 on Debian Trixie (mariadb backend) -- I know that's a bit unorthodox to ask here for help on a non venv-based installation, but hopefully I'll first gain a bit of insight of MM3 in order to formulate a more precise request to Debian maintainers. ## Issue #1. A newly invited (from Postorius mass subscription page) and confirmed user doesn't get any password in their invitation/welcome e-mail. I guess that's because MM3 allows a user to subscribe without having an account, right? Else, there's a problem. ## Issue #2 Anyway, if that new user asks for a password reset on Postorius they get "Server error An error occurred while processing your request." Log shows: ``` ERROR 2025-08-29 17:59:17,227 173488 django.request Internal Server Error: /accounts/password/reset/ Traceback (most recent call last): File "/usr/lib/python3/dist-packages/django/core/handlers/exception.py", line 55, in inner response = get_response(request) File "/usr/lib/python3/dist-packages/django/core/handlers/base.py", line 197, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/usr/lib/python3/dist-packages/django/views/generic/base.py", line 105, in view return self.dispatch(request, *args, **kwargs) ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/django/utils/decorators.py", line 46, in _wrapper return bound_method(*args, **kwargs) File "/usr/lib/python3/dist-packages/django/views/generic/base.py", line 144, in dispatch return handler( form.save(self.request) ~~~~~~~~~^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/allauth/account/forms.py", line 633, in save adapter.send_password_reset_mail(user, email, context) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/allauth/account/adapter.py", line 577, in send_password_reset_mail return self.send_mail("account/email/password_reset_key", email, context) ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/allauth/account/adapter.py", line 201, in send_mail msg.send() ~~~~~~~~^^ File "/usr/lib/python3/dist-packages/django/core/mail/message.py", line 299, in send return self.get_connection(fail_silently).send_messages([self]) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^ File "/usr/lib/python3/dist-packages/django/core/mail/backends/smtp.py", line 134, in send_messages sent = self._send(message) File "/usr/lib/python3/dist-packages/django/core/mail/backends/smtp.py", line 152, in _send self.connection.sendmail( ~~~~~~~~~~~~~~~~~~~~~~~~^ from_email, recipients, message.as_bytes(linesep="\r\n") ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/usr/lib/python3.13/smtplib.py", line 861, in sendmail self.ehlo_or_helo_if_needed() ~~~~~~~~~~~~~~~~~~~~~~~~~~~^^ File "/usr/lib/python3.13/smtplib.py", line 611, in ehlo_or_helo_if_needed if not (200 <= self.ehlo()[0] <= 299): ~~~~~~~~~^^ File "/usr/lib/python3.13/smtplib.py", line 451, in ehlo self.putcmd(self.ehlo_msg, name or self.local_hostname) ~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.13/smtplib.py", line 378, in putcmd self.send(f'{s}{CRLF}') ~~~~~~~~~^^^^^^^^^^^^^^ File "/usr/lib/python3.13/smtplib.py", line 365, in send raise SMTPServerDisconnected('please run connect() first') smtplib.SMTPServerDisconnected: please run connect() first ``` The same happens if the new users tries to sign up. Any idea? Cheers -- Marco

3 3

Subscription Request asking for Confirmation instead of Moderation
by Henry Hartley Aug. 29, 2025

Aug. 29, 2025

We have a list where the Subscription Policy (Settings -> Member Policy -> Subscription Policy) is set to "Moderate" and when I send a message to LISTNAME-join(a)example.com<mailto:LISTNAME-join@example.com> (not the real domain, obviously) everything works as expected and the user shows up in the Pending Approval list. We have a Drupal website that allows users to submit a form that, among other things, sends a subscription request to our Mailman3 'join' address. When that happens, however, instead of going to the Pending Approval list, the name is shows on the Pending Confirmation page. We don't send a Welcome message so as far as I can tell, they do not get an email asking them to confirm their email address. Two questions: 1. Are there particular headers that are causing the email to go to the Confirmation page instead of the Approval page? Or are there particular headers we can add that will help with this? 2. Is there any way for us to move an address from the Confirmation Pending page to confirmed on the backend (preferably through the web interface, but on the server itself, if necessary)? Here are the headers sent with the subscriber's email address changed to FirstLast(a)SCHOOL.edu<mailto:FirstLast@SCHOOL.edu> and our BCC mailbox domain changed to COMPANY.com. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed; delsp=yes Content-Transfer-Encoding: 8Bit X-Mailer: Drupal Return-Path: FirstLast(a)SCHOOL.edu<mailto:FirstLast@SCHOOL.edu> Sender: FirstLast(a)SCHOOL.edu<mailto:FirstLast@SCHOOL.edu> From: FirstLast(a)SCHOOL.edu<mailto:FirstLast@SCHOOL.edu> Bcc: mailman-noreply(a)COMPANY.com<mailto:mailman-noreply@COMPANY.com> -- Henry Hartley Westat RB 2151

3 8

Today no question, but my toolbox: set "global" user preferences; list or delete held messages
by Wikinaut Aug. 27, 2025

Aug. 27, 2025

After some (sorry for bothering you) questions here, I was able to set up a mailman3 system which I regard as perfect for my use. Perhaps, you had similar problems with your installation, especially when coming from mailman2 and, like me, from majordomo...... I collected a lot of information which was presented in this mailling list archive here and also answers of my questions (thanks Mark and others) News: https://github.com/Wikinaut/mailman3-tools has all of these tools. README says: Scripts for maintenance or setting-up of modern mailman3 instances set preferences for all users list held messages delete held messages older n days My setting is strictly as described in the documentation: mailman3 + postorius/hyperkitty are installed via pip in an (venv) /opt/mailman/ My user scripts and a huge mailing list generator (not published here) are in a directory apart from that: user maillistgen home directory /home/maillistgen user maillistgen has some sudo rights set uo in /etc/sudoers a wrapper script is /home/maillistgen/run_mailman.sh which sets the correct path for Python, mailman3 and the (venv). I hope, you like my tiny part of contribution and attribution back to Mark.

1 0

Today no question, but my toolbox: set "global" user preferences; list or delete held messages
by Wikinaut Aug. 27, 2025

Aug. 27, 2025

After some (sorry for bothering you) questions here, I was able to set up a mailman3 system which I regard as perfect for my use. Perhaps, you had similar problems with your installation, especially when coming from mailman2 and, like me, from majordomo...... I collected a lot of information which was presented in this mailling list archive here and also answers of my questions (thanks Mark and others) News: https://github.com/Wikinaut/mailman3-tools has all of these tools. README says: Scripts for maintenance or setting-up of modern mailman3 instances set preferences for all users list held messages delete held messages older n days My setting is strictly as described in the documentation: mailman3 + postorius/hyperkitty are installed via pip in an (venv) /opt/mailman/ My user scripts and a huge mailing list generator (not published here) are in a directory apart from that: user maillistgen home directory /home/maillistgen user maillistgen has some sudo rights set uo in /etc/sudoers a wrapper script is /home/maillistgen/run_mailman.sh which sets the correct path for Python, mailman3 and the (venv). I hope, you like my tiny part of contribution and attribution back to Mark.

1 0

How can i suppress sending moderation mail to all owners?
by Markus Grandpré Aug. 25, 2025

Aug. 25, 2025

Dear list members, How can I configure the list settings the way that emails intended for moderators are delivered only to them, and not to the owners/administrators of the list? Best, Markus Grandpré -- Markus Grandpré (he/him) Universität Konstanz Kommunikations-, Informations- und Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre und Infrastruktur Sachgebiet Diensteadministration 78457 Konstanz Tel: +49 7531 88-4342D

4 4

Python backtrace from `mailman -h`
by Peter Chubb Aug. 25, 2025

Aug. 25, 2025

Hi Folks, I'm running the Debian-packaged mailman3 (yes I know ...) and running: sudo -u list mailman -h gives a python backtrace (which I've appended the tail end of). Can someone who has the upstream installed version (using venv) please check that `mailman -h` works there before I waste too much time investigating in the wrong places? ... File "/usr/lib/python3/dist-packages/mailman/bin/mailman.py", line 44, in _load add_components('commands', ICLISubCommand, self._commands) ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/mailman/utilities/modules.py", line 218, in add_components for component_class in find_pluggable_components(subpackage, interface): ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/mailman/utilities/modules.py", line 181, in find_pluggable_components for name, plugin_config in config.plugin_configs: ^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/mailman/config/config.py", line 291, in plugin_configs plugin_sections = self._config.getByCategory('plugin', []) ^^^^^^^^^^^^^^^^^^^^^^^^^^ AttributeError: 'NoneType' object has no attribute 'getByCategory' Peter C

2 2

Why are moderation mails sent to list moderator (if there are any) _and_ then also to the list owner?
by Wikinaut Aug. 24, 2025

Aug. 24, 2025

Dear all, I am quity puzzled to receive a bunch of mails which are moderators works - I just set up one person as a list moderator - but I do receive the moderation request as well. How can this be stopped? I just tested the behaviour and I can't see any switch in the list settings (at the moment) to avoid sending moderations to the owner for such lists, where moderator(s) are defined. A Bug?

2 1

[Bug] Someone not a member of list is treated as member - strange
by Wikinaut Aug. 24, 2025

Aug. 24, 2025

In my list test I have my address1 as member (only this one member). I definitely send a mail from my address2[sic] to ml test. The list settings are: 1. accept mails from members (address2 is not a member) 2. discard mails from non-members (address2 is not a member of ml test) When sending from address2, my mail is accepted. When I, for sake of completeness switch 1. to moderate mails from member[sic], my mail from address2 gets moderated. Please explain. It looks like a bug. I double-checked the field "accept from non-members" to be empty, yes, is empty, where I otherwise add all members by adding the internal ml whitelist in form of the entry @whitelist@mydomain.com .

3 10

Missing Base64 encoding from control message reply
by lists-mailman3＠janaberger.de Aug. 22, 2025

Aug. 22, 2025

Dear all, I have a setup with GNU Mailman 3.3.8 where a user tried to subscribe. When replying to the "confirm" message, the user received a completely garbled response, like so: N�z˥��ʋ�zf��&��j��u�[zZ0:��v��,j�z֢��k�e�0 4Dҹ��r�^b��r�ߊ��*'��yם��{ax�L�X��0:��v��,j�z֢��k�d�m�-��zz�rn��l]y+��-E�( �^N��'��M��tۯ��Mz��^i��׮��}�o�\ӷ��6sN�zf��ݮ��r��z˥��b�{h��݉��f�r�ne== (The line above contains numerous unprintable characters, etc.) The user then forwarded the .eml file to me, which clearly shows the contents of the mail as plain text while being announced as base64 (Content-Transfer-Encoding: base64): START OF EML Return-Path: <LISTNAME-bounces(a)lists.DOMAIN.COM> Received: from DOMAIN.COM ([144.76.173.241]) by mx-ha.USERDOMAIN.NET (mx06 [IP]) with ESMTPS (Nemesis) id 1M27WV-1qhRFk39Sr-00AQcR for <USER(a)USERDOMAIN.NET>; Thu, 21 Sep 2023 19:10:37 +0200 Received: from localhost (localhost.localdomain [127.0.0.1]) by DOMAIN.COM (Postfix) with ESMTP id 4058B3BD5EEF for <USER(a)USERDOMAIN.NET>; Thu, 21 Sep 2023 19:10:37 +0200 (CEST) Received: from DOMAIN.COM ([127.0.0.1]) by localhost (DOMAIN.COM [127.0.0.1]) (amavis, port 10024) with ESMTP id x0ngnlRnGraH for <USER(a)USERDOMAIN.NET>; Thu, 21 Sep 2023 19:10:37 +0200 (CEST) Received: from [IP] (unknown [IP]) by DOMAIN.COM (Postfix) with ESMTP id DC8603BD5EEE for <USER(a)USERDOMAIN.NET>; Thu, 21 Sep 2023 19:10:36 +0200 (CEST) Subject: =?utf-8?q?The_results_of_your_email_commands?= From: LISTNAME-bounces(a)lists.DOMAIN.COM To: USER(a)USERDOMAIN.NET Content-Transfer-Encoding: base64 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Message-ID: <169531623416.29.5762261018677554285@mailman-core> Date: Thu, 21 Sep 2023 17:10:34 +0000 Precedence: bulk X-Mailman-Version: 3.3.8 List-Id: <LISTNAME.lists.DOMAIN.COM> List-Help: <mailto:LISTNAME-request@lists.DOMAIN.COM?subject=help> List-Owner: <mailto:LISTNAME-owner@lists.DOMAIN.COM> List-Subscribe: <mailto:LISTNAME-join@lists.DOMAIN.COM> List-Unsubscribe: <mailto:LISTNAME-leave@lists.DOMAIN.COM> Envelope-To: <USER(a)USERDOMAIN.NET> X-Spam-Flag: NO The results of your email command are provided below. - Original message details: From: USER <USER(a)USERDOMAIN.NET> Subject: Re: Your confirmation is needed to join the LISTNAME(a)lists.DOMAIN.COM mailing list. Date: Thu, 21 Sep 2023 19:10:26 +0200 Message-ID: <3c1eaaf8-1677-432f-b9dc-07f18902c06c(a)email.android.com> - Results: Confirmation token did not match - Done. END OF EML Is this possibly a bug in Mailman? Any ideas on what else could be causing this?

7 16

particular list member seems unmanageable from CLI
by Stephan Aug. 22, 2025

Aug. 22, 2025

We have a list member that got disabled due to bounces, but that should be fixed after we implemented DMARC and SPF. So as I don't know how to access the disabled status from the CLI (we have no GUI), I tried to delete and re-subscribe them. But although they are listed as a member, they cannot be deleted: # sudo -u list mailman members list(a)domain.tld | grep "$x" M... <M....@web...> # sudo -u list mailman delmembers -m "$x" -l list(a)domain.tld Member not subscribed (skipping): M... <M....@web...> How can I fix this from the command line? Either by restoring their "disabled" status, or deleting and re-subscribing them?

2 1

Xapian error on RHEL9 - module 'xapian' has no attribute 'QueryParser'
by l.reilly＠ucl.ac.uk Aug. 21, 2025

Aug. 21, 2025

Hi, I'm trying to set up Mailman 3 on a RHEL9 (unfortunately Debian/Ubuntu aren't options) and have been making some progress, but I'm having trouble getting Xapian to work. I first tried to install it using Method 1 (https://docs.mailman3.org/en/latest/install/virtualenv.html#set-up-xapian) however, xapian_wheel_builder.sh seems to just exit right as it starts "preparing xapian wheel...". I ended up installing Xapian 1.4.29 from source and symlinking xapian in the venv as per Method 2. When trying to search the archives the error below is generated. Has anyone else encountered this before? Thanks. ################################################################################# Internal Server Error: /archives/search AttributeError at /archives/search module 'xapian' has no attribute 'QueryParser' Request Method: GET Request URL: https://mailinglists-dev.ucl.ac.uk/archives/search?mlist=skgtlmr-test%40mai… Django Version: 4.2.23 Python Executable: /opt/mailman/venv/bin/python3.12 Python Version: 3.12.9 Python Path: ['/opt/mailman/mm', '/', '/opt/mailman/venv/bin', '/etc/mailman3', '/usr/lib64/python312.zip', '/usr/lib64/python3.12', '/usr/lib64/python3.12/lib-dynload', '/opt/mailman/venv/lib64/python3.12/site-packages', '/opt/mailman/venv/lib/python3.12/site-packages', '/etc/mailman3'] Server time: Thu, 21 Aug 2025 11:05:02 +0100 Installed Applications: ['hyperkitty', 'postorius', 'django_mailman3', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.humanize', 'rest_framework', 'django_gravatar', 'compressor', 'haystack', 'django_extensions', 'django_q', 'allauth', 'allauth.account', 'allauth.socialaccount'] Installed Middleware: ('allauth.account.middleware.AccountMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'django.middleware.security.SecurityMiddleware', 'django_mailman3.middleware.TimezoneMiddleware', 'postorius.middleware.PostoriusMiddleware') Traceback (most recent call last): File "/opt/mailman/venv/lib64/python3.12/site-packages/django/core/handlers/exception.py", line 55, in inner response = get_response(request) ^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib64/python3.12/site-packages/django/core/handlers/base.py", line 197, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib64/python3.12/site-packages/hyperkitty/views/search.py", line 54, in search results = EmptySearchQuerySet() ^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib64/python3.12/site-packages/haystack/query.py", line 25, in __init__ self._determine_backend() ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib64/python3.12/site-packages/haystack/query.py", line 58, in _determine_backend self.query = connections[backend_alias].get_query() ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib64/python3.12/site-packages/haystack/utils/loading.py", line 114, in __getitem__ self.thread_local.connections[key] = load_backend( File "/opt/mailman/venv/lib64/python3.12/site-packages/haystack/utils/loading.py", line 60, in load_backend return import_class(full_backend_path) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib64/python3.12/site-packages/haystack/utils/loading.py", line 22, in import_class module_itself = importlib.import_module(module_path) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib64/python3.12/importlib/__init__.py", line 90, in import_module return _bootstrap._gcd_import(name[level:], package, level) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1387, in _gcd_import <source code not available> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1360, in _find_and_load <source code not available> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1331, in _find_and_load_unlocked <source code not available> ^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 935, in _load_unlocked <source code not available> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap_external>", line 999, in exec_module <source code not available> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed <source code not available> ^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib64/python3.12/site-packages/xapian_backend.py", line 50, in <module> xapian.QueryParser.FLAG_PHRASE | ^^^^^^^^^^^^^^^^^^ Exception Type: AttributeError at /archives/search Exception Value: module 'xapian' has no attribute 'QueryParser' Raised during: hyperkitty.views.search.search Request information: USER: skgtlmr GET: mlist = 'skgtlmr-test(a)mailinglists-dev.ucl.ac.uk' q = 'foo' POST: No POST data FILES: No FILES data COOKIES: EBSLIV = 'UQjksgWK7Zyd5TfaUK4KgP5PzD' _scid = 'A90JyW0nIFAyPsZyxkyUhTRixUN9PurngTShxQ' cookie-agreed-version = '1.0.0' cookie-agreed-categories = '%5B%22necessary_cookies%22%2C%22analytics_and_customisation_cookies%22%2C%22advertising_cookies%22%5D' cookie-agreed = '2' _fbp = 'fb.2.1752842717574.837640545407184978' nmstat = 'cd7efb87-0f9e-afb5-fbad-f9f4bc1769b8' _ga_QQBYV15T88 = 'GS2.3.s1753165359$o2$g1$t1753165373$j46$l0$h0' __utmc = '156947391' __utmz = '156947391.1753782039.4.2.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not%20provided)' _ga_NWBZGPY11C = 'GS2.1.s1753799417$o1$g1$t1753800249$j11$l0$h0' __utma = '156947391.1941193546.1752485543.1753782039.1753863655.5' _ga_WV6RVXXKPJ = 'GS2.1.s1755086211$o3$g0$t1755086216$j55$l0$h0' _ga_P316Z5TR5Q = 'GS2.1.s1755161312$o2$g1$t1755161324$j48$l0$h0' csrftoken = '********************' sessionid = '********************' _ga = 'GA1.1.1941193546.1752485543' _ga_35DML57W9V = 'GS2.1.s1755180982$o22$g1$t1755181740$j60$l0$h0' META: CSRF_COOKIE = 'jtklayWS008FhjoaikeHZmhSLZekOKkN' HTTP_ACCEPT = 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7' HTTP_ACCEPT_ENCODING = 'gzip, deflate, br, zstd' HTTP_ACCEPT_LANGUAGE = 'en-GB,en-US;q=0.9,en;q=0.8' HTTP_CONNECTION = 'Keep-Alive' HTTP_COOKIE = '********************' HTTP_HOST = 'mailinglists-dev.ucl.ac.uk' HTTP_REFERER = 'https://mailinglists-dev.ucl.ac.uk/archives/list/skgtlmr-test@mailinglists-…' HTTP_SEC_CH_UA = '"Not)A;Brand";v="8", "Chromium";v="138", "Google Chrome";v="138"' HTTP_SEC_CH_UA_MOBILE = '?0' HTTP_SEC_CH_UA_PLATFORM = '"Windows"' HTTP_SEC_FETCH_DEST = 'document' HTTP_SEC_FETCH_MODE = 'navigate' HTTP_SEC_FETCH_SITE = 'same-origin' HTTP_SEC_FETCH_USER = '?1' HTTP_UPGRADE_INSECURE_REQUESTS = '1' HTTP_USER_AGENT = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36' HTTP_X_FORWARDED_FOR = '10.0.115.196' HTTP_X_FORWARDED_HOST = 'mailinglists-dev.ucl.ac.uk' HTTP_X_FORWARDED_PROTO = 'https' HTTP_X_FORWARDED_SERVER = 'mail-man03d.addev.ucl.ac.uk' PATH_INFO = '/archives/search' QUERY_STRING = 'mlist=skgtlmr-test%40mailinglists-dev.ucl.ac.uk&q=foo' RAW_URI = '/archives/search?mlist=skgtlmr-test%40mailinglists-dev.ucl.ac.uk&q=foo' REMOTE_ADDR = '127.0.0.1' REMOTE_PORT = '41572' REQUEST_METHOD = 'GET' SCRIPT_NAME = '' SERVER_NAME = '127.0.0.1' SERVER_PORT = '8000' SERVER_PROTOCOL = 'HTTP/1.1' SERVER_SOFTWARE = 'gunicorn/23.0.0' gunicorn.socket = <socket.socket fd=4, family=2, type=1, proto=0, laddr=('127.0.0.1', 8000), raddr=('127.0.0.1', 41572)> wsgi.errors = <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7f9096342ec0> wsgi.file_wrapper = <class 'gunicorn.http.wsgi.FileWrapper'> wsgi.input = <gunicorn.http.body.Body object at 0x7f909652b020> wsgi.input_terminated = True wsgi.multiprocess = False wsgi.multithread = False wsgi.run_once = False wsgi.url_scheme = 'https' wsgi.version = '(1, 0)' Settings: Using settings module settings ABSOLUTE_URL_OVERRIDES = {} ACCOUNT_AUTHENTICATION_METHOD = 'username_email' ACCOUNT_DEFAULT_HTTP_PROTOCOL = 'http' ACCOUNT_EMAIL_REQUIRED = True ACCOUNT_EMAIL_UNKNOWN_ACCOUNTS = False ACCOUNT_EMAIL_VERIFICATION = 'mandatory' ACCOUNT_LOGIN_METHODS = {'username', 'email'} ACCOUNT_SIGNUP_FIELDS = ['username*', 'email*', 'password1*', 'password2*'] ACCOUNT_UNIQUE_EMAIL = True ADMINS = "(('Mailman Suite Admin', 'root@localhost'), ('Cloud Platforms Admin', 'l.reilly(a)ucl.ac.uk'))" ALLOWED_HOSTS = ['localhost', '127.0.0.1', '*'] APPEND_SLASH = True AUTHENTICATION_BACKENDS = "('django.contrib.auth.backends.ModelBackend', 'allauth.account.auth_backends.AuthenticationBackend')" AUTH_PASSWORD_VALIDATORS = '********************' AUTH_USER_MODEL = 'auth.User' BASE_DIR = PosixPath('/opt/mailman/web') CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} CACHE_MIDDLEWARE_ALIAS = 'default' CACHE_MIDDLEWARE_KEY_PREFIX = '********************' CACHE_MIDDLEWARE_SECONDS = 600 COMPRESSORS = {'css': 'compressor.css.CssCompressor', 'js': 'compressor.js.JsCompressor'} COMPRESS_CACHEABLE_PRECOMPILERS = '()' COMPRESS_CACHE_BACKEND = 'default' COMPRESS_CACHE_KEY_FUNCTION = '********************' COMPRESS_CLEAN_CSS_ARGUMENTS = '' COMPRESS_CLEAN_CSS_BINARY = 'cleancss' COMPRESS_CLOSURE_COMPILER_ARGUMENTS = '' COMPRESS_CLOSURE_COMPILER_BINARY = 'java -jar compiler.jar' COMPRESS_CSS_HASHING_METHOD = 'mtime' COMPRESS_DATA_URI_MAX_SIZE = 1024 COMPRESS_DEBUG_TOGGLE = None COMPRESS_ENABLED = True COMPRESS_FILTERS = {'css': ['compressor.filters.css_default.CssAbsoluteFilter', 'compressor.filters.cssmin.rCSSMinFilter'], 'js': ['compressor.filters.jsmin.rJSMinFilter']} COMPRESS_JINJA2_GET_ENVIRONMENT = <function CompressorConf.JINJA2_GET_ENVIRONMENT at 0x7f9097504fe0> COMPRESS_MINT_DELAY = 30 COMPRESS_MTIME_DELAY = 10 COMPRESS_OFFLINE = True COMPRESS_OFFLINE_CONTEXT = {'STATIC_URL': '/static/'} COMPRESS_OFFLINE_MANIFEST = 'manifest.json' COMPRESS_OFFLINE_MANIFEST_STORAGE = 'compressor.storage.OfflineManifestFileStorage' COMPRESS_OFFLINE_MANIFEST_STORAGE_ALIAS = 'compressor-offine' COMPRESS_OFFLINE_TIMEOUT = 31536000 COMPRESS_OUTPUT_DIR = 'CACHE' COMPRESS_PARSER = 'compressor.parser.AutoSelectParser' COMPRESS_PRECOMPILERS = "(('text/x-scss', 'sassc -t compressed {infile} {outfile}'), ('text/x-sass', 'sassc -t compressed {infile} {outfile}'))" COMPRESS_REBUILD_TIMEOUT = 2592000 COMPRESS_ROOT = '/opt/mailman/web/static' COMPRESS_STORAGE = 'compressor.storage.CompressorFileStorage' COMPRESS_STORAGE_ALIAS = 'compressor' COMPRESS_TEMPLATE_FILTER_CONTEXT = {'STATIC_URL': '/static/'} COMPRESS_URL = '/static/' COMPRESS_URL_PLACEHOLDER = '/__compressor_url_placeholder__/' COMPRESS_VERBOSE = False COMPRESS_YUGLIFY_BINARY = 'yuglify' COMPRESS_YUGLIFY_CSS_ARGUMENTS = '--terminal' COMPRESS_YUGLIFY_JS_ARGUMENTS = '--terminal' COMPRESS_YUI_BINARY = 'java -jar yuicompressor.jar' COMPRESS_YUI_CSS_ARGUMENTS = '' COMPRESS_YUI_JS_ARGUMENTS = '' CSRF_COOKIE_AGE = 31449600 CSRF_COOKIE_DOMAIN = None CSRF_COOKIE_HTTPONLY = False CSRF_COOKIE_MASKED = False CSRF_COOKIE_NAME = 'csrftoken' CSRF_COOKIE_PATH = '/' CSRF_COOKIE_SAMESITE = 'Lax' CSRF_COOKIE_SECURE = False CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure' CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN' CSRF_TRUSTED_ORIGINS = [] CSRF_USE_SESSIONS = False DATABASES = {'default': {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'mailmanweb', 'USER': 'mailman', 'PASSWORD': '********************', 'HOST': 'localhost', 'PORT': '5432', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'CONN_HEALTH_CHECKS': False, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIGRATE': True, 'MIRROR': None, 'NAME': None}}} DATABASE_ROUTERS = [] DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440 DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000 DATA_UPLOAD_MAX_NUMBER_FILES = 100 DATETIME_FORMAT = 'N j, Y, P' DATETIME_INPUT_FORMATS = ['%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M'] DATE_FORMAT = 'N j, Y' DATE_INPUT_FORMATS = ['%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y'] DEBUG = False DEBUG_PROPAGATE_EXCEPTIONS = False DECIMAL_SEPARATOR = '.' DEFAULT_AUTO_FIELD = 'django.db.models.AutoField' DEFAULT_CHARSET = 'utf-8' DEFAULT_EXCEPTION_REPORTER = 'django.views.debug.ExceptionReporter' DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter' DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage' DEFAULT_FROM_EMAIL = 'mailman(a)ucl.ac.uk' DEFAULT_INDEX_TABLESPACE = '' DEFAULT_TABLESPACE = '' DISALLOWED_USER_AGENTS = [] EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend' EMAIL_HOST = '*************' EMAIL_HOST_PASSWORD = '********************' EMAIL_HOST_USER = '' EMAIL_PORT = 25 EMAIL_SSL_CERTFILE = None EMAIL_SSL_KEYFILE = '********************' EMAIL_SUBJECT_PREFIX = '[Django] ' EMAIL_TIMEOUT = None EMAIL_USE_LOCALTIME = False EMAIL_USE_SSL = False EMAIL_USE_TLS = False FILE_UPLOAD_DIRECTORY_PERMISSIONS = None FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler'] FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440 FILE_UPLOAD_PERMISSIONS = 420 FILE_UPLOAD_TEMP_DIR = None FILTER_VHOST = False FIRST_DAY_OF_WEEK = 0 FIXTURE_DIRS = [] FORCE_SCRIPT_NAME = None FORMAT_MODULE_PATH = None FORM_RENDERER = 'django.forms.renderers.DjangoTemplates' HAYSTACK_CONNECTIONS = {'default': {'PATH': '/opt/mailman/web/xapian_index', 'ENGINE': 'xapian_backend.XapianEngine'}} HYPERKITTY_ENABLE_GRAVATAR = False IGNORABLE_404_URLS = [] INSTALLED_APPS = ['hyperkitty', 'postorius', 'django_mailman3', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.humanize', 'rest_framework', 'django_gravatar', 'compressor', 'haystack', 'django_extensions', 'django_q', 'allauth', 'allauth.account', 'allauth.socialaccount'] INTERNAL_IPS = [] LANGUAGES = [('af', 'Afrikaans'), ('ar', 'Arabic'), ('ar-dz', 'Algerian Arabic'), ('ast', 'Asturian'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('ckb', 'Central Kurdish (Sorani)'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'), ('hy', 'Armenian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('ig', 'Igbo'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kab', 'Kabyle'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('ky', 'Kyrgyz'), ('lb', 'Luxembourgish'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'), ('ms', 'Malay'), ('my', 'Burmese'), ('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('tg', 'Tajik'), ('th', 'Thai'), ('tk', 'Turkmen'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('uz', 'Uzbek'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')] LANGUAGES_BIDI = ['he', 'ar', 'ar-dz', 'ckb', 'fa', 'ur'] LANGUAGE_CODE = 'en-us' LANGUAGE_COOKIE_AGE = None LANGUAGE_COOKIE_DOMAIN = None LANGUAGE_COOKIE_HTTPONLY = False LANGUAGE_COOKIE_NAME = 'django_language' LANGUAGE_COOKIE_PATH = '/' LANGUAGE_COOKIE_SAMESITE = None LANGUAGE_COOKIE_SECURE = False LOCALE_PATHS = [] LOGGING = {'version': 1, 'disable_existing_loggers': False, 'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'}}, 'handlers': {'mail_admins': {'level': 'ERROR', 'filters': ['require_debug_false'], 'class': 'django.utils.log.AdminEmailHandler'}, 'file': {'level': 'INFO', 'class': 'logging.handlers.WatchedFileHandler', 'filename': '/opt/mailman/mm/var/logs/mailmanweb.log', 'formatter': 'verbose'}, 'console': {'class': 'logging.StreamHandler', 'formatter': 'simple'}}, 'loggers': {'django.request': {'handlers': ['mail_admins', 'file'], 'level': 'ERROR', 'propagate': True}, 'django': {'handlers': ['file'], 'level': 'ERROR', 'propagate': True}, 'hyperkitty': {'handlers': ['file'], 'level': 'DEBUG', 'propagate': True}, 'postorius': {'handlers': ['console', 'file'], 'level': 'INFO'}, 'q': {'level': 'WARNING', 'propagate': False, 'handlers': ['console', 'file']}}, 'formatters': {'verbose': {'format': '%(levelname)s %(asctime)s %(process)d %(name)s %(message)s'}, 'simple': {'format': '%(levelname)s %(message)s'}}} LOGGING_CONFIG = 'logging.config.dictConfig' LOGIN_REDIRECT_URL = 'list_index' LOGIN_URL = 'account_login' LOGOUT_REDIRECT_URL = None LOGOUT_URL = 'account_logout' MAILMAN_ARCHIVER_FROM = "('127.0.0.1', '::1')" MAILMAN_ARCHIVER_KEY = '********************' MAILMAN_REST_API_PASS = '********************' MAILMAN_REST_API_URL = '********************' MAILMAN_REST_API_USER = '********************' MANAGERS = [] MEDIA_ROOT = '' MEDIA_URL = '/' MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage' MESSAGE_TAGS = {40: 'danger'} MIDDLEWARE = "('allauth.account.middleware.AccountMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'django.middleware.security.SecurityMiddleware', 'django_mailman3.middleware.TimezoneMiddleware', 'postorius.middleware.PostoriusMiddleware')" MIGRATION_MODULES = {} MONTH_DAY_FORMAT = 'F j' NUMBER_GROUPING = 0 PASSWORD_HASHERS = '********************' PASSWORD_RESET_TIMEOUT = '********************' POSTORIUS_TEMPLATE_BASE_URL = 'http://localhost:8000' PREPEND_WWW = False Q_CLUSTER = {'retry': 360, 'timeout': 300, 'save_limit': 100, 'orm': 'default'} ROOT_URLCONF = 'mailman_web.urls' SECRET_KEY = '********************' SECRET_KEY_FALLBACKS = '********************' SECURE_CONTENT_TYPE_NOSNIFF = True SECURE_CROSS_ORIGIN_OPENER_POLICY = 'same-origin' SECURE_HSTS_INCLUDE_SUBDOMAINS = False SECURE_HSTS_PRELOAD = False SECURE_HSTS_SECONDS = 0 SECURE_PROXY_SSL_HEADER = None SECURE_REDIRECT_EXEMPT = [] SECURE_REFERRER_POLICY = 'same-origin' SECURE_SSL_HOST = None SECURE_SSL_REDIRECT = False SERVER_EMAIL = 'mailman(a)ucl.ac.uk' SESSION_CACHE_ALIAS = 'default' SESSION_COOKIE_AGE = 1209600 SESSION_COOKIE_DOMAIN = None SESSION_COOKIE_HTTPONLY = True SESSION_COOKIE_NAME = 'sessionid' SESSION_COOKIE_PATH = '/' SESSION_COOKIE_SAMESITE = 'Lax' SESSION_COOKIE_SECURE = False SESSION_ENGINE = 'django.contrib.sessions.backends.db' SESSION_EXPIRE_AT_BROWSER_CLOSE = False SESSION_FILE_PATH = None SESSION_SAVE_EVERY_REQUEST = False SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer' SETTINGS_MODULE = 'settings' SHORT_DATETIME_FORMAT = 'm/d/Y P' SHORT_DATE_FORMAT = 'm/d/Y' SIGNING_BACKEND = 'django.core.signing.TimestampSigner' SILENCED_SYSTEM_CHECKS = [] SITE_ID = 1 SOCIALACCOUNT_PROVIDERS = {'openid': {'SERVERS': [{'id': 'yahoo', 'name': 'Yahoo', 'openid_url': 'https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fme.yahoo.c…'}]}, 'google': {'SCOPE': ['profile', 'email'], 'AUTH_PARAMS': {'access_type': 'online'}}, 'facebook': {'METHOD': 'oauth2', 'SCOPE': ['email'], 'FIELDS': ['email', 'name', 'first_name', 'last_name', 'locale', 'timezone'], 'VERSION': 'v2.4'}} STATICFILES_DIRS = '()' STATICFILES_FINDERS = "('django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder', 'compressor.finders.CompressorFinder')" STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage' STATIC_ROOT = '/opt/mailman/web/static' STATIC_URL = '/static/' STORAGES = {'default': {'BACKEND': 'django.core.files.storage.FileSystemStorage'}, 'staticfiles': {'BACKEND': 'django.contrib.staticfiles.storage.StaticFilesStorage'}} TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'APP_DIRS': True, 'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.i18n', 'django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.tz', 'django.template.context_processors.csrf', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', 'django_mailman3.context_processors.common', 'hyperkitty.context_processors.common', 'postorius.context_processors.postorius']}}] TEST_NON_SERIALIZED_APPS = [] TEST_RUNNER = 'django.test.runner.DiscoverRunner' THOUSAND_SEPARATOR = ',' TIME_FORMAT = 'P' TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] TIME_ZONE = 'UTC' USE_DEPRECATED_PYTZ = False USE_I18N = True USE_L10N = True USE_THOUSAND_SEPARATOR = False USE_TZ = True USE_X_FORWARDED_HOST = False USE_X_FORWARDED_PORT = False WSGI_APPLICATION = 'mailman_web.wsgi.application' X_FRAME_OPTIONS = 'DENY' YEAR_MONTH_FORMAT = 'F Y'

3 5

cron error - /opt/mailman/venv/bin/mailman-web runjobs daily
by Odhiambo Washington Aug. 21, 2025

Aug. 21, 2025

I wonder what this means and whether it's fatal. How do I fix it? ``` ERROR OCCURED IN JOB: sync_mailman (APP: hyperkitty) Traceback (most recent call last): File "/opt/mailman/venv/lib/python3.11/site-packages/django_extensions/management/commands/runjobs.py", line 51, in runjobs job().execute() File "/opt/mailman/venv/lib/python3.11/site-packages/hyperkitty/jobs/sync_mailman.py", line 36, in execute sync_with_mailman() File "/opt/mailman/venv/lib/python3.11/site-packages/hyperkitty/lib/mailman.py", line 178, in sync_with_mailman mlist.update_from_mailman() File "/opt/mailman/venv/lib/python3.11/site-packages/hyperkitty/models/mailinglist.py", line 226, in update_from_mailman self._update_owner_mods_from_mailman(mm_list) File "/opt/mailman/venv/lib/python3.11/site-packages/hyperkitty/models/mailinglist.py", line 231, in _update_owner_mods_from_mailman user = get_django_user(owner) ^^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib/python3.11/site-packages/django_mailman3/lib/user.py", line 30, in get_django_user email_addr = EmailAddress.objects.get(email=member.address.email) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib/python3.11/site-packages/django/db/models/manager.py", line 87, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/mailman/venv/lib/python3.11/site-packages/django/db/models/query.py", line 640, in get raise self.model.MultipleObjectsReturned( *allauth.account.models.EmailAddress.MultipleObjectsReturned: get() returned more than one EmailAddress -- it returned 2!* ``` I suspect it's something to do with my action yesterday while attempting to reply to a thread from HyperKitty. The superuser account uses my address - odhiambo at gmail dot com.I am also the listowner for most lists. I tried unsuccessfully to create an account on Postorious using the same email address. I kept getting sent links to verify the account, over and over. Finally, I was able to verify the account, but cannot login with it. -- 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]

3 6

Spam from non list members
by Odhiambo Washington Aug. 20, 2025

Aug. 20, 2025

Hello Team, I have received spam in the last few days, posted to one of my lists. The spam is from non-subscribers. I am wondering how this spam makes it to the list in the first place, and how to stop them. Below are the headers from one such spam: ``` Delivered-To: odhiambo(a)gmail.com Received: by 2002:a05:6358:478c:b0:1f8:8ba6:62f4 with SMTP id i12csp6474433rwn; Mon, 18 Aug 2025 13:08:57 -0700 (PDT) X-Google-Smtp-Source: AGHT+IHwGjDJGZU1VZV2Thd34wgXeV2X6aweYtnKYgygiua1m7FH5CCqq+Meam6X7EFnMO9s7JBE X-Received: by 2002:a17:906:7314:b0:af4:11e1:f877 with SMTP id a640c23a62f3a-afddcb70ffamr6800866b.21.1755547737149; Mon, 18 Aug 2025 13:08:57 -0700 (PDT) ARC-Seal: i=2; a=rsa-sha256; t=1755547737; cv=pass; d=google.com; s=arc-20240605; b=SxOZ4g+V75ZlHjnb68dGFk0C43UBXEiiHFbsec2Nd8CciQe2WoDWDKivUrl9AOXU8C JtJmmL+iQfTp/gAwWVbIys7CzEEKx3zoApV867a0tIoQO3GJpNz/wMJ2uJhNwNJ13rCZ 3VpCG0/8yMKme8Gl+wi2hFlpTusPD5//yEvj+2nUjbPyqlQTsgiGK40IsE2dPSv7nuG7 SLCJlXQCxPLlUVo7Qhi8TuK5jmbK2k0JP4L2QpGXISMX5oRUJJX7BoZT5bn8eXRPLGUq IYGEqw+PUP9E/qwBLRrJ+aESBQsfAwMtjQn9UC9jJHX3kXkjL3a5SuOrrbxlXnfnTijU w8NA== ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:from:list-unsubscribe:list-subscribe:list-post:list-owner :list-help:list-archive:archived-at:list-id:subject:reply-to :precedence:message-id-hash:message-id:to:date:mime-version :dkim-signature; bh=68hDV7fTzXN9aXRXs+9wXgUwlV63FoOfuranZTCGBok=; fh=LcmHOTIZU58Nx4GQGbrz/At1kQTaA+xCcs3xKrMC9Wg=; b=OIvR32zF5EzJs4iH6pixYvTBd9Iwk9uWSDONJeWI3PdG2RPnT36Tj5sApTR8UhVtir d2vO3HCSlHlFI4+uMXE/upRQ3KQVCWYPT6LQpnkoEVrRoMJjqHobtTceOtBlGxIX00G6 Vfa8s7ZwcBoX2XjbRcesjHVB9mtrukG05CULR2u88JsS90d1qGMjSeitGuyY5QLEKJ+H S1q1s7b6fMKfnb267vEvxIKYerfeDdDOHanGNhD04NB3SlSyecm6b48AknFCZi7GzJsR EvLXXa3C2jibniaKXmEF5AG0VRtxoP0PBpHjUmIK/kZnuEpHCBYFu2tFgzFI5FCwNnYv 6jbA==; dara=google.com ARC-Authentication-Results: i=2; mx.google.com; dkim=neutral (body hash did not verify) header.i=(a)gmail.com header.s=20230601 header.b=lrYcmBua; arc=pass (i=1 dkim=pass dkdomain=gmail.com dmarc=pass fromdomain= gmail.com) spf=pass (google.com: domain of kictanet-bounces+odhiambo= gmail.com(a)lists.kictanet.or.ke designates 62.169.28.150 as permitted sender) smtp.mailfrom="kictanet-bounces+odhiambo= gmail.com(a)lists.kictanet.or.ke"; dmarc=pass (p=REJECT sp=NONE dis=NONE) header.from= lists.kictanet.or.ke Return-Path: <kictanet-bounces+odhiambo=gmail.com(a)lists.kictanet.or.ke> Received: from eu.kictanet.or.ke (eu.kictanet.or.ke. [62.169.28.150]) by mx.google.com with ESMTPS id a640c23a62f3a-afcdcfe5991si517853766b.444.2025.08.18.13.08.56 for <odhiambo(a)gmail.com> (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 18 Aug 2025 13:08:57 -0700 (PDT) Received-SPF: pass (google.com: domain of kictanet-bounces+odhiambo= gmail.com(a)lists.kictanet.or.ke designates 62.169.28.150 as permitted sender) client-ip=62.169.28.150; Authentication-Results: mx.google.com; dkim=neutral (body hash did not verify) header.i=(a)gmail.com header.s=20230601 header.b=lrYcmBua; arc=pass (i=1 dkim=pass dkdomain=gmail.com dmarc=pass fromdomain= gmail.com) spf=pass (google.com: domain of kictanet-bounces+odhiambo= gmail.com(a)lists.kictanet.or.ke designates 62.169.28.150 as permitted sender) smtp.mailfrom="kictanet-bounces+odhiambo= gmail.com(a)lists.kictanet.or.ke"; dmarc=pass (p=REJECT sp=NONE dis=NONE) header.from= lists.kictanet.or.ke Received: from localhost ([127.0.0.1]) by eu.kictanet.or.ke with esmtp (Exim 4.98.1) (envelope-from <kictanet-bounces+odhiambo= gmail.com(a)lists.kictanet.or.ke>) id 1uo6A4-0000000CHwU-30KF for odhiambo(a)gmail.com; Mon, 18 Aug 2025 23:08:56 +0300 ARC-Seal: i=1; cv=none; a=rsa-sha256; d=lists.kictanet.or.ke; s=key1; t=1755547736; b=WkY2XGB/eY32LXMsnCNNrNdXajnBtFGm4p5kjCBhIEAcd+rwyzcg26LYFQG7xp/C2eDHU 0Ij/iuvUvOll+9RGPyq73w8FOw15OR1M/h5mN/HbykF4Gnh+6pU8d8DaK2h7E9eTAMIRDDR mOOdT73jjkynnevslUkGAIh/vxfWdjk= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d= lists.kictanet.or.ke; s=key1; t=1755547736; h=from : sender : reply-to : subject : date : message-id : to : cc : mime-version : content-type : content-transfer-encoding : content-id : content-description : resent-date : resent-from : resent-sender : resent-to : resent-cc : resent-message-id : in-reply-to : references : list-id : list-help : list-unsubscribe : list-subscribe : list-post : list-owner : list-archive; bh=68hDV7fTzXN9aXRXs+9wXgUwlV63FoOfuranZTCGBok=; b=q+bZ206QFffk+jpGYRebx7cXXD8dTCLs1b68gzV3Uy+YFTO9p03p5ENBl9kr1DvcJALbh 7mPz/3YdH7Sa1CS3mZhelKmjqhYWQtZMOOzJ7/kXbO8jEUpHoEFXaxQO1HNNm28zaYy12pk WAYeNDzfyGoGKKZKgzmuQKdAYCNk+Sk= ARC-Authentication-Results: i=1; eu.kictanet.or.ke; dkim=pass header.d= gmail.com; arc=none; dmarc=pass header.from=gmail.com policy.dmarc=quarantine Authentication-Results: eu.kictanet.or.ke; dkim=pass header.d=gmail.com; arc=none (Message is not ARC signed); dmarc=pass (Used From Domain Record) header.from=gmail.com policy.dmarc=quarantine Received: from mail-oi1-f176.google.com ([209.85.167.176]) by eu.kictanet.or.ke with esmtps (TLS1.3:ECDHE_X25519__ECDSA_SECP256R1_SHA256__AES_128_GCM:128) (Exim 4.98.1) (envelope-from <quickshop444(a)gmail.com>) id 1uo69F-0000000CHw6-1JXW for kictanet(a)lists.kictanet.or.ke; Mon, 18 Aug 2025 23:08:06 +0300 Received: by mail-oi1-f176.google.com with SMTP id 5614622812f47-435de702f1fso2631726b6e.1 for <kictanet(a)lists.kictanet.or.ke>; Mon, 18 Aug 2025 13:08:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755547683; x=1756152483; darn= lists.kictanet.or.ke; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=VIfOtrMM7bTnhQ2Vwudc5SN3FMByl3WOhTpPHII44vg=; b=lrYcmBua+w6Bq0NF+BjwZgn8yxO7BXzLEigyKu+xeimln4TjDkkDHPzCJoW2qln051 PB/DLqRobhXvFiB80p4tCguJkioXwsArwcLpz0eKrZi5+KFyFF4i3Y8aVOnHjZuQVoWn i0R3iRIWoK1J7dhhE+Z6SjRqgydk9t2nTKjWP8Qpgj+ONNUhF2RUeJnbZDPzVOXJOkOM g6pus9P42pT2Qp8xqunoYrwE1C5J4ziHPGGmAcIqZxK4TAL1rlHBWsy5efwaZZHBVvH4 5+oh+lw0X8P6/lBaExCuf4O9xj0ktRnwF/oHKbxMc8OsNAsXUqK+7zJuGsVOlAxfI8tF eGaw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755547683; x=1756152483; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=VIfOtrMM7bTnhQ2Vwudc5SN3FMByl3WOhTpPHII44vg=; b=iyOUsbMz9IsR6xGEZ1Lvn+ragXtxE1CfvCDZHmTlRU4KKEykXa9RnRe6lmCFVJKQYH BMxZ59L87Vtf5AXa5Vt8LeTqULxxxHOztYCCv+csi+VxYtPBr1lUZSwnPUMO37iT1uvt QOr7AWvedxrt1MvxzfPhDQOarrOay9EChH0s9nXOysFdvjYXKHx2i0vhEGIXnjAj5ui2 e53iIqnDMJ+iv6VSMxHE9O+3421rsuXaYogucRQ7FVhae9FPaxAe5cgtSk71wrqpKh6Y vWVKwlZVztPGcnX2R05ea2BKV0abHRJs0kioN036/2wwJcJX3m+tLqA0T0qU+Gea29tH 4e0g== X-Forwarded-Encrypted: i=1; AJvYcCXJYQJTIxYe+ntWNIJiIQdkhulnObBqF1pTm+MLmzzHR4xeMvq7zSVVLgyN7kVydj7UNXu5A+KFGA==@ lists.kictanet.or.ke X-Gm-Message-State: AOJu0YzBFe9uK6i55MNFpUaAY6wiAhSx4GeurEwMn/DWn6BM4nk4ry8Z ajoJRzQlF3Hwux2sHk4q5ra/GGkHMzgm1bayjVK8W9Xk4Dg5995oiNIHaIsRpd8g2xBOF9uTtxX zAZJ2auVDEvfzWQCxSP+87j6Wd8HNP872LiKfSRralIoS X-Gm-Gg: ASbGncv/WYBdRjKCdN2pJTsDyku20b+nOFUnMvxuNuEGPQPuFCOpCp/MBCYuDl2lQWt 00iuEMQW9S+FLITUAOo8+QSRVOzIWknJTUsqmVz5NwK3sXpnuivw9BiWnIs1H5Blm4lJpMArMCs npvmQuRwWfuA99g9LeiaxGiVoLxj9qhGJzRTKa+wVOR2OkCdK6BFtTwo1xl5gRqH/bRMWfa5HIK 1DO7Ro2XX7OAxSWonfeRQ== X-Received: by 2002:a17:902:e54a:b0:240:3f4d:b9b1 with SMTP id d9443c01a7336-2449d05e0a3mr8416945ad.29.1755547279353; Mon, 18 Aug 2025 13:01:19 -0700 (PDT) MIME-Version: 1.0 Date: Mon, 18 Aug 2025 13:00:00 -0700 X-Gm-Features: Ac12FXwU-LzlgvQbYAbxCFBjP5t_XgFleCuipXiCWzABWwrGt1wOQB1VonTnm7k To: Odhiambo Washington <odhiambo(a)gmail.com> X-DKIM: Status on eu.kictanet.or.ke (62.169.28.150) using Exim 4.98.1: dkim=pass; signing_identity="gmail.com" X-Spam-Score: 3.0 (++) X-Spam-Report: Action: no action Symbol: DWL_DNSWL_NONE(0.00) Symbol: ARC_NA(0.00) Symbol: R_DKIM_ALLOW(-0.20) Symbol: RWL_MAILSPIKE_POSSIBLE(0.00) Symbol: FROM_HAS_DN(0.00) Symbol: TO_DN_SOME(0.00) Symbol: FREEMAIL_FROM(0.00) Symbol: R_SPF_ALLOW(-0.20) Symbol: MIME_GOOD(-0.10) Symbol: PREVIOUSLY_DELIVERED(0.00) Symbol: URI_COUNT_ODD(1.00) Symbol: TO_MATCH_ENVRCPT_SOME(0.00) Symbol: MID_RHS_MATCH_FROMTLD(0.00) Symbol: DKIM_TRACE(0.00) Symbol: RCPT_COUNT_TWO(0.00) Symbol: DMARC_POLICY_ALLOW(-0.50) Symbol: RCVD_IN_DNSWL_NONE(0.00) Symbol: SUBJECT_ENDS_EXCLAIM(0.00) Symbol: FROM_EQ_ENVFROM(0.00) Symbol: MIME_TRACE(0.00) Symbol: RCVD_TLS_LAST(0.00) Symbol: ASN(0.00) Symbol: RCVD_COUNT_TWO(0.00) Symbol: FREEMAIL_ENVFROM(0.00) Symbol: R_UNDISC_RCPT(3.00) Message-ID: CAEqek54J5Ad1Z65moLQ8zqKDYeF8Ri35QXVKpqjnJQghHo1dyw(a)mail.gmail.com X-Spam-Score-Integer: 29 Message-ID: < CAEqek54J5Ad1Z65moLQ8zqKDYeF8Ri35QXVKpqjnJQghHo1dyw(a)mail.gmail.com> Message-ID-Hash: XWBI7NL5ECN4ZKRW2VWIBHDKXLD7UPCH X-Message-ID-Hash: XWBI7NL5ECN4ZKRW2VWIBHDKXLD7UPCH X-MailFrom: quickshop444(a)gmail.com X-Mailman-Rule-Hits: header-match-kictanet.lists.kictanet.or.ke-18 X-Mailman-Rule-Misses: dmarc-mitigation; no-senders; approved; loop; banned-address; header-match-kictanet.lists.kictanet.or.ke-0; header-match-kictanet.lists.kictanet.or.ke-1; header-match-kictanet.lists.kictanet.or.ke-2; header-match-kictanet.lists.kictanet.or.ke-3; header-match-kictanet.lists.kictanet.or.ke-4; header-match-kictanet.lists.kictanet.or.ke-5; header-match-kictanet.lists.kictanet.or.ke-6; header-match-kictanet.lists.kictanet.or.ke-7; header-match-kictanet.lists.kictanet.or.ke-8; header-match-kictanet.lists.kictanet.or.ke-9; header-match-kictanet.lists.kictanet.or.ke-10; header-match-kictanet.lists.kictanet.or.ke-11; header-match-kictanet.lists.kictanet.or.ke-12; header-match-kictanet.lists.kictanet.or.ke-13; header-match-kictanet.lists.kictanet.or.ke-14; header-match-kictanet.lists.kictanet.or.ke-15; header-match-kictanet.lists.kictanet.or.ke-16; header-match-kictanet.lists.kictanet.or.ke-17 X-Mailman-Version: 3.3.10 Precedence: list Reply-To: "Kenya's premier ICT Policy engagement platform." < kictanet(a)lists.kictanet.or.ke> Subject: [kictanet] Never Miss a Moment: Discover our Ultimate Wireless Mini Wi-Fi Security Camera! Easy to install, app-controlled, with night vision and motion detection—stay secure and connected! List-Id: "Kenya's premier ICT Policy engagement platform." < kictanet.lists.kictanet.or.ke> Archived-At: < https://lists.kictanet.or.ke/archives/list/kictanet@lists.kictanet.or.ke/me… > List-Archive: < https://lists.kictanet.or.ke/archives/list/kictanet@lists.kictanet.or.ke/> List-Help: <mailto:kictanet-request@lists.kictanet.or.ke?subject=help> List-Owner: <mailto:kictanet-owner@lists.kictanet.or.ke> List-Post: <mailto:kictanet@lists.kictanet.or.ke> List-Subscribe: <mailto:kictanet-join@lists.kictanet.or.ke> List-Unsubscribe: <mailto:kictanet-leave@lists.kictanet.or.ke> From: Quick Shop via KICTANet <kictanet(a)lists.kictanet.or.ke> Cc: Quick Shop <quickshop444(a)gmail.com> Content-Type: multipart/mixed; boundary="===============5859792345051880634==" --===============5859792345051880634== Content-Type: multipart/alternative; boundary="000000000000f8ee83063ca93364" --000000000000f8ee83063ca93364 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable ``` -- 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]

6 13

Column 'starting_email_id' cannot be null
by kroerig＠web.de Aug. 18, 2025

Aug. 18, 2025

Hello, after upgrading from Debian 11 to Debian 12 achiving incoming mails always fails with Traceback (most recent call last): File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 581, in get_or_create return self.get(**kwargs), False File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 435, in get raise self.model.DoesNotExist( During handling of the above exception (Thread matching query does not exist.), another exception occurred: File "/usr/lib/python3/dist-packages/django/db/backends/mysql/base.py", line 73, in execute return self.cursor.execute(query, args) File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 316, in _query self._do_get_result(db) File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 147, in _do_get_result self._result = result = self._get_result() File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 349, in _get_result return self._get_db().store_result() During handling of the above exception ((1048, "Column 'starting_email_id' cannot be null")), another exception occurred: File "/usr/lib/python3/dist-packages/django/core/handlers/exception.py", line 47, in inner response = get_response(request) File "/usr/lib/python3/dist-packages/django/core/handlers/base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/usr/lib/python3/dist-packages/django/views/decorators/http.py", line 40, in inner return func(request, *args, **kwargs) File "/usr/lib/python3/dist-packages/hyperkitty/views/mailman.py", line 117, in _decorator return func(request, *args, **kwargs) File "/usr/lib/python3/dist-packages/django/views/decorators/csrf.py", line 54, in wrapped_view return view_func(*args, **kwargs) File "/usr/lib/python3/dist-packages/hyperkitty/views/mailman.py", line 163, in archive add_to_list(mlist_fqdn, msg) File "/usr/lib/python3/dist-packages/hyperkitty/lib/incoming.py", line 153, in add_to_list email.save() File "/usr/lib/python3/dist-packages/django/db/models/base.py", line 739, in save self.save_base(using=using, force_insert=force_insert, File "/usr/lib/python3/dist-packages/django/db/models/base.py", line 763, in save_base pre_save.send( File "/usr/lib/python3/dist-packages/django/dispatch/dispatcher.py", line 180, in send return [ File "/usr/lib/python3/dist-packages/django/dispatch/dispatcher.py", line 181, in <listcomp> (receiver, receiver(signal=self, sender=sender, **named)) File "/usr/lib/python3/dist-packages/hyperkitty/signals.py", line 48, in Email_on_pre_save kwargs["instance"].on_pre_save() File "/usr/lib/python3/dist-packages/hyperkitty/models/email.py", line 239, in on_pre_save thread, _thread_created = Thread.objects.get_or_create( File "/usr/lib/python3/dist-packages/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 588, in get_or_create return self.create(**params), True File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 453, in create obj.save(force_insert=True, using=self.db) File "/usr/lib/python3/dist-packages/django/db/models/base.py", line 739, in save self.save_base(using=using, force_insert=force_insert, File "/usr/lib/python3/dist-packages/django/db/models/base.py", line 776, in save_base updated = self._save_table( File "/usr/lib/python3/dist-packages/django/db/models/base.py", line 881, in _save_table results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) File "/usr/lib/python3/dist-packages/django/db/models/base.py", line 919, in _do_insert return manager._insert( File "/usr/lib/python3/dist-packages/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 1270, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql cursor.execute(sql, params) File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers return executor(sql, params, many, context) File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/lib/python3/dist-packages/django/db/backends/mysql/base.py", line 78, in execute raise IntegrityError(*tuple(e.args)) Exception Type: IntegrityError at /hyperkitty/api/mailman/archive Exception Value: (1048, "Column 'starting_email_id' cannot be null") Postorius Version 1.3.8 HyperKitty Version 1.3.7 Any ideas how to fix this? Klauas

4 5

help with startup scripts
by Piet Barber Aug. 15, 2025

Aug. 15, 2025

Hello, I'm trying to get mailman3 working on Ubuntu. I'm following these instructions: https://docs.list.org/en/latest/install/virtualenv.html#setup-virtualenv I've gotten to the point where I can successfully su - to the mailman3 user, and manually start the mailman3 process with the startup command. However, when I follow the systemctl startup scripts as per the instructions at the URL above, it get stuck in the startup ... forever Starting from the command line works great! (venv) mailman@arcus:~$ /opt/mailman/venv/bin/mailman start Starting Mailman's master runner Generating MTA alias maps (venv) mailman@arcus:~$ (venv) mailman@arcus:~$ /opt/mailman/venv/bin/mailman status GNU Mailman is running (master pid: 47815) But when I try to start it from systemctl, it just hangs forever... root@arcus:/etc/nginx# systemctl start mailman3 If I background it, and check it out from systemctl status, I get that It's stuck in the startup mode. root@arcus:/etc/nginx# systemctl status mailman3 ● mailman3.service - GNU Mailing List Manager Loaded: loaded (/etc/systemd/system/mailman3.service; enabled; preset: enabled) Active: activating (start) since Wed 2025-08-13 23:12:05 UTC; 29s ago Process: 49024 ExecStart=/opt/mailman/venv/bin/mailman start (code=exited, status=0/SUCCESS) Tasks: 17 (limit: 4605) Memory: 878.0M (peak: 878.5M) CPU: 11.030s I've tried this with and without the forking entry in the systemctl configuration. No matter what I do, it's stuck in the ... Active: activating (start) since Wed 2025-08-13 23:13:37 UTC; 27s ago What am I missing? root@arcus:/etc/nginx# cat /etc/systemd/system/mailman3.service [Unit] Description=GNU Mailing List Manager After=syslog.target network.target postgresql.service [Service] Type=forking PIDFile=/opt/mailman/mm/var/master.pid User=mailman Group=mailman Environment="MAILMAN_CONFIG_FILE=/etc/mailman3/mailman.cfg" ExecStart=/opt/mailman/venv/bin/mailman start ExecReload=/opt/mailman/venv/bin/mailman restart ExecStop=/opt/mailman/venv/bin/mailman stop Restart=on-failure RestartSec=15 [Install] WantedBy=multi-user.target root@arcus:/# -- Piet Barber http://www.pietbarber.com/ http://blog.pietbarber.com/

4 7

db migration from mailman3.2.2 to mailman3.3.9 (sqlite3 to postgres16)
by Peter Thornton Aug. 13, 2025

Aug. 13, 2025

Hello, I know this question comes up here periodically, but I am having some trouble performing a data migration from an older version of mailman3 to a more recent one. We have a legacy environment with: mailman3.2.2 postorius 1.2.4 hyperkitty 1.2.2 there are two sqlite3 dbs for mailman core and mailman web. I've staged a new environment using the docker-mailman project with the following: mailman3.3.9 postorius 1.3.10 hyperkitty 1.3.8 there is a single postgres db here for both core and web. I've tried migration a few different ways, using pgloader, and also with some manual python scripts. Data is definitely not my forte, but I am struggling to get a working instance. I am running into several issues such as foreignkeyviolations, datatype mismatches, unique PK errors, etc.. Does anyone out there have a prescriptive process for this migration, or a suggestion for workflow/tooling that has worked in a similar upgrade process? Thanks! -Peter

2 1

default processing
by Sam Darwin Aug. 13, 2025

Aug. 13, 2025

Notice the repeated use of the word "default" (which is a great word, by the way). This creates confusion: Default action to take when this member posts to the list. List default -- follow the list's default member action. Default Processing -- run additional checks and accept the message. Due to backwards compatibility it may be difficult to change. But if it could be modified, how about: Action to take when this member posts to the list. List default -- follow the list's default member action. Standard Processing -- run additional checks and accept the message. In other words, in the context of message acceptance, the word "default" should have a certain selected meaning. Then make extra effort to choose other words for other actions, as proposed here, "Standard Processing", or something similar.

3 8

Website 404 error
by peter＠pi4cc.nl Aug. 11, 2025

Aug. 11, 2025

Hello I'm running Debian 12 with the latest version and installed mailman3 via apt install-mailman3-full. Everything works, I'm using MySQL as the database. There's something strange, and I can't find a source/solution. When I first access the website domain.nl/mailman3, it's redirected to domain.nl/mailman/postorius/lists/, resulting in a 404 error (3 after mailman is missing). When I accessed it a second time with the same link (domain.nl/mailman3), I was redirected to domain.nl/mailman3/postorius/lists and the welcome page appeared. This is strange... I tested it on a mobile device with Chrome and Firefox, and on a desktop with Chrome and Edge. All the results were the same. Is there a specific file to look add? Regards, Peter

3 2

Migration of archives mailman2 to mailman3: python: can't open file '/opt/mailman/manage.py': [Errno 2] No such file or directory
by Wikinaut Aug. 10, 2025

Aug. 10, 2025

Your current *) documentation says Migrate the list archives from Mailman 2 to Mailman 3 by running the following command: $ python manage.py hyperkitty_import -l foo-list(a)example.com $var_prefix/archives/private/foo-list.mbox/foo-list.mbox (venv) /opt/mailman $ python manage.py python: can't open file '/opt/mailman/manage.py': [Errno 2] No such file or directory What did I wrong or what is that part of your documentation missing? *) https://docs.mailman3.org/en/latest/migration.html

3 6

I wanted to upgrade the mailman3 documentation, but cannot see the promised link "edit on github"
by Wikinaut Aug. 10, 2025

Aug. 10, 2025

https://docs.mailman3.org/en/latest/documentation.html#edit-on-gitlab Please can you fix that?

1 0

Vote irregularities
by Ron Aug. 10, 2025

Aug. 10, 2025

I've been playing with the voting system on a couple of lists (this one included). There are some weird behaviours I've noticed: * votes are frequently not immediately reflected - a page reload is required * some votes display as: 0 0 You dislike it (cancel) Here we see I've voted on a message, but the counts are still zero up and zero down. I just down-voted one of my posts as a test, and nothing changed in the page to reflect the vote. Often it takes multiple clicks, sometimes a page reload. Browser console shows voting generates a 200 response to a POST method, but the JSON confuses me: like 0 dislike 0 html '\n\n <form method="post" class="likeform"\n action="/archives/list/talk(a)lists.domain.tld/message/IK6WH4IQPZXOG3CIFV4CJGOKVFARGXA5/vote">\n <input type="hidden" name="csrfmiddlewaretoken" value="***">\n \n\t\t\n\t\t\t<a class="youlike vote "\n\t\t\thref="#like" data-vote="1" aria-label="Like thread">\n\t\t\t\t\t<i class="fa fa-thumbs-o-up"></i> 0\n\t\t\t</a>\n\t\t\t<a class="youdislike vote"\n\t\t\thref="#dislike" data-vote="-1" aria-label="Dislike thread">\n\t\t\t\t<i class="fa fa-thumbs-o-down"></i> 0\n\t\t\t</a>\n\t\t\n \n\n </form>\n' The uwsgi.log file entry for that vote is: [pid: 4010303|app: 0|req: 552908/575956] 127.0.0.1 () {66 vars in 1374 bytes} [Sun Aug 10 02:28:21 2025] POST /archives/list/talk(a)lists.domain.tld/message/IK6WH4IQPZXOG3CIFV4CJGOKVFARGXA5/vote => generated 696 bytes in 376 msecs (HTTP/1.1 200) 9 headers in 394 bytes (1 switches on core 1) Following the Permalink beside the voting options loads the specific message with no votes showing. Ctrl+F5 shows no votes. Re-casting vote and reloading shows no votes. Clicking "Back to thread" shows my message and: > 0 0 You dislike it (cancel) I don't think I've ever seen reliable voting on any MM3 site, including this one (I don't think I've seen zero / zero You {like|dislike} it (cancel) here, but multiple vote attempts to see the results is not unusual). Searching the archive shows something from ~6-7 years ago where caching was modified, seems relevant but nothing since. Am I alone in this, or is the feature so unused that nobody else noticed this?

2 1

Problem upgrading from 2.1 to 3, dockerized
by jesper.holck＠ibsgaarden.dk Aug. 9, 2025

Aug. 9, 2025

I recently followed the instructions here https://github.com/g4rf/dockerized-mailcow-mailman, and was able to create a new Mailman 3, Debian-based installation. I then followed the instructions here https://docs.mailman3.org/en/latest/migration.html in order to migrate from my old, Centos-based installation, to the new, Debian-based installation. It seemed to work well, but unfortunately a problem showed up. Whenever someone posted to one of the lists on the new installation, the messages were rejected by Postfix: postfix-mailcow-1 | Aug 5 20:55:48 ef2b760c2e61 postfix/cleanup[8681]: B7B856099EC: message-id=<A8946B8E-2A47-4701-9548-4544981FAC5E(a)gmail.com> postfix-mailcow-1 | Aug 5 20:55:49 ef2b760c2e61 postfix/cleanup[8681]: B7B856099EC: milter-reject: END-OF-MESSAGE from unknown[172.22.1.1]: 5.7.1 This message does not meet our delivery requirements; from=<mylist-bounces(a)myserver.dk> to=<mylistuser1(a)gmail.com> proto=ESMTP helo=<[172.19.199.4]> postfix-mailcow-1 | Aug 5 20:55:50 ef2b760c2e61 postfix/cleanup[8681]: 216D36099EC: message-id=<A8946B8E-2A47-4701-9548-4544981FAC5E(a)gmail.com> postfix-mailcow-1 | Aug 5 20:55:50 ef2b760c2e61 postfix/cleanup[8681]: 216D36099EC: milter-reject: END-OF-MESSAGE from unknown[172.22.1.1]: 5.7.1 This message does not meet our delivery requirements; from=<mylist-bounces(a)myserver.dk> to=<mylistuser2(a)mail.dk> proto=ESMTP helo=<[172.19.199.4]> So, for each of the existing lists, I had to delete the old list and create a new one - with the same name and the same users. After this, everything seems to work as expected. Thanks for all the work you all has put into this, Jesper

2 1

mailman addmember/syncmember commands print undecoded UTF-8 [ADD] or [DEL] mail addresses in its messages like "[ADD] =?utf-8?q?John_=....."
by Wikinaut Aug. 8, 2025

Aug. 8, 2025

My post here is merely about the information output when running mailman addmembers/syncmembers where I discovered strange looking lines. I noticed that addmember and syncmember output looks like [ADD] =?utf-8?q?John_=28Foo=29_Doe_=5Bcomment1=5D_=5Bcomment2=5D?= <john.foo.doe(a)example.com> whereas the entries in the Web-GUI look fine. I triple-checked the textfile from which the names stem from, yes, the file is UTF8. Is this behaviour of addmember/syncmember command output commonly known - or is this a small cosmetic bug? PS. At some moment I had, probably from my test and legay data file, also these codings in about fifty entries of my users lists, but deleted that users with a small script, so that user list is now clean. My post here is merely about the information output when running mailman addmembers/syncmembers.

3 9

clearing pending db
by Morris Jones Aug. 8, 2025

Aug. 8, 2025

I have an admittedly out-of-date installation of Mailman 3.3 (3.3.2 Tom Sawyer) but it's been working without issues for a long time, so I haven't had much incentive to bring it up to date. Sorry! A couple of my larger mailing lists (around 500 members) are currently very slow when making changes through the UI (maybe that's my raison-to-update). They also both have very large lists of members "pending confirmation." My suspicion is that the large pending list is slowing down other operations. But pendingdb.evict() doesn't seem to clear the list. For example, on one of my lists: >>> from mailman.interfaces.pending import IPendings >>> >>> from zope.component import getUtility >>> >>> pendingdb = getUtility(IPendings) >>> pendingdb.count() 5040 >>> pendingdb.evict() >>> pendingdb.count() 5040 >>> I have several lists, but none of them are extremely active, so I don't have a problem with wiping the pending db for all of them. And I also might be totally wrong in my guess. Mojo -- Morris Jones, Monrovia, CA

3 3

Support question, not a bug: Is it possible and how, programmatically to change all settings from domain1 to domain2?
by Wikinaut Aug. 8, 2025

Aug. 8, 2025

@Mark & Stephen, now, where here everything appears to run smoothly on a new server, I want to change the testmail.domain (domain1) settings to mail.domain (domain2) settings. It would be a great help, if this can be done by python script respectively a mailman3 shell script. Is there any on your desk, or can you help me? I already defined in mailman/admin (django admin) that new target domain. I guess, at the end, there might also be a very changes in mailman.cfg and settings.py necessary.

1 0

Main daemon process sticks around after forking
by Jérôme Charaoui Aug. 8, 2025

Aug. 8, 2025

Hello, I'm running a (rather large) mailman3 instance on Debian 13 (trixie) using the distribution packages. To manage the mailman3 daemon, the package installs this systemd service unit: https://sources.debian.org/src/mailman3/3.3.10-2/debian/mailman3.service/ It has been working fine until recently: after a reboot, we noticed the mailman3 unit consistently failing to start due to a timeout error. I figured out that the timeout was related to the service unit type (Type=forking) and the fact that the main/parent process was forking subprocesses (and running normally), writing a PID file, but it wasn't exiting, so systemd identifies this as an error and aborts the service. Since switching to Type=simple, it has been working fine. I'm wondering if anyone else has seen such behavior and how I could troubleshoot it. Thanks! -- Jérôme

2 3

How to create a list with → advertised=false ← by command line "mailman create [OPTIONS] LISTNAME" ?
by Wikinaut Aug. 7, 2025

Aug. 7, 2025

I use the following REST-API sequence (excerpt:) to create a list but want to use the much quicker command line. However, only a few [OPTIONS] can be set via command line. Why? My wish is to have all options available in the command line of mailman? Excerpt from my generateMailinglists.py: # see https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/rest/docs/… updates = { "description": f"{ML} {listname} ({NOW})", "info": f"{ML} {listname} (autogenerated {NOW})", "display_name": listname, "subject_prefix": f"[{listname.upper()}] ", "advertised": False, # the list will not be shown on mailman3 startpage "allow_list_posts": True, "default_nonmember_action": "discard", "default_member_action": "accept", "subscription_policy": "open", # accepted values are: open, confirm, moderate, confirm_then_moderate "unsubscription_policy": "open", # accepted values are: open, confirm, moderate, confirm_then_moderate "send_welcome_message": False, "send_goodbye_message": False, "archive_policy": "private", # accepted values are: public, private, never "preferred_language": "de", "member_roster_visibility": "members" # accepted values are: public, members, moderators } update_config(fqdn_listname, updates)

4 8

How to run this script (attached) in the mailman shell (or withlist)?
by Wikinaut Aug. 6, 2025

Aug. 6, 2025

https://dpaste.com/39ZMH3M7S (Text below) The code works perfectly when pasted into the live shell of mailman. But not when I start "(venv) mailman withlist -r set_member_pref". ... module = import_module(module_path) File "/usr/lib/python3.9/importlib/__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1030, in _gcd_import File "<frozen importlib._bootstrap>", line 1007, in _find_and_load File "<frozen importlib._bootstrap>", line 984, in _find_and_load_unlocked ModuleNotFoundError: No module named 'set_members_prefs' What is wrong? Please can anyone help? Please can you add information in the documentation how exactly to run a script like that? # def set_members_prefs(): from zope.component import getUtility from mailman.interfaces.listmanager import IListManager from mailman.interfaces.member import DeliveryMode, DeliveryStatus hide_address = False delivery_status = DeliveryStatus.enabled lm = getUtility(IListManager) for mlist in lm.mailing_lists: print(f"... members in {mlist.fqdn_listname}") for member in mlist.members.members: prefs = member.preferences prefs.acknowledge_posts = True prefs.hide_address = hide_address prefs.preferred_language = 'de' prefs.receive_list_copy = True prefs.receive_own_postings = True prefs.delivery_mode = DeliveryMode.regular prefs.delivery_status = delivery_status print(f"Updated {member.address.email} in list {mlist.fqdn_listname}")

2 6

Held messages not delivered after approval
by Stephan Krinetzki Aug. 6, 2025

Aug. 6, 2025

Hi all, I'm running into an issue with Mailman 3. Mails sent to a list are being held due to moderation settings — which is expected — but after approving them, they are not delivered to list members. The message does not end up in the shunt queue, and nothing is delivered. Here's what I see in the Mailman log: Jul 30 16:12:23 2025 (213300) HOLD: mm(a)lists.example.com post from sender(a)sub.example.com held, message-id=<20250730141221.5VVrn%sender(a)sub.example.com>: The message is not from a list member Jul 30 16:12:39 2025 (213338) held message approved, message-id: <20250730141221.5VVrn%sender(a)sub.example.com> In the mail log, I only see the message arriving — there's no sign of it being sent out. Any ideas on what could be going wrong or where else I should look? Mailman Core-Version GNU Mailman 3.3.10 (Tom Sawyer) Mailman Core API-Version 3.1 Mailman Core Python-Version 3.11.11 (main, Jun 20 2025, 00:00:00) [GCC 11.5.0 20240719 (Red Hat 11.5.0-5)] OS: Rocky 9 with Postfix MTA, installed as venv Thanks in advance Stephan

5 29

Whitelist in mailman3: How to allow only ~400 e-mail senders in a file whitelist to send to a list?
by Wikinaut Aug. 5, 2025

Aug. 5, 2025

In mailman2, it was quite handy to place "@whitelist" into the field sender/accept_these_nonmembers, when such a file has been set up. How can I (per list or programmatically) define the ~400 e-mail senders to be allowed to send to my about 30 lists? And, yes, I already searched for a solution of this problem, but could not find any.

2 2

How to create (or change) certain member preferences (in a list, or for all lists) by command line "mailman create [OPTIONS] LISTNAME" ? (Suggestion: modification of this command)
by Wikinaut Aug. 5, 2025

Aug. 5, 2025

Some member preferences - such as hide_address - cannot be set with the [OPTIONS] in the command line. I suggest to modify the code so that all member preferences can be set via the command line. What do you think? This is how I currently patch (some) member preferences (hide_address is a variable here) in a python script, but this takes a lot of time, depending on the number of users.... YMMV. patch_url = f"{member['self_link']}/preferences" patch_data = { "acknowledge_posts": True, "hide_address": hide_address, "preferred_language": "de", "receive_list_copy": True, "receive_own_postings": True, "delivery_mode": "regular", # accepted values are: regular, plaintext_digests, mime_digests, summary_digests "delivery_status": delivery_status # accepted values are: enabled, by_user, by_bounces, by_moderator, unknown } r = requests.patch(patch_url, json=patch_data, auth=AUTH, headers=HEADERS)

3 3