ERROR sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name xxxx to address
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,
On 3/2/23 14:03, o.mankewitz@gmail.com wrote:
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
Do you have literally <mypassword> in url: postgresql://mailman:<mypassword>@localhost/mailman
<mypassword> needs to be replaced with the actual password for the
postgress mailman user. I.e. the password you provided when you did
CREATE USER mailman WITH PASSWORD 'secure-password'; in postgres (and
hopefully didn't set it to literally secure-password).
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (2)
-
Mark Sapiro -
o.mankewitz＠gmail.com