Re: How to view bayesian database in legible text

2017-11-13 Thread Michael Parker
> On Nov 9, 2017, at 10:15 AM, Emanuel wrote: > I am interested in seeing the bayes info in the database, because it was > created years ago > > There does exist a plugin, that allows you to fill in the actual text for the hashed value. https://wiki.apache.org/spamassassin/UnmaintainedCust

Re: bayes sql: bayes_seen needs UPDATE

2017-06-24 Thread Michael Parker
Jesse, Thanks for the report. For sure get this into Bugzilla once you get the account setup. Please make sure you include which version of MySQL you are running as well. The Bayes SQL stuff hasn’t been updated in many many years, it might be that MySQL changed the permissions for INSERT on D

Re: Shortcircuit work partially

2016-08-30 Thread Michael Parker
Apologies if any of this ends up being not so up to date. It’s been ages since the Check plugin was written. You’re most likely going to want to write your own Check plugin to change this behavior. If you look at check_main you’ll see the DNS based tests get fired off before the priority loop

Re: Perl regex compilation in spamd

2013-07-09 Thread Michael Parker
On Jul 9, 2013, at 9:18 AM, RW wrote: > > I was wondering when perl REs are compiled in spamd. My understanding > is that perl compiles REs when they are first evaluated. Is anything > done to make this happen in the spamd parent? Yes, on startup a fake message is scanned to prime the pump an

Re: Bayes_vars records on MySQL not created automatically

2013-05-08 Thread Michael Parker
On May 8, 2013, at 8:06 AM, Matteo Dessalvi wrote: > > I always thought that SA would be able to operate autonomously and that it > will create the > proper records in all the tables of the DB. Am I missing something? Is this > the designed behavior? > It's been awhile since I wrote and loo

Re: how decode tokens's column

2012-05-11 Thread Michael Parker
On May 11, 2012, at 8:34 AM, Jacopo Fabiani wrote: > > > My question is: where do I get wrong? Is there a way to decode encoded token > that I got with sa-learn --backup command? > No, there is no way to decode the bayes tokens. Search this mailing list several years ago for possible work ar

Re: Is there a header size limit on To: header rules?

2012-04-20 Thread Michael Parker
On Apr 20, 2012, at 12:17 PM, cyboc wrote: > > We have been receiving 419 spam with extremely long lists of email addresses > in the To: header. I'm talking hundreds of addresses. > > I've noticed that the same email addresses keep on appearing near my user's > email address in the To: header.

Re: New versions of Perl are slower

2012-04-10 Thread Michael Parker
On Apr 10, 2012, at 4:12 PM, Julian Yap wrote: > I'm running SpamAssassin 3.3.2 port revision 6 (latest from FreeBSD > ports) on FreeBSD 8.2-RELEASE 64-bit. > > I recently upgraded my Perl from 5.10 to 5.14 but I needed to > downgrade because SpamAssassin was crashing on a daily basis. See > bu

Re: Spamassassin rules from sql

2012-02-01 Thread Michael Parker
On Feb 1, 2012, at 10:37 AM, Miguel Fernandes wrote: > Hi! > > I'm just wondering, is there a limitation on the type of rules that can be > added to the SpamassAssin rules table? > Because adding something like (subject scoring): > > header TEST_SUBJECT Subject =~ /test/i (I've tried several c

Re: A SpamAssassin Crash Course for Admins

2011-11-29 Thread Michael Parker
On Nov 29, 2011, at 9:13 PM, Dorian Chan wrote: > Hello again, > I've attached version 2.0 with this email (it's the clean version without all > the comments :) ). I've pretty much finished up the definitions and some > cleaning up. Again, I would really enjoy feedback! > Everywhere you say "

Re: Only running network tests when necessary - feature request

2010-10-29 Thread Michael Parker
On Oct 29, 2010, at 8:42 PM, dar...@chaosreigns.com wrote: > I'd like to see spamassassin only run network tests when they might > affect the outcome. Why? Assuming a reasonably fast connection network checks are basically free. They are kicked off at the start of a scan and the results are co

Re: Writing Spamassassin plugin.

2010-06-18 Thread Michael Parker
These might be starting to get dated a little but I think that if you look at the "Extending Apache SpamAssassin Using Plugin" slides and notes from here: http://people.apache.org/~parker/presentations/index.html That will give you a good idea on what you need to accomplish for your plugin. Mic

Re: segmentation fault on startup

2010-01-10 Thread Michael Parker
On Jan 10, 2010, at 6:58 PM, Robert P. Weaver wrote: [28414] dbg: replacetags: replacing tags [28414] dbg: replacetags: done replacing tags [28414] dbg: bayes: tie-ing to DB file R/O /users/ rweaver/.spamassassin/bayes_toks [28414] dbg: bayes: tie-ing to DB file R/O /users/ rweaver/.spamassas

Re: actual facts (was Re: HABEAS_ACCREDITED SPAMMER)

2009-12-04 Thread Michael Parker
FYI, the original bug is here: https://issues.apache.org/SpamAssassin/show_bug.cgi?id=3998 All the bitching about it, took me about 30 seconds to find it. Michael

Re: How to log sending IP in spamd

2009-10-05 Thread Michael Parker
On Oct 4, 2009, at 1:46 PM, Steve Fatula wrote: We use Spamassassin via spamc/spamd via procmail. In the maillog file, we see when there is spam, the message indicates a bunch of information. raddr shows up always as 127.0.0.1, which is our course our connection to SPAMD from our machine v

Re: Do I need to do anything to maintain MySQL?

2009-10-05 Thread Michael Parker
On Oct 4, 2009, at 8:56 PM, Steven W. Orr wrote: I did some googling, and the more I read, the more apparent that the documentation is a little light. So here are the questions that I think are really the 800 pound elephant in the room: * If I do set bayes_auto_expire to 0 and I am using M

Re: Parallelizing Spam Assassin

2009-07-31 Thread Michael Parker
On Jul 31, 2009, at 1:55 AM, poifgh wrote: I ran freshly build SA with Bayes and DNSBL turned off. Why am I not seeing a linear increase in the throughput? Is a file locking creating the bottleneck? If yes, which particular file is being locked? If no, what could be the reason for this?

Re: URI-DNSBL problem with spamassassin 3.2.5

2009-07-09 Thread Michael Parker
On Jul 9, 2009, at 1:40 PM, Eddy Beliveau wrote: but Ido not find any timing.log file on my current directory or anywhere on my system!! Did I missed something ? I doubt all the necessary hooks are in place for that plugin to work in 3.2.5, you'd need to run 3.3 to make use of that plu

Re: Plugging dspam into SA

2009-07-09 Thread Michael Parker
On Jul 9, 2009, at 7:07 AM, Frank DeChellis wrote: If anybody has any advice or ideas, please let me know. This is probably way beyond what you wanted to get into but the Bayes subsystem has plugin hooks so you could write your own dspam plugin to use. I'm not aware of anyone trying i

Re: lookup user_prefs in SQL database (not using spamc)

2009-03-25 Thread Michael Parker
On Mar 25, 2009, at 9:30 AM, Guido wrote: I believe it means you should take up this issue with the Amavisd- new support forum. Since you are not RUNNING SpamAssassin/spamc/spamd then some parts of the configuration simply are not made effective in your situation. You must look for a sol

Re: Two servers, one database. A question

2009-02-14 Thread Michael Parker
On Feb 14, 2009, at 3:47 PM, Lindsay Haisley wrote: On Sat, 2009-02-14 at 15:04 -0600, Bob Proulx wrote: I would bet on Bayes/userpref queries being more efficient than the spamc/spamd traffic. I like that you are asking the question. But I hate to guess at which is better though. The

Re: Secure spamd server

2009-02-04 Thread Michael Parker
On Feb 4, 2009, at 11:06 AM, Andre wrote: On Wed, 4 Feb 2009, Matus UHLAR - fantomas wrote: On 03.02.09 21:39, Andre wrote: spamc is never called from Exim in this case, so the --ssl switch can't be used. At least that is my understanding (maybe mis-understanding?) of the situation.

Re: Test order

2009-01-08 Thread Michael Parker
On Jan 7, 2009, at 5:10 AM, Benny Pedersen wrote: On Tue, January 6, 2009 03:11, Matt Kettler wrote: Check your .pre files to make sure the shortcircuit plugin is loaded in one of them. (Note: loadplugin statements added to local.cf will NOT work, they should be in the .pre files) is this

Re: bayes SQL delays

2008-11-03 Thread Michael Parker
On Nov 2, 2008, at 12:55 PM, Micah Anderson wrote: I have spamd setup to use bayes in a mysql database, works fine. I've turned off auto-expiry and instead run a cronjob to expire in the middle of the night (removes about 40k tokens on a run). I've made the DB innoDB so it can handle lockin

Re: Merge of bases bayesians

2008-08-22 Thread Michael Parker
On Aug 22, 2008, at 5:36 AM, Eduardo Júnior wrote: I have an e-mail server 1, which has spamassassin with a basic Bayesian. And I also have another e-mail server 2, which is another basic Bayesian. Can I make a merge of the two bases without an overwrite? Thus, my new basis would be a un

