Again, thank you for replying. However, the step you provided did not make any difference. I'm still getting the same error: × mailman3.service - GNU Mailing List Manager Loaded: loaded (/etc/systemd/system/mailman3.service; enabled; preset: enabled) Active: failed (Result: exit-code) since Mon 2024-07-22 20:17:57 UTC; 1min 31s ago Process: 1466 ExecStart=/opt/mailman/venv/bin/mailman start (code=exited, status=1/FAILURE) CPU: 827ms
Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: id SERIAL NOT NULL, Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: email VARCHAR, Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: list_id VARCHAR, Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: PRIMARY KEY (id) Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ) Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ] Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: (Background on this error at: https://sqlalche.me/e/20/f405) Jul 22 20:17:57 tpalxinflistsp1 systemd[1]: mailman3.service: Control process exited, code=exited, status=1/FAILURE Jul 22 20:17:57 tpalxinflistsp1 systemd[1]: mailman3.service: Failed with result 'exit-code'. Jul 22 20:17:57 tpalxinflistsp1 systemd[1]: Failed to start mailman3.service - GNU Mailing List Manager. root@tpalxinflistsp1:~# journalctl -xeu mailman3.service Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: return bind.execute(self) Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ^^^^^^^^^^^^^^^^^^ Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: File "/opt/mailman/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1418, in execute Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: return meth( Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ^^^^^ Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: File "/opt/mailman/venv/lib/python3.12/site-packages/sqlalchemy/sql/ddl.py", line 180, in _execute_on_connection Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: return connection._execute_ddl( Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ^^^^^^^^^^^^^^^^^^^^^^^^ Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: File "/opt/mailman/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1529, in _execute_ddl Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ret = self._execute_context( Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ^^^^^^^^^^^^^^^^^^^^^^ Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: File "/opt/mailman/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: return self._exec_single_context( Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ^^^^^^^^^^^^^^^^^^^^^^^^^^ Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: File "/opt/mailman/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: self._handle_dbapi_exception( Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: File "/opt/mailman/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2353, in _handle_dbapi_exception Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: raise sqlalchemy_exception.with_traceback(exc_info[2]) from e Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: File "/opt/mailman/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: self.dialect.do_execute( Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: File "/opt/mailman/venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: cursor.execute(statement, parameters) Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for schema public Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: LINE 2: CREATE TABLE ban ( Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ^ Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: [SQL: Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: CREATE TABLE ban ( Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: id SERIAL NOT NULL, Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: email VARCHAR, Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: list_id VARCHAR, Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: PRIMARY KEY (id) Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ) Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: ] Jul 22 20:17:57 tpalxinflistsp1 mailman[1466]: (Background on this error at: https://sqlalche.me/e/20/f405)
BTW, no errors were ignored/skipped at all. The database step did not generate any errors, it just creates the two databases (mailman and mailmanweb) and adds permissions to "mailman" user (https://docs.mailman3.org/en/latest/install/virtualenv.html#setup-database)