Bug #70736 Warning about missing RSA keypair is wrong
Submitted: 26 Oct 2013 18:11 Modified: 1 Jun 2014 15:28
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S3 (Non-critical)
Version:5.6.14 OS:Any
Assigned to: CPU Architecture:Any
Tags: rsa, SHA256

[26 Oct 2013 18:11] Daniël van Eeden
Description:
From the error log:

2013-10-26 18:03:52 1150 [Note] RSA private key file not found: /opt/mysql/data//private_key.pem. Some authentication plugins will not work.
2013-10-26 18:03:52 1150 [Note] RSA public key file not found: /opt/mysql/data//public_key.pem. Some authentication plugins will not work.

This is wrong because:
1. It does not clearly indicate which RSA keypair it is talking about (authentication or SSL)
2. "will nog work" is not true: A keypair OR SSL is needed to get the sha256 auth plugin to work. 

http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html

How to repeat:
Start a new MySQL Server.

Suggested fix:
Change from 
"RSA private key file not found: %{filepath}. Some authentication plugins will not work"
to
"RSA private key file for sha256 authentication not found: %{filepath}, authentication with sha256 for non-SSL connections will not work"
[28 Oct 2013 6:49] Umesh Shastry
Hello Daniel,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[1 Jun 2014 15:28] Daniël van Eeden
Added tags