- Mailman-users - lists.mailman3.org

Data too long for column 'data' in workflowstate
by Morris Jones Dec. 14, 2020

Dec. 14, 2020

I ran into this error attempting to add a user to a mailing list: (pymysql.err.DataError) (1406, "Data too long for column 'data' at row 1") [SQL: INSERT INTO workflowstate (token, step, data) VALUES (%(token)s, %(step)s, %(data)s)] [parameters: {'token': '7394fbf654b3faffc6a65eb95e0616eea6651b9e', 'step': 'do_confirm_verify', 'data': '{"pre_approved": false, "pre_confirmed": false, "pre_verified": false, "invitation": false, "address_key": "dorothyxxxxxxxx(a)gmail.com", "subscriber_key": 1, "user_key": "00201c01dcc443c3a0d8f6d1ea42e230", "token_owner_key": 1, "send_welcome_message": null}'}] In MySQL I see that column 'data' in workflowstate is VARCHAR(255), and the data in the query is 259 characters. If I have a moment I'll write a bug or patch ... but I'm not really current on schema migrations. Mojo -- Morris Jones, Monrovia, CA BridgeMojo <http://bridgemojo.com> Old Town Sidewalk Astronomers <http://otastro.org> Mojo's Blog <http://mojo.whiteoaks.com>

2 2

Permission denied for /list:member:digest:header.txt
by Eric Broens Dec. 14, 2020

Dec. 14, 2020

Hi, despite mailman is running as mailman user and the required periodic jobs have all been created in crontab for the mailman user, a permission denied exception for the digest file has been logged in mailman.log: Dec 14 11:31:42 2020 (399913) Uncaught runner exception: [Errno 13] Permission denied: '/var/lib/mailman3/templates/lists/...//list:member:digest:header.txt' The subdirectories and files of the templates subdirectory got the root owner and group: drwxr-xr-x. 3 mailman mailman 4096 Dec 12 17:58 templates drwxr-xr-x. 11 root root 4096 Dec 12 19:20 lists -rw-rw----. 1 root root 16 Dec 12 19:19 list:member:digest:header.txt How can this be avoided? Best Regards,Eric

3 8

Importing config and archives only partially succeeded?
by Eric Broens Dec. 13, 2020

Dec. 13, 2020

Today I have migrated about 30 mailinglists from mailman 2.1 to mailman 3.3.2 & Hyperkitty 1.3.3. Although no error responses were given when importing the 2.1 pck files, and neither for importing the archives, for about half of the mailinglists the hyperkitty webpage doesn't show any subscribers, nor archived emails. The imported members and other settings are correctly shown in the postorius page. Is there anything that I can verify why the archive is not shown on the hyperkitty page?The hyperkitty_email database table does contain the emails. Thanks in advance,Eric

2 11

troubleshooting hyperkitty
by Morris Jones Dec. 10, 2020

Dec. 10, 2020

Working on a new installation -- lists seem to be working in terms of distributing postings. But none of the postings are appearing in an archive yet. I created a mailman-hyperkitty.cfg file in /opt/mailman/var/etc/. It has a base_url for the "hyperkitty installation," and I'm not sure where that's supposed to be. The comment says "This address will be used by Mailman to forward incoming emails to Hyperkitty for archiving." I set base_url to http://mailman.whiteoaks.com/hyperkitty (changing "localhost" from the example). It redirects to https:, I set new secret keys here and in mailman.cfg. No new posts appear, and nothing archive related shows up in mailman's log. The mailman qcluster is running. The runner=archive job is running. Can someone suggest a troubleshooting strategy? Best regards, Mojo -- Morris Jones, Monrovia, CA BridgeMojo <http://bridgemojo.com> Old Town Sidewalk Astronomers <http://otastro.org> Mojo's Blog <http://mojo.whiteoaks.com>

3 10

Hyperkitty Recommended mySQL Database Setup & Archive Importing
by matthew＠alberti.us Dec. 10, 2020

Dec. 10, 2020

