Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread JKL
On 06/30/2011 09:03 PM, Axb wrote: > On 2011-06-30 20:51, JKL wrote: >> I finally sorted out the database so that it really had the rights it >> needed. ( /me coughs and hides in the corner. ) > > no worries.. we've all been there, at one time or another > >> >> I have passed several hundred piece

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Axb
On 2011-06-30 20:51, JKL wrote: I finally sorted out the database so that it really had the rights it needed. ( /me coughs and hides in the corner. ) no worries.. we've all been there, at one time or another I have passed several hundred pieces of spam messages into the dB. However it says

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread JKL
On 06/30/2011 06:29 PM, Axb wrote: > Your debug data sez: > > On 2011-06-30 18:19, J4K wrote: >> Learned tokens from 0 message(s) (1 message(s) examined) > > permissions? > > -D will usually give you a good pointer on what's going on. > (thanks JM for beating that into my single cell brain) Hi,

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Axb
Your debug data sez: On 2011-06-30 18:19, J4K wrote: Learned tokens from 0 message(s) (1 message(s) examined) permissions? -D will usually give you a good pointer on what's going on. (thanks JM for beating that into my single cell brain)

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/30/2011 06:02 PM, Axb wrote: > Please only reply to the list... > > On 2011-06-30 18:00, J4K wrote: >> >> # sa-learn --username=spamd --ham .HAM/cur/ >> Learned tokens from 717 message(s) (764 message(s) examined) >> # sa-learn --username=spamd --spam .Junk/cur >> Learned tokens from 311 mess

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Axb
Please only reply to the list... On 2011-06-30 18:00, J4K wrote: # sa-learn --username=spamd --ham .HAM/cur/ Learned tokens from 717 message(s) (764 message(s) examined) # sa-learn --username=spamd --spam .Junk/cur Learned tokens from 311 message(s) (368 message(s) examined) pls run sa-lear

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/30/2011 05:54 PM, Axb wrote: > > ok.. you said "Spamd runs as root." > > in that case: > > bayes_sql_override_username spamd > > then as per Bowie: > > sa-learn --username=spamd --ham /path/to/ham > sa-learn --username=spamd --spam /path/to/spam > > then > sa-learn --dump magic > > Ahh, I m

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Axb
On 2011-06-30 17:50, J4K wrote: On 06/30/2011 05:38 PM, Axb wrote: On 2011-06-30 17:34, J4K wrote: On 06/30/2011 05:27 PM, Axb wrote: spamassassin --lint -D bayes Spamd runs as root. * make a user/group spamd and run as such don't run as root. I'm a tad confused: spamd is launched

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Axb
On 2011-06-30 17:34, J4K wrote: > On 06/30/2011 05:27 PM, Axb wrote: >> spamassassin --lint -D bayes > Spamd runs as root. add user user spamd and run as such don't run spamd as root. set: bayes_sql_override_username spamd then feed bayes manually then run sa-learn --dump magic and sh

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Bowie Bailey
On 6/30/2011 11:34 AM, J4K wrote: > On 06/30/2011 05:27 PM, Axb wrote: >> spamassassin --lint -D bayes > Hi Axb, > > Spamd runs as root. > > # spamassassin --lint -D bayes ... > Jun 30 17:32:12.720 [2775] dbg: bayes: using username: postfix Have you tried specifying the username for sa-learn?

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/30/2011 05:27 PM, Axb wrote: > spamassassin --lint -D bayes Hi Axb, Spamd runs as root. # spamassassin --lint -D bayes Jun 30 17:32:10.858 [2775] dbg: FuzzyOcr: focr_bin_helper: 'pnmnorm,pnminvert,ppmtopgm' Jun 30 17:32:10.858 [2775] info: FuzzyOcr: Adding <3> new helper apps Jun 30 17

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Axb
On 2011-06-30 17:16, J4K wrote: use_bayes 1 skip_rbl_checks 1 bayes_auto_learn 0 # bayes_auto_learn_threshold_nonspam0.1 # bayes_auto_learn_threshold_spam 13.0 bayes_expiry_max_db_size30 bayes_auto_expire 1 bayes_sql_override_username postfix

Re: Bayes and mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
[SNIP] Hi there, This is the table I have in mysql, and the one I intend to populate with data:- mysql> describe bayes_vars; ++--+--+-+++ | Field | Type | Null | Key

Re: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/30/2011 01:45 PM, J4K wrote: > On 06/30/2011 11:37 AM, J4K wrote: >> On 06/30/2011 11:09 AM, J4K wrote: >>> On 06/29/2011 09:55 PM, Lawrence @ Rogers wrote: On 29/06/2011 4:58 PM, JKL wrote: > select count(spam_count) from bayes_vars Run this query SELECT username,spam

Now: Bayes with mysql Was: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/30/2011 01:45 PM, J4K wrote: > On 06/30/2011 11:37 AM, J4K wrote: >> On 06/30/2011 11:09 AM, J4K wrote: >>> On 06/29/2011 09:55 PM, Lawrence @ Rogers wrote: On 29/06/2011 4:58 PM, JKL wrote: > select count(spam_count) from bayes_vars Run this query SELECT username,spam

Re: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/30/2011 11:37 AM, J4K wrote: > On 06/30/2011 11:09 AM, J4K wrote: >> On 06/29/2011 09:55 PM, Lawrence @ Rogers wrote: >>> On 29/06/2011 4:58 PM, JKL wrote: select count(spam_count) from bayes_vars >>> Run this query >>> >>> SELECT username,spam_count,ham_count FROM bayes_vars >>> >>> Thi

