Yeah I read it but not worked for me until now
I'm using Ubuntu 12.04LTS what doesn't use dkim-filter, but using opendkim so I changed your code
from:
- aptitude install libaprutil1-dbd-mysql razor libnet-dns-perl libmailtools-perl spamc spamassassin libmail-dkim-perl dkim-filter clamsmtp libtie-cache-perl libdbd-mysql-perl pyzor
to:
- aptitude install libaprutil1-dbd-mysql razor libnet-dns-perl libmailtools-perl spamc spamassassin libmail-dkim-perl opendkim clamsmtp libtie-cache-perl libdbd-mysql-perl pyzor
After the mysql can't create these sql-s
mysql -u spamassassin -p spamassassin < /usr/share/doc/spamassassin/sql/awl_mysql.sql
mysql -u spamassassin -p spamassassin < /usr/share/doc/spamassassin/sql/userpref_mysql.sql
mysql -u spamassassin -p spamassassin < /usr/share/doc/spamassassin/sql/bayes_mysql.sql
because the spamassassin user doesn't have create right, so i modified your script
from:
- insert into db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) values('localhost','spamassassin','spamassassin','Y','Y','Y','Y');
to:
- insert into db (Host, Db, User, Create_priv, Select_priv, Insert_priv, Update_priv, Delete_priv) values('localhost','spamassassin','spamassassin', 'Y','Y','Y','Y','Y');
after the import the mysql said there is an error in mysql syntax (not your fault) so i chaged the TYPE=MyISAM to ENGINE=MyISAM in evry .sql files.
Now the installing OK however I installed Amavis instead of ClamSMTP
Ps: I attached the modified sqls, so you can download it and just copy over usr/share/doc/spamassassin/sql/