Thanks, Noel. Very helpful. MySQL is definitely installed and working,
but I don't know about Milter, as it was set up by someone else who
didn't quite do well by me in educating me in the find points of Postfix
management, which is why I am where I am today. I'll get on that and
report back.
On 10/22/2019 3:46 PM, Noel Jones wrote:
On 10/22/2019 1:58 PM, Steve Matzura wrote:
I am running a copy of configurations from a running version 2
installation from Ubuntu 14.04, now alive as version 3 on Ubuntu 18.04.
I thought I'd be slick and port over all the user mailbox directories
in /var/mail/vmail, all the customized .cf's, and the MySQL database.
Everything ported over nicely, Postfix runs in backward compatibility
mode, but for every mail message, I get this in syslog:
Oct 22 18:51:36 tgvprod postfix/pickup[1114]: 852EB604E4: uid=1000
from=<tgvpadmin>
Oct 22 18:51:36 tgvprod postfix/cleanup[2770]: warning: connect to
Milter service inet:localhost:8891: Connection refused
This usually means the milter service isn't started, or not installed.
Or maybe the firewall preventing connections to the milter.
Did you install the milter from the other machine and copy its
config? Ditto firewall config?
Test until you get the milter working. The default value
milter_default_action=tempfail will prevent postfix from receiving
mail until this is fixed.
Oct 22 18:51:36 tgvprod postfix/cleanup[2770]: warning:
proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for
"tgvpadmin@tgvprod"
maybe your sql service isn't started, or not installed.
Did you install sql and copy the sql config files from the old machine?
Test until you get sql queries working. Generally it's easier to
start with hash: files before adding the complexity of a database.
To prevent losing mail, postfix will tempfail all mail when there's a
map lookup error.
-- Noel Jones