Fisheye migration hssql (eval db) to mysql failing

[simon adriaanse]

We are trying to migrate fisheye to a mysql db, but it fails at restoring the active object tables.

We are using version:

• MySQL 5.7.22
• mysql-connector-java-5.1.47-bin.jar
• Ubuntu 18.04
• Fisheye 4.7.0
• Database Schema Version 107

Created the DB with:

mysql> SET GLOBAL default_storage_engine = 'InnoDB';
mysql> CREATE DATABASE fisheye CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

mysql> GRANT ALL PRIVILEGES ON fisheye.* TO 'fisheyeuser'@'localhost' IDENTIFIED BY 'password';
mysql> FLUSH PRIVILEGES;

MySQL config:

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_bin

Connection parameters in fisheye:

useUnicode=true
characterEncoding=UTF8MB4
connectionCollation=utf8mb4_bin

When we start the migration, following the tutorial, everything looks okay.
Test connection: no problem. Backing up AO tables no problem. dropping some tables, then settings some constraints and finally restoring AO tables and then fails.

We have tried:

• instead of UTF8MB4 => utf8 with utf8_bin collate
  • which results in fisheye asking for UTF8MB4, in addition to the failure.
• different versions of mysql connector (newer)
  • same failure

Everything seems to me like as described in the tutorials/manuals.

Do any of you have an idea of what the problem might be?

[simon adriaanse]

admins please close this topic, the problem is solved.