cannot open databases, lock failed, file exists

[Mark Martinec]

Alex,

> > A better solution is to move bayes database to SQL, as Robert
> > suggested.
> 
> Yes, have now done this, but the document referenced is cut down too
> much from the original, and has several problems.
> 
> To start, the schema doesn't work with current versions of mysql. Use
> this one instead:
> 
> http://svn.apache.org/repos/asf/spamassassin/trunk/sql/bayes_mysql.sql

Right, the bayes_mysql.sql from trunk (on its way to become a SA 3.4.0)
has an up-to-date schema, which is still compatible with SA 3.3 series.

Also the README* documents there were updated, and still compatible
with 3.3:
  http://svn.apache.org/repos/asf/spamassassin/trunk/sql/
 
> I'm also having problems with the AWL instructions from that document.
> It seems I don't have an existing AWL to convert to be imported into
> mysql. How do I now create and begin to use the auto-whitelist?

Just start awl from scratch. Create a database (awl_mysql.sql, README.awl),
make sure it is r/w accessible to a given username, and enable it in your
local.cf, e.g.:

user_awl_sql_username        vscan
user_awl_sql_password        xxxxxxsecretxxxx
auto_whitelist_factory       Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn                 DBI:mysql:sa:127.0.0.1:3306

I also use:

auto_whitelist_ipv4_mask_len 24
auto_whitelist_ipv6_mask_len 48
auto_whitelist_distinguish_signed 1

auto_whitelist_factor        0.05


  Mark