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

osquery

New question. Looking through <https://fleetdm.com/docs/configuration/fleet-server-configuration> I don't see an option for MySQL to set the SSL mode to "required". The REDIS configs have `use_tls` but all the TLS options for MySQL are about using a client certificate. Is there a way to tell Fleet to only use SSL for MySQL?

I haven’t tried it without, so might not be necessary, but was surprised I couldn’t find the option. I’ll open a ticket if it doesn’t work.

I'm pretty sure configuring any of these flags forces fleet into using SSL for mysql: <https://fleetdm.com/docs/configuration/fleet-server-configuration#mysql-tls-ca>

This is the primary setting:

<https://fleetdm.com/docs/configuration/fleet-server-configuration#mysql-tls-config>

ooh, so I can just set that to true, nice