JDBC Connection to MYSQL

Question

Dear all,

After reading mutli ticket on that seemlike very same issue, I could not fix mine ...

* OS : CentOS 8 (fully new and updated)
* DB : MySQL 8 (fully new and updated)
* JDBC Connector : 8.0.22
* Jira : atlassian-servicedesk-4.13.1-x64

Issue : Can connect my Jira fresh install to my mysql DB.

Error : You have specified a database that is not empty, please specify an empty database. If you want to upgrade an existing installation, please follow these instructions instead.

Fix attempt :

Use the version 5.7 of the connector : mysql-connector-java-5.1.49 (I tried to rename package/restart serive/..) > when I use this version the error switch to : Could not find driver with class name: com.mysql.cj.jdbc.Driver

Drop & recreate the DB (which was and is empty no table)

Any idea how to fix this and IF there is a fix maybe update the tutorial :)

Thanks a lot

Marc

Daniel Ebers · Answer

There is a Suggestion open with Atlassian to support PostgreSQL 13. Feel free to watch & vote the issue to get notified when things change in this matter:

https://jira.atlassian.com/browse/JRASERVER-71709

Marc Hendryckx · Answer

@Daniel Ebers

On last question on that matter, will the version 13 of psql works with the last version of jira (on the long run i mean since it's already working quite well beside a warning telling me that the version is not supported), since the version 11 now quite old ... i wanted to get rid of that :/

Thanks

Marc Hendryckx · Answer

ok ok thanks for your return.

I've give up on MySql, I'm now using Postgresql which is working as expected "out of the box".

If someone ever knows the fix for MySQL it could be interesting for someone in my case but so far Jira doesn't support MySQL 8.