Re: Postfix/SpamAssassin Integration

2006-04-07 Thread James Keating
Michael Monnerie wrote: I just found this: http://wiki.apache.org/spamassassin/IntegratePosfixViaSpampd mfg zmi I have already tried this script and it was very close to what I was wanting, but it does not connect to spamd in any manner. It actually uses the perl libraries to interact wit

Re: Postfix/SpamAssassin Integration

2006-04-07 Thread James Keating
Michael Monnerie wrote: On Freitag, 7. April 2006 14:09 James Keating wrote: Any other thoughts? I just found this: http://wiki.apache.org/spamassassin/IntegratePosfixViaSpampd mfg zmi I have already tried this script and it was very close to what I was wanting, but it does not connect to

Re: Postfix/SpamAssassin Integration

2006-04-07 Thread James Keating
Gary W. Smith wrote: In master.cf we have: smtp inet n - n - - smtpd -o content_filter=filter: filterunix - n n - - pipe flags=Rq user=filter argv=/etc/mail/spamassassin/filter.sh -f ${sender} -- ${recipient} filter.sh: sp

RE: Postfix/SpamAssassin Integration

2006-04-06 Thread James Keating
Quoting "Gary W. Smith" <[EMAIL PROTECTED]>: James, Timeout is 600 seconds. If spamd doesn't have respond in that amount of time them there is something else is wrong. I suppose that if all of the spamd threads are clogged then you might find a waiting list but 600 seconds is a lifetime. Th

Re: Postfix/SpamAssassin Integration

2006-04-05 Thread James Keating
[EMAIL PROTECTED] wrote: Is this a high volume mail server? Yes it is rather high volume server, I don't have any estimates on # of messages. Something like this should do the trick (this is off the cuff, and just a reference, you will have to modify for your exact setup). master.cf spam

Postfix/SpamAssassin Integration

2006-04-05 Thread James Keating
Dear Sirs/Madams, I have been attempting to properly integrate SpamAssassin into Postfix and have not found the solution that I am looking for. Currently I have Spamassassin running as a daemon (spamd, version 3.1.0a-2) which uses MySQL to store Bayes, AWL, user preferences and stats. Postf

Re: Status of StatsPlugin?

2006-03-30 Thread James Keating
Daniel J. Cody wrote: Hi All, Does anyone know if the StatsPlugin ( http://wiki.apache.org/spamassassin/StatsPlugin ) is being actively developed anymore? I have made a few updates to it in the past, but nothing super recent. The link to James' website ( http://www.okeating.net/blosxom.c

Re: Real-Time Stats Plugin Released

2006-01-08 Thread James Keating
wrote: James Keating <[EMAIL PROTECTED]> writes: Morning All, I have released a real-time stats collection plugin (http://wiki.apache.org/spamassassin/StatsPlugin)for SpamAssassin. Actually James, now that you have that atomic insert/update in there, you can get rid of $user_

Re: Real-Time Stats Plugin Released - UPDATE RELEASED

2006-01-02 Thread James Keating
ues or problems. Thanks for everyone's input, more is always appreciated. Thanks, James Jim C. Nasby wrote: On Wed, Dec 28, 2005 at 02:19:51AM -0600, Chris Thielen wrote: James Keating wrote: Well the simplest fix is the one that I did not implement in the first place, using

Re: Real-Time Stats Plugin Released - UPDATE RELEASED

2005-12-30 Thread James Keating
in or http://www.okeating.net/blosxom.cgi/2005/12/31#statsplugin-update Let me know if you see any other issues or problems. Thanks for everyone's input, more is always appreciated. Thanks, James Jim C. Nasby wrote: On Wed, Dec 28, 2005 at 02:19:51AM -0600, Chris Thielen wrote: James Keatin

Re: Real-Time Stats Plugin Released

2005-12-27 Thread James Keating
Gary V wrote: Well the simplest fix is the one that I did not implement in the first place, using "ON DUPLICATE KEY". However, I did not implement that because of its only being in version 4.1 of MySQL and I still use Debian stable for most production machines, which runs 4.0.x. Anyway, I wi

Re: Real-Time Stats Plugin Released

2005-12-27 Thread James Keating
poke at it some more. - James Jim C. Nasby wrote: On Tue, Dec 27, 2005 at 09:33:11PM -0500, James Keating wrote: Indeed. My thinking behind storing both system totals ($TOTALS) and user totals in the database was for easy error checking. Each day you can quickly/easily run through the databas

Re: Real-Time Stats Plugin Released

2005-12-27 Thread James Keating
with duplicated entries. I think MySQL has a merge command that would be more appropriate. Also, it appears that this would work on PostgreSQL with minimal modifications. If anyone's interested in that I'd be happy to help. On Mon, Dec 26, 2005 at 11:03:45AM -0500, James Keating wrote

Real-Time Stats Plugin Released

2005-12-26 Thread James Keating
Morning All, I have released a real-time stats collection plugin (http://wiki.apache.org/spamassassin/StatsPlugin)for SpamAssassin. The plugin collects data into a MySQL DB based on the date and username that SpamAssassin was invoked with. This creates a single row for each user, each day.