Title
#kolide
SK

SK

03/22/2020, 11:19 AM
Hey All, quick question. If I create a new MySQL DB will the OSQuery agents enrolled in the old DB do a new enroll for the new DB?
zwass

zwass

03/22/2020, 5:22 PM
They will try to. You need to ensure that the enroll secret is the same so that they can authenticate successfully.
SK

SK

03/22/2020, 5:25 PM
Hey @zwass thanks for your reply. Will try it out in a dev first. 😉
8:51 AM
@zwass Is there a way to check the DB for health? Maybe there are some corrupt entries etc.
zwass

zwass

03/23/2020, 4:06 PM
If there are corrupt entries I'd expect to see errors in the server logs. There's no way that Fleet does a full DB check for health.
SK

SK

03/23/2020, 8:14 PM
@zwass one more question, how can you ensure you get the same enroll secret with the new DB? Is there a setting somewhere? Just tried it but got a new enroll secret.