I have a clean Jira install, in the setup wizard when trying to select a custom database,
I always get this error
Error connecting to database
Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near '=InnoDB'.
I figured, this might be some front end input parsing error, so I tried to use the config.sh file. This reported the same error
I found this thread aswell https://community.atlassian.com/t5/Jira-questions/Setting-up-Mysql-DB-giving-a-connection-error/qaq-p/267550
I tried editing the dbconf.xml file, but that didn't feel like the way to go. Got timezone errors there.
Anyway, I know for a fact the database is working and is available. Besides, the error message seems like a query syntax error?
I don't know what to do or try from here
Hi there, Found this while looking into some other database issues.
It appears Oracle recently released the 8.0 version of the connector/j
This seems to cause some issues during install and changes some things in the url string.
You can download the 5.1 version from oracle https://dev.mysql.com/downloads/connector/j/5.1.html
Atlassian's documentation on connecting Jira to MySQL does recommend to use the 5.1.x version of that jdbc driver.
To copy the MySQL JDBC driver to your application server:
- Get the MySQL driver:
- If you are installing JIRA, download the recommended MySQL driver JDBC Connector/J 5.1.
You can download either the
.zipfile by selecting the 'Platform Independent' option. Extract the jar for the driver (e.g.
mysql-connector-java-5.x.x-bin.jar) from the archive.
Atlassian has not tested Jira against this newer Connector/J 8.0 yet, I would not expect it to work until the time when Jira begins to support MySQL 8, which has not happened yet.
[Edit: updated link to direct to 5.1]
I'll put in my 2c that when you start using -x-x nomenclature, it wasn't clear that v5.1 is correct. This is because you should be doing 5-1-xx rather than 5-x-x. Also, you should go out of your way to say that despite the current version being 8, we're asking you to go all the way back to 5. Cheers.
The roof is on FIRE… network outages, broken processes, upset clients and employees. Each day seemed to bring more and more issues. Incidents were communicated via email, messengers (skype or teams) ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events