Re: Re-injection

2008-08-05 Thread Michael Parker
On Aug 5, 2008, at 7:57 AM, LDB wrote: Is it possible to re-inject a caught piece email that was labeled HAM, in spamd or spamc and force it to learn it as spam for bayes? Yes. First read up on the --allow-tell command line switch for spamd, if you're ok with the "risks" then start spamd

Re: Install mysq for bayes

2008-07-15 Thread Michael Parker
On Jul 15, 2008, at 4:04 AM, Alex Woick wrote: Paolo De Marco schrieb am 11.07.2008 11:17: I want to migrate to mysql form my bayes. I have installed perl modules, mysql and modify local.cf. When i run amavisd debug i see this lines: Jul 11 11:16:36 mail.ial.fvg.it /usr/local/sbin/amavisd[1756

Re: mysql AWL issue....

2008-07-08 Thread Michael Parker
On Jul 8, 2008, at 12:42 PM, Adam Harrison wrote: I put the following in local.cf (passwords obscured): bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:spamassassin:sa-db.intelius.com:3306 bayes_sql_username readwrite bayes_sql_password

Re: Short circuit priority doesnt seem to work

2008-06-26 Thread Michael Parker
On Jun 26, 2008, at 7:01 PM, Benny Pedersen wrote: On Thu, June 26, 2008 23:09, Larry Nedry wrote: Benny, you might want to read the docs: docs needs updating, all test i have done is showing this is not working so here Hmmm then you are running a faulty or modified version I guess,

Re: Short circuit priority doesnt seem to work

2008-06-26 Thread Michael Parker
, 2008 21:17, Michael Parker wrote: Negative numbers come before positive numbers. nope order is positive to negative you might find it is correct by testing more :) Benny, you might want to read the docs: <http://spamassassin.apache.org/full/3.2.x/doc/Mail_SpamAssassin_Conf.html > O

Re: Short circuit priority doesnt seem to work

2008-06-26 Thread Michael Parker
On Jun 26, 2008, at 12:05 PM, Benny Pedersen wrote: On Thu, June 26, 2008 17:13, ram wrote: How do I enforce SA to wait for results negative short circuited rules of higher priority before shorcicuiting mail as spam due to positive ones make priority positive not negative, default all h

Re: SQL DB schema issue

2008-05-28 Thread Michael Parker
On May 28, 2008, at 10:38 AM, Rocco Scappatura wrote: Hello, I'm using SA with SQL support under Amavid-new. My DBMS is MySQL. I 'm preparing one another Antispam server and I ve installed the latest stable software available. I ve dumped bayes DB (schema + data) from an already working

Re: MySQL and Size Of bayes_expiry_max_db_size

2008-05-27 Thread Michael Parker
On May 27, 2008, at 4:22 PM, Larry Nedry wrote: Greetings, This weekend I created a MySQL db to store my bayes tokens. It seems to be working well but I'm a little puzzled by the default size of bayes_expiry_max_db_size. I understand that the default size is 150,000 which seems very lo

Re: Persistent DB connections

2008-04-22 Thread Michael Parker
On Apr 22, 2008, at 5:31 AM, Christoph Petersen wrote: He guys, for my setup I use a MySQL DB as the store for bayes and AWL. Every process is opening, querying and closing his own DB connection which results in latency and is not necessary. Really? Thats interesting, in all my tests MyS

Re: Bayes DB growing without bound; expiry not working

2008-04-21 Thread Michael Parker
On Apr 21, 2008, at 8:40 AM, Chris St. Pierre wrote: On Mon, 21 Apr 2008, Michael Parker wrote: select * from bayes_vars; ... 2289 rows in set (0.00 sec) What user do you run bayes under on your MXs? I think you've found the issue. We run as spamd. # sa-learn -u spamd --dump

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

Re: libspamc.so and bayes

2008-02-07 Thread Michael Parker
On Feb 6, 2008, at 4:49 AM, Or Goshen wrote: Is it possible to use libspamc.so to tell spamd that a message is either spam or ham ? ie, imitate "sa-learn --spam/--ham" using libspamc.so. There dont seem to be any documentation about the library, all I could find are comments in the header f

Re: Expiry problem

