Re: Bayes database in mysql on multiple servers

2011-12-01 Thread Michael Scheidell
On 12/1/11 10:06 AM, Benny Pedersen wrote: does not make sense so hire a unix programmer to help you understand. -- Michael Scheidell, CTO o: 561-999-5000 d: 561-948-2259 >*| *SECNAP Network Security Corporation * Best Mobile Solutions Product of 2011 * Best Intrusion Prevention Product

Re: Bayes database in mysql on multiple servers

2011-12-01 Thread Benny Pedersen
On Thu, 1 Dec 2011 01:01:04 -0500, Michael Scheidell wrote: sed -i '' -e '/INSERT INTO bayes_seen/s/INTO/IGNORE INTO/' MySQL.pm ALTER TABLE `bayes_seen` ENGINE = INNODB no, that won't do anything (I use engine = innodb), what has innodb have to do with replication collisions? innodb is

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Michael Scheidell
On Wed, 30 Nov 2011 08:23:59 -0500, Michael Scheidell wrote: sed -i '' -e '/INSERT INTO bayes_seen/s/INTO/IGNORE INTO/' MySQL.pm (hey SA folks.. any reason not to just put that into 3.4.0? won't hurt anything, will it?) or simply just ALTER TABLE `bayes_seen` ENGINE = INNODB no, that

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Benny Pedersen
On Wed, 30 Nov 2011 08:23:59 -0500, Michael Scheidell wrote: sed -i '' -e '/INSERT INTO bayes_seen/s/INTO/IGNORE INTO/' MySQL.pm (hey SA folks.. any reason not to just put that into 3.4.0? won't hurt anything, will it?) or simply just ALTER TABLE `bayes_seen` ENGINE = INNODB

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Walter Hurry
On Wed, 30 Nov 2011 08:25:43 -0800, John Hardin wrote: > On Wed, 30 Nov 2011, Walter Hurry wrote: >> Why replicate? Why not just share the same database? > > Latency and reliability of the link between the "geographically separate > locations". Replication is typically robust in the face of unre

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread John Hardin
On Wed, 30 Nov 2011, Walter Hurry wrote: On Wed, 30 Nov 2011 09:11:49 +0100, Robert Schetterer wrote: Am 30.11.2011 09:06, schrieb Matus UHLAR - fantomas: On 30.11.11 00:17, Alex wrote: I have two fedora15 boxes that process mail for a few domains, and recently set up bayes in mysql for each

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Nigel Frankcom
On Wed, 30 Nov 2011 15:14:33 + (UTC), Walter Hurry wrote: >On Wed, 30 Nov 2011 09:11:49 +0100, Robert Schetterer wrote: > >> Am 30.11.2011 09:06, schrieb Matus UHLAR - fantomas: >>> On 30.11.11 00:17, Alex wrote: I have two fedora15 boxes that process mail for a few domains, and rec

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Walter Hurry
On Wed, 30 Nov 2011 09:11:49 +0100, Robert Schetterer wrote: > Am 30.11.2011 09:06, schrieb Matus UHLAR - fantomas: >> On 30.11.11 00:17, Alex wrote: >>> I have two fedora15 boxes that process mail for a few domains, and >>> recently set up bayes in mysql for each of them. The servers are in >>> g

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Matus UHLAR - fantomas
I have two fedora15 boxes that process mail for a few domains, and recently set up bayes in mysql for each of them. The servers are in geographically different locations, a few hops from each other. Since they both process mail for the same domains, I thought it made sense to share the database be

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Michael Scheidell
Hi all, I have two fedora15 boxes that process mail for a few domains, and recently set up bayes in mysql for each of them. The servers are in geographically different locations, a few hops from each other. Since they both process mail for the same domains, I thought it made sense to share the da

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Robert Schetterer
Am 30.11.2011 09:06, schrieb Matus UHLAR - fantomas: > On 30.11.11 00:17, Alex wrote: >> I have two fedora15 boxes that process mail for a few domains, and >> recently set up bayes in mysql for each of them. The servers are in >> geographically different locations, a few hops from each other. Since

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Matus UHLAR - fantomas
On 30.11.11 00:17, Alex wrote: I have two fedora15 boxes that process mail for a few domains, and recently set up bayes in mysql for each of them. The servers are in geographically different locations, a few hops from each other. Since they both process mail for the same domains, I thought it mad

AWL size reduction (was Re: Bayes database clearance)

2008-07-08 Thread Kris Deugau
(Subject changed to match the OP's question, which wasn't actually about Bayes.) Jared Hall wrote: Try: http://www.deepnet.cx/~kdeugau/spamtools/trim_whitelist and customize the script as per your installation. Hope that helps. FWIW I'm now running this nightly on a pair of systems with a gl

Re: Bayes database clearance

2008-07-06 Thread Jared Hall
Try: http://www.deepnet.cx/~kdeugau/spamtools/trim_whitelist and customize the script as per your installation. Hope that helps. Jared Hall General Telecom, LLC. Tobias Eichner wrote: I'm using the script at http://svn.apache.org/repos/asf/spamassassin/branches/3.2/tools/check_whitelist to

Re: Bayes database

2008-05-06 Thread Theo Van Dinter
On Tue, May 06, 2008 at 04:16:06PM +0200, polloxx wrote: > Your Bayesian database has become dirty: too mush ham mails get a > score of BAYES_99, certainly for one of your customer domains. > > Is there a way to sanitize the database without clear the whole thing? > What are the best practices to k

Re: Bayes database

2008-05-06 Thread Matus UHLAR - fantomas
On 06.05.08 16:16, polloxx wrote: > Your Bayesian database has become dirty: too mush ham mails get a > score of BAYES_99, certainly for one of your customer domains. > Is there a way to sanitize the database without clear the whole thing? do you keep all mail you've user to learn? If so, re-check

Re: Bayes database corrupt.

2008-01-20 Thread Theo Van Dinter
On Mon, Jan 21, 2008 at 11:02:23AM +1300, Michael Hutchinson wrote: > Does anyone know how to fix a corrupted Bayes Database ? Why do you think the DB is corrupt? All you said is that the children were doing processing on the DB, which sounds a lot like an expire run. -- Randomly Selected Tagli

Re: Bayes database corrupted

2007-09-18 Thread Duane Hill
On Tue, 18 Sep 2007 at 13:09 +0200, [EMAIL PROTECTED] confabulated: Hi! I have a problem with SpamAssassin and the bayes database files. These files, and users' messages too, are stored in a external SAN. This SAN have a high use, and sometimes some users' bayes files are been corrupted. If I

RE: Bayes database corrupted

2007-09-18 Thread Listas
I don't need starter DB's, this is not the problem. I am looking for a a way to detect the corrupted files in logs or similar. Thanks. > Hi > > Check the permissions on the file for that file/directory structure and > user. > > If you haven't got a backup then there are some nice starter DB's t

RE: Bayes database corrupted

2007-09-18 Thread Martin.Hepworth
Hi Check the permissions on the file for that file/directory structure and user. If you haven't got a backup then there are some nice starter DB's to get you going at wwwl.fsl.com/support. -- Martin Hepworth Snr Systems Administrator Solid State Logic Tel: +44 (0)1865 842300 > -Original Mes

Re: bayes database

2007-05-05 Thread Matt Kettler
night duke wrote: > Hi doing spamassassin -D --lint appears bayes database at > /root/.spamassassin/bayes_toks > > It's good to have there the bayes database? That's only true when you run spamassassin as root. SA, by default, uses a bayes directory in the home directory of whatever user invokes

Re: Bayes Database Missing

2006-11-22 Thread twofers
The files you are looking for are bayes_toks and bayes_seen They may be in /root/.spamassassin/ Try to find those files in a spamassassin default directory somewhere and cp them to that directory. First try to find them and do a: locate -u#catalogs all the files on your ser

Re: Bayes Database Missing

2006-11-21 Thread leemansvg
sorry, I there's no bayes files in /etc/mail/spamassassin/ directory. I'm using MailScanner. twofers wrote: > > You can try: > mkdir /var/lib/MailScanner/ > #Creates the directory > > cp /etc/mail/spamassassin/bayes* /var/lib/MailScanner/ > #Copies the bayes databases from the defau

Re: Bayes Database Missing

2006-11-21 Thread Matt Kettler
Matt Kettler wrote: > leemansvg wrote: > >> I see in my spam.assassin.pref.conf file this entry, >> bayes_path /var/lib/MailScanner/bayes >> >> however when I navigate to this directory this database is not there, is >> there a way to generate this database. I've been noticing a

Re: Bayes Database Missing

2006-11-21 Thread Matt Kettler
leemansvg wrote: > I see in my spam.assassin.pref.conf file this entry, > bayes_path /var/lib/MailScanner/bayes > > however when I navigate to this directory this database is not there, is > there a way to generate this database. I've been noticing a lot of spam > getting through a

Re: Bayes Database Missing

2006-11-21 Thread twofers
You can try: mkdir /var/lib/MailScanner/ #Creates the directory cp /etc/mail/spamassassin/bayes* /var/lib/MailScanner/ #Copies the bayes databases from the default spamassassin directory to the bayes_path directory /etc/init.d/spamassassin restart or /etc/init.d/psa-spamassassin

Re: Bayes database under MySQL

2005-06-22 Thread Arvinn Løkkebakken
Mike Jackson wrote: I have SA 3.0.2 set up with vpopmail, using MySQL for user preferences, auto whitelisting and bayesian storage. It seems that with auto_learn turned on, SA is keeping a per-user bayes DB in MySQL, which is great. However, I can't figure out how I can teach SA about spam

Re: Bayes database under MySQL

2005-06-21 Thread Mike Jackson
I have SA 3.0.2 set up with vpopmail, using MySQL for user preferences, auto whitelisting and bayesian storage. It seems that with auto_learn turned on, SA is keeping a per-user bayes DB in MySQL, which is great. However, I can't figure out how I can teach SA about spam/ham on a per-user basis

Re: Bayes Database RW Lock

2005-06-17 Thread Paul R. Ganci
Paul R. Ganci wrote: I assume this message implies my Bayes database is corrupted and that is why I keep finding stale lock files. Namely every bayes_journal_max_size = 102400 Bytes (or whatever unit) the system attempts to sync the Bayes database which crashes leaving behind the lock file.

Re: Bayes Database RW Lock

2005-06-16 Thread Paul R. Ganci
Matt Kettler wrote: Paul R. Ganci wrote: -rw-rw-rw-1 prganci users 165988 May 14 10:05 bayes_journal -rw---1 pangione users 34 May 14 10:00 bayes.lock That's a little troubling.. are you having problems with spamd instances crashing? The lock is at least 5 m

Re: Bayes Database RW Lock

2005-05-14 Thread Paul R. Ganci
Matt Kettler wrote: bayes_auto_expire 0 With this setting you've got a cronjob running sa-learn --force-expire. Right? Yes. If not, fix that. rw-rw-rw-1 prganci users 165988 May 14 10:05 bayes_journal -rw---1 pangione users 34 May 14 10:00 bayes.lock That's

Re: Bayes Database RW Lock

2005-05-14 Thread Matt Kettler
Paul R. Ganci wrote: > I am at my wits end regarding this issue. I am getting very frequent: > > May 14 09:58:05 citlatepetl spamd[5125]: Cannot open bayes databases > /home/spam-filter/etc/mail/spamassassin/bayes_* R/W: lock failed: File > exists > This is very common, and is not a problem UNLES

Re: bayes database merge?

2005-03-30 Thread Michael Parker
On Wed, Mar 30, 2005 at 02:22:34PM -0600, Rich Winkel wrote: > Hi, I was wondering how one might go about merging two or more bayes > databases into one? I have a user who for various reasons can't save > his spam back to the server, so I thought I'd create a database for him > by "averaging" othe

Re: bayes database

2005-02-26 Thread Norman Zhang
I'm using spamassassin with amavisd-new. I like to setup a path for system wide bayes database in local.cf. e.g., bayes_path /var/amavisd/.spamassassin/bayes # slocate bayes /usr/share/spamassassin/23_bayes.cf /usr/bin/amavisd-checkbayesdb /var/lib/amavis/var/.spamassassin/bayes_toks /var/lib/amavi

Re: bayes database, Berkeley vs. SQL

2005-02-09 Thread Michael Parker
On Wed, Feb 09, 2005 at 11:12:23AM +0100, Arvinn Løkkebakken wrote: > Has anyone measured the difference in performance? > There are benchmark results available for the single server with mysql on a localhost. NOTE: that the DBM tests were done with a local database with lock_method flock, and no

RE: Bayes Database

2004-12-18 Thread Gary W. Smith
It’s in the archives.  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.  If you do an sa-learn as root or another use then the files will be created and locked un their acco

Re: Bayes Database Location

2004-09-29 Thread Matt Kettler
At 12:01 PM 9/29/2004, Israel Carr wrote: I'm running spamassassin on win32 and want to change the location of the bayes database to another drive/folder. Any suggestions? Read the docs: 2.6.x: http://spamassassin.apache.org/full/2.6x/dist/doc/Mail_SpamAssassin_Conf.html 3.0.x: h