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 me
hoo: MAPolceNOC
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
PROTECTED]
-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 act
: 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, it
)
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 writ
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? User
arker [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
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 - it won't allow me to create the
>column w/o a default value (since it'
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 th
EMAIL PROTECTED]
-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
TECTED]
-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 Con
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 i
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 database.
>>
>>
> What's the point of running independe
[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
Ronan,
Yes it can/has been done and it works flawlessly. We currently have 4 front
end SA processing machines that tie into a single MySQL cluster (running HA
with DRBD mirroring for failover).
Basically you just need to point your SA's on each machine to the MySQL
database. Here is mine:
aut
MAIL 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 :
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
failover/rep
-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
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 singl
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
ailto:[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 se
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-whitelis
[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 i
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 knowle
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 knowl
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 alre
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 lo
27 matches
Mail list logo
