Re: Why does sa-compile access the bayes db?

2020-05-29 Thread Matus UHLAR - fantomas
On 2020-05-28 15:32, Bert Van de Poel wrote: Almost all of the email we process are forwarders. It doesn't really make sense for us to do a non-global bayes db. The large majority of email we process is also for a uniform group: student organizations at our local university. On 28.05.20

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Bert Van de Poel
Oh, I had misunderstood you, Matus. My bad! I thought you meant we should use a separate bayes db for every mailbox user, but now I understand you were referring to the amavis user which indeed runs everything. I just moved the existing bayes db (after stopping amavis of course) to the

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Benny Pedersen
On 2020-05-28 15:32, Bert Van de Poel wrote: Almost all of the email we process are forwarders. It doesn't really make sense for us to do a non-global bayes db. The large majority of email we process is also for a uniform group: student organizations at our local university. does not matt

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Benny Pedersen
On 2020-05-28 15:22, Matus UHLAR - fantomas wrote: On 28.05.20 13:38, Bert Van de Poel wrote: We're using a global bayes_path defined in local.cf: This is your problem imho. if you use amavis, you need no bayes database, but amavis users', i guess in /var/lib/amavis/.spamassassin/ if amavis

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Benny Pedersen
On 2020-05-28 10:18, Matus UHLAR - fantomas wrote: I wonder where did these files come from. did you sety bayes_path in /etc/spamassassin/ ? setup userprefs file for amavisd, in this file make sure bayes data keep in amavisd user, not the spamassasin user where there is no write access hop

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Matus UHLAR - fantomas
On 28.05.20 15:32, Bert Van de Poel wrote: Almost all of the email we process are forwarders. It doesn't really make sense for us to do a non-global bayes db. The large majority of email we process is also for a uniform group: student organizations at our local university. you

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Bert Van de Poel
Almost all of the email we process are forwarders. It doesn't really make sense for us to do a non-global bayes db. The large majority of email we process is also for a uniform group: student organizations at our local university. On 28/05/2020 15:22, Matus UHLAR - fantomas wrote

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Matus UHLAR - fantomas
omewhat confusing is that we noticed our daily cronjob running sa-update and sa-compile was giving us an error concerning permissions: May 25 00:31:25.488 [8381] warn: bayes: cannot write to /var/lib/spamassassin/bayes_db/bayes_journal, bayes db update ignored: Permission denied bayes:

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Bert Van de Poel
noticed our daily cronjob running sa-update and sa-compile was giving us an error concerning permissions: May 25 00:31:25.488 [8381] warn: bayes: cannot write to /var/lib/spamassassin/bayes_db/bayes_journal, bayes db update ignored: Permission denied bayes: cannot write to /var/lib/spamassassin/bayes

Re: Why does sa-compile access the bayes db?

2020-05-28 Thread Matus UHLAR - fantomas
at was somewhat confusing is that we noticed our daily cronjob running sa-update and sa-compile was giving us an error concerning permissions: May 25 00:31:25.488 [8381] warn: bayes: cannot write to /var/lib/spamassassin/bayes_db/bayes_journal, bayes db update ignored: Permission denied bayes: cannot wr

Re: Why does sa-compile access the bayes db?

2020-05-27 Thread Bert Van de Poel
Plugin initialization+journal sync would make a lot of sense. What would be the cleanest solution in that case? It's quite annoying to receive the same error mail every day. Should we use --cnf to disable the bayes plugin, or is there a more elegant solution? Should we file a bug about this?

Re: Why does sa-compile access the bayes db?

2020-05-25 Thread RW
On Mon, 25 May 2020 23:34:27 +0200 Bert Van de Poel wrote: > My question therefore specifically is: what exactly does sa-compile > do to the bayes database files? I don't know for sure, but it's probably just a side-effect of initializing plugins. Possibly it's trying to perform an opportunistic

Why does sa-compile access the bayes db?

2020-05-25 Thread Bert Van de Poel
ewhat confusing is that we noticed our daily cronjob running sa-update and sa-compile was giving us an error concerning permissions: May 25 00:31:25.488 [8381] warn: bayes: cannot write to /var/lib/spamassassin/bayes_db/bayes_journal, bayes db update ignored: Permission denied bayes: cannot wr

Re: Switching to SQL for user preferences: will I need to transfer the bayes DB?