Hi, I've been working for quite a while to setup a production mailman3. Using the docker containers, I have been pretty successful getting it to work. Part of the challenge now is that there are a lot of issues when importing archives from mailman2. This of course is more common on lists that are over 10 years old. From what I've been reading, it seems like Mailman3 expects the mysql database to use UTF8 encoding. It appears, by default, that when using the docker-mailman containers, that the character set is set to latin1. This may explain why there are lots of import errors, and maybe also why there are a lot of errors when threads are deleted in hyperkitty's UI. Is it the case that UTF8 is the preferred character set? I also saw some threads indicating that maybe utf8mb4 is more preferred. I'd like to try to change the character_set on the database, if that is advisable. Also, is Hyperkitty 1.3.4 officially released? I see that the list.org instance is using it, but the latest announce I've seen is for 1.3.3. Thanks. - Matt Alberti

3 8

Version mismatch
by Andrew Bernard Dec. 9, 2020

Dec. 9, 2020

In the annoucement mail, the new version is - Mailman Core 3.3.0 (Tom Swayer) but on my webpage I see: Mailman Core Version GNU Mailman 3.3.0 (La Villa Strangiato) Mailman Core API Version 3.0 Mailman Core Python Version 3.7.3 (default, Apr 3 2019, 05:39:12) [GCC 8.3.0] Why is the version name from the previous release? is my setup wrong? [There are so many issues I keep reporting here about Mailman that get no response that I wonder if there is something fundamentally wrong with my site.] Andrew

4 3

Message moderatin without login
by Michael Lorenzen Dec. 8, 2020

Dec. 8, 2020

Hi, are there any plans to allow message moderation without having to login to posterious? I am very pleased with the new web interface and the rest api, but i miss the ability to moderate messages either by mail, with different reply addresses to discard, reject or accept hold messages or by html links with one time codes to achieve the same. I tried to reply on the mail attachment with the confirm ... subject, but that did not seem to work (neither reject nor accept with approved: placed into the first line of the mail). Best regards, Michael

2 1

Moderated Signup with "info" box?
by chris＠zimmerman.to Dec. 8, 2020

Dec. 8, 2020

Hi all, we have a mailman deployment that we are using for a private neighborhood community board. We have the list setup for moderated approval signup. The trouble is, when someone signs up, we only get a request with their email address. I would like to be able to use the web form, but have a "notes" field that would get submitted with the signup request. the notes field would be where the user would note name/home address. So when one of our moderators get the request, they can figure out quick who the request is coming from. Can anyone provide some guidance or assistance on how to make that happen?

5 8

Spam getting in for moderated list
by Quanah Gibson-Mount Dec. 6, 2020

Dec. 6, 2020

I have a list that has the following settings: List members -> Hold: This holds the message for approval by the list moderators. Non-subscribers -> Silent discard And yet, spam emails from a spammer that signed up to the list are going straight through and being delivered. Is this a known bug in mailman 3.2.1? Example: <https://lists.openldap.org/hyperkitty/list/openldap-bugs@openldap.org/threa…> It even has this list header: X-Mailman-Rule-Hits: member-moderation and version is X-Mailman-Version: 3.2.1 I think it was sent via the web interface? User-Agent: HyperKitty on https://lists.openldap.org/ I checked the settings for this subscribed spam user, and it specifically says "list default" for moderation, so it should have been moderated. Thanks, Quanah -- Quanah Gibson-Mount Product Architect Symas Corporation Packaged, certified, and supported LDAP solutions powered by OpenLDAP: <http://www.symas.com>

2 2

mailman-suite scheduled tasks
by Eric Broens Dec. 6, 2020

Dec. 6, 2020

Hi, The documentation https://docs.mailman3.org/en/latest/config-web.html includes a section on scheduled tasks that need to be included in cron. "runjobs" seems to be available only from "manage.py". Do these scheduled tasks need to be executed from the python virtual environment?If so, is there a way to do that directly from cron, or should I create a script for these tasks which can be called from by cron? Best Regards,Eric

2 2