Re: The Future of Email is SQL

2006-06-10 Thread Jim C. Nasby
likely you are to see benefit from using a database. -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming

Re: The Future of Email is SQL

2006-06-09 Thread Jim C. Nasby
you need. One nice thing about databases is they make it possible to do things like partition your tables by month/week/whatever. You can then move older data onto larger partitions that use slower, cheaper drives. -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your

Re: The Future of Email is SQL

2006-06-09 Thread Jim C. Nasby
that's actually standards compliant. Probably the best bet would be to offer support for SQLite and PostgreSQL. That allows small users to have the 0 maintenance of SQLite while big users get the scaleability of PostgreSQL. -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give

Re: The Future of Email is SQL

2006-06-09 Thread Jim C. Nasby
crashing and the administrator having to rebuild the database while the mail server is down for the next 10 hours. Just because MS couldn't figure out how to do this correctly doesn't mean it can't be done. -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer

Re: The Future of Email is SQL

2006-06-09 Thread Jim C. Nasby
aren't good ones though but it's something we've been able to work with for some time. Why would you deal with the short-commings when you could just use PostgreSQL, SQLite, or even Innobase? -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain

Re: SQL Bayes

2006-03-24 Thread Jim C. Nasby
where username = '[EMAIL PROTECTED]'; -- Matthew.van.Eerde (at) hbinc.com 805.964.4554 x902 Hispanic Business Inc./HireDiversity.com Software Engineer -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy

Out of office emails

2006-02-08 Thread Jim C. Nasby
=2.8 required=5.0 tests=AWL,BAYES_50, FORGED_OUTLOOK_HTML,HTML_90_100,HTML_MESSAGE,MIME_HTML_ONLY autolearn=no version=3.1.0 From: Jfabricio - Coordenador de TI [EMAIL PROTECTED] To: Jim C. Nasby [EMAIL PROTECTED] Subject: Re: Spamassassin Learn Date: Wed, 8 Feb 2006 08:18:23 -0200

Re: Spamassassin Learn

2006-02-08 Thread Jim C. Nasby
? -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what?

Re: Spamassassin Learn

2006-02-08 Thread Jim C. Nasby
without requiring users to supply emails they receive stamps for? -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD

Re: Spamassassin Learn