2020-01-08 Thread Bill Cole
On 8 Jan 2020, at 7:47, Guido Goluke, MajorLabel wrote: Will I need to move the Bayes DB to an 'SQL form' when I switch to SQL-style user preferences? No. The Bayes, user prefs, and TxRep (or AWL) databases each have their own independent configurations -- Bill Cole b...@sccons

Switching to SQL for user preferences: will I need to transfer the bayes DB?

2020-01-08 Thread Guido Goluke, MajorLabel
My setup is that of only virtual e-mail users. The 'vmail' user handles all internal stuff. Right now, I have a cronjob on the vmail user that scans 'learn spam' folders on a couple of mailboxes so that the bayes DB is built up on the vmail user and the learnt false negative

Re: What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread Robert Chalmers
ok, thanks all. I think I have it. zeus:bayes_db robert$ ls -la total 6528 drwxr-xr-x 5 spamuser wheel 170 3 Mar 15:35 . drwxrwxrwx 3 root wheel 102 3 Mar 14:37 .. -rw-rw 1 spamuser wheel49632 3 Mar 16:22 bayes_journal -rw-rw 1 spamuser wheel 176128 3 Mar 1

Re: What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread RW
On Thu, 3 Mar 2016 15:35:38 + Robert Chalmers wrote: > So what exactly is the ?kludge? - given that mostly I followed the > Wiki and various other setup guidelines? I?m not doing per user > configs, but site wide. If you are running spamd as spamuser the files, and the directory they are in,

Re: What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread Tom Hendrikx
Hi, you probably messed up the permissions by running sa-learn or any other tool that messes with the bayes files directly (i.e. not via spamd) as root. Your changes work because they allow read/write access to anyone on the system, which is not very secure. Best would be to do something like:

Re: What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread Robert Chalmers
ok, I can see that. Interesting I missed it on the set up So, I’m running on OSX, and have to use plist files to start processes. The spamd owner is ‘spamuser’ - ( just because I did…. and as it’s not used outside that, I may as well leave it as such.) /opt/local/bin/daemondo

Re: What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread RW
On Thu, 3 Mar 2016 14:46:33 + Robert Chalmers wrote: > > /var/spamassassin/bayes_db > > drwxr-xr-x 3 root wheel 102 3 Mar 14:37 . > drwxr-xr-x 28 root wheel 952 23 Jan 15:58 .. > drwxr-xr-x 5 root wheel 170 3 Mar 14:37 bayes_db > > > -rw-rw-rw- 1 root wheel 2304 3 Mar

Re: What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread Robert Chalmers
ah. So as in local.cf # Bayesian classifier auto-learning (default: 1) # bayes_auto_learn 1 bayes_path /var/spamassassin/bayes_db/bayes bayes_file_mode 0777 bayes_auto_learn_threshold_nonspam -0.001 bayes_auto_learn_threshold_spam 9.0 /var/spamassassin/bayes_db drwxr-xr-x 3 root wh

Re: What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread Reindl Harald
Am 03.03.2016 um 15:30 schrieb Robert Chalmers: ok, I fixed it, but what is it recording ??? tail -f bayes_journal t 1457015338 ba89bf20a0 t 1457015338 f5539dc198 t 1457015338 11973086ed http://spamassassin.apache.org/full/3.4.x/doc/sa-learn.html the timestamps when a token was last seen h

Re: What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread Robert Chalmers
ok, I fixed it, but what is it recording ??? tail -f bayes_journal t 1457015338 ba89bf20a0 t 1457015338 f5539dc198 t 1457015338 11973086ed > On 3 Mar 2016, at 14:22, Robert Chalmers wrote: > > /var/spamassassin/bayes_db/bayes_journal Robert Chalmers rob...@chalmers.com

What do I do to fix this? bayes db update ignored: Permission denied

2016-03-03 Thread Robert Chalmers
Should this set of directories be globally writable? Or writable by spamd? or postfix? spamd[298]: bayes: cannot write to /var/spamassassin/bayes_db/bayes_journal, bayes db update ignored: Permission denied Robert Chalmers rob...@chalmers.com <mailto:rob...@chalmers.com>.au Quantum

Re: [Q] Bayes dB: ratio of spam and ham heavily in favour of ham

2011-08-22 Thread Benny Pedersen
On Mon, 22 Aug 2011 15:46:14 +0200, J4K wrote: # sa-learn --dump magic 0.000 0 3 0 non-token data: bayes db version 0.000 0640 0 non-token data: nspam 0.000 0 7001 0 non-token data: nham 0.000 0

[Q] Bayes dB: ratio of spam and ham heavily in favour of ham

2011-08-22 Thread J4K
Afternoon gentlemen, Seems the Bayes dB has become lop-sided in favour of ham. SA is doing its job as there is little spam coming through these recently. I had hoped we could keep it one third spam and two thirds spam. Does the slant shown below (nspam verses nham) cause any problems

Re: Bayes DB on single-node MySQL cluster

2010-07-26 Thread Michael Scheidell
On 7/26/10 5:40 PM, Paul Hirose wrote: https://issues.apache.org/SpamAssassin/show_bug.cgi?id=5998 I just added a comment. Hmm, I'm still on 5.0.77 (the basic RHEL5 repository version.) Do you know which plugin? the innodb plugin for mysql. supports compression on innodb databases, e

Re: Bayes DB on single-node MySQL cluster

2010-07-26 Thread Paul Hirose
example about how it failed or anything, but I'm still a touch shy about > > going against the devs :) > > biggest issues seem to be, you need a 5.1.47 or newer mysql, and I think you > want to use the plugin (i think). > still get deadlocks while multi threads are trying to up

Re: Bayes DB on single-node MySQL cluster

2010-07-26 Thread Michael Scheidell
w it failed or anything, but I'm still a touch shy about going against the devs :) biggest issues seem to be, you need a 5.1.47 or newer mysql, and I think you want to use the plugin (i think). still get deadlocks while multi threads are trying to update the bayes DB. but if you 

Bayes DB on single-node MySQL cluster

2010-07-26 Thread Paul Hirose
RHEL5.5, MySQL GA 5.0.77, MySQL Cluster 7.1.4b, 64bit, SpamAssassin 3.2.5 (but hoping to go to 3.3.1 soon.) In short, I stumbled across: http://www.clusterdb.com/mysql-cluster/how-can-a-database-be-in-memory-and-durable-at-the-same-time/ which essentially shows how to create a MySQL Cluster, bu

Problems importing Bayes DB into MySQL Cluster

2010-06-24 Thread David Sanchez Herrero
11.2 x86_64 machine, but I've got this error messages: "[16738] dbg: bayes: found bayes db version 3 [16738] dbg: bayes: using userid: 23 [16738] dbg: bayes: _put_token: Updated an unexpected number of rows. [16738] dbg: bayes: error inserting token for line: t 0 1 1276665832 eefbe3bf4e&quo

Bayes db and training questions

2010-04-11 Thread Alex
o timeout and be skipped? If so, how can I find out if that's happening? I thought it might be helpful to include '--dump magic' here: 0.000 0 3 0 non-token data: bayes db version 0.000 01190999 0 non-token data: nspam 0.000

Re: Bayes db and token expiry questions

2010-03-29 Thread Alex
Hi, >> Well, what's the missing 120 MB? The journal? Do a complete sync and >> then delete it. > > Probably the signatures in bayes_seen - there's no mechanism for ageing > them out. And I assume that isn't a problem then? >> "too big" is not an absolute figure. If you store 1-occurence tokens >

Re: Bayes db and token expiry questions

2010-03-29 Thread RW
On Mon, 29 Mar 2010 13:03:59 +0200 Kai Schaetzl wrote: > Alex wrote on Sun, 28 Mar 2010 13:38:25 -0400: > > > I have a bayes db that's about 160MB with a 40MB token db on a > > system with about 100k messages per day. > > Well, what's the missing 120 MB? T

Re: Bayes db and token expiry questions

2010-03-29 Thread Kai Schaetzl
Alex wrote on Sun, 28 Mar 2010 13:38:25 -0400: > I have a bayes db that's about 160MB with a 40MB token db on a system > with about 100k messages per day. Well, what's the missing 120 MB? The journal? Do a complete sync and then delete it. I've just raised the max_db_size

Bayes db and token expiry questions

2010-03-28 Thread Alex
Hi, I have a bayes db that's about 160MB with a 40MB token db on a system with about 100k messages per day. I've just raised the max_db_size set to 1.1M tokens (there are currently 1.06M tokens in there). I've also changed bayes to write to the journal instead of directly to the da

Re: repair bayes db ?

2010-01-31 Thread Kai Schaetzl
Ralph Bornefeld-Ettmann wrote on Sat, 30 Jan 2010 02:56:34 +0100: > it should be enough to rebuild table bayes_global_vars. He isn't using SQL it seems. Kai -- Get your web at Conactive Internet Services: http://www.conactive.com

Re: repair bayes db ?

2010-01-29 Thread Ralph Bornefeld-Ettmann
Am 29.01.2010 19:56, schrieb tonjg: > > raq550 running strongbolt 2, spamassassin.i386 0:3.2.5-1.el4 > I get the following error when trying to do a an sa-learn command: > bayes: bayes db version 0 is not able to be used, aborting! at > /usr/lib/perl5/vendor_perl/5.8.5/Mail

repair bayes db ?

2010-01-29 Thread tonjg
raq550 running strongbolt 2, spamassassin.i386 0:3.2.5-1.el4 I get the following error when trying to do a an sa-learn command: bayes: bayes db version 0 is not able to be used, aborting! at /usr/lib/perl5/vendor_perl/5.8.5/Mail /SpamAssassin/BayesStore/DBM.pm line 196. Is there a fix for this

Upgrading bayes DB

2009-08-04 Thread MySQL Student
Hi, I'm still working on my bayes training project, but also trying to upgrade the bayes DB due to upgrading perl and all the associated modules. I started with this output from "sa-learn --dump magic" 0.000 0 3 0 non-token data: bayes db version 0

Re: sharing the bayes DB?

2009-07-15 Thread Bernd Petrovitsch
On Tue, 2009-07-14 at 15:12 +0300, Jari Fredriksson wrote: > > google found me nothing authoritative on this, so I > > figured asking is the way to go... > > > > Is it good/bad/etc to share out a MySQL Bayes DB from a > > central host to multiple machines running sp

Re: sharing the bayes DB?

