amavis-new and mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxxxxxxxxxx>, 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.


_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos




[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux