Re: The Future of Email is SQL

2006-06-10 Thread Marc Perkel
Jim C. Nasby wrote: On Fri, Jun 09, 2006 at 06:16:15PM -0400, Rob McEwen wrote: MS Exchange... one big Database Exactly... And that is one reason why I wouldn't touch this SQL idea with a 10 foot pole.. the fact that Exchange works this

Re: The Future of Email is SQL

2006-06-10 Thread Marc Perkel
Steve Thomas wrote: While this is quite an interesting topic, I have to ask why it's on the spamassassin list. Message stores aren't spamassassin specific and this is already a pretty high-volume list. Does this discussion really belong here? St- The reason I posted it here as well as

Re: The Future of Email is SQL

2006-06-10 Thread Marc Perkel
Gary W. Smith wrote: It's getting there, albeit slowly. I think that if you rule out any up and coming application but it's just not there yet we wouldn't have an opensource community... We have a variety of reasons for using MySQL, most of them aren't good ones though but it's something

Problems after upgrade to SA 3.1.3: PerMsgStatus.pm can't locate object methods check_for_spf_neutral....

2006-06-10 Thread Thomas Schlosser
Hi,I have updated my SA installation yesterday. Most but not all seems to run well.In my mail.log I constantly find these errors all referring on some methods called from PerMsgStatus.pm:snip Jun 10 12:21:54 homesrv spamd[6367]: Failed to run __ENV_AND_HDR_FROM_MATCH SpamAssassin test,

Re: Problems after upgrade to SA 3.1.3: PerMsgStatus.pm can't locate object methods check_for_spf_neutral....

2006-06-10 Thread Radoslaw Zielinski
Thomas Schlosser [EMAIL PROTECTED] [10-06-2006 15:38]: [...] I updated it via perl -MCPAN - e shell - force install Mail::SpamAssassin The output was too long to have a chance to see if any problems have been reportet. New SA should have been installed somewhere around /usr/local (if your perl

Re: Problems after upgrade to SA 3.1.3: PerMsgStatus.pm can't locate object methods check_for_spf_neutral....

2006-06-10 Thread Thomas Schlosser
Thanks for the immediate answer!It seems that the old SA was under /usr/lib/perl5/vendor_perl/5.8.6/Mail/SpamAssassin/while the new one under /usr/lib/perl5/site_perl/5.8.6/Mail/SpamAssassin/rpm reported two packages spamassassin and perl-spamassassin. I have deinstalled these using YAST (rpm

Re: The Future of Email is SQL

2006-06-10 Thread NM Public
Sur 2006-06-09, Marc Perkel skribis: Perhaps the headers and other information that you would index be kept in the database and the body of the message stored somewhere else, perhaps even as files. It seems that this is what Zimbra does. Check out my blog post here: For IMAP, SQL just

SA 3.1.3 Binary RPMs for FC4?

2006-06-10 Thread John D. Hardin
All: My hosted mail server is Fedora Core 4, and I'd rather not put a development environment on it if I can avoid doing so. Is anybody hosting binary RPMs for SA 3.1.x (ideally 3.1.3) for FC4? Thanks. -- John Hardin KA7OHZICQ#15735746http://www.impsec.org/~jhardin/ [EMAIL PROTECTED]

Re: The Future of Email is SQL

2006-06-10 Thread Marc Perkel
NM Public wrote: Sur 2006-06-09, Marc Perkel skribis: Perhaps the headers and other information that you would index be kept in the database and the body of the message stored somewhere else, perhaps even as files. It seems that this is what Zimbra does. Check out my blog post here:

Re: The Future of Email is SQL

2006-06-10 Thread qqqq
I would defer to the smart people to figure out the details. However I do wonder if the actual body content of the message would be best stored in a file and the SQL used to store anything and everything you would want to index. That would keep the SQL file size down if that's an issue.

Re: SA 3.1.3 Binary RPMs for FC4?

2006-06-10 Thread Craig McLean
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John D. Hardin wrote: All: My hosted mail server is Fedora Core 4, and I'd rather not put a development environment on it if I can avoid doing so. Is anybody hosting binary RPMs for SA 3.1.x (ideally 3.1.3) for FC4? Don't know about 3.1.3,

Re: The Future of Email is SQL

2006-06-10 Thread Jay Plesset
"fast enough" is a value judgement. Fast enough may be ok, if you have a few hundred or even a few thousand users, saving small mailboxes. In a large scale system, where you have a million users, each of which has thousands of messages, I doubt any current database, SQL or other will have

Labeling Bug?

2006-06-10 Thread David Goldsmith
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 A message with this set of SA headers just made it through to my mailbox. X-Spam-Flag: YES X-Spam-Checker-Version: SpamAssassin 3.1.3 (2006-06-01) on iceman12.giac.net X-Spam-Level: ** X-Spam-Status: Yes, score=7.0 required=6.8

Re: Labeling Bug?

2006-06-10 Thread Daryl C. W. O'Shea
On 6/10/2006 8:07 PM, David Goldsmith wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 A message with this set of SA headers just made it through to my mailbox. X-Spam-Flag: YES X-Spam-Checker-Version: SpamAssassin 3.1.3 (2006-06-01) on iceman12.giac.net X-Spam-Level: **

Re: The Future of Email is SQL

2006-06-10 Thread jdow
From: NM Public [EMAIL PROTECTED] Sur 2006-06-09, Marc Perkel skribis: Perhaps the headers and other information that you would index be kept in the database and the body of the message stored somewhere else, perhaps even as files. It seems that this is what Zimbra does. Check out my blog

Re: SA 3.1.3 Binary RPMs for FC4?

2006-06-10 Thread jdow
From: Craig McLean [EMAIL PROTECTED] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John D. Hardin wrote: All: My hosted mail server is Fedora Core 4, and I'd rather not put a development environment on it if I can avoid doing so. Is anybody hosting binary RPMs for SA 3.1.x (ideally 3.1.3) for

Re: The Future of Email is SQL

2006-06-10 Thread Jim C. Nasby
On Sat, Jun 10, 2006 at 01:23:35PM -0600, wrote: I would defer to the smart people to figure out the details. However I do wonder if the actual body content of the message would be best stored in a file and the SQL used to store anything and everything you would want to index. That

Re: The Future of Email is SQL

2006-06-10 Thread kbaker
Jim C. Nasby wrote: On Sat, Jun 10, 2006 at 01:23:35PM -0600, wrote: I would defer to the smart people to figure out the details. However I do wonder if the actual body content of the message would be best stored in a file and the SQL used to store anything and everything you would want