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)
• Status: Verified
• Category: MySQL Server: Logging
• Severity: S3 (Non-critical)
• Version: 5.6.14
• OS: Any
• 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] MySQL Verification Team

Hello Daniel,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

[1 Jun 2014 15:28] Daniël van Eeden

Added tags