2008-01-24 Thread Michael Parker
On Jan 23, 2008, at 9:54 PM, Steven Stern wrote: It's finally started to remove tokens, so I think I'm OK. We use SQL bayes, so it was an easy matter to use ~ delete from bayes_token where atime > UNIX_TIMESTAMP(); to clean up the stuff from the future. But now your bayes_vars table is

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-23 Thread Michael Parker
On Jan 23, 2008, at 6:37 AM, Rubin Bennett wrote: Spamd output below:[EMAIL PROTECTED] ~]# spamd -q -D [12373] dbg: logger: adding facilities: all [12373] dbg: logger: logging level is DBG Can you run this again and this time pass 1-2 msgs through just like you would normally, instead of j

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-22 Thread Michael Parker
On Jan 22, 2008, at 12:17 PM, Rubin Bennett wrote: On Tue, 2008-01-22 at 10:45 -0600, Michael Parker wrote: On Jan 22, 2008, at 10:12 AM, Rubin Bennett wrote: WTF am I doing wrong?! Not including debug logs in your message. User prefs does not work with spamassassin, so you won'

Re: Spamd and MySQL userprefs/ AWL/ Bayes

2008-01-22 Thread Michael Parker
On Jan 22, 2008, at 10:12 AM, Rubin Bennett wrote: WTF am I doing wrong?! Not including debug logs in your message. User prefs does not work with spamassassin, so you won't see anything there, but you should be seeing something for Bayes SQL and AWL SQL if they are configured correctly.

Re: sa 32x-branch 'make test' fails @ "t/spamc_optL.t" (among others ...) on freebsd

2007-12-31 Thread Michael Parker
On Dec 31, 2007, at 10:23 AM, snowcrash+sa wrote: but bear in mind that it will probably only get attention from other jail users heh. understood. and, expected. alas, i know it's wasted breath to argue that the prevalence of SA-(& everything else, for that matter)-in-jails/VMs is on

Re: Mondo bayes_toks - millions of entries

2007-11-30 Thread Michael Parker
On Nov 30, 2007, at 1:56 PM, Wes wrote: Well, spamd is apparently doing things far more efficiently than "sa- learn --restore". Tokens are loading into the DB much faster than the restore, and postmaster is hardly ever a blip in 'top' (at least so far). When running the restore, postmaster

Re: SQL-based AWL and Bayes not working with 3.2.3

2007-11-27 Thread Michael Parker
On Nov 27, 2007, at 10:16 AM, Rene Caspari wrote: In my case it is a bug :-) Because I don't have any chance to get user specified bayes db working which come from a SQL database. Its actually a behavior change, at least for me. How are you running spamd? If you are running with -q or --s

Re: SQL-based AWL and Bayes not working with 3.2.3

2007-11-19 Thread Michael Parker
On Nov 19, 2007, at 8:57 AM, Andrew Hearn (AAISP) wrote: Rene Caspari wrote: Hi, I'm using spamassassing 3.2.3 with userspecific rules from an SQL database: /etc/spamassassin/local.cf: user_scores_dsn DBI:mysql:spamassassin:localhost [...] bayes_store_module Mail::SpamAss

Re: Book Recommendation

2007-10-26 Thread Michael Parker
cpayne wrote: > Guys, > > I am looking for books on Spamassassin. And I am wanting to know what > you guys recommend? > http://spamassassin.apache.org/ http://wiki.apache.org/spamassassin/ Seriously. There are a couple of books on SA, but they go out of date very quickly. You're much better o

Re: change mysql username in bayes_var table

2007-10-14 Thread Michael Parker
Rob Mangiafico wrote: > We're converting a server from per user mysql bayes to sitewide bayes > using the "bayes_sql_override_username USERNAME" command. We want to use > the data for one username in the mysql db already that has quite a nice > buildup of trained ham and spam. > > Can we simply

Re: Learn Ham/Spam to more than Bayes DB

