search

fleetdm / fleet

Open-source platform for IT, security, and infrastructure teams. (Linux, macOS, Chrome, Windows, cloud, data center)
https://fleetdm.com
Other
3.01k stars 418 forks source link

fleet prepare db faild with mariadb version 11.4.2-MariaDB-ubu2404 #20838

Closed kernux closed 2 months ago

kernux commented 2 months ago

Fleet version: v4.54.1

2024/07/30 17:38:19 [2023-03-17] Cleanup Host MDM Apple Profiles 2024/07/30 17:38:19 [2023-03-20] Add Reset Requested To Host Disk Encryption Keys 2024/07/30 17:38:20 [2023-03-30] Cleanup Host Disk Encryption Keys Table 2024/07/30 17:38:20 [2023-03-30] Add Software CPE Unique Constraint 2024/07/30 17:38:20 [2023-04-05] Add Bootstrap Packages Table 2024/07/30 17:38:20 [2023-04-08] Add Checksum To Profiles 2024/07/30 17:38:20 [2023-04-11] Create Host Bootstrap Packages Table 2024/07/30 17:38:20 FAIL 20230411102858_CreateHostBootstrapPackagesTable.go (create host_mdm_apple_bootstrap_packages: Error 1005 (HY000): Can't create table fleet.host_mdm_apple_bootstrap_packages (errno: 150 "Foreign key constraint is incorrectly formed")), quitting migration.

xpkoala commented 2 months ago

Hi @kernux! Apologies for the troubles you are running into. At this time MySQL version 8.0 is the only officially supported database.

You might be able to find other users who have run into this issue and found remedies in the osquery slack channel. You can find a link to join on their front page.

Since this isn't a bug related to Fleet I'm going to close this ticket out, but please feel free to open a new ticket if you are having issues with Fleet.

Thank you!

fleet-release commented 2 months ago

MariaDB glitch fixed, Smooth as a cloud city's glass. Fleet's keys unlock ease.