com.mysql.cj.exceptions.CJException: Unknown system variable 'transaction_isolation'

[7hatGuyAJ]

Description of Issue

Unable to connect to mariadb

Version: '11.0.2-MariaDB-1:11.0.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution https://hub.docker.com/_/mariadb

https://pastebin.com/gakHJzf7

Version Information

--------------------------------------------------
CMI: 9.6.2.1 SqLite
CMILib: 1.4.0.3
Server: Paper(100) 1.20.1-R0.1-SNAPSHOT
CMI economy: Disabled CMI Chat: Disabled
Modules -> 57 enabled 1 disabled: votifier
--------------------------------------------------
This server is running Paper version git-Paper-100 (MC: 1.20.1) (Implementing API version 1.20.1-R0.1-SNAPSHOT) (Git: f402f89)
Console11:28:15
You are running the latest version

Errors

Mariadb logs `[Warning] Aborted connection 3 to db: 'minecraft' user: 'andrew' host: '172.18.0.1' (Got an error reading communication packets)`

Minecraft server logs.
https://pastebin.com/gakHJzf7

Relevant Config Sections

No response

Relevant Plugins

No response

Agreements

• [X] My server is supported by CMI.
• [X] My version of CMI at the time of this report is up to date.
• [X] I have searched the github and asked around before making this report.

[FatildaIV]

The MySQL Connector/J used in CMI is not compatible with MariaDB 11+. I propose adding MariaDB Connector/J as an alternative to unsupported com.mysql.cj.jdbc.Driver.