jimwillsher 65 Posted March 4, 2015 Posted March 4, 2015 Hi is there a way to remove revoked certificates from the console? I've had trouble tonight with certificates so I now have a dozen revoked ones, and I could do with clearing them out to keep things tidy. I can guarantee that there are no agents deployed using these certificates. Happy to remove them via SQL Server if someone can tell me which tables and records. Latest ERA6 (Global). Many thanks Jim
ESET Staff michalp 20 Posted March 5, 2015 ESET Staff Posted March 5, 2015 Right now it is not possible to hide or remove peer certificates from web console. Peer certificates are stored in 'tbl_certificates' table. There is column 'removed' which controls whether that row will be displayed in web console. Putting '1' instead of '0' will hide specific certificate record. Doing this change manually will skip internal mechanism in ERA server that records changes of every static object in database. For this specific case and your ERA release, it should be safe. But do it at your own risk.
jimwillsher 65 Posted March 5, 2015 Author Posted March 5, 2015 Thanks michalp, I think I'll leave them there for a while - or hide them but then re-enable them before the next release in case it breaks something.
dcarey 2 Posted March 5, 2015 Posted March 5, 2015 Good info as i also have botched certs I'd like to hide. -Dave
verus 4 Posted March 11, 2015 Posted March 11, 2015 Do you have to revoke the certificates when using new ones or can you just leave them as they are (even if they have the same name but of course another serial) ?
jimwillsher 65 Posted March 11, 2015 Author Posted March 11, 2015 You can probable leave them, but it would get very confusing when you have to pick one. I've hidden them via SQL to simplify things.
ESET Staff michalp 20 Posted March 12, 2015 ESET Staff Posted March 12, 2015 You don't have to revoke them. Revocation is meant to be used when you want specific certificate to be not valid.
jimwillsher 65 Posted March 12, 2015 Author Posted March 12, 2015 ok, but I would like to hide them somehow.
ESET Moderators Peter Randziak 1,223 Posted March 19, 2015 ESET Moderators Posted March 19, 2015 Hello Jim, we plan to add such functionality in future releases. P.R.
Planetshadow 0 Posted June 17, 2015 Posted June 17, 2015 Hi! I have several certs that I would like to hide as well... Could you give me the SQL Queries to accomplish this in the ESET Database?
jimwillsher 65 Posted June 17, 2015 Author Posted June 17, 2015 There's a table called [tbl_certificates]. Just set the removed field to 1 for the ones you don't want to see. Do this at your own risk - though it seems to work perfectly well. Jim
Recommended Posts