Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Migrate H2 Database to mysql 5.7

Hello,

i have a problem at the migration the integrated database to an mysql- database.

I configured the my.ini on this way:

Switching databases | Administering Jira applications Data Center and Server 8.18 | Atlassian Documentation

But if i start the configuration i get an error:
This MySQL instance is not configured correctly. Please follow the instructions for setting up MySQL 5.7+.

I searched the last 3 days at the community but i didnt found a way to handle the problem.

Best regards

Markus

1 answer

0 votes

That error message does really mean that you have something not quite right in the MySQL settings.  Have you been following https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html ?

Hi,

yes, that was the way i do.

Ok, so apart from hostnames and login credentials, what are you doing differently to what the doc says?

Also, does the error message contain any more detail?  If "MySQL instance is not configured correctly" is not telling you any more detail, then you have done something very different to the doc and Jira can't see what it is.  But usually, it will tell you what to look at.  

It is probably worth a look at the Jira application log too - even if the front-end error contains no detail, when Jira starts up and tries to connect to the database, it does some checks and reads the responses, echoing error lines into the log.  That might tell you what you are missing.

I found a way to deal with the problem. But it was very crazy. I have installed and configured a MySQL server 5.7.9.

When configuring Jira, I permanently chose my own database server in version 5.7 and got the error "This MySQL instance is not configured correctly. Please follow the instructions to set up MySQL 5.7+".
Finally, I chose the MySQL 5.6 option and it works perfectly.

Crazy way, but it works

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

91 views 1 10
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