Bug #49023 MEM advisor - check for SSL certificate expiration

• Submitted: 24 Nov 2009 5:53
• Modified: 24 Nov 2009 7:11
• Reporter: Andrew Dalgleish
• Status: Verified
• 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...