RE: 2.5.0.Beta10 available

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ] [ by messages with attachments ]

From: Murray S. Kucherawy <msk_at_cloudmark.com>
Date: Wed, 4 Jan 2012 11:52:46 -0800

> -----Original Message-----
> From: opendkim-dev-bounce_at_lists.opendkim.org [mailto:opendkim-dev-bounce_at_lists.opendkim.org] On Behalf Of Andreas Schulze
> Sent: Monday, January 02, 2012 7:26 AM
> To: Murray S. Kucherawy
> Cc: opendkim-dev_at_lists.opendkim.org
> Subject: Re: 2.5.0.Beta10 available
>
> > o Distribute reputation/mkdb.mysql.
> I have still errors in opendkim-genrates:
> pass #3 failed: Cannot add or update a child row: a foreign key
> constraint fails (`opendkim`.`aggregate`, CONSTRAINT `aggregate_ibfk_1`
> FOREIGN KEY (`domain`) REFERENCES `domains` (`id`) ON DELETE CASCADE)
>
> should I delete the database and recreate a new one?

No, the schemas need adjustment. Prior to the reputation stuff, the "domain" columns were always non-negative non-NULL non-zero values, but the reputation makes special cases of 0 and -1, so the types and constraints need to be relaxed.

In reputation/mkdb-rep.mysql, the "domain" columns are no longer unsigned, and the two foreign key constraints need to be removed. This will be fixed in Beta11.

Apologies for the oversight.

-MSK
Received on Wed Jan 04 2012 - 19:52:54 PST