On Wed, 20 Mar 2024 at 07:20, Juan Hernandez via discuss <discuss@lists.mariadb.org> wrote:

Hi,

So I’ve been running MariaDB 11.3 for a while. I have various applications working great with this server.

I want to setup a Jira 9.14 self hosted instance on one of my servers. I see mariadb.com uses Jira.

So I put the mysql java connector v8.3.0, and the mariadb java connector v3.3.3 installed in my /opt/Atlassian/jira/lib directory.

I tried connecting jira via the setup web interface to my maria db, using the mysql 8.0 driver, and I get the error that I’m not running the right version.

Is that from the driver or from JIRA?

I then added under [mysqld] in my.cnf, version = “8.0.25-0” and now get the below error.

Error connecting to database

Unknown system variable 'transaction_isolation'

https://jira.mariadb.org/browse/MDEV-21921 - added this to 11.1, so you should be right in 11.3. Its not 10.11.3 right? Can JIRA use the MariaDB Java Connector v3.3.3? A last resort is to specify the version=5.7.44 (any 5.7) and/or use a 5.7 compatible mysql java connector.

I am now getting this error when testing the connection in jira:

I don’t want to setup a postgresql instance or a mysql 8 instance, can I get this to work? Any help would be greatly appreciated.

Us too. We're still battling against JIRA supported databases a little after all these years.