Bug #54933 Workbench Server Admin doesn't parse my.cnf file correctly

• Submitted: 1 Jul 2010 13:34
• Modified: 28 Jul 2010 15:04
• Reporter: Joe Grasse
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 5.2
• OS: Any
• Assigned to: Maksym Yehorov
• CPU Architecture: Any

[1 Jul 2010 13:34] Joe Grasse

Description:
When variables with an "_" (underscore) are used in the my.cnf file, workbench will not display them as being set in the "Configuration" tab of the Server Administration.

How to repeat:
Set the server id in the my.cnf file by using server_id = 1. Then connect with Workbench and navigate to the "Replication" tab under "Configuration"

Suggested fix:
Parse the my.cnf the same as starting the server would.

[1 Jul 2010 14:19] Maksym Yehorov

Joe,

Did you try server-id for config file?
http://dev.mysql.com/doc/refman/5.0/en/replication-options.html#option_mysqld_server-id

[1 Jul 2010 14:20] Joe Grasse

Yes that works.

[1 Jul 2010 17:23] MySQL Verification Team

Thank you for the bug report.

[2 Jul 2010 13:36] Maksym Yehorov

Joe,

do you experience problems with other '_'-options, or was server_id the only issue?

[2 Jul 2010 13:37] Joe Grasse

It happens with other options as well.

[2 Jul 2010 15:34] Maksym Yehorov

Fixed.
Thanks for the report!

[27 Jul 2010 12:05] Johannes Taxacher

fix confirmed in repository

[28 Jul 2010 15:04] Tony Bedford

An entry has been added to the 5.2.26 changelog:

Configuration variables in the my.cnf file that contained an underscore character were not displayed in the Configuration section of the MySQL Workbench Administrator.