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)
Everything seems to me like as described in the tutorials/manuals.
Do any of you have an idea of what the problem might be?
