Hello,
my old Jira installation was on Debian 9 with Mysql 8.0.25 and all worked fine.
I exported the DB with dump to SQL file, installed a fresh Debian 11 with Mysql 8.0.29 (8.0.25 not available on Debian 11) and imported it in the new database created using this help https://confluence.atlassian.com/jiracore/connecting-jira-to-mysql-8-0-1018272102.html
Jira start but i have the error "
The table collation: 'utf8_bin' is unsupported by Jira. The Database collation: 'utf8mb4_bin' is supported by Jira." but the database on the new user is correctly configured.
I checked with this command :
mysql> use jiradb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb4 | utf8mb4_bin |
+--------------------------+----------------------+
1 row in set (0.00 sec)
What's wrong for you ?
I checked the same on the old server :
Database changed
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb3 | utf8_bin |
+--------------------------+----------------------+
1 row in set (0.00 sec)
It's different but no error was showed..
Jira Service Management 4.20.2
Jira Software 8.20.2
Thank you for help..
Julian
I keep getting this one wrong myself.
There are three collation settings you need to check, not just the two you've given us here.
I think you'll get something like the below, where you'll find the bold one is wrong!
mysql> select @@character_set_database, @@collation_database, @@character_set_server ;
+--------------------------+----------------------+------------------------+
| @@character_set_database | @@collation_database | @@character_set_server |
+--------------------------+----------------------+------------------------+
| utf8mb4 | utf8mb4_bin | utf8 |
+--------------------------+----------------------+------------------------+
If that's the case, you've missed one of the settings mentioned in the database setup doc you've linked to.
Hello Nic!
Here the result :
mysql> use jiradb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select @@character_set_database, @@collation_database, @@character_set_server ;
+--------------------------+----------------------+------------------------+
| @@character_set_database | @@collation_database | @@character_set_server |
+--------------------------+----------------------+------------------------+
| utf8mb4 | utf8mb4_bin | utf8mb4 |
+--------------------------+----------------------+------------------------+
1 row in set (0.00 sec)
Is it correct?
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.