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

[Sun Zhiyong]

Hi Jonas,

Thank you very much!

Before your reply, I restarted the server, now mailman3 core can't start, it says:

PID file /run/mailman3/master.pid nore readable (yet?) after start: No such file or directory

I tried to reconfig with:

$dpkg-reconfigure mailman3

it says:

The service for mailman3 failed!
The mailman3 service didn't start correctly. This is probably because you didn't configure the database appropriately. The service won't work until you do so.
If you actually DID install the database appropriately, please report the bug to the maintainers of the mailman3 package.

But I do totally the same as I did when install it.

So what's the problem?

Actually I met with this problem for many times today, each time I reinstalled it and can succfully visit frontend, and then get the error in previous email.

Rex


From: Jonas Meurer<mailto:jonas at freesources.org>
Date: 2018-04-22 18:36
To: Sun Zhiyong<mailto:izysun at outlook.com>
CC: Debian Mailman Team<mailto:pkg-mailman-hackers at lists.alioth.debian.org>
Subject: Re: [Pkg-mailman-hackers] postfix/smtpd[12870]: error: open database /var/lib/mailman3/data/postfix_domains.db: No such file or directory
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 --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-mailman-hackers/attachments/20180422/4038f000/attachment.html>