MySQL Bugs: #76918: Unhelpful error for mysql_ssl_rsa

Bug #76918	Unhelpful error for mysql_ssl_rsa_setup when datadir doesn't exist
Submitted:	3 May 2015 11:05	Modified:	11 May 2015 17:43
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.7.7-rc, , 5.7.8,8.0.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	usability

Description:
When the datadir specified on the commandline for mysql_ssl_rsa_setup doesn't exist the error message is 'Failed to normalize the arguent for --datadir', which is not really helpful.

How to repeat:
mysql_ssl_rsa_setup --datadir=/etc/mysql/ssl --verbose
2015-05-03 13:01:14 [ERROR]   Failed to normalize the argument for --datadir: /etc/mysql/ssl

Suggested fix:
Generate a more helpful error message or try to create the directory if it doesn't exist yet.

Hello Daniël,

Thank you for the report.
Observed with 5.7.8/5.8.0 builds.

Thanks,
Umesh

####

// 5.8.0

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.8.0: bin/mysql_ssl_rsa_setup --datadir=/tmp/mysql --verbose
2015-05-03 14:51:35 [ERROR]   Failed to normalize the argument for --datadir: /tmp/mysql
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.8.0:

// 5.7.8

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: bin/mysql_ssl_rsa_setup --datadir=/tmp/mysql --verbose
2015-05-03 14:52:15 [ERROR]   Failed to normalize the argument for --datadir: /tmp/mysql

Noted in 5.7.8, 5.8.0 changelogs.

When the directory specified for the secure_file_priv system variable
did not exist, the server produced a ""Failed to normalize the
argument" error message. It now produces a message indicating that
the directory did not exist. The same problem occurred for the
--datadir option to mysql_ssl_rsa_setup and was fixed the same way.

Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0