nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot connect MySQL database to Jira

catalysm

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

Accepted answers

Alex Johnson

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

All comments

Aleks Buterman

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.

Alex Johnson

Andy Heinzer

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 .tar.gz or the<span> </span>.zip file 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]

catalysm

This fixed the issue! Thanks alot

@Andy Heinzer That link takes me to the 8.0 download page, hence the confusion.

Thanks for the help!

Andy Heinzer

Sorry for the inconvenience Niek, I created a documentation bug ticket to get our technical writing team to update that document to be more explicit https://jira.atlassian.com/browse/JRASERVER-67274

Mat Chavez

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.

Nic Brough -Adaptavist-

Not sure it's "all the way back", as 8 is the version after 5. It's asking you to go back one whole release.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

jira

jira-administration

database

install

mysql