I'm using SpamAssassin 3.000000. You're right. I was looking at the wrong table. Sorry about that.
describe awl; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | username | varchar(100) | | PRI | | | | email | varchar(200) | | PRI | | | | ip | varchar(10) | | PRI | | | | count | int(11) | YES | | 0 | | | totscore | float | YES | | 0 | | +----------+--------------+------+-----+---------+-------+ -- Mark Hennessy -----Original Message----- From: Michael Parker [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 8:53 PM To: Mark Hennessy Cc: [EMAIL PROTECTED] Subject: Re: autowhitelist using a db in a MySQL replication ring? On Tue, Aug 17, 2004 at 10:28:34AM -0400, Mark Hennessy wrote: > Has anyone set up a spamassassin autowhitelist db using three or more MySQL > DBMS configured as a replication ring? The main obstacle AFAIK seems to be > that a unique record ID is kept that uses auto_increment to update, and if > any member of that ring gets disconnected somehow that there would be > conflicting records generated. Are you talking about autowhitelist or bayes? Autowhitelist under SQL doesn't use an auto_increment column. Michael
