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

[3 May 2015 11:05] Daniël van Eeden
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.
[3 May 2015 12:54] MySQL Verification Team
Hello Daniël,

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

Thanks,
Umesh
[3 May 2015 12:54] MySQL Verification Team
####

// 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
[11 May 2015 17:43] Paul DuBois
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.
[18 Jun 2016 21:26] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0

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

Page generated in 0.040 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.