https://github.com/osquery/osquery logo
Title
t

Tor Houghton

03/05/2023, 3:42 PM
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-05T15:41:56.581203777Z component=http user=tor@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"
k

Kathy Satterlee

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.
t

Tor Houghton

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) 🙂
k

Kathy Satterlee

03/06/2023, 2:52 AM
Awesome! Problem solved?
t

Tor Houghton

03/22/2023, 1:41 PM
yes 🙂