]
-Original Message-
From: Matthew Yette
Sent: Tuesday, June 14, 2005 1:23 PM
To: Michael Parker
Cc: users@spamassassin.apache.org
Subject: RE: shared SQL DB
Great stuff. Thank you Michael, I'll let you know how it goes.
--
Matthew Yette
Senior Engineer - NOC/Operations
MA Polce Consulting
Matthew Yette wrote:
Hey Michael -
In the presentation you provided, I have a question re: the AWL and the
lastupdate table column. First off - it won't allow me to create the
column w/o a default value (since it's not null). All 0's are fine - but
when I tested it, each row inserted had that
@spamassassin.apache.org
Subject: Re: shared SQL DB
Matthew Yette wrote:
Hey Michael -
In the presentation you provided, I have a question re: the AWL and the
lastupdate table column. First off - it won't allow me to create the
column w/o a default value (since it's not null). All 0's are fine
[mailto:[EMAIL PROTECTED]
Sent: Thursday, June 23, 2005 12:28 PM
To: Matthew Yette
Cc: users@spamassassin.apache.org
Subject: Re: shared SQL DB
Matthew Yette wrote:
Hey Michael -
In the presentation you provided, I have a question re: the AWL and the
lastupdate table column. First off
Matthew Yette wrote:
Also Michael - how would one write a custom rule in the database? For
example, if I have this in a .cf file:
header MY_STOCK Subject =~ /[sS]t[0]ck/i
score MY_STOCK 5.0
In which I create a new rule called MY_STOCK, how would I put that into
the userpref table? Username of
)
AIM/Yahoo: MAPolceNOC
MSN: [EMAIL PROTECTED]
-Original Message-
From: Michael Parker [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 23, 2005 4:30 PM
To: Matthew Yette
Cc: users@spamassassin.apache.org
Subject: Re: shared SQL DB
Matthew Yette wrote:
Also Michael - how would one write
: MAPolceNOC
MSN: [EMAIL PROTECTED]
-Original Message-
From: Matthew Yette
Sent: Thursday, June 23, 2005 4:39 PM
To: Michael Parker
Cc: users@spamassassin.apache.org
Subject: RE: shared SQL DB
Thanks again!
Did that, kept the score directive in the database, but oddly enough, on
a test
]
-Original Message-
From: Matthew Yette
Sent: Thursday, June 23, 2005 4:41 PM
To: Michael Parker
Cc: users@spamassassin.apache.org
Subject: RE: shared SQL DB
And I get this in the spamd debug output for all the custom score rules
I put in...
debug: Score configuration option without actual scores
MSN: [EMAIL PROTECTED]
-Original Message-
From: Matthew Yette
Sent: Thursday, June 23, 2005 4:45 PM
To: Michael Parker
Cc: users@spamassassin.apache.org
Subject: RE: shared SQL DB
Solved it myself:
The preference column will contain score RULENAME and VALUE, not
SCORE, contains the score
Matthew Yette wrote:
So to clear up the custom SQL query that's in your presentation:
It says to use global and then domain level defaults:
SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ or
username = '@GLOBAL' or username = _DOMAIN_ order by username ASC
Does that mean, if
-
From: Matthew Yette
Sent: Tuesday, June 14, 2005 1:23 PM
To: Michael Parker
Cc: users@spamassassin.apache.org
Subject: RE: shared SQL DB
Great stuff. Thank you Michael, I'll let you know how it goes.
--
Matthew Yette
Senior Engineer - NOC/Operations
MA Polce Consulting, Inc.
[EMAIL PROTECTED]
315
[EMAIL PROTECTED] wrote:
Cami wrote:
running 2 spamd servers and want to share the BAYES DB between
them... so that one never gets too swayed and that both the servers
are contantly synced etc...
anybody currently running an SQL backend off multiple Spamd servers??
and if so care to part
On Wed, 2005-06-15 at 08:41 -0700, [EMAIL PROTECTED] wrote:
Arvinn Løkkebakken wrote:
[EMAIL PROTECTED] wrote:
I'm running two SpamAssassin servers with enough traffic that
file-based Bayes was becoming a bottleneck. I installed MySQL on
both and they each maintain their own independent
Ronan,
Care to explain how you've come to set this up? We run an ISP-type
solution w/ two identical qmail-scanner/SA/clamav servers set up for
load-balancing purposes (network edge device decides which server to use
at all times). We'd like to consolidate bayes db, auto-whitelist
settings, and
running 2 spamd servers and want to share the BAYES DB between
them... so that one never gets too swayed and that both the servers are
contantly synced etc...
anybody currently running an SQL backend off multiple Spamd servers??
and if so care to part with some knowledge???
SpamAssassin
Cami wrote:
running 2 spamd servers and want to share the BAYES DB between
them... so that one never gets too swayed and that both the servers
are contantly synced etc...
anybody currently running an SQL backend off multiple Spamd servers??
and if so care to part with some knowledge???
Cami wrote:
running 2 spamd servers and want to share the BAYES DB between
them... so that one never gets too swayed and that both the servers
are contantly synced etc...
anybody currently running an SQL backend off multiple Spamd servers??
and if so care to part with some knowledge???
[EMAIL PROTECTED] wrote:
Cami wrote:
running 2 spamd servers and want to share the BAYES DB between
them... so that one never gets too swayed and that both the servers
are contantly synced etc...
anybody currently running an SQL backend off multiple Spamd servers??
and if so care to part
Matthew Yette wrote:
Care to explain how you've come to set this up? We run an ISP-type
solution w/ two identical qmail-scanner/SA/clamav servers set up for
load-balancing purposes (network edge device decides which server to use
at all times). We'd like to consolidate bayes db, auto-whitelist
:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 1:17 PM
To: Matthew Yette
Cc: users@spamassassin.apache.org
Subject: Re: shared SQL DB
Matthew Yette wrote:
Care to explain how you've come to set this up? We run an ISP-type
solution w/ two identical qmail-scanner/SA/clamav servers set up for
load
Ronan McGlue wrote:
Hi all,
running 2 spamd servers and want to share the BAYES DB between them...
so that one never gets too swayed and that both the servers are
contantly synced etc...
anybody currently running an SQL backend off multiple Spamd servers??
and if so care to part with some
Hi All,
It's 5 SA actually :-D - and I've not noted any problems that didn't
come down to slight differences in config between SA servers, once
standardised they run much the same.
The single MySQL is working well, my only concern being that I still
haven't managed to eliminate a potential
-1644 (w)
315-356-0597 (f)
AIM/Yahoo: MAPolceNOC
MSN: [EMAIL PROTECTED]
-Original Message-
From: Nigel Frankcom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 1:52 PM
To: JamesDR
Cc: users@spamassassin.apache.org
Subject: Re: Re: shared SQL DB
Hi All,
It's 5 SA actually :-D
Matthew Yette wrote:
I would think this would just involve modifying the db connection
functions inside the SA code to verify the primary connection is
established, and if not , roll onto a second (backup) server.
There are several perl DBD:: modules that can help facilitate
]
Sent: Tuesday, June 14, 2005 1:52 PM
To: JamesDR
Cc: users@spamassassin.apache.org
Subject: Re: Re: shared SQL DB
Hi All,
It's 5 SA actually :-D - and I've not noted any problems that didn't
come down to slight differences in config between SA servers, once
standardised they run much the same
25 matches
Mail list logo
