The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can't reach Jira after changing the database config

Karim Ennassiri
October 9, 2018

I just changed the configuration of the Jira database on my server from h2 to MySQL but I cannot access it anymore. I am directly redirected to /secure/errors.jsp. It was not the case before I change the configuration.


Any ideas?

 

Thanks

4 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Karim Ennassiri
October 9, 2018

Jira database is empty so i dont' care to migrate data. I just want that Jira use MySQL. 

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
October 9, 2018

What errors are showing on the error report?

How did you migrate the data from h2 to mysql?

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
October 9, 2018

You need to clear out the home directory of all the data that is associated with what you had in the h2 database as well.

Your best option is probably to stop Jira, move all the data out of the jira-home directory to somewhere safe and then run Jira again.  It should take you through setup where you can connect to your new empty database

0 votes
Karim Ennassiri
October 9, 2018

Capture du 2018-10-09 16-25-46.png

0 votes
Brant Schroeder
Community Champion
October 9, 2018

You will need to follow the steps here https://confluence.atlassian.com/adminjiraserver072/switching-databases-828787577.html for changing your DB.  Scroll down to "Migrating JIRA's data to a different type of database server" and follow those steps.

Comments for this post are closed

Community moderators have prevented the ability to post new answers.