Bug #57695 Cannot connect to remote server administration
Submitted: 24 Oct 2010 19:19 Modified: 24 Nov 2010 16:37
Reporter: Marek Mialkowski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:5.2.29 CE OS:Windows (7 x64)
Assigned to: Maksym Yehorov CPU Architecture:Any
Tags: can't connect

[24 Oct 2010 19:19] Marek Mialkowski
Description:
MySql server 5.1.51-win32 runs on Windows Server 2003.
When I was creating new Server Instance in WB all test connections passed. 
When trying to connect to server after entering password for ssh I get message:

AttributeError: ServerProfile instance has no attribute 'serverInfo'

Output window contains:

New client connection
client connection established
59273 INFO Tunnel now open ('127.0.0.1', 49577) -> ('10.10.0.120', 22) -> ('10.10.0.120', 3306)
<type 'instance'>
WARNING: Unable to fetch ProgramFiles(x86) value in local Windows machine: 
Traceback (most recent call last):
  File "C:\MySQL Workbench 5.2.29 CE\modules\wb_admin_grt.py", line 163, in do_open_administrator
    adminTab = AdministratorTab(server_instance)
  File "C:\MySQL Workbench 5.2.29 CE\modules\wb_admin_grt.py", line 113, in __init__
    self.monitor = wb_admin_monitor.WbAdminMonitor(server_profile, self.ctrl_be)
  File "C:\MySQL Workbench 5.2.29 CE\modules\wb_admin_monitor.py", line 129, in __init__
    self.mon_be = wba_monitor_be.WBAdminMonitorBE(3, server_profile, ctrl_be, self.widgets, sql)
  File "C:\MySQL Workbench 5.2.29 CE\modules\wba_monitor_be.py", line 515, in __init__
    stats = WBAWinRemoteStats(ctrl_be, server_profile, self.running, widgets['get_cpu_info'], widgets['get_mem_info'])
  File "C:\MySQL Workbench 5.2.29 CE\modules\wba_monitor_be.py", line 191, in __init__
    self.remote_admin_enabled = int(self.settings.serverInfo["remoteAdmin"]) != 0
AttributeError: ServerProfile instance has no attribute 'serverInfo'

How to repeat:
Create new server instance to remote machine.
Select 'SSH login based management', operating system: Windows.

Error occurs when trying to connect to this instance
[24 Oct 2010 19:43] Peter Laursen
Do you have Cygwin-SSH (or another SSH implementation for Windows) installed on the remote Win2003 instance?

Peter
(not a MySQL person)
[25 Oct 2010 5:52] Marek Mialkowski
Yes, I have Cygwin-SSH on Win2003
[26 Oct 2010 13:04] Greg Thomas
I'm seeing the exact same behaviour with 5.2.29 CE on Win7 32bit, talking to MySQL 5.1.40 on Win2003 32 bit.
[28 Oct 2010 22:04] Alfredo Kojima
Please attach your connections.xml file, located in your user's configuration data folder for Workbench.
Also, try creating a new profile to connect to your server, instead of the existing one.
[29 Oct 2010 16:21] Marek Mialkowski
connections.xml

Attachment: connections.xml (text/xml), 1.01 KiB.

[29 Oct 2010 16:22] Marek Mialkowski
I tried creating new profile. It still doesn't work.
[16 Nov 2010 14:17] Maksym Yehorov
The bug is fixed.
[16 Nov 2010 15:45] jens bald
in which version, it's not running with 5.2.29 CE Revision 6756
[17 Nov 2010 10:33] Greg Thomas
I can confirm that it's also not working for me, running with 5.2.29 CE Revision 6756 on Win7 32bit.
[18 Nov 2010 21:35] Johannes Taxacher
fix confirmed in repository
[24 Nov 2010 16:37] Tony Bedford
An entry has been added to the 5.2.30 changelog:

When an attempt was made to connect to a server via SSH, the following error message was generated after entering the password:

AttributeError: ServerProfile instance has no attribute 'serverInfo'
[25 Nov 2010 7:18] jens bald
5.2.30 --> It works !!!