- Mailman-users - lists.mailman3.org

Import Mailman 2.1.15 => Mailman 3 fails
by Jens Bretschneider 15 Mar '19

15 Mar '19

Hi, we want to replace our Mailman 2.1.15 installation and have installed Mailman 3 with Docker (maxking/docker-mailman). Everything seems to be fine so far, but the import of the old mailing lists fails. There are two different exceptions: MySQLdb._exceptions.OperationalError: (1366, "Incorrect string value: '\\xE2\\\x80\x8D0\xE2\\x80...' for column `mailmandb`.`hyperkitty_email`.`content` at row 1") as well as MySQLdb._exceptions.OperationalError: (1048, "Column 'description' cannot be null") The complete log can be found here: https://www.dropbox.com/s/htd4eia1cg1kyi7/mailman3_import_log.txt?dl=0 Any idea what's going wrong here? Kind regards, Jens

3 3

Unable to configure mailman . Please give any information
by pradeep Kumar xplorer 14 Mar '19

14 Mar '19

Subject: [Fwd: Please list the variables i need to modify in the configure.in] From: "Pradeep Kumar Xplorer" pradeepkumarxplorer(a)pradeepkumarxplorer.com Date: Mon, March 11, 2019 4:04 am To: mailman-users(a)mailman3.org Priority: High Read Receipt: Requested [ Send Read Receipt Now ] Options: View Full Header | Print | Download this as a file ---------------------------- Original Message ---------------------------- Subject: Please list the variables i need to modify in the configure.in From: "Pradeep Kumar Xplorer" pradeepkumarxplorer(a)pradeepkumarxplorer.com Date: Thu, March 7, 2019 6:36 am To: mailman-users(a)python.org before running the configure script I changed AC_PREFIX_DEFAULT(/home1/explodi4/public_html/MAILMAN) and it still says /home/mailman does not exist. Pradeep Kumar Xplorer http://www.dhyanayoga.info http://www.pradeepkumarxplorer.com/2016/CyberCrime/index.php

2 1

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

Managing users
by worik 01 Mar '19

01 Mar '19

Is there a interface for managing users? I can use the data base directly to query `auth_user` etcetera, but Postorious? 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)

2 1

Bounces address spammed
by Enrique Terrazas 28 Feb '19

28 Feb '19

Greetings, I hope everyone is having a good day. We have a highly visible list that is being spammed with join requests from spoofed addresses. When the confirmation email is sent a bounce is received by the list owner. The count is in the 100’s of bounced emails/hour. We noticed they are all coming from one particular domain, this may help if we are able to filter/block the domain. What would be the best way to handle this? Is there a way to handle this granularly at the list level? Thank you as always for your assistance. Enrique

2 2

Member occur in Subscription Requests when Subscription Policy = Confirm
by Henrik Rasmussen 27 Feb '19

27 Feb '19

When Subscription Policy is set to Confirm (only), new potential subscriber appears in Subscription Requests until they have confirmed that they actually want to subscribe. As expected, the new potential subscriber receives a mail with a link to confirm. And also as expected, since moderation is NOT needed, the admin does not receive a mail about authorisation. Why does the new potential subscriber appear in Subscription Requests until confirmed by the subscriber, when the admin doesn't have to appove anyway? Is that by design? /Henrik Rasmussen

2 1

Archives visible to all
by worik 25 Feb '19

25 Feb '19

When I load my new mailing list system, before I log in, I can see the archives of all the lists. Without logging in. Even lists with archives set to private archives. What can I do about that? 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)

2 3

Is logging.subscribe working in /etc/mailman.cfg?
by ktso＠cuhk.edu.hk 25 Feb '19

25 Feb '19

I have put the following in /etc/mailman.cfg and restart mailman. An empty file can be created but nothing can be logged when admin or non-member subscribe/unsubscribe. Anything I have missed? So far I can only see log appear in mailman.log and smtp.log. Thanks. [logging.subscribe] path: subscribe.log level: debug

3 5

Changing delivery mode for ALL subscribers on a SINGLE list using REST
by Henrik Rasmussen 25 Feb '19

25 Feb '19

