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

Daniel Lidberg

05/24/2023, 8:15 AM
👋 running fleetdm with MariaDB (10.5.19 which I guess might not be supported?) and running into the
Something's gone wrong
error in Hosts among other places. Any thoughts? Happy to provide more info 🙂
image.png
b

Benjamin Edwards

05/24/2023, 10:52 AM
Let’s start with what version of fleet and server logs if any. Correct MariaDB isn’t supported and we’ve seen issues with migrations in the past. We test with MySQL 5.7 and 8.0. If you are early in your Fleet journey I’d suggest going with MySQL 8 if that’s an option for you.
d

Daniel Lidberg

05/24/2023, 11:38 AM
fleet version 4.31.1
Copy code
level=error ts=2023-05-24T11:35:11.926685424Z component=http user=redacted method=GET uri="/api/latest/fleet/hosts?page=0&per_page=50&device_mapping=true&order_key=display_name&order_direction=asc" took=674.365µs err="list hosts: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'JSON)\n\t\t\tELSE CAST(TRUE AS JSON)\n\t\tEND,\n\t\t'raw_decryptable',\n\t\tCASE\n\t\t\tWHEN h...' at line 69"
b

Benjamin Edwards

05/24/2023, 1:49 PM
Yeah this looks like a compatibility issue. I don’t think there is much we can do besides move to MySQL.
d

Daniel Lidberg

05/24/2023, 2:17 PM
Gotcha and no worries 🙂 And MySQL is the only supported DB? I guess I'll probably start from scratch instead of trying to migrate.. Still just a PoC so not a problem.
b

Benjamin Edwards

05/24/2023, 2:18 PM
Yes MySQL is the only supposed DB.
10 Views