Hello! There is an error in the Fleet logs when I try to fetch data from the host:

Oct 20 11:21:42 <fleet_server> fleet[106691]: {"component":"http","err":"error in query ingestion","ingestion-err":"ingesting query software_windows: update host software: insert software: Error 1366: Incorrect string value: '\\xD0' for column 'vendor' at row 1","ip_addr":"127.0.0.1","level":"error","method":"POST","took":"128.611874ms","ts":"2023-10-20T08:21:42.038681543Z","uri":"/api/v1/osquery/distributed/write","x_for_ip_addr":"127.0.0.1"}

What I've done: • change MySQL config to:

[mysqld]
init_connect='SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;'
skip-character-set-client-handshake
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

• change collate for the

software

table and column

vendor

to

utf8mb4_unicode_ci

But the error remains and the programs tab is empty. Is there a way to fix this problem without updating Fleet?

Fleet: 4.26.0

Go: go1.19.4

osquery: 5.9.1

Greetings @Alexander Samrega Could you try running the host vitals

software_windows

https://fleetdm.com/docs/using-fleet/understanding-host-vitals#software-windows query as a live query and see if returning good data? We do recommend updating fleet for better support. We'd be able to far better assist if seeing error on current version https://fleetdm.com/docs/deploy/upgrading-fleet

@Grant Bilstad, the host vitals

software_windows

have exetuted without errors and returned good data (there are some values in

vendor

column with cyrillic text)

Hey @Alexander Samrega, Trying to help as much as we can. We support current major fleet release listed on this channel description. Packs are removed from the UI but still available from CLI or REST API for backwards compatibility. https://fleetdm.com/docs/get-started/faq#where-did-the-packs-page-go

@Grant Bilstad, OK, thanks for the information and quick response!