Bug #49023 MEM advisor - check for SSL certificate expiration
Submitted: 24 Nov 2009 5:53 Modified: 24 Nov 2009 7:11
Reporter: Andrew Dalgleish Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S4 (Feature request)
Version:2.1.0.1096 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[24 Nov 2009 5:53] Andrew Dalgleish
Description:
A customer reported they would like MEM to be able to warn about the expiration date of mysqld SSL certificates.

As a work-around, if you have FILE privs you can load the SSL certificate files like this:
CREATE TEMPORARY TABLE ssl_key SELECT LOAD_FILE(@@ssl_key);

How to repeat:
feature request
[21 Feb 2014 10:09] Daniƫl van Eeden
In MySQL 5.6.3 Ssl_server_not_after was introduced. This could help here.

http://dev.mysql.com/doc/refman/5.6/en/server-status-variables.html#statvar_Ssl_server_not...