Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

hey guys, when running `fleet prepare db` is there anyway to debug the returned error:

 `Error retrieving migration status: cannot get table migration status`

This is for a new db we wish to migrate to. Network connectivity isn’t the issue so wondering how we can debug.

Are you able to see any logs from the MySQL server? Is it perhaps a permissions issue?

I've never seen this particular error before and looking at the code I see there's more information we could expose. I'll make a quick change to do that which will be available in the release next week. Until then I think you're best off with the MySQL logs.

thanks Zack. I’ll grab the SQL logs from the DBAs and see what we find