hm; did something break between 4.27 and 4.28? the "Hosts" view now says "something's gone wrong" and the following error:
level=error ts=2023-03-05T154156.581203777Z component=http email@example.com method=GET uri="/api/latest/fleet/hosts?page=0&per_page=50&device_mapping=true&order_key=display_name&order_direction=asc" took=38.047354ms 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'name', hmdm.name\n\t) mdm_host_data\n...' at line 69"
03/05/2023, 5:26 PM
Hi @Tor Houghton ! While MariaDB can often act as a drop-in replacement for MySQL, it isn’t officially supported and we don’t test for it. I haven’t seen any reports of this error, so it’s likely a compatibility issue.
03/05/2023, 7:03 PM
Thanks; which MySQL version is the lowest that you support?
(Never mind, I am now running on latest mysql-common) 🙂