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

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 Leaders.
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 Leaders.
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.

Suggest an answer

Log in or Sign up to answer