Re: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Benny Pedersen
On Thu, 30 Jun 2011 11:41:16 +0200, J4K wrote: loadplugin Mail::SpamAssassin::Plugin::Rule2XSBody should not be in a cf file but in a pre file, check other pre files to enable it Thank-you. Moved this into v320.pre remember to run sa-compile aswell after sa-update(s)

Re: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/30/2011 11:38 AM, Benny Pedersen wrote: > On Thu, 30 Jun 2011 11:09:18 +0200, J4K wrote: > >> loadplugin Mail::SpamAssassin::Plugin::Rule2XSBody > > should not be in a cf file but in a pre file, check other pre files to > enable it Thank-you. Moved this into v320.pre

Re: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread Benny Pedersen
On Thu, 30 Jun 2011 11:09:18 +0200, J4K wrote: loadplugin Mail::SpamAssassin::Plugin::Rule2XSBody should not be in a cf file but in a pre file, check other pre files to enable it

Re: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/30/2011 11:09 AM, J4K wrote: > On 06/29/2011 09:55 PM, Lawrence @ Rogers wrote: >> On 29/06/2011 4:58 PM, JKL wrote: >>> select count(spam_count) from bayes_vars >> Run this query >> >> SELECT username,spam_count,ham_count FROM bayes_vars >> >> This will give a list of usernames that have bee

Re: [Q] Writing rule for career opportunity type messages

2011-06-30 Thread J4K
On 06/29/2011 09:55 PM, Lawrence @ Rogers wrote: > On 29/06/2011 4:58 PM, JKL wrote: >> select count(spam_count) from bayes_vars > Run this query > > SELECT username,spam_count,ham_count FROM bayes_vars > > This will give a list of usernames that have been used to learn ham > and spam into SpamAssa

Re: [Q] Writing rule for career opportunity type messages

2011-06-29 Thread Lawrence @ Rogers
On 29/06/2011 4:58 PM, JKL wrote: select count(spam_count) from bayes_vars Run this query SELECT username,spam_count,ham_count FROM bayes_vars This will give a list of usernames that have been used to learn ham and spam into SpamAssassin's Bayes MySQL DB. For a site-wide installation, this s

Re: [Q] Writing rule for career opportunity type messages

2011-06-29 Thread JKL
On 06/29/2011 09:15 PM, John Hardin wrote: > On Wed, 29 Jun 2011, JKL wrote: > >> mysql> select count(spam_count) from bayes_vars; >> +---+ >> | count(spam_count) | >> +---+ >> | 185 | >> +---+ >> >> mysql> select count(ham_count) from b

Re: [Q] Writing rule for career opportunity type messages

2011-06-29 Thread John Hardin
On Wed, 29 Jun 2011, JKL wrote: mysql> select count(spam_count) from bayes_vars; +---+ | count(spam_count) | +---+ | 185 | +---+ mysql> select count(ham_count) from bayes_vars; +--+ | count(ham_count) | +-

Re: [Q] Writing rule for career opportunity type messages

2011-06-29 Thread John Hardin
On Wed, 29 Jun 2011, Simon Loewenthal wrote: Just checked and am now unsure whether it is enables or not: oot@logout:/etc/spamassassin# grep -i bay local.cf Use Bayesian classifier (default: 1) ayes_auto_learn 1 I suggest you disable auto-learn until you have a good manually collected an

Re: [Q] Writing rule for career opportunity type messages

2011-06-29 Thread JKL
On 06/29/2011 08:50 PM, Lawrence @ Rogers wrote: > On 29/06/2011 3:59 PM, JKL wrote: >> On 06/29/2011 04:59 PM, John Hardin wrote: >>> On Wed, 29 Jun 2011, J4K wrote: >>> Over the past few months I noticed an increase in 'Start New Employment Today | Career Opportunity' style email.

Re: [Q] Writing rule for career opportunity type messages

2011-06-29 Thread Lawrence @ Rogers
On 29/06/2011 3:59 PM, JKL wrote: On 06/29/2011 04:59 PM, John Hardin wrote: On Wed, 29 Jun 2011, J4K wrote: Over the past few months I noticed an increase in 'Start New Employment Today | Career Opportunity' style email. The rules I use, that are pretty much stock rules, correctly tag the ema

Re: [Q] Writing rule for career opportunity type messages

2011-06-29 Thread JKL
On 06/29/2011 04:59 PM, John Hardin wrote: > On Wed, 29 Jun 2011, J4K wrote: > >> Over the past few months I noticed an increase in 'Start New Employment >> Today | Career Opportunity' style email. The rules I use, that are >> pretty much stock rules, correctly tag the email as spam. Usually the >>

Re: [Q] Writing rule for career opportunity type messages

2011-06-29 Thread John Hardin
On Wed, 29 Jun 2011, J4K wrote: Over the past few months I noticed an increase in 'Start New Employment Today | Career Opportunity' style email. The rules I use, that are pretty much stock rules, correctly tag the email as spam. Usually the Spam score hovers between 5.5 and 6.9. Is there some

[Q] Writing rule for career opportunity type messages

2011-06-29 Thread J4K
Dear all, Over the past few months I noticed an increase in 'Start New Employment Today | Career Opportunity' style email. The rules I use, that are pretty much stock rules, correctly tag the email as spam. Usually the Spam score hovers between 5.5 and 6.9. I would like to add a rule that adds mo