It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

Fisheye migration hssql (eval db) to mysql failing Edited

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?

 

1 comment

admins please close this topic, the problem is solved.

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Next-gen

Keyboard shortcuts have arrived for next-gen projects!

...ollected feedback from users around the lack of shortcuts, and we’re here to address that: In next-gen projects, I miss the keyboard shortcuts badly. This is particularly true on the Board, but also i...

121 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you