Oct 25, 2006 8:57 AM Helpful (0) Reply options Link to this post by pterobyte, pterobyte Oct 25, 2006 4:14 PM in response to Kristoffer Level 6 (11,101 points) Servers Enterprise S 19:41 0:01 MailScanner: waiting for messages postfix 11478 0.0 0.2 33096 23500 ? S 0:00 spamd child 32632 pts/1 S 0:01 /usr/bin/perl -T -w /usr/bin/sa-learn --spam --single 32638 pts/1 S+ 0:00 grep spam The sa-learn, 32632, is stuck waiting for a lock file to This is one of the reasons that site-wide DBs aren't as good as personal ones -- your definition of ham/spam is at least somewhat different from someone else's, and so the http://ecoflashapps.com/cannot-open/cannot-open-bayes-databases-root-spamassassin-bayes-r-o-tie-failed.html
Comment 1 Simon Matter 2007-06-12 23:58:28 UTC I see the same problem since 3.2.0, now also with 3.2.1. In case of problems with the functioning of SA Bugzilla, please contact [email protected] What am I missing that it's still creating lockfiles? Does spamassassin work properly?Have you tried restaring the server? http://www.gossamer-threads.com/lists/spamassassin/users/8332
For further information contact email-integrity [at] dns felicity at kluge Aug17,2004,8:41AM Post #7 of 19 (11485 views) Permalink Re: Bayes database [In reply to] On Tue, Aug 17, 2004 at 04:10:25PM +0100, "Rogers, Delete any lock files and try restarting spamassassin or exim. All rights reserved. Oct 25, 2006 9:14 AM Helpful (0) Reply options Link to this post Apple Footer This site contains user submitted content, comments and opinions and is for informational purposes only.
the bayes database is usualy in the home directory of the user which spamassassin runs as. And the bayes_journal file is gone, though unfortunately I forgot to check that before re-running sa-learn so I don't know which pass sync'd it. Check the permissions on the /etc/mail/spamassassin/bayes_* files to ensure that the user trying to issue the update (in my case, it's filter) has access to the file. SpamAssassin version 3.3.1 running on Perl version 5.10.0 Comment 8 istvan.cebrian 2011-11-09 18:25:04 UTC Am also suffering from this problem.If I run lsof +D /.spamassassin no process is running that uses
I also tried to edit /etc/MailScanner/spam.assassin.prefs.conf without success. Hope this helps. -- Randomly Selected Tagline: "The only way you'll get me to talk is through slow painful torture, and I don't think you've got the grapes." - Stewie on Any SA older than 2.64 is subject to a DoS attack from malformed mime segments.. Thanks falko, [[emailprotected] ~]# ps gauwx clamav 2938 0.1 2.2 223024 185464 ?
Comment 7 Kevin A. By the way, I tried this on /etc/MailScanner/MailScanner.conf Run As User = postfix Run As Group = postfix Incoming Work User = Incoming Work Group = clamav Quarantine User = root Hopefully this will cure the problem, but don't blame me if it breaks stuff please Reply With Quote Quick Navigation E-Mail Top Site Areas Settings Private Messages Subscriptions Who's Online Search Are you using Selinux or something similar?
If you don't have the mails, then you don't know what the tokens in question are, and so you can't do anything short of restarting the DB and doing a better https://wiki.dhits.nl/index.php/SpamAssassin However after restarting spamassassin there are memory usage goes right back to 400mb. maybe the files got locked by some hung process. Check all mails that were used for autolearn and train all mail whose BAYES score is not proper (probably all hams that do not get BAYES_00 and all spams that do
Aug 17 00:05:38 mail-in-1 spamd: Cannot open bayes databases /usr/local/share/spamassassin/run/bayes_* R/W: lock failed: File exists ZoŽ Rogers dns ltd 83 princes street, edinburgh, eh2 2er t: +44 (0) 870 085 8555 Status: REOPENED Alias: None Product: Spamassassin Classification: Unclassified Component: Learner (show other bugs) Version: SVN Trunk (Latest Devel Version) Hardware: PC Linux Importance: P5 major Target Milestone: Future Assignee: SpamAssassin Developer I like to train my SA using Bayes. navigate here debug: Initialising learner debug: bayes: 14631 tie-ing to DB file R/O /etc/mail/spamassassin/bayes_toks debug: bayes: 14631 tie-ing to DB file R/O /etc/mail/spamassassin/bayes_seen debug: bayes: found bayes db version 2 debug: bayes: Not
You may want to consider just removing your current DBs, letting them get back up to speed, and switching to 3.0 (there is currently a release candidate, and a final version In April I had the same problem and I ended up extending and fixing the tool http://spamassassin.taint.org/devel/db-to-text.pl.txt and posting it to the mailing list. Is this the Spamsnake tutorial you're using?
other options to preserve bayes? ...or should i stop SA, whack the files, and restart and retrain? You could always shut down spamd, make a physical copy of it, then restart. When the lock file is left benhind, "lsof +D ~/.spamassassin" confirms that nothing is accessing any file in that directory, except the process waiting for the lock to be released (which That's only true when you run spamassassin as root.
mysql -u root -p mysql>grant insert,select,delete,update on sasql.* to 'sasqluser'@'localhost' identified by 'sasqlpass'; mysql>flush privileges; mysql>create database sasql; mysql>quit mysql sasql -u root -p < /usr/share/doc/spamassassin/sql/userpref_mysql.sql and make sure to run Are there any tools available for fixing >an SA 2.60 database or should I get rid of the database completely and >start over again? I asked that someone puts it on the > website next to the broken(!) db-to-text.pl but no one seems to care. http://ecoflashapps.com/cannot-open/cannot-open-bayes-databases-r-w-lock-failed.html Can anyone provide any insight into how difficult it would be to convert from a local berkeley db to mysql?
Hide Question All replies Helpful answers by pterobyte, pterobyte Oct 25, 2006 10:39 AM in response to Kristoffer Level 6 (11,101 points) Servers Enterprise Oct 25, 2006 10:39 AM in response By doing it in local.cf you've fundamentally forced SA to only ever be invoked as one user without breaking the whole system. All rights reserved. Note that no tokens have expired even though the last expiry ran >today and there are over 4 million tokens in the db.
It seems I don't have an existing AWL to convert to be imported into mysql.