- Mailman-users - lists.mailman3.org

ERROR: Can't load plugin sqlalchemy.dialects.postgres
by o.mankewitz＠gmail.com 03 Mar '23

03 Mar '23

Hi! I am trying to install Mailman3 using this tutorial/documentation: https://wiki.list.org/DOC/Howto_Install_Mailman3_On_Debian10 So far, so good. But running (venv) mailman@listserver: mailman info throws an error: sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:postgres First, I thought SQLAlchemy is missing, but: (venv) mailman@listserver: pip install sqlalchemy Requirement already satisfied: sqlalchemy in ./venv/lib/python3.9/site-packages (2.0.4) Requirement already satisfied: typing-extensions>=4.2.0 in ./venv/lib/python3.9/site-packages (from sqlalchemy) (4.5.0) Requirement already satisfied: greenlet!=0.4.17 in ./venv/lib/python3.9/site-packages (from sqlalchemy) (2.0.2) How can I fix this? Thank you very much for your help. Regards

2 1

ERROR sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name xxxx to address
by o.mankewitz＠gmail.com 03 Mar '23

03 Mar '23

Hi! The error above occurs when starting mailman. The xxxx shows a part from the database section of mailman.cfg. I followed the tutorial https://wiki.list.org/DOC/Howto_Install_Mailman3_On_Debian10. But since django and postgres changed some things, I had to fix some files of mailman3 to get it working. This is the part of mailman.cfg: [database] class: mailman.database.postgresql.PostgreSQLDatabase url: postgresql://mailman:<mypassword>@localhost/mailman Full error: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name "assword>@localhost" to address: Name or service not known How can I fix this? Thank you very much for your help. Regards,

2 1

Postfix problem with imported Mailman2 list
by mailman3＠outofoptions.net 03 Mar '23

03 Mar '23

I installed and tested Mailman3. I imported a Mailman2 list. All looks good but I get this error. Recipient address rejected: User unknown in virtual alias table; from=<hit(a)options.org> to=<atm(a)alist.net> The aliases seem to show up find in the GUI for the control panel software I use. Postfix virual file has a mapping of atm to atm(a)alist.net . It seems mailman at least sees the connection. From the smtp.log under mailman: `Mar 02 10:14:13 2023 (1242405) ('127.0.0.1', 56410) recip: atm(a)alist.net Mar 02 10:14:13 2023 (1242405) ('127.0.0.1', 56410) Data: b'DATA' Mar 02 10:14:13 2023 (1242405) ('127.0.0.1', 56410) Data: b'QUIT' Mar 02 10:14:13 2023 (1242405) ('127.0.0.1', 56410) connection lost Mar 02 10:14:13 2023 (1242405) Connection lost during _handle_client() Mar 02 10:53:13 2023 (1242405) Available AUTH mechanisms: LOGIN(builtin) PLAIN(builtin)`

2 1

GSOC 2023 mentors
by Stephen J. Turnbull 27 Feb '23

27 Feb '23

Hi everybody We still have no mentors for GSOC 2023. Last chance to sign up (with the Python Software Foundation org) is Feb 25. - You don't need to be a Mailman core dev or a Python guru. - Generic mail geeks welcome. - Code spelunking (ie, "grepping for error messages") is very desirable. - Some Python, obviously. - Experience using and preferably administering Mailman. - Opinions about existing bugs and new features a must, of course! ;-) Requires a couple hours a week, somewhat irregularly, from secondary mentors (you), more like 5-10 from primary mentor (me, and you if the bus factor comes into play). Anybody interested, let me know. If you have questions about it, please respond on-list so others can see. Steve

1 2

Messages not picking up header or footer template
by benjamin＠tougshire.com 27 Feb '23

27 Feb '23

Hi I can't figure out how to get headers or footers on my messages Example: I create a footer in Postorius. The name in the form is '[list:member:regular:footer] - The footer for a regular (non-digest) message.' The data is 'Test Footer' I can see the entry in the database with the uri: http://localhost:8000/mailman3/api/templates/list/testing.comms.sdcvirginia… I can do a wget on that uri and download a copy of the footer, and it looks right But when I send a message to the list and the message is forwarded, the footer isn't on the messages that members receive Looking at mailman.log, I cannot see any attempt to access the footer. I can see connections to the REST API (config, roster/owner, roster/moderator) that correspond to the time I sent the message So what am I doing wrong? Thank you Ben

2 1

Error downloading CSV for 1,300 members
by Jose Bernal 23 Feb '23

23 Feb '23

Any suggestions on troubleshooting downloading a modest-size CSV file for a list with 1,300 members? Clicking "CSV Export" on smaller lists works fine, but on this larger list I get this error in mailman-web.log: Thu Feb 23 10:03:32 2023 - uwsgi_response_write_body_do(): Broken pipe [core/writer.c line 429] during GET /mailman3/postorius/lists/ members.list.ocdla.org/csv_view/ (172.31.54.89) OSError: write error --------------------- José Bernal Web/Application Engineer Cell 541-228-8481 jbernal.web.dev(a)gmail.com

