Jump to content

Recommended Posts

Posted

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
Posted

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.

Posted

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.

Posted

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

 

-Dave

Posted

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

Posted

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
Posted

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

  • 2 months later...
Posted

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?

Posted

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

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...