Failed to created mysql database using 1.9.11 script and mysql 5.7
Failed to created mysql database using 1.9.11 script and mysql 5.7
9:59:11.865 [PERF] 2021-08-30 07:46:43,127 >>>> Remote executing kea-admin db-init mysql -u keatest -p keatest -n keatest on device: 149.20.57.246 kea
09:59:12.440 Checking if there is a database initialized already...
09:59:12.440 mysql: [Warning] Using a password on the command line interface can be insecure.
09:59:12.440 Verifying create permissions for keatest
09:59:12.440 mysql: [Warning] Using a password on the command line interface can be insecure.
09:59:12.440 MySQL Version is: 5.7.35-0ubuntu0.18.04.1
09:59:12.440 mysql: [Warning] Using a password on the command line interface can be insecure.
09:59:12.440 mysql: [Warning] Using a password on the command line interface can be insecure.
09:59:12.440 mysql: [Warning] Using a password on the command line interface can be insecure.
09:59:12.440 mysql: [Warning] Using a password on the command line interface can be insecure.
09:59:12.440 Initializing database using script /usr/share/kea/scripts/mysql/dhcpdb_create.mysql
09:59:12.440 mysql: [Warning] Using a password on the command line interface can be insecure.
09:59:27.380 ERROR 1064 (42000) at line 4021: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT fk_lease4_state' at line 1
jenkins@perf-kea-1:~$ mysql --version
mysql Ver 14.14 Distrib 5.7.35, for Linux (x86_64) using EditLine wrapper