[Pkg-mailman-hackers] Bug#891937: Bug#891937: mailman3-suite: Hyperkitty tries to connect postgres on system using sqlite

[Jonas Meurer]

Control: reassign -1 mailman3-suite
Control: notfound -1 3.1.1
Control: found -1 0+20170523-10

Control: tag -1 +moreinfo

Hi Markus,

thanks for the bugreport.

Am 02.03.2018 um 20:23 schrieb Markus Gschwendt:
> Fresh install with sqlite as DB.
> Hyperkitty tries to connect postgres on system using sqlite.
> Postgres is not installed on this system.

Unfortunately I'm unable to reproduce this bug. Can you provide more
information?

Please completely purge the package 'mailman3-suite' and make sure that
'/var/lib/mailman3/web' is gone.

Afterwards, reinstall 'mailman3-suite', choose sqlite3 as database
backend (it's the default anyway) and see whether the bug still happens.

If it does, can you provide the contents of
'/etc/mailman3/mailman3-suite.py'? Make sure to anonymize at least
SECRET_KEY, MAILMAN_REST_API_PASS and MAILMAN_ARCHIVER_KEY in case you
want to keep them private (e.g. if it's a productive setup).

Thanks in advance.

Cheers,
 jonas

> 
> Mail from (hourly) cronjob:
> 
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/dist-
> packages/django_extensions/management/commands/runjobs.py", line 34, in
> runjobs
>     job().execute()
>   File "/usr/lib/python2.7/dist-
> packages/hyperkitty/jobs/thread_starting_email.py", line 39, in execute
>     starting_email__isnull=True).all():
>   File "/usr/lib/python2.7/dist-packages/django/db/models/query.py",
> line 250, in __iter__
>     self._fetch_all()
>   File "/usr/lib/python2.7/dist-packages/django/db/models/query.py",
> line 1118, in _fetch_all
>     self._result_cache = list(self._iterable_class(self))
>   File "/usr/lib/python2.7/dist-packages/django/db/models/query.py",
> line 53, in __iter__
>     results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
>   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
> 164, in connect
>     conn = _connect(dsn, connection_factory=connection_factory,
> async=async)
> OperationalError: could not connect to server: No such file or
> directory
>         Is the server running locally and accepting
>         connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
> 
> ERROR OCCURED IN HOURLY JOB: thread_starting_email (APP: hyperkitty)
> START TRACEBACK:
> END TRACEBACK
> 
> _______________________________________________
> Pkg-mailman-hackers mailing list
> Pkg-mailman-hackers at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mailman-hackers
> 


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 866 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-mailman-hackers/attachments/20180303/d7c519a4/attachment-0001.sig>