Trying to figure this out, as it worked on my old server, but lots is different on my new server....
I forgot the mysql connection for amavis-new in my new mailserver, as none of the tutorials I was pouring through mentioned this, even though they claim they supported virtual domains...
Maybe amavis-new has gotten smart enough to recognize a domain as not the one describe and suspect relaying. Anyway...
in /etc/amavis/amavis.conf I added:
@lookup_sql_dsn = ( ['DBI:mysql:database=postfix;host=127.0.0.1;port=3306', 'postfix', 'password'] );
but am getting in maillog:
Nov 20 09:15:10 z9m9z postfix/error[3237]: AC81A62159: to=user@virtualdomain.com, relay=none, delay=1, delays=0.99/0/0/0.05, dsn=4.4.2, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending DATA command)
Is there something off with that connection? Something is listening on port 3306:
# netstat -an|grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
Perhaps because I forgot:
$sql_select_policy = 'SELECT domain from domain WHERE CONCAT("@",domain) IN (%k)';
Which I picked up from an ubuntu help site google 'found' for me. The Centos amavis-new howto does not cover supporting a mysql table of virtual domains.