---------------------------------------------------------------------------
First issue:Postfix v3.5.8 on RHEL 8.
The below is from journalctl -xe:
---------------------------------------------------------------------------
Jul 03 08:12:04 somehost.somedomain postfix/qmgr[947499]: error: open
database /opt/mailman3/mm/var/data/postfix_domains.db: No such file or
directory
Jul 03 08:12:42 somehost.somedomain postfix/smtpd[947510]: error: open
database /opt/mailman3/mm/var/data/postfix_domains.db: No such file or
directory
Jul 03 08:12:42 somehost.somedomain postfix/smtpd[947510]: error: open
database /opt/mailman3/mm/var/data/postfix_lmtp.db: No such file or
directory
I manually created the var_dir: /opt/mailman3/mm/var directory
specified in the mailman.cfg file.
How do I find out how to populate the postfix_domains.db files, and
the postfix_lmtp.db file?
---------------------------------------------------------------------------
Second issue: Postgresql authentication.
PostgreSQL v10.23.
---------------------------------------------------------------------------
I have this in the active mailman3.cfg file, where xxxxxxxxxx is the
same complex password in the mailman3 config file:
url: postgresql://mailman3:xxxxxxxxxx@localhost/mailman3/mailman3
Same password when I created the mailman3 and mailman3web users:
create role mailman3 with encrypted password 'xxxxxxxxxx ';
create role mailman3web with encrypted password 'xxxxxxxxxx ';
psycopg2.OperationalError: connection to server at "localhost"
(127.0.0.1), port 5432 failed: FATAL: Ident authentication failed for
user "mailman3"
---------------------------------------------------------------------------
Contents of the "live" mailman.cfg file, from "mailman info"
---------------------------------------------------------------------------
(venv) [mailman3@someserver ~]$ cat -n /opt/mailman3/var/etc/mailman.cfg
1 # /opt/mailman3/mailman.cfg
2 [paths.here]
3 var_dir: /opt/mailman3/mm/var
4
5 [mailman]
6 layout: here
7 # This address is the "site owner" address. Certain messages
which must be
8 # delivered to a human, but which can't be delivered to a list
owner (e.g. a
9 # bounce from a list owner), will be sent to this address. It
should point to
10 # a human.
11 site_owner: user(a)example.com
12
13 [database]
14 class: mailman.database.postgresql.PostgreSQLDatabase
15 ##### url: postgresql://mailman:MYPASSWORD@localhost/mailman
16 # ----------------------------------------------------------------------------------
17 # Changed: Fri Jun 28 11:56:02 EDT 2024
18 url: postgresql://mailman3:xxxxxxxx@localhost/mailman3/mailman3
19 # Changed: Fri Jun 28 11:56:02 EDT 2024
20 # ----------------------------------------------------------------------------------
21
22 [archiver.prototype]
23 enable: yes
24
25 # For the HyperKitty archiver.
26 [archiver.hyperkitty]
27 class: mailman_hyperkitty.Archiver
28 enable: yes
29 configuration: /opt/mailman3/mailman-hyperkitty.cfg
30
31 [shell]
32 history_file: $var_dir/history.py
33
34 [mta]
35 incoming: mailman.mta.postfix.LMTP
36 outgoing: mailman.mta.deliver.deliver
37 lmtp_host: 127.0.0.1
38 lmtp_port: 8024
39 smtp_host: localhost
40 smtp_port: 25
41 configuration: python:mailman.config.postfix
42 verp_confirmations: yes
43 verp_personalized_deliveries: yes
44 verp_delivery_interval: 1
Suggestions appreciated for how to fix the postfix_domains files, and
the postgres authentication isssue.
------------- Keith