2007-10-14 Thread Michael Parker
Magnus Anderson wrote: > Hi, > > I have a script that runs every night with sa-learn to learn new ham/spam > messages for every user. > I do this with running these commands > > /usr/bin/sa-learn --ham --no-sync -u {$_array['sa_user']} {$_dir['inbox']} > /usr/bin/sa-learn --ham --no-sync -u {$_ar

Re: Bayes only if -u specified?

2007-10-12 Thread Michael Parker
Jason Frisvold wrote: > Hi all, > > Quick question. Is it possible to set up spamassassin to use Bayes > only if the -u option is passed via spamc? I'm using simscan to call > spamassassin and if the user is not specified, it falls back to the > nobody account. The bayesian database fills up wi

Re: Bayes innodb problems

2007-09-26 Thread Michael Parker
micah wrote: > On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wrote: > >> On Wed, 26 Sep 2007, Micah Anderson wrote: >> >>> SELECT count(*) >>>FROM bayes_token >>> WHERE id = '4' >>> AND ('1190846660' - atime) > '345600'; >> Who the hell wrote *tha

Re: bayes_seen = 256GB

2007-09-19 Thread Michael Parker
Dave Koontz wrote: > Theo and all. I know this topic comes up on occasion, but I am not sure > I've ever seen an explanation as to why the bayes_seen file is not auto > pruned along with the bayes db file. Since tokens expire in the main DB > file, what is the purpose of having a seen file to unl

Re: SQL error: Deadlock found when trying to get lock

2007-09-19 Thread Michael Parker
pennywise wrote: > Hello together! > > I ´ve got following problem with my spamassassin which I couldn´t solve. > When I use > > su vscan -c '/usr/local/bin/sa-learn -D --force-expire --sync' > > I got this error message: > > [72597] dbg: bayes: token_expiration: SQL error: Deadlock fo

Re: List of 600,000 IP addresses of virus infected computers

2007-09-10 Thread Michael Parker
The users lists is not really an appropriate place to advertise your spam/virus filtering business. Please do not feed the trolls. Thanks Michael

Re: Who wants my spam - seriously!

2007-09-06 Thread Michael Parker
Please do not feed the trolls. Michael

Re: header /^\Q...\E$/m

2007-09-01 Thread Michael Parker
[EMAIL PROTECTED] wrote: > < so whenever one uses a ^ or $ in a pattern, one is almost obliged to > < append a /m flag, otherwise one risks being at a mercy of malicious > < senders... Depending on a situation, this can be a security risk. > > Sure wish Mail::SpamAssassin::Conf would mention all t

Re: spamd keeps running at 99% CPU until i kill the process

2007-08-28 Thread Michael Parker
Richard Hobbs wrote: > Hello, > > Could the size of "bayes_seen" and "bayes_toks" be causing this timeout? > No, those aren't really that big, but it does look like you have an expiration problem. To solve your immediate problem you could just turn off bayes, that will get mail flowing again an

Re: Really Stupid Question: Plugins

2007-07-18 Thread Michael Parker
Skip Brott wrote: > I haven't yet had to implement any pdf plugins, but I am looking to do so. > I am running SA 3.1.9 and perl 5.8.8. From what I can see, my plugins are > here: > > /usr/lib/perl5/site_perl/5.8.0/Mail/SpamAssassin/ > > And there is no related folder for 5.8.8 > > Is that the l

Re: PDFText Plugin for PDF file scoring - PDFText2.pm for ver 3.2

2007-07-16 Thread Michael Parker
Theo Van Dinter wrote: > > IMO, if people find this a useful enough feature of 3.2, it's a relatively > trivial change in the code as I recall, so a bugzilla request to backport > may get somewhere for a future 3.1 release. > I would +1 a backport. Michael

Re: No Bayes!!

2007-06-28 Thread Michael Parker
Lindsay Haisley wrote: > On Thu, 2007-06-28 at 15:43 -0400, Theo Van Dinter wrote: >> On Thu, Jun 28, 2007 at 02:27:36PM -0500, Lindsay Haisley wrote: >>> So what's the best fix for this? Should one just freeze SA at an >>> earlier version on a production server until this is fixed upstream? Is >

Re: per-user rules from mysql

2007-05-08 Thread Michael Parker
Duane Hill wrote: > > header L_TO_ME ToCc =~ /[EMAIL PROTECTED]/ > describe L_TO_ME Email addressed to me > score L_TO_ME 0.010 > You can't do rules with SQL user prefs, not even with allow_user_rules. Only non-admin config options are allowed. Michael

Re: Problem upgrading from 3.1.8 to 3.1.20, check.pm

2007-05-07 Thread Michael Parker
[EMAIL PROTECTED] wrote: > Hi, > > I've been upgrading several stable servers running 3.1.8 for months > without any issues to 3.1.20, and got a problem in one of them. When > trying to restart spamd, I get this: > > @4000463ee4f622539324 [5532] error: check: no loaded plugin > implements '

Re: Invalid use of \\ in string literal from postgresql

2007-05-04 Thread Michael Parker
Graham Murray wrote: > I am using spamassassin 3.2.0 and Postgresql 8.2.4 for bayes and awl. > > I am seeing several messages from Postgresql like the following > > spamd[18408]: WARNING: nonstandard use of \\ in a string literal > spamd[18408]: LINE 1: select > put_tokens(1,'{"003272\\\

Re: ANNOUNCE: Apache SpamAssassin 3.2.0 available

2007-05-04 Thread Michael Parker
Anders Norrbring wrote: > > I just ran into a big problem.. > > [25735] warn: bayes: database version is different than we understand > (3), aborting! at > /usr/lib/perl5/vendor_perl/5.8.8/Mail/SpamAssassin/BayesStore/SQL.pm > line 136 Double check your config for your database, make sure it

Re: problem with Mail::SpamAssassin::PerMsgStatus - SA 3.2.0

2007-05-04 Thread Michael Parker
Maciej Friedel wrote: > I can't make sa-compile because > > [EMAIL PROTECTED]:~# spamassassin --lint > [23577] warn: Couldn't get Connecting IP header X-SA-Exim-Connect-IP for > message <[EMAIL PROTECTED]>, skipping greylisting call > [23577] warn: rules: failed to run CG_FUJI_JPG test, skipping:

Re: Question on use of SpamCop plugin

2007-04-19 Thread Michael Parker
Steven W. Orr wrote: > What I've currently been using is this script: > > #! /bin/bash > exec tee >(mail [EMAIL PROTECTED]) | sa-learn --spam > > Is there an advantage to using -r over what I have? (something like) > exec tee >(spamassassin -r) | sa-learn > -r will also perform the sa-learn po

Re: Mass-Check Hangs

2007-04-03 Thread Michael Parker
There is a bug in the 3.1 ArchiveIterator code that causes things to hang on msgs that are too large or too small. This got fixed in the 3.2 code, probably needs to be back ported. Feel free to open up a bug. Thanks Michael Larry Nedry wrote: > Hi All, > > I'm trying to use mass-check to test

Last Reminder: Google Summer of Code Applications

2007-03-25 Thread Michael Parker
Apache GSoC wiki page: http://wiki.apache.org/general/SummerOfCode2007 It already has several ideas for possible projects, but don't feel limited by our list, make up your own proposal if you would like. Thanks Michael Parker

Students: Get Paid to Hack on SpamAssassin

2007-03-20 Thread Michael Parker
of something from here: http://wiki.apache.org/spamassassin/WeLoveVolunteers that you would like to work on, feel free to add it to the list and submit an application. Thanks Michael Parker

Google Summer of Code 2007 - Students Wanted

2007-03-16 Thread Michael Parker
here: http://wiki.apache.org/spamassassin/WeLoveVolunteers that you would like to work on, feel free to add it to the list and submit an application. Last year we were able to take on several projects, its a nice way to earn 4500 USD over the summer. Thanks Michael Parker

Re: Undefined subroutine &Mail::SpamAssassin::Plugin::DBI::dbi

2007-02-24 Thread Michael Parker
Michael Monnerie wrote: >> Either a) you have something goofed up there or b) something is >> goofed in how we setup the INC path for plugins. > > Something must have changed that breaks DBIPlugin, because at 3.1.7 > I don't have that error. > Please file a bug in Bugzilla. It might be somethi

