[Pkg-mailman-hackers] Bug#891703: mailman3-suite: DB user isn't read from setting_local (mailman3-suite.py in /etc)

[Eric Côté]

Package: mailman3-suite
Version: 0+20170523-11
Followup-For: Bug #891703

Hi,

Bug is still present.


Like I mentioned in my original report, "mailman3suite" is the user in
/usr/share/mailman3-suite/settings.py . I've had to hand edit it so my install
reads my DB settings in /etc/mailman3/mailman3-suite.py . 


Here's a log excerpt:

=== >8 ===

ERROR 2018-03-04 03:38:09,552 11510 hyperkitty.lib.utils Failed to update the fulltext index: FATAL:  Peer authentication failed for user "mailmansuite"
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/hyperkitty/lib/utils.py", line 186, in run_with_lock
    fn(*args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/hyperkitty/search_indexes.py", line 87, in update_index
    update_cmd.update_backend("hyperkitty", "default")
  File "/usr/lib/python2.7/dist-packages/haystack/management/commands/update_index.py", line 256, in update_backend
    total = qs.count()
  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 364, in count
    return self.query.get_count(using=self.db)
  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line 499, in get_count
    number = obj.get_aggregation(using, ['__count'])['__count']
  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line 480, in get_aggregation
    result = compiler.execute_sql(SINGLE)
  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 887, in execute_sql
    cursor = self.connection.cursor()
  File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 254, in cursor
    return self._cursor()
  File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 229, in _cursor
    self.ensure_connection()
  File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 213, in ensure_connection
    self.connect()
  File "/usr/lib/python2.7/dist-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 213, in ensure_connection
    self.connect()
  File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 189, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/usr/lib/python2.7/dist-packages/django/db/backends/postgresql/base.py", line 176, in get_new_connection
    connection = Database.connect(**conn_params)
  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 130, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
OperationalError: FATAL:  Peer authentication failed for user "mailmansuite"

=== 8< ===

Seems this might be in either python-django-hyperkitty (which is I think is the
case), since the log is referencing django and hyperkitty, or in
python3-mailman-hyperkitty (which doesn't seem to be picking up my list content
anyway; I should be seeing archives, but I don't, in the web UI).

I dunno how to refile a bug to another source package or tag another (if that's doable).

Sorry if it's not on this package and the bother this may have caused - it's
nice something else got fixed though :).


Thank you for your work,
Eric


-- System Information:
Debian Release: buster/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-5-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mailman3-suite depends on:
ii  dbconfig-mysql            2.0.9
ii  dbconfig-pgsql            2.0.9
ii  dbconfig-sqlite3          2.0.9
ii  debconf [debconf-2.0]     1.5.66
ii  lsb-base                  9.20170808
ii  node-less                 1.6.3~dfsg-2
ii  python                    2.7.14-4
ii  python-django-hyperkitty  1.1.4-3
ii  python-django-postorius   1.1.2-2
ii  python-psycopg2           2.7.4-1
ii  python-pymysql            0.8.0-1
ii  python-whoosh             2.7.4+git6-g9134ad92-1
ii  ruby-sass                 3.5.3-1
ii  ucf                       3.0038
ii  uwsgi                     2.0.15-10.2
ii  uwsgi-plugin-python       2.0.15-10.2

Versions of packages mailman3-suite recommends:
ii  nginx-extras [nginx]  1.13.9-1

Versions of packages mailman3-suite suggests:
ii  mariadb-server-10.1 [virtual-mysql-server]  1:10.1.29-6
ii  postgresql                                  10+190

-- Configuration Files:
/etc/logrotate.d/mailman3-suite changed:
/var/log/mailman3/mailman-suite.log {
	copytruncate
	daily
	rotate 5
	compress
	delaycompress
	missingok
	notifempty
    su www-data list
	create 660 www-data list
}
/var/log/mailman3/mailman-suite-uwsgi.log {
	copytruncate
	weekly
	rotate 3
	compress
	delaycompress
	missingok
	notifempty
    su www-data list
	create 660 www-data list
}


-- debconf information excluded