While in Mailman Settings a user can change delivery mode for either Global (all subscriptions regardless of address or list), Address based (regardless of list name) or List Based (regardless of address). The list admin can change a user's delivery mode setting on a single list (affecting only that address and only that list), but only one subscriber at the time on the list. Changing a user's delivery mode can also be done using REST[1], but I asume this will affect the user's subscription on all the lists where she subscribed using the same address. How do I change ALL the subscribers[2] on a _single list_ to a certain delivery mode, using REST? [1] https://mailman.readthedocs.io/en/latest/src/mailman/rest/docs/preferences.… [2] Most likely by iterating through all subscribers, one at the time, on the list in question.

2 4

Tracking from gravatar
by worik 19 Feb '19

19 Feb '19

Privacy badger reports one tracker (for which it disables cookies) on my Mailman installation. It is: secure.gravatar.com What is this for and how do I get rid of it? I looked at the site and it seems like some sort of take a avatar any where. I do not want that on the lists I am managing for this group of users. 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)

3 3

Turn off social logins?
by worik 18 Feb '19

18 Feb '19

How do I turn off the social logins? I looked in the admin manual but They are not working, but I absolutely do not want them for now. Maybe one day, but my users will be allergic to even the hint.... 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)

12 27

hyperkitty failed to create a thread
by Danil Smirnov 17 Feb '19

17 Feb '19

Hi all, What could be a reason of HyperKitty failing to create a thread from chained emails? For example, see "RECENTLY ACTIVE DISCUSSIONS" on page https://wlug.mailman3.com/hyperkitty/list/wlug@lists.wlug.org/ "Openvpn and Network mapping" discussion displayed as five threads instead of only one... Any ideas how to improve HyperKitty ability to detect threaded messages? With my best regards, Danil Smirnov

6 19

Logging of unsubscribe process
by Johannes Winter 16 Feb '19

16 Feb '19

Dear MM3 list, I was wondering whether the unsubscribe process is logged. One user accidentally hit "unsubscribe all" aborted the process but is now unsure whether he accidentally deleted users. Is there a easy way to check? Best regards, Johannes Winter

2 1

Remove message from send queue
by Johannes Winter 15 Feb '19

15 Feb '19

Dear MM3 list, A address with false syntax got added accidentally to one of our lists. The smtp server now rejects the mail with the following error codes found in mailman.log: Feb 15 11:36:55 2019 (34) <bbd7a3da-32e7-ad12-4b5b-e250b3447639(a)domain.tld> recipients refused: {'l3s3105p7(a)91.55.218.102': (401, b'4.1.3 Bad recipient address syntax')} Feb 15 11:36:55 2019 (34) <bbd7a3da-32e7-ad12-4b5b-e250b3447639(a)domain.tld> smtp to xxx(a)yyy.com for 1 recips, completed in 0.031468868255615234 seconds Feb 15 11:36:55 2019 (34) <bbd7a3da-32e7-ad12-4b5b-e250b3447639(a)domain.tld> post to list from address(a)domain.tld, 767768 bytes, 1 failures Feb 15 11:36:55 2019 (34) <bbd7a3da-32e7-ad12-4b5b-e250b3447639(a)domain.tld> delivery to l3s3105p7(a)91.55.218.102 failed with code 401, b'4.1.3 Bad recipient address syntax' How to remove this mails from the queue? Removing the address from the list doesn't help. Best regards, Johannes Winter

2 1

Mass subscription maximum addresses
by Enrique Terrazas 14 Feb '19

14 Feb '19

Greetings, Is there a maximum amount of accounts that can be imported using the postorius mass subscription application? I know we can import using the command line; some of our customers have very large mailing lists that change by semester. Trying to see how much of that work could be handled by the list owner rather than by the mailman admins. As always thank you for your time and assistance. Best regards, Enrique

2 1

Feature list / compare mailman3 <-> mailman3
by Torge Riedel 14 Feb '19

14 Feb '19

Hi, here I have found an interesting sentence: https://mailman.readthedocs.io/en/latest/src/mailman/docs/release-notes.html "Mailman 3 is not yet feature complete with Mailman 2.1" Is there somewhere an overview of what is missing / different? Since I'm faced with changing the server where mailman is running on, I came up to install mailman3 instead of mailman2. Best regards Torge

