MySQL Bugs: #47954: The administrator module handles the log-bin ini setting incorrectly

Bug #47954	The administrator module handles the log-bin ini setting incorrectly
Submitted:	9 Oct 2009 18:49	Modified:	30 Nov 2009 14:22
Reporter:	Rodrigo Saboya	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.4	OS:	Any
Assigned to:	Maksym Yehorov	CPU Architecture:	Any
Tags:	administrator

Description:
When the log-bin option is present in the config file without a value, Workbench Administration module fails to parse the file. The documentation states that no value for this option is a valid config option for MySQL:

http://dev.mysql.com/doc/refman/5.0/en/binary-log.html

How to repeat:
Set the "log-bin" option without a value in the [mysqld] section of your mysql configuration file and try to open that file with the MySQL Workbench administration module.

Suggested fix:
Apparently the problem is that the log-bin option is of type "dir", but when set to no value it fails because the value of the variables of this type are treated as strings. When the program tries to strip whitespace from the value, the error occurs:

wb_admin_config_file_ui.py
       if tag == "txt" or tag == "dir":
         if value is None:
           value = ""
         value = value.strip(" \r\n\t")
         control(1).set_value(value)
Possible fixes:
 - Handle the log-bin option in a special way and add a checkbox like "Use default location".
 - Warn the user that he should specify a location and that not doing so is a malpractice, and populate the text box with the default path.

Added check. Scheduled addition of errors+warnings report for config file parsing.

admin now correctly parses this parameter (also when left empty)

Added to 5.2.9 changelog.

See also Bug #49057