Re: intermittent lock issue
Dirk Bonengel <[email protected]>
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <[email protected]> |
David, you need to tell SpamAssassin (not Maia) how to connect to the MySQL Bayes data. That should be done by adding the following lines in your SpamAssassin local.cf, just make sure you use your Maia DB connection data. You should also comment out any other Bayes config stuff (Caveat - that's an old snippet, if the don't work - ask google) |# Tell Spamassissin to use MySQL for bayes data bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:db_spam:localhost:3306 bayes_sql_username dbspam bayes_sql_password passwort| HTH Dirk Am 16.09.2015 um 20:17 schrieb David Newman: > On 9/15/15 11:05 PM, Dirk Bonengel wrote: >> David, >> >> i suggest using MySQL to store SpamAssassin's Bayes data. Should give >> you a performance boost and you get rid of the lovking issues. Should be >> no problem migrating your data .... >> >> Dirk > Thanks, Dirk. > > Per the pho-postfix setup instructions [1], Maia comes with a > maia-mysql.sql initial setup script to create a 'maia' database. Pasting > the comments from the script, the database sets up these tables: > > [bayes_expire] is SpamAssassin 3.x's Bayes database expiry reference > > [bayes_global_vars] is SpamAssassin 3.x's Bayes database global variables > > [bayes_seen] is SpamAssassin 3.x's Bayes database token reference > > [bayes_token] is SpamAssassin 3.x's Bayes database token list > > [bayes_vars] is SpamAssassin 3.x's Bayes database variables scoreboard > > Is that what you meant, or is some other setup needed to use MySQL to > store Bayes data? > > Thanks again. > > dn > > [1] http://www.purplehat.org/?page_id=5 > > >> -------- Ursprüngliche Nachricht -------- >> Von: David Newman <[email protected]> >> Datum: 15.09.2015 20:29 (GMT+01:00) >> An: [email protected] >> Betreff: [Maia-users] intermittent lock issue >> >> (cross-posting from the pho-postfix list, as I haven't gotten an answer >> there) >> >> Maia 1.0.4 on FreeBSD running as user vscan. User vscan's crontab >> includes this line: >> >> 0 * * * * /usr/local/share/maia/scripts/process-quarantine.pl --learn >> --report > /dev/null >> >> Around once a day or so, and not at any particular time I can discern, >> the cron job fails with errors like this: >> >> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W: >> lock failed: File exists >> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W: >> lock failed: File exists >> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W: >> lock failed: File exists >> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W: >> lock failed: File exists >> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W: >> lock failed: File exists >> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W: >> lock failed: File exists >> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W: >> lock failed: File exists >> >> How to address the locking issue? >> >> Thanks! >> >> dn >> >> _______________________________________________ >> Maia-users mailing list >> [email protected] >> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users > _______________________________________________ > Maia-users mailing list > [email protected] > http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users _______________________________________________ Maia-users mailing list [email protected] http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users