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 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] 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.073 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.