Re: Undefined subroutine &Mail::SpamAssassin::Plugin::DBI::dbi

2007-02-19 Thread Michael Parker
Chris wrote: > On Monday 19 February 2007 6:06 pm, Theo Van Dinter wrote: >> On Mon, Feb 19, 2007 at 05:50:27PM -0600, Chris wrote: >>> This was the output of my sa-update cronjob this morning: >>> >>> Undefined subroutine &Mail::SpamAssassin::Plugin::DBI::dbi called >>> at /etc/mail/spamassassin/D

Re: Bayes db size....

2007-02-17 Thread Michael Parker
Dave Koontz wrote: > I am sure this has been asked numerous times before, but what is the logic > in having auto expiry on the bayes DB, and not seen? Seems that once tokens > have been removed from the DB there is little to no use for 'unlearning' any > associated messages. Besides on a busy sys

Re: Export and append Bayes DB

2007-02-16 Thread Michael Parker
Sam Przyswa wrote: > Hi, > > Is it possible to export a Bayes DB from a server and then append (not > restore) it to others servers ? > No, you generally can't combine two bayes databases that way. Best bet is to pick the most complete one and use it. For more details see a really long post on

Re: Doubt with user_scores_sql_custom_query

2007-01-30 Thread Michael Parker
Kim Christensen wrote: > * Jorge Cardona <[EMAIL PROTECTED]> [2007-01-29 23:48:52 -0500]: > >> Hi. >> I got a question about this parameter, the spamassassin documentation >> tells this: >> >> 1) Current default query: >>SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ >> OR u

Re: Doubt with user_scores_sql_custom_query

2007-01-29 Thread Michael Parker
Jorge Cardona wrote: > Hi. > I got a question about this parameter, the spamassassin documentation > tells this: > > 1) Current default query: >SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ > OR username = '@GLOBAL' ORDER BY username ASC > > 2) Use global and then domain l

Re: bayes store PgSQL error

2007-01-24 Thread Michael Parker
Tom Allison wrote: > [1174] dbg: bayes: using username: tallison > [1174] dbg: bayes: unable to connect to database: missing "=" after > "bayes:192.168.0.100:5432" in connection info string > > > bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL > bayes_sql_dsn DBI:Pg:bayes:192.168.0.

