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]
Would like an answer as well. Reconstituting our Jira environment with newest versions, including Connector/J 8.0 and getting the exact same error. Everything else appears to work properly.
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.
Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...
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