2006-02-08 Thread Jim C. Nasby
On Wed, Feb 08, 2006 at 11:49:09AM -0500, Matt Kettler wrote: Jim C. Nasby wrote: On Wed, Feb 08, 2006 at 11:29:36AM -0500, Matt Kettler wrote: However, looking in the config files, HASHCASH rules have the userconf flag. This means that the Autolearner will also ignore these rules too

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
-token data: nspam 0.000 0 255134 0 non-token data: nham I just changed bayes_auto_learn_threshold_spam to 5.0, we'll see what that does... -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
, and still get autolearned as ham) What would be the easiest way to do that? Grep through my caughtspam maildir? -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
On Tue, Feb 07, 2006 at 05:02:25PM -0500, Matt Kettler wrote: Jim C. Nasby wrote: On Tue, Feb 07, 2006 at 04:40:40PM -0500, Matt Kettler wrote: I would also check to make sure you don't have a lot of spam coming in that's getting autolearned as ham. (note: the learner's idea of score

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
On Tue, Feb 07, 2006 at 01:45:48PM -0800, jdow wrote: From: Jim C. Nasby [EMAIL PROTECTED] On Tue, Feb 07, 2006 at 03:16:57PM -0500, Matt Kettler wrote: My current training ratio is about 7:1 spam:nonspam, but in the past it's been as bad as 20:1. Both of those are very far off from equal

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
On Tue, Feb 07, 2006 at 05:47:36PM -0500, Matt Kettler wrote: Jim C. Nasby wrote: On Tue, Feb 07, 2006 at 05:02:25PM -0500, Matt Kettler wrote: Jim C. Nasby wrote: On Tue, Feb 07, 2006 at 04:40:40PM -0500, Matt Kettler wrote: I would also check to make sure you don't have a lot of spam

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
On Tue, Feb 07, 2006 at 06:17:20PM -0500, Matt Kettler wrote: Jim C. Nasby wrote: Are there any autolearn strings? Are they all autolearn=no? are there any decent number that are autolearn=failed or autolearn=disabled? grep -r autolearn caughtspam/ | grep -v 'Binary file' | sed -e 's

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
On Tue, Feb 07, 2006 at 05:36:56PM -0600, Jim C. Nasby wrote: On Tue, Feb 07, 2006 at 06:17:20PM -0500, Matt Kettler wrote: Jim C. Nasby wrote: Are there any autolearn strings? Are they all autolearn=no? are there any decent number that are autolearn=failed or autolearn=disabled

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
On Tue, Feb 07, 2006 at 06:47:06PM -0500, Matt Kettler wrote: Jim C. Nasby wrote: Are you using network tests? Without DNSBLs it's often hard to get enough header points to cause spam learning.. I believe so... grep loadplugin /usr/local/etc/mail/spamassassin/init.pre

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
On Tue, Feb 07, 2006 at 05:45:54PM -0600, mike wrote: Probably would work if you were running Linux. The problem isn't that it isn't working, the problem is that it's working too well. I guess maybe that's something you're not used to. :P -- Jim C. Nasby, Database Architect

Re: Spamassassin Learn

2006-02-07 Thread Jim C. Nasby
makes the most sense? -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what?

Re: Real-Time Stats Plugin Released

2005-12-28 Thread Jim C. Nasby
/5sl.html is how you would do this in a function in PostgreSQL, though there's no reason I can think of why you couldn't do that in perl instead (though it would perform much slower). -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy

Re: Real-Time Stats Plugin Released

2005-12-27 Thread Jim C. Nasby
-- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what?

Re: Real-Time Stats Plugin Released

2005-12-27 Thread Jim C. Nasby
input would be wonderful on that. I will poke around and see what I can come up with on my own. I could give you a fix if it was PostgreSQL, but I'm not really a MySQL person. Jim C. Nasby wrote: Neat plugin. I have two comments: I wouldn't store $TOTALS or the total column

Re: I'm afraid I might have to report this list as a spam source

2005-12-25 Thread Jim C. Nasby
to be extremely fast so that MTAs could use it while an email is inbound. That would allow (for example) hitting a number of RBLs and scoring them, instead of using a single RBL as a go/no-go decision. -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy

Re: I'm afraid I might have to report this list as a spam source

2005-12-22 Thread Jim C. Nasby
making it past that is a good indication of where SA could be improved afterall. -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow

Re: US winning war on spam ?!?!?!

2005-12-22 Thread Jim C. Nasby
are people who are sending enough spam to get the attention of big ISPs due to the amount of money it's costing them. -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today

Re: I'm afraid I might have to report this list as a spam source

2005-12-22 Thread Jim C. Nasby
of is this would have to perform better than a full-blown SA check does. If much of SA's time is spent doing things like BAYES checks then hopefully that wouldn't be an issue. -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net

Re: US winning war on spam ?!?!?!

2005-12-21 Thread Jim C. Nasby
'? Fortunately, thanks to SpamAssassin, the numbers hitting my users mailboxs are extremely low. My gratitude to all who have contributed to the development of SA. Ditto that. Bigtime. +1 -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some

Re: VACUUM FULL help

2005-12-14 Thread Jim C. Nasby
note, it would be good if SA itself issued periodic vacuums after X number of updates or deletes to tables, but I suspect adding that might be more trouble than it's worth. On 12/13/05, Jim C. Nasby [EMAIL PROTECTED] wrote: Why are you running vacuum full? There shouldn't be any need

Re: VACUUM FULL help

2005-12-13 Thread Jim C. Nasby
with a .cf file that disables Bayes and AWL while vacuuming and then restarts SA with the normal config. Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461