MySQL Bugs: #48906: Error editing my.cnf

Bug #48906	Error editing my.cnf
Submitted:	19 Nov 2009 13:37	Modified:	15 Jan 2010 13:20
Reporter:	Pavel Dobryakov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.8 4572	OS:	Windows
Assigned to:	Maksym Yehorov	CPU Architecture:	Any

Description:
I tried to configure the Server Administration.
When you set up when checking the path to the mysqld section of my.cnf and verify the correctness of the path, and when checking the section was a mistake. The same is observed for 2 servers for the test. For the test was taken Serer Debian + MySql 5.0.81.
However, the profile is created, go to him I can not run the tab Configuration (if you try to open the tab-error: "Unhandled exception: global name 'tempfile' is not defined") and Logs (if you try to open-error: Unhandled exception: Error executing 'Select @ @ log_output': Unknown system variable 'log_output')

How to repeat:
Use MySql 5.0.81 on OS Debian Leny
Workbench running under Windows XP

Have the same with global name 'tempfile' is not defined.

Workbench running under Windows Vista 64bit
MySQL 5.1.40

What version of Python do you have in debian?

I ran the tests on multiple servers. Here's a list of versions of Python:
2.5.2-3
2.5.2-15
2.4.6-1
2.4.3
2.4.4
And everywhere arose the bug with viewing logs and editing my.cnf

I am having the same problem with ubuntu 9.4

Problem about tempfile has been fixed by reviewing source code.
Problem about log_output has been fixed in a previous release.

Just installed version 5.2.11 OSS Beta Revision 4842 running under Windows 7 (x64).  Connecting to mysql version 5.1.37 on latest ubuntu version.  Only change to the my.cnf file is allowing a different bind address.  Get the error message:  Unhandled exception: global name 'tempfile' is not defined whenever you click on the Configuration tab.

Here is more detail about the error message:

Traceback (most recent call last):
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_configuration.py", line 187, in tab_changed
    panel.page_activated()
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 21, in page_activated
    self.create_ui()
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 163, in create_ui
    self.load_options_from_cfg()
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_ui.py", line 512, in load_options_from_cfg
    self.cfg_be.parse_file(self.file_name_ctrl.get_string_value())
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_be.py", line 294, in parse_file
    self.file_name = self.read_mysql_cfg_file(file_name)
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_config_file_be.py", line 251, in read_mysql_cfg_file
    local_file_name = self.ctrl_be.fetch_file(file_name)
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 434, in fetch_file
    temp_file = tempfile.mkstemp()
NameError: global name 'tempfile' is not defined

This is fixed:
unhandled exception: [Errno 22] Invalid argument:
'C:\\users\\tax\\appdata\\local\\temp\\tmpo47ttn'.

Also, fixed config loading.

fix confirmed. will be included in 5.2.12

An entry has been added to the 5.2.12 changelog:

Various errors occurred when attempting to modify the server configuration using the Configuration tab of the Administrator:

Unhandled exception: global name 'tempfile' is not defined
      
Unhandled exception: [Errno 22] Invalid argument:
'C:\\users\\tax\\appdata\\local\\temp\\tmpo47ttn'
      
Also, if the Logs tab was selected in order to view the server log files the following error occurred:

Unhandled exception: Error executing 'Select @ @
log_output': Unknown system variable 'log_output'

Have the same with global name 'tempfile' is not defined. Still an issue.

Running Mysql Workbench 5.2.11 OSS BETA Rev 4842 on Windows 7 (64bit) 
connecting to 
CentOS 5.4 (FINAL) with
Mysql  Ver 14.14 Distrib 5.1.42, for pc-linux-gnu (i686) using readline 5.1

In Mysql Workbench selecting Server Administration -> Configuration tab
ERROR:
Unhandled exception: global name 'tempfile' is not defined