Re: Problem with mass-check on cygwin

2007-01-18 Thread Michael Parker
Fred T wrote: > Hello users, > > I'm getting ready for the mass-check run for rescoring 3.2 and I'm > seeing an awful lot of messages like: > > bayes: cannot open bayes databases > /cygdrive/E/Temp/spamassassin-trunk/masses/spam > assassin/bayes_* R/W: lock failed: File exists > > Being on

Re: getting Bayes token data from spamassassin

2007-01-17 Thread Michael Parker
Jonas Eckerman wrote: > Justin Mason wrote: >> http://spamassassin.apache.org/full/3.1.x/doc/Mail_SpamAssassin_Plugin.html#item_bayes_learn > > Thanks! > >> by the way, a nice, working plugin that does this would be quite useful > > Since it was so straight-forward I made a small plugin that col

Re: getting Bayes token data from spamassassin

2007-01-15 Thread Michael Parker
Stuart Robinson wrote: > Hello, all. > >> On Mon, Jan 15, 2007 at 01:54:07AM -0800, Stuart Robinson wrote: >>> I've searched around a bit, both on gmane and Google, but I haven't found >>> much more information regarding your two points. What IS stored in the >>> token field of the table bayes_tok

Re: Unknown option: a when restarting spamd

2007-01-05 Thread Michael Parker
Geoff Soper wrote: > I've recently moved from calling spamassasin to using spamc/spamd. Today > I had a "/etc/rc.d/init.d/spamd restart" fail with the message "Unknown > option: a". Googling this led me to the /etc/sysconfig/spamassassin and > /etc/rc.d/init.d/spamd files, both of which specified t

Re: SA-Learn Recover to SQL is slow.

2007-01-04 Thread Michael Parker
Big Wave Dave wrote: > On 1/3/07, Gary V <[EMAIL PROTECTED]> wrote: >> >It finally finished the restore. >> > >> >For the sake of information to help future users >> > >> >The "backup" file being used to restore into the new SQL database was >> >99MB and took 17hrs to import on my AMD 1.2Ghz ma

Re: SA-Learn Recover to SQL is slow.

2007-01-03 Thread Michael Parker
Big Wave Dave wrote: > > > What am I missing? > > I'd be thankful for any input. You're not missing anything. The import takes a long time to run. Its doing a lot of updates which are expensive in SQL. The good news is that you can pretty much use the system while its doing the import becaus

Re: sa + bayes/sqlite _performance_? reasons _not_ to use it?

2006-12-31 Thread Michael Parker
snowcrash+spamassassin wrote: > i'm interested in using sqlite across my 'entire' mail server env. > currently, exim+dovecot+spamassassin. > > i know sqlite _can_ be used for bayes db in sa. lots of info on that. > > any reasons it should NOT be used? > > i'm guessing performance, compared to d

Re: Spamassassin and Oracle bayesians DB

2006-12-21 Thread Michael Parker
Jose Javier Sianes Ruiz wrote: > Now I’m studding the possibility to build a very large Bayesian database. > Due to a huge amount of user I got (over 100,000 and possibly doubled next > year, with 8MB of Bayesian information each one on theirs Maildirs), I have > discarded use MySQL or PostgreSQL,

Re: Help spamassassin + msql user defined rules

2006-12-13 Thread Michael Parker
Gert Horne wrote: > Hi, > > I need some help. > > I am trying to configure spamassassin to read my user defined rules. > > I want to be able to block messages based on body and subject rules > defined in a mysql table > > My debug output state that spamassassin is working fine with mysql > >

Re: SA 3.1.7 not picking up SQL-based Bayes

2006-12-03 Thread Michael Parker
C. Bensend wrote: >> Ahh but you didn't run the command I asked you to run. You are passing >> the user: [EMAIL PROTECTED] to SpamAssassin so it will use that as >> the key for the database, running the command from the command like that >> way is going to use your unix id as the key. I'm guessin

Re: SA 3.1.7 not picking up SQL-based Bayes

2006-12-03 Thread Michael Parker
C. Bensend wrote: >> I think its just a slightly confusing message. If you run: >> sa-learn -u [EMAIL PROTECTED] >> >> Does it show that you have 200 ham and 200 spam in the database? If so >> then there is a problem, if not you just need to train it some more. >> >> What the WARNING is telling y

Re: SA 3.1.7 not picking up SQL-based Bayes

