Virtual Users And Domains With Postfix, Courier And MySQL

[Mave]

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?

[Mave]

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

[till]

Originally Posted by Mave

$sql_select_white_black_list = undef; # undef disables SQL white/blacklisting

This line looks fine to mee. Can you please post some of the lines before this line.

[falko]

Please copy and paste amavisd.conf from http://www.howtoforge.com/virtual_po...ota_courier_p3 . This should help to avoid typos.

[Mave]

Originally Posted by falko

Please copy and paste amavisd.conf from http://www.howtoforge.com/virtual_po...ota_courier_p3 . This should help to avoid typos.

That did solve the problem, thanks.