Has anyone else faced the problem attached below i...
# fleetm
Mark Kamau
05/21/2024, 11:47 PMHas anyone else faced the problem attached below in the past. I'd appreciate some assistance😫
Mark Kamau
05/22/2024, 12:03 AMHere is the error I have traced on my logs:
Copy code
May 22 02:57:32 fleetvm fleet[1138]: {"component":"http","err":"list hosts: Error 1064 (42000): 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(FALSE AS JSON)\n\t\tEND,\n\t\t'server_url',\n\t\tCASE\n\t\t\tWHEN hmdm....' at line 62","level":"error","method":"GET","took":"1.827367ms","ts":"2024-05-21T23:57:32.500763517Z","uri":"/api/latest/fleet/hosts?page=0&per_page=50&device_mapping=true&order_key=display_name&order_direction=asc","user":"test"}k
Kathy Satterlee
05/22/2024, 3:25 PMHi @Mark Kamau! While MariaDB can generally be used as a drop-in replacement for MySQL, there are occasionally compatibility issues like this. We officially support MySQL, and recommend staying away from alternative DB servers as they are untested.
m
Mark Kamau
05/22/2024, 5:20 PMThank you @Kathy Satterlee. Tha actually helps a lot. Ill try and move the db to MYSQL
2 Views