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.

_______________________________________________
Kea-users mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users

Reply via email to