March 2019 - Mailman-users - lists.mailman3.org

hyperkitty error importing (from mm2 mbox) HTML emails / binary attachments
by M4tze 13 Mar '19

13 Mar '19

Dear list, I am importing emails from mm2 mbox archives into hyperkitty. This generally works but for HTML mails or mails having binary attachments, I get some errors: + ProgrammingError: (1064, u'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'_binary\'<html>\\n<head>\\n<meta http-equiv=\\"Content-Type\\" content=\\"text/html; c\' at line 1') + I am using the following debian/ubuntu packages: * mailman3 3.1.1-9 * mailman3-full 3.1.1-9 * mailman3-web 0+20170523-14 * python-django-mailman3 1.1.0-4 * python-mailmanclient 3.1.1-5 * python3-mailman-hyperkitty 1.1.0-4 * mysql-server 5.7.25-0ubuntu0.18.04.2 * mysql-server-5.7 5.7.25-0ubuntu0.18.04.2 * mysql-server-core-5.7 5.7.25-0ubuntu0.18.04.2 I changed the charset & collation of the mailman-web (incl. hyperkitty's) tables from latin1 to UTF8_mb4, which was neccessary to fix errors importing UTF8 mail. Does anyone has an idea of how to fix that? Kind regards - m4tze

1 0

mailman admin (django) interface does not work anymore after deleting website example.com
by Torge Riedel 10 Mar '19

10 Mar '19

Hi, I've just installed successfully mailman3 and started with basic configuration. When adding a new domain it gives me a link to a django admin page where I have to configure the available websites. I deleted the existing "example.com" and added a new one "lists.mydomain.de". Now the admin (django) interface always gives "An error occurred while processing your request". After one of the first navigation clicks I saw a message that "site with id 1 is missing". Can you point me to where the problem is and how to solve it? Maybe it was not a good idea to delete the existing one, but I would have expected that django will prevent this, if it will fail afterwards. Thanks and regards Torge The logs: Traceback (most recent call last): File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner response = get_response(request) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/core/handlers/base.py", line 156, in _get_response response = self.process_exception_by_middleware(e, request) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/core/handlers/base.py", line 154, in _get_response response = response.render() File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/template/response.py", line 106, in render self.content = self.rendered_content File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/template/response.py", line 83, in rendered_content content = template.render(context, self._request) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/template/backends/django.py", line 61, in render return self.template.render(context) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/template/base.py", line 169, in render with context.bind_template(self): File "/usr/lib/python3.6/contextlib.py", line 81, in __enter__ return next(self.gen) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/template/context.py", line 246, in bind_template updates.update(processor(self.request)) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django_mailman3/context_processors.py", line 32, in common context["site_name"] = get_current_site(request).name File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/contrib/sites/shortcuts.py", line 13, in get_current_site return Site.objects.get_current(request) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/contrib/sites/models.py", line 60, in get_current return self._get_site_by_id(site_id) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/contrib/sites/models.py", line 32, in _get_site_by_id site = self.get(pk=site_id) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/opt/mailman/web/venv/lib/python3.6/site-packages/django/db/models/query.py", line 399, in get self.model._meta.object_name django.contrib.sites.models.Site.DoesNotExist: Site matching query does not exist.

3 3

Automatic response to non-members
by daniel.eckhoff＠gmail.com 08 Mar '19

08 Mar '19

Hi! I have a mailing list, where I accept every incoming message without subscription. I set this up for a recruitment website (jobs(a)xyz.org). It works nice. All mails are sent to archive where me and other admins can go through all applications. Now we want to set up an automatic response to incoming messages. I tried to set "Autorespond postings" but since the applicants are not subscribers, this won't work. I aso set the template for "Notice sent to a poster when their message has been received by the mailing list". Both approaches don't seem to work. Any ideas to get this working without relying on additional software?

2 1

Domain Resolving Issue
by brian＠emwd.com 07 Mar '19

07 Mar '19

I am running a Mailman 3 server with about 5 list domains configured on it. Most of them resolve quickly both to Postorius and HyperKitty. However there is one domain that resolves very slowly. Once it does, access to other pages/tasks go quickly. If you don't do anything with that domain in the browser after about 5 minutes, it takes its time again to resolve. What could be causing this? The webserver is Nginx. Not sure if this is a Mailman 3 issue or not. Brian

2 1

Change settings via mailman shell
by kk＠eco.cept.org 06 Mar '19

06 Mar '19

I am trying to find a way to set some parameters on the lists from a shell script. One specific parameter - max_message_size is not presented through the REST interface apparantly, and i found a way to set this with mailman shell command. Continuing this path i seem not to be able to set any other parameters like this: m.archive_policy = 'never' m.subject_prefix = '' m.dmarc_mitigate_action = 'munge_from' m.dmarc_mitigate_unconditionally = True commit() However i end up with this error: sqlalchemy.exc.StatementError: (builtins.AttributeError) 'str' object has no attribute 'value' [SQL: 'UPDATE mailinglist SET archive_policy=?, dmarc_mitigate_action=?, dmarc_mitigate_unconditionally=?, subject_prefix=? WHERE mailinglist.id = ?'] [parameters: [{'dmarc_mitigate_unconditionally': 'True', 'dmarc_mitigate_action': 'munge_from', 'subject_prefix': '', 'archive_policy': 'never', 'mailinglist_id': 65}]] Not sure what to make of it, but it seems like the fields are not there. I then proceed to get a list of all parameters with information found here: http://docs.mailman3.org/projects/mailmanclient/en/latest/src/mailmanclient… and the parameters seems to exist - however this list is made with the REST interface - so my question are - are there a difference in parameters in "mailman shell" command and REST interface - and how do i then get a list of parameter and possible settings in the "mailman shell" command ? Thanks in advance Kenneth Denmark

2 1

Mailman3 without Hyperkitty in docker
by Danil Smirnov 04 Mar '19

04 Mar '19

Hi, I'm interesting in Mailman3 deployment with archiving feature completely disabled. I've tried to deploy Core + Postorius using this docker-compose template: https://github.com/maxking/docker-mailman/blob/master/docker-compose-postor… Unfortunately Postorius version came with this template is quite outdated: 1.2.0a1 (as reported in page footer). In Hyperkitty-enabled docker image I see version 1.2.3. I've also checked image maxking/postorius:rolling but it seems irrelevant/broken (container exits with error). Are there newer Postorius docker image I can use? Thanks, Danil Smirnov

3 18

Re: postorius only show 50 owner lists
by Alejandro Lopez 03 Mar '19

03 Mar '19

Ok, thanks!

1 0

postorius only show 50 owner lists
by elalelopez＠gmail.com 02 Mar '19

02 Mar '19

Hi, I have installed mailman3 suite on Debian 9. And postorius only lists up to 50 addresses when filter by owner: https: //lists.domain/mailman3/postorius/lists/? role = owner A first query in the database returns all the lists, but then, when it makes the subsequent queries for each list, it ends when it reaches 50. Any ideas? regards

2 3

Selective mailing
by chucka＠blackforest-co.com 02 Mar '19

02 Mar '19

I'm trying to find out if I move my web site to a hosting company using MM Ver 3 - with SQL. If I have a membership list in MySql used by MM - can I send an email to a select group? ["Your dues are due"]. Assumes the MM tables can be accessed? Anyhow what I want to do is: send message96 where expire > next month else send message95 Thanks

4 7

From address of subscription notifications
by worik 02 Mar '19

02 Mar '19

Friends When I subscribe some body to to a list I on I get a notification that says it comes from changeme(a)example.com As far as I can tell no subscribers are getting mail with that, so this is not a crises. But it is untidy and I cannot find where to change it. SERVE_FROM_DOMAIN is set in the mailman-web/environment section of docker-compose.yaml (I am using the docker distribution...) cheers Worik -- If not me then who? If not now then when? If not here then where? So, here I stand, I can do no other root(a)worik.org 021-1680650, (03) 4821804 Aotearoa (New Zealand)

4 4