2 1

Different (official?) documentations available - what is the correct one?
by Torge Riedel 14 Feb '19

14 Feb '19

Hi, I've found two different documentations: http://docs.mailman3.org/en/latest/index.html https://mailman.readthedocs.io/en/latest/README.html Where the first one looks to me like the official documentation (when looking at the URL), the second one looks more up-to-date. Is there a reason behind it? Best regards Torge

2 1

Gmail emails bouncing - anybody seen this problem?
by worik 14 Feb '19

14 Feb '19

Friends On a fresh install (docker) on a fresh VPS I am getting all Mailman messages to Gmail addresses bouncing telling me I am sending too many messages. Has anybody else have this problem? I am getting the following error in mail.log: "Our system has detected an unusual rate of 550-5.7.1 unsolicited mail originating from your IP address. To protect our 550-5.7.1 users from spam, mail sent from your IP address has been blocked. 550-5.7.1 Please visit 550-5.7.1 https://support.google.com/mail/?p=UnsolicitedIPError to review our 550 5.7.1 Bulk Email Senders Guidelines. l26si395949wme.8 - gsmtp" I have been to the URL mentioned and exhausted my options there. 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)

3 6

Postorius 1.2.3 and MailmanClient 3.2.1 is now out
by Abhilash Raj 11 Feb '19

11 Feb '19

Hi All, I am very pleased to announce (a bit late) that Postorius 1.2.3 and MailmanClient 3.2.1 is now out. The full set of changelog can be found in the documentation[1][2]. The most notable feature that I can think of is non-member management in Postorius. New releases are available on PyPI[3][4]. Thanks to all the contributors who made this release possible! :) [1]: https://postorius.readthedocs.io/en/latest/news.html#id2 [2]: https://mailmanclient.readthedocs.io/en/latest/src/mailmanclient/docs/NEWS.… [3]: https://pypi.org/project/mailmanclient/ [4]: https://pypi.org/project/postorius/ -- thanks, Abhilash Raj (maxking)

2 6

How can administrator sign people up to a list?
by worik 11 Feb '19

11 Feb '19

As a list administrator, how do I add a group of email addresses to a list? 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)

2 3

Recommendation - Developer
by jk＠ascii.com 08 Feb '19

08 Feb '19

Hi - we are currently seeking a developer to work with us on leveraging HyperKitty and our current use of mailman. Any suggestions is appreciated, please DM me at jk(a)ascii.com. Thank you in advance.

1 0

mailman start - can't open file
by Mark Dale 07 Feb '19

07 Feb '19

Hi All, On a new installation (pip), when starting Mailman it seems it cannot find the "master" file. Have I missed a configuration somewhere that tells it to look in "/usr/local/bin" rather than "/usr/bin"? TIA, Mark root@sfo:/etc# mailman start Starting Mailman's master runner /usr/bin/python3: can't open file '/usr/bin/master': [Errno 2] No such file or directory root@sfo:/etc# ls -la /usr/local/bin total 1528 drwxrwsr-x 4 root staff 4096 Feb 7 05:22 . drwxrwsr-x 10 root staff 4096 Jan 23 23:12 .. -rwxr-xr-x 1 root staff 215 Feb 7 04:03 aiosmtpd -rwxr-xr-x 1 root staff 216 Feb 7 04:03 alembic -rwxr-xr-x 1 root staff 266 Feb 7 04:24 django-admin -rwxr-xr-x 1 root staff 125 Feb 7 04:24 django-admin.py -rwxr-xr-x 1 root staff 218 Feb 7 04:03 falcon-bench -rwxr-xr-x 1 root staff 225 Feb 7 04:03 falcon-print-routes -rwxr-xr-x 1 root staff 221 Feb 7 04:03 mailman -rwxr-xr-x 1 root staff 216 Feb 7 04:03 mako-render -rwxr-xr-x 1 root staff 220 Feb 7 04:03 master -rwxr-xr-x 1 root staff 214 Feb 7 04:03 nosetests -rwxr-xr-x 1 root staff 214 Feb 7 04:03 nosetests-3.4 drwxr-sr-x 2 root staff 4096 Feb 7 04:24 __pycache__ -rwxr-xr-x 1 root staff 220 Feb 7 04:03 runner -rwxr-xr-x 1 root staff 1496712 Feb 7 04:52 uwsgi drwxr-xr-x 12 root staff 4096 Feb 7 05:22 var root@sfo:/etc# mailman info GNU Mailman 3.2.0 (La Villa Strangiato) Python 3.7.2+ (default, Feb 2 2019, 14:31:48) [GCC 8.2.0] config file: /etc/mailman.cfg db url: sqlite:////etc/var/data/mailman.db devmode: DISABLED REST root url: http://localhost:8001/3.1/ REST credentials: restadmin:restpass

