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

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

Donnie Elmore

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

Ricardo

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

Ricardo

04/11/2023, 4:06 PM

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

Ricardo

04/11/2023, 4:08 PM

Copy code

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!)

4 Views

Open in Slack

Previous Next