Hi there, trying to set up Fleet for osquery and am getting a

2023/04/11 09:44:46 FAIL 20230315104937_EnsureUniformCollation.go (fixing software table: aggregating dupes: Error 1253: COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'latin1'), quitting migration.

when running the

prepare db

. I am using an existing MariaDB server version

mysql  Ver 15.1 Distrib 10.3.35-MariaDB, for Linux (x86_64) using readline 5.1

Any ideas on why this might be happening?

Please use MySQL 5.7+ or 8+ as MariaDB has known issues: https://fleetdm.com/docs/deploying/faq#what-mysql-versions-are-supported