mailman daemon does not start after yunohost 12 upgrade

[drousset]

After (smooth) upgrade to yunhost 12, mailman3 service does not start.
systemctl status mailman3 output is (actual website name hidden)

Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/url.py", line 662, in _get_entrypoint
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: cls = registry.load(name)
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: ^^^^^^^^^^^^^^^^^^^
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 343, in load
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: raise exc.NoSuchModuleError(
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:postgres
Nov 04 11:45:36 XXXXX.XXX systemd[1]: mailman3.service: Control process exited, code=exited, status=1/FAILURE
Nov 04 11:45:36 XXXXX.XXX systemd[1]: mailman3.service: Failed with result 'exit-code'.
Nov 04 11:45:36 XXXXX.XXX systemd[1]: Failed to start mailman3.service - Mailman3 server.
Nov 04 11:45:36 XXXXX.XXX systemd[1]: mailman3.service: Consumed 1.172s CPU time.

After googling the messages, the error seems to be related to a postgres/postgresql problem (Can't load plugin: sqlalchemy.dialects:postgres) but I can't find the origin of the problem.

Any help welcome
Thanks

[e-jim]

Hey @drousset
I was able to solve the issue just by modifying the line that starts with url: in the file /etc/mailman3/mailman.cfg
There, all I needed to do was replacing postgres:// by postgresql://
Everything seems to work from there (just restarted the service: systemctl start mailman3)

[drousset]

Hi You're right ! I looked around for a remaining occurence of this f... postgres without success ! Merci D. Le 11/12/2024 à 15:44, Jérémie Parisel a écrit :

…

Hey @drousset <https://github.com/drousset> I was able to solve the issue just by modifying the line that starts with url: in the file /etc/mailman3/mailman.cfg There, all I needed to do was replacing postgres:// by postgresql:// Everything seems to work from there (just restarted the service: systemctl start mailman3) — Reply to this email directly, view it on GitHub <#48 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACRRXBK34WFZDEXGVJHYWFT2FBFTZAVCNFSM6AAAAABREM2JBKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKMZWGE4TIMZXG4>. You are receiving this because you were mentioned.Message ID: ***@***.***>