[Pkg-mailman-hackers] postfix/smtpd[12870]: error: open database /var/lib/mailman3/data/postfix_domains.db: No such file or directory

[Jonas Meurer]

Hi Rex,

Am 22.04.2018 um 12:25 schrieb Sun Zhiyong:
> I installed mailman3 on debian, it can visit http://server/mailman3/,
> but when login, it says Sever Error (500). in
> /var/log/mailman3/web/mailman-web.log there is a line:
> SMTPRecipientsRefused: {u'xxx at xx.com': (451, '4.3.0 <xxx at xx.com>:
> Temporary lookup failure')} 
> # xxx at xx.com is superuser email address.

Apparently your local mailserver (Postfix) is not able to send mail to
'xxx at xx.com'. Postorius (the Mailman3 web interface) sends a
confirmation mail to the user at first login. This mail cannot be sent
for some reason.

> in postfix log file, there is:
> Apr 22 18:05:53 mail postfix/smtpd[12870]: error: open database
> /var/lib/mailman3/data/postfix_domains.db: No such file or directory
> Apr 22 18:05:53 mail postfix/smtpd[12870]: error: open database
> /var/lib/mailman3/data/postfix_lmtp.db: No such file or directory
> 
> how to solve it?

That's because you didn't configure any list domain yet. Mailman only
creates/updates these lookup table files when list domains are edited.

As far as I know, Postfix should ignore this error and still deliver
normal mail.

The error will go away automatically once you added the first list
domain for Mailman3.

You can also manually create empty lookup tables with the following
commands:

$ touch /var/lib/mailman3/data/postfix_{domains,lmtp}
$ chmod 660 /var/lib/mailman3/data/postfix_{domains,lmtp}
$ chown list:list /var/lib/mailman3/data/postfix_{domains,lmtp}
$ postmap /var/lib/mailman3/data/postfix_{domains,lmtp}

Please let us know if your login error is fixed by creating the files or
if it was another problem.

Cheers,
 jonas

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://alioth-lists.debian.net/pipermail/pkg-mailman-hackers/attachments/20180422/e756c619/attachment.sig>