👋 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 🙂

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.

fleet version 4.31.1

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"

Yeah this looks like a compatibility issue. I don’t think there is much we can do besides move to MySQL.

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.

Yes MySQL is the only supposed DB.