I am following the howto mentioned in the title but stuck on page 3. I have just editted /etc/amavis/amavisd.conf and entered the following commands: adduser clamav amavis /etc/init.d/amavis restart When amavis restarts i get the following error: Stopping amavisd: amavisd-new. Starting amavisd: Error in config file /etc/amavis/amavisd.conf: syntax error at /etc/amavis/amavisd.conf line 835, near "'SELECT "Y" as local FROM domains WHERE CONCAT("@",domain) IN (%k)';" (failed). This line is in the howto so what could be wrong with it?
Problem solved, syntax was wrong, my bad. But now i get the next error, but this line seems correct to me Starting amavisd: Error in config file /etc/amavis/amavisd.conf: Can't modify concatenation (.) or string in scalar assignment at /etc/amavis/amavisd.conf line 846, near "undef;" syntax error at /etc/amavis/amavisd.conf line 846, near "undef;" (failed). The line says: $sql_select_white_black_list = undef; # undef disables SQL white/blacklisting
Please copy and paste amavisd.conf from http://www.howtoforge.com/virtual_postfix_mysql_quota_courier_p3 . This should help to avoid typos.