3 2

MM3 templates
by Odhiambo Washington 16 Feb '23

16 Feb '23

I followed this: https://gitlab.com/mailman/mailman/-/issues/901 I created a similar template which I placed in /opt/mailman/mm/var/templates/lists/kictanet.lists.kictanet.or.ke/en/ I also restarted Mailman. However, when I test, the mail I get is not what I expected. The template used is different than the one referenced above. <CUT> From: < kictanet-confirm+e486c811933b179525ed673751e9b817c4b4b2e4(a)lists.kictanet.or.ke > Date: Wed, Feb 15, 2023 at 4:01 PM Subject: Your confirmation is needed to join the kictanet(a)lists.kictanet.or.ke mailing list. To: OdhiamboW <myaddress(a)outlook.com> Email Address Registration Confirmation Hello, this is the GNU Mailman server at lists.kictanet.or.ke. We have received a registration request for the email address myaddress(a)outlook.com Before you can start using GNU Mailman at this site, you must first confirm that this is your email address. You can do this by replying to this message. Or you should include the following line -- and only the following line -- in a message to kictanet-request(a)lists.kictanet.or.ke: confirm e486c811933b179525ed673751e9b817c4b4b2e4 Note that simply sending a `reply' to this message should work from most mail readers. If you do not wish to register this email address, simply disregard this message. If you think you are being maliciously subscribed to the list, or have any other questions, you may contact kictanet-owner(a)lists.kictanet.or.ke </CUT> The part that has the URL from the referenced template is here. 1. Where is this template that the system used and can I edit it? 2. Why is it not using the template I created? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

2 9

Multi-domain oddities in Hyperkitty and Postorius
by Jeremy Stanley 16 Feb '23

16 Feb '23

In the OpenDev Collaboratory we've got a bunch of separate Mailman 2.1 vhosts we've started migrating into a single Mailman 3.3.7 server, desiring to take full advantage of its improved multi-domain support. For the most part everything is working great (kudos to everyone who maintains the software and documentation, it's excellent). One of the things our users noticed fairly quickly was Hyperkitty on the second vhost was incorrectly showing the FQDN of the first vhost near the top of its pages. This is covered in the FAQ of course, and seems to imply that what we want is to switch the SITE_ID from 1 to 0 in our settings.py in order to take advantage of magic domain-guessing behavior. So far so good. Unfortunately, SITE_ID = 0 seems to explicitly require the addition of "mail hosts" (or "mail domains" from Django's perspective), and all the web routing returns error pages for any list sites besides the first one since, by default, our server did not have these predefined. What's odd is that, if I log into Postorius as admin and visit the "manage domains" page, suddenly the database gets populated with mail hosts for all of the FQDNs associated with our imported mailing lists. I would not have expected merely visiting that page as an admin to have a side effect of adding entries for the "missing" mail hosts, is that an intentional behavior or merely a bug? Once these entries are automatically added by visiting that page, they're all associated with the one "web host" ("site" in Django) we have for the server, and now the list filtering functionality in Postorius breaks and any of the vhosts all display the full set of mailing lists on the server rather than only those associated with a particular vhost (note that this seems to only be confusing Postorius, Hyperkitty has them correctly filtered still). Okay, so it looks like this is because the mail hosts are all tied to the one web host. We can create additional "sites" in the Django admin UI and then switch the association of the mail hosts to those distinct web hosts. But after doing so, the first vhost still seems to show an unfiltered list of all lists in Postorius (Hyperkitty continues to be fine), while Postorius on the other vhosts correctly shows their filtered sets of lists instead. I also noticed when mailman-web is starting up, its log claims the first site is being set as the "default domain," so have to wonder if that's related to this behavior. Should we create an extra web host to serve as the "default" so that all our typical vhosts get the expected list filtering behavior, or am I completely off-base and there's a much better approach I've missed? Sorry this is so long, I feel like I have at most a tenuous grasp of the details and variables involved, but hopefully it makes sense to someone. Thanks in advance for any recommendations or guidance. -- Jeremy Stanley

2 9

Multiple domain problem
by Lars Bjørndal 14 Feb '23

14 Feb '23

Hi, list! I have lists on two domains, example1.com and example2.com. The mail interface works perfectly. However, connecting a browser to example1.com, I get the title List index - example1.com, and the web interface seems to work fine. If I connect to example2.com, the title is example2.com, without the preceding List index. And the body says Page not found. I can't find anything in the logs that tells me the reason. SITE_ID is set to 0. Any idea? Thanks in advance, Lars

3 9

Templates location on the file system
by Odhiambo Washington 14 Feb '23

14 Feb '23

I am reading this: https://gitlab.com/mailman/mailman/-/issues/901#note_578684415 However, I cannot make heads or tails on what is meant by <LC>. Please help :) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

2 2