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:Microsoft Windows
Assigned to: Maksym Yehorov CPU Architecture:Any

[19 Nov 2009 13:37] Pavel Dobryakov
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
[19 Nov 2009 21:13] Sergey Romanov
Have the same with global name 'tempfile' is not defined.

Workbench running under Windows Vista 64bit
MySQL 5.1.40
[27 Nov 2009 5:07] Alfredo Kojima
What version of Python do you have in debian?
[27 Nov 2009 5:20] Pavel Dobryakov
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
[26 Dec 2009 19:44] Allen Ford
I am having the same problem with ubuntu 9.4
[30 Dec 2009 18:57] Alfredo Kojima
Problem about tempfile has been fixed by reviewing source code.
Problem about log_output has been fixed in a previous release.
[5 Jan 2010 17:32] Andre Hazelwood
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.
[5 Jan 2010 22:52] Andre Hazelwood
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
[13 Jan 2010 17:11] Maksym Yehorov
This is fixed:
unhandled exception: [Errno 22] Invalid argument:
'C:\\users\\tax\\appdata\\local\\temp\\tmpo47ttn'.

Also, fixed config loading.
[14 Jan 2010 18:01] Johannes Taxacher
fix confirmed. will be included in 5.2.12
[15 Jan 2010 13:20] Tony Bedford
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'
[19 Jan 2010 4:39] Tony Ledbetter
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