PDA

View Full Version : Virtual Users And Domains With Postfix, Courier And MySQL


Mave
12th April 2006, 01:32
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
12th April 2006, 01:40
Problem solved, syntax was wrong, my bad. :p

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
12th April 2006, 09:46
$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
12th April 2006, 11:49
Please copy and paste amavisd.conf from http://www.howtoforge.com/virtual_postfix_mysql_quota_courier_p3 . This should help to avoid typos.

Mave
12th April 2006, 20:30
Please copy and paste amavisd.conf from http://www.howtoforge.com/virtual_postfix_mysql_quota_courier_p3 . This should help to avoid typos.
That did solve the problem, thanks. :)