2 2

Strange error in uwsgi-error.log
by brian＠emwd.com 07 Feb '19

07 Feb '19

I am seeing the following error being logged every few minutes: 18:50:29 [Q] INFO Process-1:7 processing [update_from_mailman] 18:50:29 [Q] ERROR malformed return hook '<function process_task_result at 0x7f588e8c5950>' for [update_from_mailman] 18:50:29 [Q] ERROR Failed [update_from_mailman] - null value in column "description" violates not-null constraint DETAIL: Failing row contains (1, testlist@"listdomain", Testlist, null, [Testlist] , 2, 2018-12-21 22:22:08.440729+00, testlist."listdomain"). : Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) psycopg2.IntegrityError: null value in column "description" violates not-null constraint DETAIL: Failing row contains (1, testlist@"listdomain", Testlist, null, [Testlist] , 2, 2018-12-21 22:22:08.440729+00, testlist."listdomain"). The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/django_q/cluster.py", line 377, in worker res = f(*task['args'], **task['kwargs']) File "/usr/lib/python3.6/site-packages/hyperkitty/tasks.py", line 66, in unlock_and_call return func(*args, **kwargs) File "/usr/lib/python3.6/site-packages/hyperkitty/tasks.py", line 293, in update_from_mailman mlist.update_from_mailman() File "/usr/lib/python3.6/site-packages/hyperkitty/models/mailinglist.py", line 192, in update_from_mailman self.save() File "/usr/lib/python3.6/site-packages/django/db/models/base.py", line 718, in save force_update=force_update, update_fields=update_fields) File "/usr/lib/python3.6/site-packages/django/db/models/base.py", line 748, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "/usr/lib/python3.6/site-packages/django/db/models/base.py", line 812, in _save_table forced_update) File "/usr/lib/python3.6/site-packages/django/db/models/base.py", line 861, in _do_update return filtered._update(values) > 0 File "/usr/lib/python3.6/site-packages/django/db/models/query.py", line 712, in _update return query.get_compiler(self.db).execute_sql(CURSOR) File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1383, in execute_sql cursor = super().execute_sql(result_type) File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1065, in execute_sql cursor.execute(sql, params) File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/usr/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) django.db.utils.IntegrityError: null value in column "description" violates not-null constraint DETAIL: Failing row contains (1, testlist@"listdomain", Testlist, null, [Testlist] , 2, 2018-12-21 22:22:08.440729+00, testlist."listdomain"). Any ideas? Thanks, Brian

3 5

Various settings files for mailman3-web
by worik 07 Feb '19

07 Feb '19

Friends What is the difference between the three settings*.py files in /usr/share/mailman3-web/? ~$ ls /usr/share/mailman3-web/settings* -l -rw-r--r-- 1 root root 14939 Feb 7 01:50 /usr/share/mailman3-web/settings.py lrwxrwxrwx 1 root root 28 Sep 17 11:00 /usr/share/mailman3-web/settings_local.py -> /etc/mailman3/mailman-web.py -rw-r--r-- 1 root root 6178 Sep 17 11:00 /usr/share/mailman3-web/settings_local.py.sample 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)

2 1

Mass subscription in "file submit"
by erlonmz＠terra.com.br 05 Feb '19

05 Feb '19

We would like add members using "file submit" "class ListMassSubscription(forms.Form): emails = forms.FileField( label='Select File' help_text='Select a file' ) " What is your opinion about this change?

