Much better procmail alternative (was Re: Verifying .procmailrc settings to delete high scoring spam messages)

2013-04-08 Thread David F. Skoll
On Mon, 8 Apr 2013 16:02:27 -0600 Bob Proulx wrote: > Karsten Bräckelmann wrote: > > Unfortunately, no. While procmail implements some flavor of > > "extended" Regular Expressions, there are still quite some > > differences to other regex engines, I got sufficiently fed up with procmail that I

Re: master/slave sql backend for spamassassin

2013-04-08 Thread Alex
Hi, My hope is to not reinvent the wheel here, but at the moment the sql backend is the single point of failure. >>> >>> >>> Look into MariaDB/Galera cluster as a mysql drop in replacement. >>> >>> http://blog.mariadb.org/mariadb-galera-cluster-5-5-29-stable-ga-released/ >> >> I'm also v

Re: Verifying .procmailrc settings to delete high scoring spam messages

2013-04-08 Thread Bob Proulx
Karsten Bräckelmann wrote: > Bob Proulx wrote: > > * ^X-Spam-Level: \*{10} > > Unfortunately, no. While procmail implements some flavor of "extended" > Regular Expressions, there are still quite some differences to other > regex engines, like egrep's or PCRE. Most notably, the repetition > opera

Re: Verifying .procmailrc settings to delete high scoring spam messages

2013-04-08 Thread Karsten Bräckelmann
On Sun, 2013-04-07 at 21:44 -0600, Bob Proulx wrote: [ Bunch of good advise snipped. ] > :0 > * ^X-Spam-Level: \*\*\*\*\*\*\*\*\*\* > devnull/ > > Since procmail uses Extended Regular Expressions there is one more > optimization I would make. I wouldn't list out every star. It gets > har

Re: Dev-nulling is a bad idea [Was: Verifying .procmailrc settings to delete high scoring spam messages]

2013-04-08 Thread Bowie Bailey
On 4/8/2013 1:06 PM, Walter Hurry wrote: On Mon, 08 Apr 2013 10:52:11 +0200, Andrzej A. Filip wrote: I would suggest redirecting such messages to another folder/maildir. The folder should auto-purge old messages (e.g. older than 30 days). Shit does happen. I remember at least one case in which

Re: Dev-nulling is a bad idea [Was: Verifying .procmailrc settings to delete high scoring spam messages]

2013-04-08 Thread Walter Hurry
On Mon, 08 Apr 2013 10:52:11 +0200, Andrzej A. Filip wrote: > I would suggest redirecting such messages to another folder/maildir. > The folder should auto-purge old messages (e.g. older than 30 days). > Shit does happen. I remember at least one case in which mailing list > (ham) thread about spam

Re: master/slave sql backend for spamassassin

2013-04-08 Thread Axb
On 04/08/2013 05:21 PM, Alex wrote: Hi, On Mon, Apr 8, 2013 at 8:39 AM, Axb wrote: On 04/08/2013 02:32 PM, Per-Erik Persson wrote: Both for performance and stability reasons I need to setup multiple sqlbackends for spamassassin. I have found some bits about the perl failover module, postgres

Re: master/slave sql backend for spamassassin

2013-04-08 Thread Alex
Hi, On Mon, Apr 8, 2013 at 8:39 AM, Axb wrote: > On 04/08/2013 02:32 PM, Per-Erik Persson wrote: >> >> Both for performance and stability reasons I need to setup multiple >> sqlbackends for spamassassin. >> I have found some bits about the perl failover module, postgres >> clustering and patches

Re: master/slave sql backend for spamassassin

2013-04-08 Thread Axb
On 04/08/2013 02:32 PM, Per-Erik Persson wrote: Both for performance and stability reasons I need to setup multiple sqlbackends for spamassassin. I have found some bits about the perl failover module, postgres clustering and patches to spamassassin. Does anyone have a working solution to share w

master/slave sql backend for spamassassin

2013-04-08 Thread Per-Erik Persson
Both for performance and stability reasons I need to setup multiple sqlbackends for spamassassin. I have found some bits about the perl failover module, postgres clustering and patches to spamassassin. Does anyone have a working solution to share with multiple spamassassin servers accessing multip

Dev-nulling is a bad idea [Was: Verifying .procmailrc settings to delete high scoring spam messages]

2013-04-08 Thread Andrzej A. Filip
On 04/08/2013 05:12 AM, Thomas Cameron wrote: > [...] > I want to delete any spam that scores over 10, though. I believe that I > should insert a new rule between the first and second, and I want to use > the X-Spam-Level header. But since it uses asterisks, which are > interpreted as regex wildcar