replace mysql with mariaDB in jira

For licence reasons, we have to change our mySQL Database to MariaDB.

The database was installed succesfully but JIRA does not start with the connector of MariaDB I have downloaded here : https://downloads.mariadb.org/client-java/1.1.8/

It still requires the official mySQL connector.

Do you know what dbconfig.xml should I use ?

Any experience of JIRA with Maria DB ?

4 answers

1 accepted

This widget could not be displayed.

For support reasons, I'd suggest that you do not do this.  Atlassian only support MySQL, PostGreSQL, Oracle and MS-SQL-server.  If you use another database, they will try to help you, but if they suspect the database, you're on your own and will need to migrate back to a supported one to get any further help.  (I suspect Maria support will arrive eventually, but it's not going to be soon)

That said, you can make other databases work fine with JIRA.  I've run it on some pretty unusual ones, and the trick is basically to make the Tomcat datasource work correctly.  I've not tried it with Maria, but the ones I did make it work with were simply a case of following the instructions for connecting up a Tomcat and checking for quirks.

So, what error messages are you getting when you try MariaDB?

Thanks. The tool "config.bat" says :

Driver for the database MySQL not found. Ensure it is installed in the 'lib' directory.
If you are upgrading a standalone distribution of JIRA, this may be due to the fact that JIRA no longer ships with MySQL drivers.
Please visit https://docs.atlassian.com/jira/docs-062/Connecting+JIRA+to+MySQL for more information.

What type of database should I use ?

What is the dataconfig.xml should I write ?

Oh, you won't get it to work with the wizards, they only handle the supported databases. You could select MySQL for now, run with that and then swap over to Maria later (before putting any data into it). The MariaDB driver needs to go into the Tomcat lib directory rather that JIRAs though.

Justin Burke Atlassian Team May 23, 2015

I just want to stress the point that Nic made earlier. You won't be able to get support on your instance if you are using MariaDB. We only allow MS SQL, MySQL, Oracle, and PostGres.

Actually, the version of jira we currently use is not supported anymore (too old). So I know that I won't be able to open a ticket in the jira of the support team anyway. If any big problem we will think about restoring data in a supported database.

This widget could not be displayed.

In fact I changed the package to org.mariadb.jdbc.Driver in the dbconfig.xml.

Thanks

This widget could not be displayed.

There is a ticket open in Atlassian that indicates that MariaDB is not supported for JIRA. See https://jira.atlassian.com/browse/JRA-32347

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

534 views 23 15
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you