2 1

Installation problem: Ubuntu 18.10 mailman3-full. EMAIL_HOST_USER
by worik 05 Feb '19

05 Feb '19

Friends I am installing on a fresh ubuntu 18.10 using mailman3-full. Following http://docs.mailman3.org/en/latest/config-web.html after http://docs.mailman3.org/en/latest/config-core.html and I have got to point where I am a bit stumped. I have to set EMAIL_HOST_USER and EMAIL_HOST_PASSWORD I am unsure what I should use here. What sort of user? 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)

2 1

Using MySQL via unix socket
by Torge Riedel 02 Feb '19

02 Feb '19

Hi, I'm trying to setup mailman3 on Linux and try to find out how the connection string must look like to let it accept unix sockets. A call to mysql -umailman -p successfully uses the socket on the machine and logs in. I tried mysql+pymysql://mailman:mailmanpass@127.0.0.1/mailman3?charset=utf8&use_unicode=1&unix_socket=/var/run/mysqld/mysqld.sock as the connection string but it says that mysql server is not available. Which is the same if remove the "unix_socket" parameter. I have found this parameter when searching the net, but I'm not sure if it is supported. Thanks in advance and best regards Torge

2 2

Audit Logs
by Enrique Terrazas 31 Jan '19

31 Jan '19

Greetings, I’m wondering if there is an “audit log” of sorts to see who made changes to a specific list. What we’re after is a way of tracking, in case requested, who made additions or deletions of subscribers etc. I can see the DELETE commands in the ./mailman/logs/mailman.log file but it doesn’t specifically state who made the request. It can be inferred from the timestamps. I’m just wondering if there is somewhere else I should be looking for this information. Thank you, Enrique J. Terrazas

2 1

Issue with mySQLdb-module on Debian
by Bjoern Franke 24 Jan '19

24 Jan '19

Hi, I already opened a debian bugreport for it, but I'm still wondering why the following issue appears: File "/usr/lib/python3/dist-packages/django/db/backends/mysql/base.py", line 30, in <module> 'Did you install mysqlclient or MySQL-python?' % e django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named 'MySQLdb'. Did you install mysqlclient or MySQL-python? python3-pymysql, which is a dependency of mailman3-web and provides mySQLdb, is installed. (Maybe it's time to migrate to postgres.) Kind regards Bjoern

3 4

importing from google groups.
by Abhijith PA 23 Jan '19

23 Jan '19

Hello. Is it possible to import google group archives to mailman3. With this[1] script, I was able to export archives. Please let me know if anyone have tried and succeeded. --abhijith [1] - https://github.com/icy/google-group-crawler

2 1

MAILMAN_HOST_IP_AUTO
by Johannes Winter 22 Jan '19

22 Jan '19

Dear MM3 list, while doing some reboot proofing for our mailman setup, I once more ran into https://github.com/maxking/docker-mailman/issues/133. May it be that https://github.com/maxking/docker-mailman/pull/143 hasn't made it yet into the docker image maxking/mailman-web:0.2 which is the current recommended stable version? Would be real nice (for stability!) to have this feature included. Best regards, Johannes Winter

2 1

MAILMAN_HOST_IP_AUTO
by Johannes Winter 22 Jan '19

22 Jan '19

Dear MM3 list, while doing some reboot proofing for our mailman setup, I once more ran into https://github.com/maxking/docker-mailman/issues/133. May it be that https://github.com/maxking/docker-mailman/pull/143 hasn't made it yet into the docker image maxking/mailman-web:0.2 which is the current recommended stable version? Would be real nice (for stability!) to have this feature included. Best regards, Johannes Winter

1 0

MIME Digests with posts and index inline likewise Plain Text Digests
by Henrik Rasmussen 18 Jan '19

18 Jan '19

Please correct me if I'm wrong, but as I understand, Mailman attaches posts in a MIME Digest mail intead of inline in the digest mail itself, like Plain Text Digests does. Some mail readers like Gmail eventually displays attachments inline anyway, but readers like Outlook do not. Also the digest index seems to be posted as an attachment in MIME Digests. Would it be possible for Mailman to send both posts and index inline in the MIME digest? I am pretty sure it's not a feature yet, but if Mailman would be able to, I will submit an issue in core (I presume). /Henrik Rasmussen

