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

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