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

[Alex Johnson · Accepted solution]

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

[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:

1. 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 .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

[Aleks Buterman]

That was the answer, thank you!

[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.

[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.