CertStreamMonitor icon indicating copy to clipboard operation
CertStreamMonitor copied to clipboard

Published 20 hours ago • verified publisher icon AssuranceMaladieSec

Support for external database server

Open pierrehenrymuller opened this issue 5 years ago • 3 comments

Hi, Is it possible to use a database server like MySQL or PostgreSQL instead of SQLite file? Thanks

pierrehenrymuller avatar Oct 02 '19 10:10 pierrehenrymuller

Hello Pierre Henry, Yes, it is possible ... if the support for it is developed and merge into CertStreamMonitor ;-) More seriously, we don't have the usage for the moment, so, we don't have developed it until now. Please, want to code it and submit it through a PR? We can provide assistance :)

cbrocas avatar Oct 04 '19 11:10 cbrocas

Ok ;) I'll try to make this but maybe I didn't do everything I needed to properly manage the sqlite. Typically, I don't think I've seen a prune in the sqlite database that would remove entries older than N months. As a result, the sqlite base is constantly growing. How do you manage the sqlite file when it gets bigger?

pierrehenrymuller avatar Oct 04 '19 13:10 pierrehenrymuller

Currently, our dataset does not represent more than several megabytes, so cleanup the database has not been a priority for the moment. Another part of the problem is that removing entries in a Threat Intel context may not be the good solution in any context. Btw I will code soon a script that is going to be able to remove entries that are no longer checked - see commit https://github.com/AssuranceMaladieSec/CertStreamMonitor/commit/0cbd5ad09a21d6c4aec391316149efefe97c5d8e . Hope it will help.

cbrocas avatar Oct 04 '19 14:10 cbrocas