[Solved] Issue with Unimus and MariaDB/MySQL

[jpsimmonds]

Not putting this under support, as well its a resolution, not a support request. I have logged this as a support ticket for direct correspondence with the team but this is what has been discovered

When connecting to a MariaDB 11 (not sure of the equivalent MySQL version), the java connector cannot connect and returns the following error.

2023-07-12 08:34:03.110 ERROR 12 --- [cTaskExecutor-1] .s.b.b.s.DatabaseConnectionCheckBootStep : Database 'MysqlConfig{host='MariaDB', port='3306', database
ed exception is java.sql.SQLException: Unknown system variable 'transaction_isolation''

on the MariaDB side, it shows as

2023-07-11 22:34:03 3 [Warning] Aborted connection 3 to db: 'unimus' user: 'unimus_user' host: '172.23.0.3' (Got an error reading communication packets)

This is utilising docker, so I have been able to confirm that changing the docker container for MariaDB from latest (or untagged) to 10 the connection works fine, but forcing it to 11 or latest which is now 11, breaks the connection. reverting back to 10 fixes it again

[dominik.c]

Hello,
The problem is that MariaDB 11 is not supported by Unimus yet. We have it in our scope, but unfortunately we don't have an ETA yet.

[irrwitzer]

Not putting this under support, as well its a resolution, not a support request. I have logged this as a support ticket for direct correspondence with the team but this is what has been discovered
[...]This is utilising docker, so I have been able to confirm that changing the docker container for MariaDB from latest (or untagged) to 10 the connection works fine, but forcing it to 11 or latest which is now 11, breaks the connection. reverting back to 10 fixes it again

Thank you so much @jpsimmonds for sharing this solution. Saved me a lot of time....
Thanks!

[dominik.c]

Greetings,

We have a new Unimus version 2.4.2 live now, where we add a support for MariaDB 11.
More info here: viewtopic.php?f=3&t=1748

If you get a chance, give it a try and let us know if it works as expected.

Thank you and have a nice day.