configure remote mysql server, Jira and Confluence, after first-time installation

[Jay Cobb]

1) installed jira 7.10 (and Confluence 6.9.1), configured to use default local database.

2) installed MySQL 5.7 on a remote server, installed mysql-connector into Jira's (and Conluence) WEB-INF/lib

3) On remote machine, I configured MySQL server and database "jira" and "confluence" to conform to confluence database and server requirements.

Where in Admin do I point Jira (and Confluence) to the remote hosted databases in MySQL?

I'm going around in circles with "connecting JIRA applications to a database" Atlassian support pages.

I need to see a first-time setup page, hopefully to see where to input my remote MySQL URL and credentials.

Tried:

- uninstalling Jira (and Confluence)

- reinstalling both

[Andy Heinzer · Accepted solution]

Since you configured Jira to use the local database, you are going to need to first stop the application, and then edit/remove the $JIRAHOME/dbconfig.xml file.

This is the file for Jira that dictates what database settings to use.   If you remove this file and then start Jira again, it will go into the setup wizard once more.  Alternatively you can edit that dbconfig.xml file manually, OR you can use the JIRA config tool to achieve the same.

Confluence uses the same concept, but the filename is different <confluence_home>/confluence.cfg.xml controls the database connection parameters for Confluence.

Also, Jira's path for the JDBC driver installation is not WEB-INF/lib, but rather $JIRAINSTALL/lib/

Another thing to note, both Jira and Confluence current versions need to use the MySQL 5.1.x drivers.   Recently MySQL started releasing a 8.0 version that has not yet been tested again Jira or Confluence.   Not sure which version you are using, but I have found this is a commonly seen problem recently. 

[Jay Cobb]

Thank you, Andrew. I'm able to connect both Jira and Confluence to my DB.

[Andy Heinzer]

Cool, glad to hear that helped :D