https://github.com/osquery/osquery logo
#fleet
Title
# fleet
j

J.R. Murray

09/16/2022, 12:20 AM
Hi, I'm getting this error running
fleet prepare db
on a fresh installation:
Copy code
INFO: 00:13:41 Deleting dummy software_cpe entries...
INFO: 00:13:41 Done deleting dummy cpe_id entries...
INFO: 00:13:41 Removing cpe_id from software_cve...
2022/09/16 00:13:41 FAIL 20220831100036_RemoveCpeIDColumnFromSoftwareCve.go (removing cpe_id FK from software_cve: Error 1091: Can't DROP FOREIGN KEY `software_cve_ibfk_1`; check that it exists), quitting migration.
k

Kathy Satterlee

09/16/2022, 12:21 AM
Hi, @J.R. Murray ! We've seen some reports of this. Are you using MariaDB?
j

J.R. Murray

09/16/2022, 12:21 AM
yes!
k

Kathy Satterlee

09/16/2022, 12:27 AM
We'd really recommend sticking with MySQL since we don't officially support (or test) MariaDB. That being said, there's a patch release coming out likely in the AM that should fix the migration issue.
j

J.R. Murray

09/16/2022, 12:28 AM
makes sense, thank you for the quick response
k

Kathy Satterlee

09/16/2022, 4:44 AM
Thanks for reaching out!