Jump to content

Archived

This topic is now archived and is closed to further replies.

jimwillsher

Remove revoked certs from console (ERA6)

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Good info as i also have botched certs I'd like to hide.

 

-Dave

Share this post


Link to post
Share on other sites

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) ?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

You don't have to revoke them. Revocation is meant to be used when you want specific certificate to be not valid.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...