Donnie Elmore

04/11/2023, 1:46 PM
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?


04/11/2023, 4:06 PM
Hi Donnie, You are setting collation utf8mb4_unicode_ci for character set latin1 which is not valid according to your error log. Follow this link, you will find more information about this.
Basically you seem to have created the database with character set latin and now try to use utfmb8
CREATE DATABASE czech_slovak_names 
  CHARACTER SET = 'keybcs2'
  COLLATE = 'keybcs2_bin';
(from the mariadb website) So just make sure you create the database with the proper collation/character settings. (I am uncertain if this prepare db would create the database as well or just write into an existing one - if it creates the database as well - then it should take care of both server flags and act accordingly => could be a potential bug!)