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

Question

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

Ricardo · Answer

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 <https mariadb com kb en setting character sets and collations >

Ricardo · Answer

Basically you seem to have created the database with character set latin and now try to use utfmb8

Ricardo · Answer

```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 = gt could be a potential bug