2006-12-03 Thread Michael Parker
C. Bensend wrote: > Hey folks, > >I'm finishing up a mailserver upgrade this weekend, and I notice > that my new SQL-based install isn't picking up on user-based Bayes > data. This is on a new, squeaky-clean OpenBSD 4.0-STABLE machine > running on AMD64, using SpamAssassin 3.1.7 with perl 5.8

SQL Performance w/ SpamAssassin

2006-11-28 Thread Michael Parker
Gary V wrote: > > I was curious about a couple settngs that I heard can affect performance > when using Innodb so I did a few ad hoc tests: > > http://www200.pair.com/mecham/spam/mysqlspeed.txt > > http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ >

Re: Converting bayes DB to MySQL

2006-11-27 Thread Michael Parker
Dan Bongert wrote: > I'm in the process of converting my Bayes DB setup from in users' home > directories (since I'm setting up a separate SpamAssassin server, and > accessing Bayes via NFS is causing insane amounts of I/O). > > After a bunch of fiddling, I have a MySQL server set up properly, tab

Re: BayesStore/SQL.pm

2006-11-26 Thread Michael Parker
Giampaolo Tomassoni wrote: > No answer to this? > > Is this the wrong list to ask code details? I thought I saw an answer to this alreadymaybe I was mistaken. > > Thanks, > > giampaolo > > From: Giampaolo Tomassoni [mailto:[EMAIL PROTECTED] >> What is $self->_userid in seen_put() and the

Re: How to use --allow-tell?

2006-11-26 Thread Michael Parker
Todd A. Jacobs wrote: > I was perusing the man pages for spamd in spamassassin 3.1.7, and came > across something that seems to imply that I can use spamc to tell spamd > to update a sitewide bayesian database: > > -l, --allow-tell > Allow learning and forgetting (to a local Bayes databa

Re: subscribing to the users list documentation

2006-10-10 Thread Michael Parker
Email Lists wrote: > > Personally, I would make it stand out in a different yet better way... it > isn't like I didn't look for it for 15 minutes and I quit being "stupid" > years ago... > > Or so I thought ;-) > Its a WIKI!!! Make it better!! Michael

ApacheCon 2006 and SpamAssassin

2006-09-14 Thread Michael Parker
Howdy, This year ApacheCon will be held in Austin, Texas. http://www.us.apachecon.com/index.html In addition to all of the other Apache Software Foundation related talks there will be at least two SpamAssassin talks: High Performance Apache SpamAssassin Extending Apache SpamAssassin Using Plug

Re: Bayes conversion from DB to SQL question

2006-09-13 Thread Michael Parker
Tim Rosmus wrote: > I've been running multiple in/out servers using Bayes and the local > Bayes DB storage on the local machine[s]. Now I am moving Bayes > to a site wide SQL setup. My question is on the sa-learn backup/ > restore from DB to SQL... > > Should I backup/restore all local machine

Re: Allowing IMAP/POP to Send Email & United Nations etc....

2006-08-03 Thread Michael Parker
Nigel Frankcom wrote: > I'll put on my flameproof underwear for this > > There's been a huge amount of crossfire on these/this subject, but I > don't see how it has anything to do with SA; or am I missing the > point? > > Different protocols, yet another level of policing, but nothing about >

Re: sa-learn slow with Bayes and PostgreSQL

2006-07-11 Thread Michael Parker
Randall Perry wrote: > I recently updated to the latest SA and at the same time converted bayes > from file db to PostgreSQL. > > I notice that using sa-learn with SQL now is very slow compared to file db. > Is this normal, and is accessing the db while scanning mail any slower with > SQL? > >

Re: SA::DBI plugin and SA 3.1.3

2006-06-23 Thread Michael Parker
Michael Monnerie wrote: > On Samstag, 24. Juni 2006 02:30 Michael Parker wrote: >> Add --debug dbiplugin to your starup command line. > > Sorry I checked that already, but forgot to post it: > # spamd -D dbiplugin -q -c -l -r /var/run/spamd.pid --min-children=2 > --max-chil

Re: SA::DBI plugin and SA 3.1.3

2006-06-23 Thread Michael Parker
Michael Monnerie wrote: > On Dienstag, 20. Juni 2006 18:09 Michael Parker wrote: >> You're pointed at the wrong DBI.pm. I updated the wiki to make it >> more obvious. > > It's running now, but I can't see caching to happen. Below some > log lines. Any ideas

Re: SQL Bayes with Postgres in SUSE9.3

2006-06-22 Thread Michael Parker
Michael Monnerie wrote: > > I would say the docs are not correct, at least to one who is not > specialist in configuring DBI. I found the info on the DBI man page, > but still the docs here are wrong. You are not reading completely, especially the part that says: "For an example of connection

  1   2   3   4   >