Thread: Log the incoming old SSL certs by pid or any way
Hello!
PGSQL 9.6, Linux, SSL.
We want to change certs to new, but somehow we need to detect which old cert is in use before the expiration.
So now they could connect with old and new too. We want to warn the clients with old certs to update, before they will be denied.
Do we have chance to log somewhere the connected client's certificate, or some info about it?
As I know the CRL can block unwanted certs - they will be denied.
Is there any, similar list where we can registrate the cert and when it used we can log it?
Do you know about any mechanism for this? I hope you understand what we need.
Thank you for it!
dd
## Durumdara (durumdara@gmail.com): > Do we have chance to log somewhere the connected client's certificate, or > some info about it? There's pg_stat_ssl, and if you had an recent version of PostgreSQL (9.6 is too old for that), you'd even have the serial number of the certificate in there: https://www.postgresql.org/docs/12/monitoring-stats.html#PG-STAT-SSL-VIEW On the other hand, you could check the certificates directly, e.g. https://github.com/matteocorti/check_ssl_cert or even just some scripting around openssl. (That assumes that you know where those client certificates are). Regards, Christoph -- Spare Space