I am working on migrating my database from Postgres to MySQL. I am at the point where I am re-installing Confluence and I get to the step where I choose the database type (MySQL). It warns me that I need the ODBC driver. The instructions indicate that this will happen and that I can ignore the error. The problem is that I cannot bypass or skip the error. Clicking next goes nowhere. I have confirmed I have the file in the proper directory (/opt/atlassian/confluence-mysql/confluence/WEB-INF/lib/mysql-connector-java-5.1.44-bin.jar).
I was following the directions here, Step 8.3 is where I am having the issue. here: https://confluence.atlassian.com/conf64/database-setup-for-mysql-936511512.html
I understand you have the mysql JDBC driver file in the <Confluence installation> /confluence/WEB-INF/lib folder but the setup wizard appears to hang when you click next to set up the database.
Is it possible that the database tables are being set up when the installation appears to be going nowhere? That step can take a few minutes to complete. Does the browser say "waiting for server" after you click Next?
Please see Confluence does not start due to Spring Application context has not been set. It's a different error but it has some good guidelines for installing Confluence:
Do not run Confluence as root, and ensure that the user running Confluence has full read and write access to the home folder. This can be set by running chmod -R with the appropriate permissions, to apply them recursively to each sub folder. An example of the right permissions would be:
chown -R confluence.confluence <confluence-install-folder>
chown -R confluence.confluence <confluence-home-folder>
chmod -R u=rwx,go-rwx <confluence-install-folder>
chmod -R u=rwx,go-rwx <confluence-home-folder>
The user confluence is only a suggestion. You can change it for another username.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs