RE: 2.5.0-Beta9 available

From: Murray S. Kucherawy <msk_at_cloudmark.com>
Date: Wed, 28 Dec 2011 20:40:49 -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: Tuesday, December 27, 2011 1:43 PM
> To: Murray S. Kucherawy
> Cc: opendkim-dev_at_lists.opendkim.org
> Subject: Re: 2.5.0-Beta9 available
>
> OK, I updated my sql tables and now opendkim-ganrates throws new
> errors:
>
> 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)
>
> the userid used to access mysql has no full access. May that be the
> reason ?

There are several reasons you can get this error. There's a MySQL page that lists them. Among them:

1) are both "domains" and "aggregate" of type InnoDB?

2) are the definitions of "domains.id" and "aggregate.domain" the same?

You might have to change the "aggregate.domain" definition to be "int unsigned not null" in reputation/mkdb-rep.mysql to eliminate the second problem.

If that still doesn't fix it, let me know and I'll look at the other cases.

-MSK
Received on Thu Dec 29 2011 - 04:40:50 PST