Bug #62600 SSH connection problem
Submitted: 2 Oct 2011 13:06 Modified: 12 Dec 2011 14:49
Reporter: Carsten Demmrich Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.35 CE Revision 7915 OS:Windows
Assigned to: CPU Architecture:Any
Tags: ssh

[2 Oct 2011 13:06] Carsten Demmrich
Description:
The MySQL Worbench is running on Window Vista 32 bit.
The same problem have I on Window 7 Ultimate 64 bit with MySQl Workbench 5.2.31 CE Revision 7115.

I can´t connect with mysql server over SSH. The mysql server (5.1.54-ubuntu4) is running on Ubuntu Desktop 11.04.
The rsa key was generated on ubuntu server. I have than the rsa private key exported on window pc. Over puttygen have I created the putty private key. With this key can I than with putty connect to ubuntu. SSH is then successful installed.
Only the workbench can´t connect with server. I use the same private rsa key file.
The error message is: Could not establish SSH connection: Bad authenication type (allowed_types=['publickey'])

How to repeat:
Create new server instance.
 Selection: Remote Host. Enter IP and next
 Connection Method: Standard TCP/IP. I do not enter password for user. than next.
 It´s rigth. I can´t connect to server. Than next.

Selectin: SSH login based management. 
 Operating System: Linux
 MySql Installation Type: Ubuntu Linux(MySQL Package)
Than next.

Check "Authenticate Using SSH Key"
And now use I the private rsa key file.
Than next.

MySQL Workbench can´t connect with server.
[3 Oct 2011 15:59] Armando Lopez Valencia
Hello Carsten.
Please try with the private key that you generated in Ubuntu, not the one that you generated with putty, that will allow you to connect.
Please let us know your results.
Thanks.
[4 Oct 2011 21:06] Carsten Demmrich
Sorry. This was a mistake. I have used the generated private rsa key from ubuntu.
With this key can´t I connect with mysql server.
[5 Oct 2011 17:53] Carsten Demmrich
Sorry. This was a mistake. I have used the generated private rsa key
from ubuntu.
With this key can´t I connect with mysql server.
[12 Dec 2011 14:49] Armando Lopez Valencia
Closing defect.
Thanks a lot for your report Carsten, please let us know if you find anything else.