[Kea-users] Kea 1.6 with MySQL Cluster
Fernando Ruza Rodriguez
fernandor at sescam.jccm.es
Fri Apr 26 13:09:34 UTC 2019
Sorry, I've installed:
mysql-cluster-community-server-7.6.9-1.el7.x86_64
Regards, Fernando.
-----Mensaje original-----
De: Philippe Havard <cdrole at gmail.com>
Para: Fernando Ruza Rodriguez <fernandor at sescam.jccm.es>
Cc: Kea-users at lists.isc.org <Kea-users at lists.isc.org>
Asunto: Re: [Kea-users] Kea 1.6 with MySQL Cluster
Fecha: Fri, 26 Apr 2019 09:04:27 -0400
Not all version of ndb support foreign key. Wich version are you using?
On Friday, April 26, 2019, Fernando Ruza Rodriguez
<fernandor at sescam.jccm.es> wrote:
Hi, I'm trying to setup kea 1.6 with MySQL NDB Cluster backend.
Has someone experienced with them?
I have changed the "ENGINE" in all create tables statements with
ENGINE=NDBCLUSTER in the script dhcpdb_create.mysql however when
I run it I get the following errors, I think, when created the
tables keadhcp.dhcp4_pool and keadhcp.dhcp6_pool for the foreign
keys they have:
...
ERROR 1215 (HY000): Cannot add foreign key constraint
Query OK, 0 rows affected (0,46 sec)
Query OK, 0 rows affected (1,50 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (1,77 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0,48 sec)
ERROR 1146 (42S02): Table 'keadhcp.dhcp4_pool' doesn't exist
Query OK, 0 rows affected (0,48 sec)
...
ERROR 1215 (HY000): Cannot add foreign key constraint
ERROR 1215 (HY000): Cannot add foreign key constraint
Query OK, 0 rows affected (1,65 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (1,36 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0,57 sec)
ERROR 1146 (42S02): Table 'keadhcp.dhcp6_pool' doesn't exist
Query OK, 1 row affected (0,03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Thanks in advanced for any help.
Regards, Fernando.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190426/51c3e604/attachment.htm>
More information about the Kea-users
mailing list