[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.html>


More information about the Kea-users mailing list