Re: Workbench configuration tabs are empty with MariaDB ( general, etc ... except Performance and Misc )

Printscreen ( PNG ) of configuration MySQL and MariaDB
LPexportBug706499_PrintScreen.PNG

Re: Workbench configuration tabs are empty with MariaDB ( general, etc ... except Performance and Misc )
I'm setting "won't fix" because we can't fix Workbench. There is a MYSQL bug about it http://bugs.mysql.com/bug.php?id=61219, which is said to be fixed in the next WB version.

Re: Workbench configuration tabs are empty with MariaDB ( general, etc ... except Performance and Misc )
I've tried to repeat on Ubuntu 10.10 x64, with MariaDB 5.2.6 (from repositories) and MySQL Workbench 5.2.34 .deb package from the official site.

My actions where:
1. Install MySQL
2. Install Workbench
3. Try using Workbench
4. Install MariaDB (this will un-install MySQL and put MariaDB instead)
5. Try using Workbench
5.1 Edit /etc/mysql/my.cnf and try again

On step#3, everything worked ok.

On step #5, workbench has shown me message that

"Configuration file didn't contain section [mysqld], so a new one was added. If
that is not correct, please fix the section name in the Server Instance Editor
and reopen the administrator.

and I couldn't see any options (see attached screenshot)

I looked into /etc/mysql/my.cnf and found it to be MariaDB's file (with MariaDB-specific options, mentions of openquery, etc) . Also, the main section of the file was named [server], not [mysqld].

I assumed that Workbench was confused by MariaDB's .cnf file, so I've edited it until it was very close to MySQL's default configuration file. The message about "Configuration file didn't contain ..." is now gone, however, I still can't see any options except optimizer_switch.

I've tried to repeat on Ubuntu 10.10 x64, with MariaDB 5.2.6 (from repositories) and MySQL Workbench 5.2.34 .deb package from the official site.

My actions where:
1. Install MySQL
2. Install Workbench
3. Try using Workbench
4. Install MariaDB (this will un-install MySQL and put MariaDB instead)
5. Try using Workbench
5.1 Edit /etc/mysql/my.cnf and try again

On step#3, everything worked ok.

On step #5, workbench has shown me message that

"Configuration file didn't contain section [mysqld], so a new one was added. If
that is not correct, please fix the section name in the Server Instance Editor
and reopen the administrator.

and I couldn't see any options (see attached screenshot)

I looked into /etc/mysql/my.cnf and found it to be MariaDB's file (with MariaDB-specific options, mentions of openquery, etc) . Also, the main section of the file was named [server], not [mysqld].

I assumed that Workbench was confused by MariaDB's .cnf file, so I've edited it until it was very close to MySQL's default configuration file. The message about "Configuration file didn't contain ..." is now gone, however, I still can't see any options except optimizer_switch.

workbench-no-options.png
LPexportBug706499_workbench-no-options.png

Re: Workbench configuration tabs are empty with MariaDB ( general, etc ... except Performance and Misc )
optimizer_switch option looks like this. Workbench allows me to edit it.

optimizer_switch option looks like this. Workbench allows me to edit it.
workbench-optimizer-switch.png
LPexportBug706499_workbench-optimizer-switch.png

Re: Workbench configuration tabs are empty with MariaDB ( general, etc ... except Performance and Misc )
.. That is, I can really change its value and the change gets into the right place in /etc/mysql/my.cnf.

Launchpad bug id: 706499

Re: Workbench configuration tabs are empty with MariaDB ( general, etc ... except Performance and Misc )

In the corresponding MySQL bug http://bugs.mysql.com/bug.php?id=61219, there is an entry that describes the magic

[26 May 18:00] Maksym Yehorov
Workbench works as expected, it is only that the options set is dependent on a server
version, so there is 1 valid option for 5.2.6 according to docteam's xml file which
describes mysql options.

this single option is the optimizer_switch. bet it was introduced in the now already forgotten MySQL 5.2