March 2023 - Mailman-users - lists.mailman3.org

ERROR: Can't load plugin sqlalchemy.dialects.postgres
by o.mankewitz＠gmail.com March 3, 2023

March 3, 2023

Hi! I am trying to install Mailman3 using this tutorial/documentation: https://wiki.list.org/DOC/Howto_Install_Mailman3_On_Debian10 So far, so good. But running (venv) mailman@listserver: mailman info throws an error: sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:postgres First, I thought SQLAlchemy is missing, but: (venv) mailman@listserver: pip install sqlalchemy Requirement already satisfied: sqlalchemy in ./venv/lib/python3.9/site-packages (2.0.4) Requirement already satisfied: typing-extensions>=4.2.0 in ./venv/lib/python3.9/site-packages (from sqlalchemy) (4.5.0) Requirement already satisfied: greenlet!=0.4.17 in ./venv/lib/python3.9/site-packages (from sqlalchemy) (2.0.2) How can I fix this? Thank you very much for your help. Regards

2 1

ERROR sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name xxxx to address
by o.mankewitz＠gmail.com March 3, 2023

March 3, 2023

Hi! The error above occurs when starting mailman. The xxxx shows a part from the database section of mailman.cfg. I followed the tutorial https://wiki.list.org/DOC/Howto_Install_Mailman3_On_Debian10. But since django and postgres changed some things, I had to fix some files of mailman3 to get it working. This is the part of mailman.cfg: [database] class: mailman.database.postgresql.PostgreSQLDatabase url: postgresql://mailman:<mypassword>@localhost/mailman Full error: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name "assword>@localhost" to address: Name or service not known How can I fix this? Thank you very much for your help. Regards,

2 1

Postfix problem with imported Mailman2 list
by mailman3＠outofoptions.net March 3, 2023

March 3, 2023

I installed and tested Mailman3. I imported a Mailman2 list. All looks good but I get this error. Recipient address rejected: User unknown in virtual alias table; from=<hit(a)options.org> to=<atm(a)alist.net> The aliases seem to show up find in the GUI for the control panel software I use. Postfix virual file has a mapping of atm to atm(a)alist.net . It seems mailman at least sees the connection. From the smtp.log under mailman: `Mar 02 10:14:13 2023 (1242405) ('127.0.0.1', 56410) recip: atm(a)alist.net Mar 02 10:14:13 2023 (1242405) ('127.0.0.1', 56410) Data: b'DATA' Mar 02 10:14:13 2023 (1242405) ('127.0.0.1', 56410) Data: b'QUIT' Mar 02 10:14:13 2023 (1242405) ('127.0.0.1', 56410) connection lost Mar 02 10:14:13 2023 (1242405) Connection lost during _handle_client() Mar 02 10:53:13 2023 (1242405) Available AUTH mechanisms: LOGIN(builtin) PLAIN(builtin)`

2 1