2 1

Re: digests are created but not sent out
by "Jörg M. Schulz" 17 Jan '19

17 Jan '19

Well, the template files seem to reside in the database, not on the filesystem. So maybe there is some other issue here?

1 0

Change domain, easy?
by Thor Atle Rustad 14 Jan '19

14 Jan '19

Hello list, How can I change the domain (from spammedtodeath.example.org to newdomain.example.org. The change should apply to all relevant settings as well as existing lists. Sincerely, Thor Atle Rustad

2 1

MM3 Docker
by Odhiambo Washington 11 Jan '19

11 Jan '19

[Requesting everyone to be patient with me because I am not so good with Linux, Docker is a completely new thing to me, and MM3, well....] So, I have a VM running Ubuntu-18.04. It is in a Data Centre somewhere. It has an IP n.n.n.n (a public IP). Also, it does not have high resources. However, I hope I can at least get to install MM3 and test it using https://asynchronous.in/docker-mailman/ If I could run MM3 using the apt-get install method, perhaps that would have made my life a bit easier, hoping that MM3 can actually be run in parallel with MM2.1 on the same host. Is anyone doing that already?? Anyway, I need some hand-holding using the docker method for now. I am reading the steps as documented on the https://asynchronous.in/docker-mailman/ and somethings aren't clear to me: I have created two files: (a) /opt/mailman/web/settings_local.py: SERVE_FROM_DOMAIN: 'mm3.my.co.ke' ALLOWED_HOSTS: 'my.co.ke' HYPERKITTY_API_KEY: 'Whatever' MAILMAN_ADMIN_USER: 'admin' MAILMAN_ADMIN_EMAIL: 'odhiambo(a)gmail.com' SECRET_KEY: 'Whatever' EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend' EMAIL_HOST = '172.19.199.1' EMAIL_PORT = 25 (b) /opt/mailman/core/mailman-extra.cfg HYPERKITTY_API_KEY: 'Whatever' DATABASE_URL: 'mysql+pymysql://mailman:mailmanpass@database/mailmandb' DATABASE_TYPE: 'mysql' DATABASE_CLASS: 'mailman.database.mysql.MySQLDatabase' Questions: Are the formats correct? Do I use quotes or not? My docker-compuse.yaml: version: '2' services: mailman-core: image: maxking/mailman-core:latest container_name: mailman-core hostname: mailman-core volumes: - /opt/mailman/core:/opt/mailman/ links: - database:database depends_on: - database environment: - DATABASE_URL=mysql+pymysql://mailman:mailmanpass@database/mailmandb - DATABASE_TYPE=mysql - DATABASE_CLASS=mailman.database.mysql.MySQLDatabase - HYPERKITTY_API_KEY=someapikey networks: mailman: ipv4_address: 172.19.199.2 mailman-web: image: maxking/mailman-web:latest container_name: mailman-web hostname: mailman-web depends_on: - database links: - mailman-core:mailman-core - database:database volumes: - /opt/mailman/web:/opt/mailman-web-data environment: - DATABASE_URL=mysql://mailman:mailmanpass@database/mailmandb - DATABASE_TYPE=mysql - HYPERKITTY_API_KEY=someapikey - SECRET_KEY=thisisaverysecretkey - DYLD_LIBRARY_PATH=/usr/local/mysql/lib/ networks: mailman: ipv4_address: 172.19.199.3 database: environment: MYSQL_DATABASE: mailmandb MYSQL_USER: mailman MYSQL_PASSWORD: mailmanpass MYSQL_RANDOM_ROOT_PASSWORD: "yes" restart: always image: mariadb:10.3 volumes: - /opt/mailman/database:/var/lib/mysql After all that, I have run the following: wash@lists:~/docker-mailman$ docker-compose up -d Creating network "docker-mailman_mailman" with driver "bridge" Creating docker-mailman_database_1 ... done Creating mailman-core ... done Recreating 4b7bc1ecef65_mailman-web ... done Question - Should I assume everything is okay and proceed to the next steps? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-)

4 21

digests are created but not sent out
by "Jörg M. Schulz" 09 Jan '19

09 Jan '19

sudo -u list mailman digests -vp tells that the most recent digest has been sent, but nobody receives these digests. No mail or other log file has any clue what has happened. digest_queue = config.switchboards['digest'] >>> digest_queue <mailman.core.switchboard.Switchboard object at 0x7f9c8ed14940> >>> digest_queue.files [] m.digest_send_periodic = True Normal, non-digest messages are sent correctly. Administrative messages as well. Using GNU Mailman 3.2.0 (La Villa Strangiato) Where could I look for errors / stuck queues? /var/lib/mailman3/lists /var/lib/mailman3/lists/mailman.unswolke.de /var/lib/mailman3/lists/mailman.unswolke.de/digest.2.3.mmdf /var/lib/mailman3/lists/mailman.unswolke.de/digest.3.2.mmdf /var/lib/mailman3/lists/mailman.unswolke.de/digest.4.2.mmdf /var/lib/mailman3/lists/mailman.unswolke.de/digest.2.6.mmdf /var/lib/mailman3/lists/mailman.unswolke.de/digest.2.4.mmdf /var/lib/mailman3/lists/mailman.unswolke.de/digest.4.1.mmdf /var/lib/mailman3/lists/mailman.unswolke.de/digest.3.1.mmdf /var/lib/mailman3/lists/mailman.unswolke.de/digest.mmdf /var/lib/mailman3/lists/mailman.unswolke.de/digest.4.3.mmdf

2 13

Docker-mailman (performance?): "AH00894: declining URL", "AH01077: declining URL", "AH01105: NOT Closing connection", "AH01076: url: ... proxyname: (null) proxyport: 0"
by Henrik Rasmussen 09 Jan '19

09 Jan '19

I am using docker-mailman with GNU Mailman 3.2.0 (La Villa Strangiato). Even I have had no complains previously, a list admin have received proxy errors a couple of days. Right after one occurrence I immediately looked at the logs and while I had no related errors in the log files in /var/log/mailman/web/{uwsgi,uwsgi-error,mailmanweb}.log, the Apache log often shows "AH00894: declining URL", "AH01077: declining URL", "AH01105: NOT Closing connection", "AH01076: url: ... proxyname: (null) proxyport: 0". The errors seems to go back a long time, also on previous versions of Mailman, but no one have complained about it until now. Apache is version 2.4.6 on a RHEL 7 assuming Red Hat have backported any bugs about timeout previously know as hardcoded timeout of 30s etc. I assume therefore that even Mailman did not indicate any errors, it may have been too slow to respond. The server does not seem to be slow at all. Is there a way I can enhance the performance of Mailman (Docker)? I've asked about performance previously, but as I don't think my current question is related to REST, it's probably not related to https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/…. Henrik

1 0

Removing Archives for a Deleted List
by kelly.close＠lrewater.com 09 Jan '19

09 Jan '19

Renewing this question ... maybe, there is now a straightforward way to delete archives associated with a deleted list in MM3? Through the UI would be ideal, but if there is a command line approach, I can make that work. Searching the message boards has not turned up anything either way for me. Thoughts? ~Kelly

2 1

hyperkitty base_url
by Thomas Stein 08 Jan '19

08 Jan '19

Hi all. Now I'm struggeling with configuring hyperkitty. It's not clear to me which base_url to set. Currently it's base_url: http://localhost:8001/hyperkitty/ but that leads to Jan 04 21:01:39 2019 (8322) HyperKitty failure on http://localhost:8000/hyperkitty/api/mailman/urls: <html><title>Auth required</title><body> <h1>Authorization Required</h1></body></html> (401) The api_key is set in /usr/share/mailman3-web/settings.py. I suppose I'm doing it wrong. Any hints appreciated. thanks and cheers t.

4 8

Auth question
by David Krantz 08 Jan '19

08 Jan '19

Hi, I have of course activated password login as it was not possible to get the provider based logins to work (might be but not worth the time for me right now). Is there any way for an user to request a new password when it is forgotten? I presume that the Persona login is removed now. I cannot hide it in my version or at least I do not know how. cheers // David

6 25