2009-07-15 Thread Karsten Bräckelmann
figured asking is the way > to go... > > Is it good/bad/etc to share out a MySQL Bayes DB from a central host to > multiple machines running spamd? -- char *t="\10pse\0r\0dtu...@ghno\x4e\xc8\x79\xf4\xab\x51\x8a\x10\xf4\xf4\xc4"; main(){ char h,m=h=*t++,*x=t+2*h,c,i,l=*x,s=

Re: sharing the bayes DB?

2009-07-14 Thread Jari Fredriksson
> google found me nothing authoritative on this, so I > figured asking is the way to go... > > Is it good/bad/etc to share out a MySQL Bayes DB from a > central host to multiple machines running spamd? It is good. I have shared a bayes database via nfs (w/o SQL) and mysql and tho

sharing the bayes DB?

2009-07-14 Thread Michael 'Moose' Dinn
google found me nothing authoritative on this, so I figured asking is the way to go... Is it good/bad/etc to share out a MySQL Bayes DB from a central host to multiple machines running spamd? -- Michael 'Moose' Dinn, Network Manager Airfire Telephone and Data Inc. (902) 420-1

Re: Am I fscking up my bayes db?

2009-07-12 Thread Matus UHLAR - fantomas
On 09.07.09 09:30, Daniel Schaefer wrote: > I have a similar setup. If a Spam message makes it to my inbox with less > than the required_score, I put it into a SPAM folder and run sa-learn on > the folder. Should I also implement the following ignore rules? > > bayes_ignore_header X-Spam-Fl

Re: Am I fscking up my bayes db?

2009-07-09 Thread RW
On Thu, 09 Jul 2009 09:30:37 -0400 Steve Bertrand wrote: > It's extremely infrequent how often I have to touch my email setup, > but I've always been curious about this. > > Given your recommendation, would you say that a reset on the db should > be performed? > Essentially, is it fair to say

Re: Am I fscking up my bayes db?

2009-07-09 Thread John Hardin
On Thu, 9 Jul 2009, Martin Gregorie wrote: On Thu, 2009-07-09 at 08:50 -0400, Steve Bertrand wrote: My question is, given that the messages have already been processed by the 'cuda's (with their header stamps in place), am I damaging, or at risk of confusing the learning process of SA when I cl

Re: Am I fscking up my bayes db?

2009-07-09 Thread Chr. von Stuckrad
On Thu, 09 Jul 2009, Martin Gregorie wrote: > Here's a simple bash shell script fragment that does the job and does it > fairly fast: > > > for f in data/*.txt ... > gawk ' ... > done > ==

Re: Am I fscking up my bayes db?

2009-07-09 Thread Martin Gregorie
On Thu, 2009-07-09 at 08:50 -0400, Steve Bertrand wrote: > My question is, given that the messages have already been processed by > the 'cuda's (with their header stamps in place), am I damaging, or at > risk of confusing the learning process of SA when I classify these > messages as SPAM? > Not r

Re: Am I fscking up my bayes db?

2009-07-09 Thread Steve Bertrand
Mike Cardwell wrote: > Steve Bertrand wrote: >> My question is, given that the messages have already been processed by >> the 'cuda's (with their header stamps in place), am I damaging, or at >> risk of confusing the learning process of SA when I classify these >> messages as SPAM? >> >> Are there

Re: Am I fscking up my bayes db?

2009-07-09 Thread Daniel Schaefer
Mike Cardwell wrote: Steve Bertrand wrote: Hi everyone, I aggregate my work and personal email accounts within the same email client. All accounts are IMAP-based. My $work employs a Barracuda cluster, and of course my box runs SA. From time-to-time, I'll get a SPAM message come through the '

Re: Am I fscking up my bayes db?

2009-07-09 Thread Mike Cardwell
Steve Bertrand wrote: Hi everyone, I aggregate my work and personal email accounts within the same email client. All accounts are IMAP-based. My $work employs a Barracuda cluster, and of course my box runs SA. From time-to-time, I'll get a SPAM message come through the 'cuda's. From there,

Am I fscking up my bayes db?

2009-07-09 Thread Steve Bertrand
Hi everyone, I aggregate my work and personal email accounts within the same email client. All accounts are IMAP-based. My $work employs a Barracuda cluster, and of course my box runs SA. >From time-to-time, I'll get a SPAM message come through the 'cuda's. >From there, I move the message from

Re: move bayes-db to mysql, unable to initialize database for amavis user, aborting!

2009-04-22 Thread Helmut Schneider
Micke Andersson wrote: Helmut Schneider wrote: Hi, I tried to move a global (not per user) bayes-db to mysql5.0 to use it with 3 different machines. From local.cf: use_bayes 1 bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn

Re: move bayes-db to mysql, unable to initialize database for amavis user, aborting!

2009-04-22 Thread Micke Andersson
Helmut Schneider wrote: > Hi, > > I tried to move a global (not per user) bayes-db to mysql5.0 to use it > with 3 different machines. > >> From local.cf: > > use_bayes 1 > bayes_store_module Mail::SpamAssassin::BayesStore::SQL > bayes_sql_dsn

move bayes-db to mysql, unable to initialize database for amavis user, aborting!

2009-04-22 Thread Helmut Schneider
Hi, I tried to move a global (not per user) bayes-db to mysql5.0 to use it with 3 different machines. From local.cf: use_bayes 1 bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:SpamAssassin bayes_sql_username amavis

Re: force Bayes DB to expire

2008-09-20 Thread Stefan Jakobs
On Thursday 18 September 2008 18:50, you wrote: > > Hello list, > > > > first I'm wondering why I got the following error, because in my local.cf > > I set 'bayes_auto_expire 1' to prevent SpamAssassin from expire the > > bayes-db (or did amavis the ex

Re: force Bayes DB to expire

2008-09-18 Thread Michael Scheidell
> Hello list, > > first I'm wondering why I got the following error, because in my local.cf I > set 'bayes_auto_expire 1' to prevent SpamAssassin from expire the bayes-db (or > did amavis the expire?): Ah? Bayes will auto expire if you set it for 'true'

force Bayes DB to expire

2008-09-18 Thread Stefan Jakobs
Hello list, first I'm wondering why I got the following error, because in my local.cf I set 'bayes_auto_expire 1' to prevent SpamAssassin from expire the bayes-db (or did amavis the expire?): Sep 18 13:15:48 server amavis[19655]: (19655-04) (!)SA TIMED OUT, backtrace: at

Re: Reduce Bayes DB

2008-06-16 Thread Jari Fredriksson
>> On Mon, June 16, 2008 15:04, furban wrote: >> >>> Chang the database >>> ALTER TABLE `awl` ADD `lastupdate` TIMESTAMP NOT NULL ; >>> So I thing I can do the same with bayes_seen. >> >> yes same can be done with bayes_seen, no problem, just >> dont expire one day old seens, i keep 6 month backl

bayes db size and processing cycles

2008-06-16 Thread Robert - elists
Does a larger Bayes DB add significant processing overhead to SA cpu needs? Or are people mainly talking about it today only because of size reduction needs? - rh

Re: Reduce Bayes DB

2008-06-16 Thread Jari Fredriksson
> On Mon, June 16, 2008 15:04, furban wrote: > >> Chang the database >> ALTER TABLE `awl` ADD `lastupdate` TIMESTAMP NOT NULL ; >> So I thing I can do the same with bayes_seen. > > yes same can be done with bayes_seen, no problem, just > dont expire one day old seens, i keep 6 month backlogs >

Re: Reduce Bayes DB

2008-06-16 Thread Benny Pedersen
On Mon, June 16, 2008 15:04, furban wrote: > Chang the database > ALTER TABLE `awl` ADD `lastupdate` TIMESTAMP NOT NULL ; > So I thing I can do the same with bayes_seen. yes same can be done with bayes_seen, no problem, just dont expire one day old seens, i keep 6 month backlogs Benny Pedersen

Re: Reduce Bayes DB

2008-06-16 Thread furban
-u filter --force-expire help or is that done automatic? Frank furban wrote: > > Hi, > > I would like to reduce the size of my bayes db. > The filesize of the bayes_seen.MYI is now near 1GByte. > > # sa-learn -u filter --dump magic > 0.000 0 3

Re: Reduce Bayes DB

2008-06-16 Thread furban
WHERE lastupdate <= DATE_SUB(SYSDATE(), INTERVAL 2 MONTH);" | mysql So I thing I can do the same with bayes_seen. Frank furban wrote: > > Hi, > > I would like to reduce the size of my bayes db. > The filesize of the bayes_seen.MYI is now near 1GByte. > > # sa-le

Re: Reduce Bayes DB

2008-06-16 Thread Matt Kettler
furban wrote: Hi, I would like to reduce the size of my bayes db. The filesize of the bayes_seen.MYI is now near 1GByte. # sa-learn -u filter --dump magic 0.000 0 3 0 non-token data: bayes db version 0.000 0 38413200 0 non-token data: nspam

Reduce Bayes DB

2008-06-16 Thread furban
Hi, I would like to reduce the size of my bayes db. The filesize of the bayes_seen.MYI is now near 1GByte. # sa-learn -u filter --dump magic 0.000 0 3 0 non-token data: bayes db version 0.000 0 38413200 0 non-token data: nspam 0.000 0

Re: multiple SA machines running against same Bayes-DB

2008-04-28 Thread Rick Macdougall
Koopmann, Jan-Peter wrote: Hi, is there a simple way of using the same Bayes-DB (mysql based) for multiple Spamassassin installations concurrently? Can I just point all machines to the same DB or will this lead to corruption? I've been doing it like that for over 2 years with

multiple SA machines running against same Bayes-DB

2008-04-28 Thread Koopmann, Jan-Peter
Hi, is there a simple way of using the same Bayes-DB (mysql based) for multiple Spamassassin installations concurrently? Can I just point all machines to the same DB or will this lead to corruption? Kind regards, JP

Re: Bayes DB growing without bound; expiry not working

2008-04-21 Thread Michael Parker
magic 0.000 0 3 0 non-token data: bayes db version 0.000 01492123 0 non-token data: nspam 0.000 0 660634 0 non-token data: nham 0.000 0 73178711 0 non-token data: ntokens 0.000 0 1189775610

Re: Bayes DB growing without bound; expiry not working

2008-04-21 Thread Chris St. Pierre
data: bayes db version 0.000 01492123 0 non-token data: nspam 0.000 0 660634 0 non-token data: nham 0.000 0 73178711 0 non-token data: ntokens 0.000 0 1189775610 0 non-token data: oldest atime 0.000 0 12087

Re: Bayes DB growing without bound; expiry not working

2008-04-21 Thread Michael Parker
On Apr 21, 2008, at 8:17 AM, Chris St. Pierre wrote: Consequently, my database is growing, apparently without bound. Any ideas how I can get expiry to work properly again? (Hopefully without completely dumping the database?) select * from bayes_vars; What user do you run bayes under on yo

Bayes DB growing without bound; expiry not working

2008-04-21 Thread Chris St. Pierre
count(*) | +--+ | 2266388 | +--+ 1 row in set (0.00 sec) But sa-learn doesn't seem to know that: # sa-learn --dump magic 0.000 0 3 0 non-token data: bayes db version 0.000 0 0 0 non-token data: nspam 0.000 0 0 0

Re: large bayes db may cause downgrade in performance???

2007-11-07 Thread John D. Hardin
On Wed, 7 Nov 2007, Matias Lopez Bergero wrote: > John D. Hardin wrote: > > On Wed, 7 Nov 2007, Matias Lopez Bergero wrote: > > FAQ. > > > > (1) turn off Bayes auto-expire. It's taking longer to clean your > > database than spamd is willing to wait, so you're collecting lots of > > aborted cleanu

Re: large bayes db may cause downgrade in performance???

2007-11-07 Thread Matias Lopez Bergero
John D. Hardin wrote: > On Wed, 7 Nov 2007, Matias Lopez Bergero wrote: > FAQ. > > (1) turn off Bayes auto-expire. It's taking longer to clean your > database than spamd is willing to wait, so you're collecting lots of > aborted cleanup data and your database is not being cleaned up; > > then, >

Re: large bayes db may cause downgrade in performance???

2007-11-07 Thread John D. Hardin
On Wed, 7 Nov 2007, Matias Lopez Bergero wrote: > -rw---1 spamdspamd10182656 Feb 28 2007 bayes_toks.expire10134 > -rw---1 spamdspamd 4472832 Feb 23 2007 bayes_toks.expire10399 > -rw---1 spamdspamd10629120 Oct 24 00:54 bayes_toks.expire1220 > -rw---

large bayes db may cause downgrade in performance???

2007-11-07 Thread Matias Lopez Bergero
spamd 0 Sep 15 21:14 > __db.bayes_toks.expire9362. As you can see, I have stopped using AWL a wile ago... but what are all those bayes_toks.expire~ and __db.bayes_toks~~??? it's seems that I need to clean this up a little bit :-D Could this be performed with sa-learn --sync? I a

Re: Learn Ham/Spam to more than Bayes DB

2007-10-14 Thread Magnus Anderson
t;> These mail boxes are in mbox format. I also rely on -u for overriding the >> username, as I use Bayes and AWL in MySQL for eatch username. >> >> The problem now is though that I want to report ham/spam to more than >> just >> my Bayes DB if users want to do that.

Re: Learn Ham/Spam to more than Bayes DB

2007-10-14 Thread Michael Parker
I use Bayes and AWL in MySQL for eatch username. > > The problem now is though that I want to report ham/spam to more than just > my Bayes DB if users want to do that. I want to report spam to > Pyzor,Razor,Dcc and SpamCop. > > But sa-learn doesn't support this. Does

Learn Ham/Spam to more than Bayes DB

2007-10-14 Thread Magnus Anderson
er']} {$_dir['ham']} /usr/bin/sa-learn --spam --no-sync -u {$_array['sa_user']} {$_dir['spam']} These mail boxes are in mbox format. I also rely on -u for overriding the username, as I use Bayes and AWL in MySQL for eatch username. The problem now is though tha

Re: Bayes DB file locations help

2007-08-26 Thread Matt Kettler
got2go wrote: > Hello all, > > I am trying to get Bayes working on CentoS 4.3 with Postfix, MailScanner, > IMP (with Spam reporting feature). > Check your /etc/mail/spamassassin/mailscanner.cf. (if you don't have one, your MailScanner is ancient) If you've got this line: bayes_path /var/spo

Bayes DB file locations help

2007-08-26 Thread got2go
/var/spool/MailScanner/spamassassin/bayes.mutex Can anybody shed some light into this ? Thanks in advance! -- View this message in context: http://www.nabble.com/Bayes-DB-file-locations-help-tf4330318.html#a12332781 Sent from the SpamAssassin - Users mailing list archive at Nabble.com.

Re: Confused about which bayes db gets used with spamc?

2007-07-02 Thread Matt Kettler
CptanPanic wrote: > Hello, > I run spamc from my procmail on incoming messages. Does this mean that all > messages are using root bayes_db? spamd/spamc will *NEVER* use root's bayes db. If spamd finds itself running as root it will setuid itself to nobody for safety. > If so w

Re: Confused about which bayes db gets used with spamc?

2007-06-30 Thread Bob McClure Jr
iew this message in context: > http://www.nabble.com/Confused-about-which-bayes-db-gets-used-with-spamc--tf4004657.html#a11373245 > Sent from the SpamAssassin - Users mailing list archive at Nabble.com. Cheers, -- Bob McClure, Jr. Bobcat Open Systems, Inc. [EMAIL PROTECTED] htt

Confused about which bayes db gets used with spamc?

2007-06-30 Thread CptanPanic
in context: http://www.nabble.com/Confused-about-which-bayes-db-gets-used-with-spamc--tf4004657.html#a11373245 Sent from the SpamAssassin - Users mailing list archive at Nabble.com.

Re: Bayes DB

2007-05-11 Thread Daniel Aquino
Ok it looks like using sa-learn created the databases fine even with only 1 ham/spam...

Re: Bayes DB

2007-05-11 Thread Daniel Aquino
I didn't even realize my reply's were not being sent to the thread I started... Sorry!

RE: Bayes DB

2007-05-11 Thread Bowie Bailey
Daniel Aquino wrote: > > run these commands as the defang user. > > Would it be bad to use "root" because defang is not a real user.. "spamd" will not run as root. If you try it, it will switch to "nobody". You can deal with this two ways: If your mail accounts are owned by real users on the s

RE: Bayes DB

2007-05-11 Thread Bowie Bailey
al for SA's purposes. > So I'm thinking "after" I install this gateway, I could set it up to > trap incoming messages some how and collect 200 spam/ham to train the > bayes db... That is what I am doing for the accounts that I control. The gateway sorts the mail int

RE: Bayes DB

2007-05-11 Thread Bowie Bailey
Daniel Aquino wrote: > > 1) What (exactly) did you do? > > # local.cf config file at this url > http://pastie.caboo.se/60756 > > > What user is SA running as? What are the permissions on the bayes > > directory? > > drwx-- 2 defang defang 4096 2007-05-11 10:48 > /var/spool/MD-Databases/

RE: Bayes DB

2007-05-11 Thread Bowie Bailey
Luis Hernán Otegui wrote: > First, RTFM. > Second, Google. > Third, oh, well... You NEED to feed Bayes a significant amount of > data, so it knows what is spam and waht is ham, due to the fact that > the kind of spam and ham you receive is different from the ones I get > on my servers. Then it will

Re: Bayes DB

2007-05-11 Thread Luis Hernán Otegui
First, RTFM. Second, Google. Third, oh, well... You NEED to feed Bayes a significant amount of data, so it knows what is spam and waht is ham, due to the fact that the kind of spam and ham you receive is different from the ones I get on my servers. Then it will start auto learning on that basis. B

RE: Bayes DB

2007-05-11 Thread Bowie Bailey
Daniel Aquino wrote: > I setup Bayes and whitelist db paths in my local.cf > The whitelist db created succesfully but the bayes_* db's did not... More information please... Just saying that it doesn't work isn't very helpful. Before we can help you, we need the two basic pieces of information:

Re: Bayes DB

2007-05-11 Thread Luis Hernán Otegui
Have you trained the bayes database? Is this a fresh install? It needs at least 200 spam and 200 ham messages to get it going. However, the more ham and spam you can feed it, the better it will perform... Luix 2007/5/11, Daniel Aquino <[EMAIL PROTECTED]>: I setup Bayes and whitelist db paths i

Bayes DB

2007-05-11 Thread Daniel Aquino
I setup Bayes and whitelist db paths in my local.cf The whitelist db created succesfully but the bayes_* db's did not...

Re: per user bayes db: auto_expiry problem --->> SOLVED

2007-03-16 Thread mailinglists
ad come up in my logs with such high scantimes. Then, I basically ran the whole day --force-expire --sync. I realized that the manual force-expire job was not applicable for 2700 users and a 2.5GB Bayes DB in mysql (myisam engine). Also I realized that doing the --force-expire job manually probably

Re: per user bayes db: auto_expiry problem, spamd child timeout, very long scantimes

2007-03-01 Thread mailinglists
xes request and write their bayes stuff to one and the same mysql box I suspect there to be the problem. This morning I ran a manual sa-learn --force-expire --sync job on the users the timeout problem occured during the night. While running the job I had several timeout errors on the bayes DB as well

Re: per user bayes db: auto_expiry problem, spamd child timeout, very long scantimes

2007-02-27 Thread John D. Hardin
On Tue, 27 Feb 2007 [EMAIL PROTECTED] wrote: > Some emails have a scantime of more than 900 seconds. > > I do not see a relation to a huge load on the SpamAssassin Servers > (I have 2 of them). The timeout problems happen when there is > small load (10 out of 20 spamds marked Busy) as well as whe

per user bayes db: auto_expiry problem, spamd child timeout, very long scantimes

2007-02-27 Thread mailinglists
Hi all I run a site for more than 2000 mailboxes with Postfix, SA 3.1.8 and procmail. Every user has his own bayes db. Allow_user_rules is deactivated. I have a number of problems: A number of emails passes spamd unfiltered due to spamd child timeout. Looking at the scantime it often is far

Bayes DB maintenance

2007-02-25 Thread Bram Mertens
Hi Like I wrote in my previous post SA's effectiveness has dropped dramatically over the past couple of days. I read something about "overtraining" bayes databases a while ago and was wondering if this could be an issue. How can I check the status of my bayes DB? The out

  1   2   3   4   >