https://github.com/osquery/osquery logo
#fleet
Title
# fleet
d

Donnie Elmore

04/11/2023, 2:00 PM
Hi there, trying to set up Fleet for osquery and am getting a
Copy code
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
Copy code
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?
z

zwass

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