On Wed, Nov 15, 2023 at 9:39 AM Lars Bjørndal <lars@lamasti.net> wrote:
I managed to upgrade the database. However, Mailman3 won't start:
× mailman3.service - GNU Mailing List Manager Loaded: loaded (/etc/systemd/system/mailman3.service; enabled; preset: disabled) Drop-In: /usr/lib/systemd/system/service.d └─10-timeout-abort.conf Active: failed (Result: exit-code) since Wed 2023-11-15 06:49:38 CET; 44min ago Process: 28224 ExecStart=/opt/mailman3/venv/bin/mailman start (code=exited, status=1/FAILURE) CPU: 948ms
nov. 15 06:49:38 dalen.lamasti.net mailman[28224]: return self.loaded_dbapi.connect(*cargs, **cparams) nov. 15 06:49:38 dalen.lamasti.net mailman[28224]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ nov. 15 06:49:38 dalen.lamasti.net mailman[28224]: File "/opt/mailman3/venv/lib64/python3.11/site-packages/psycopg2/__init__.py", line 122, in connect nov. 15 06:49:38 dalen.lamasti.net mailman[28224]: conn = _connect(dsn, connection_factory=connection_factory, **kwasync) nov. 15 06:49:38 dalen.lamasti.net mailman[28224]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ nov. 15 06:49:38 dalen.lamasti.net mailman[28224]: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "localhost" (::1), port 5432 failed: FATAL: Ident authentication failed for user "mailman" nov. 15 06:49:38 dalen.lamasti.net mailman[28224]: (Background on this error at: https://sqlalche.me/e/20/e3q8) nov. 15 06:49:38 dalen.lamasti.net systemd[1]: mailman3.service: Control process exited, code=exited, status=1/FAILURE nov. 15 06:49:38 dalen.lamasti.net systemd[1]: mailman3.service: Failed with result 'exit-code'. nov. 15 06:49:38 dalen.lamasti.net systemd[1]: Failed to start mailman3.service - GNU Mailing List Manager.
Mailman.log doesn't contain any info.
How do I find the cause of this problem?
From the above output, I'd try two things:
- Is the database really running?
$ sudo -u postgres psql
- Can mailman connect to the database:
psql -h localhost -U mailman -d mailman -W
What does those two commands give you?
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]