On 11/21/2014 09:29 AM, Alex JOST wrote:
Am 21.11.2014 um 14:42 schrieb Robert Moskowitz:
I am new to this list and not skilled at searching through archives. So
please excuse me if this is an old question...
My server is Redsleeve 6 which is a port of Centos 6 to ARM. I am
running:
amavisd-new-2.6.4-2.el6.noarch
and
postfixadmin-2.91
At first I did not have the mysql lookup (as the howto I used did not
say how) and was getting errors like:
(27022-02-3) Open relay? Nonlocal recips but not
originating:[email protected]
Figured out that I needed integration with postfixadmin to enable my
virtual domains. After some digging I found that I needed:
@lookup_sql_dsn =
( ['DBI:mysql:database=postfix;host=127.0.0.1;port=3306', 'postfix',
'password'] );
$sql_select_policy = 'SELECT domain from domain WHERE CONCAT("@",domain)
IN (%k)';
But that generated the errors:
(19513-07) lookup_sql_field(id) (WARN: no such field in the SQL table),
"[email protected]" result=undef
More googling found I should use:
$sql_select_policy = 'SELECT "Y" as local FROM domain WHERE
CONCAT("@",domain) IN (%k)';
But that is STILL generating errors:
(19761-17) lookup_sql_field(id) (WARN: no such field in the SQL table),
"[email protected]" result=undef
So what am I missing here?
This works for me:
http://sourceforge.net/p/postfixadmin/wiki/Amavis_configuration/
that looks like the ticket. So far I am getting good messages like
passing spam checking rather than the error.
For me, the database is postfix, not mail...
thanks
