connect via ssh issue

stanley · Post by **stanley** » Mon 24 Jan 2011 10:52

hello
when I try to connect via ssh it says me 'authorization failed'. username and password are definitely correct and i can connect to server with an ordinary ssh client (putty in this case).
where might be a problem?

.jp · Post by **.jp** » Mon 24 Jan 2011 11:32

Alas, we could not reproduce this problem, so we need some additional information.
1. Please specify the type (OpenSSH or ssh-win32 or another) of your SSH server.
2. What is the encoding of your username and password?

stanley · Post by **stanley** » Wed 09 Feb 2011 07:19

1. openssh on linux (ubuntu)
2. hmm... how could i check it? at least both username and password are from <128 area, no any national but only pure latin symbols.
ubuntu uses utf-8 while windows uses win-1251 encoding.

.jp · Post by **.jp** » Thu 10 Feb 2011 11:11

Please tell us the following information to help us reproduce this error:
1. Please send us the complete text of the error message.
2. Can you establish a connection if you set only the parameters on the General tab? When establishing SSH connection, you should set the General tab parameters too.

Probably, you receive the "User authentication failed?" message. If you want to use password authentication, you need to enable this authentication on the server.
To enable it, you should add a "PasswordAuthentication yes" line to the sshd_config(\Program Files\NetworkSimplicity\ssh\). If you have a "PasswordAuthentication no" line in this file, replace it with "PasswordAuthentication yes".

Also take look at dbForge Studio's documentation articles:
How To: Install and Set Up SSH Server
and
How To: Create SSH Connection

Have you managed to establish a connection successfully?

stanley · Post by **stanley** » Thu 10 Feb 2011 12:00

.jp wrote:Please tell us the following information to help us reproduce this error:
1. Please send us the complete text of the error message.
2. Can you establish a connection if you set only the parameters on the General tab? When establishing SSH connection, you should set the General tab parameters too.

Probably, you receive the "User authentication failed?" message.

right, the exact msg is

Can't connect to SSH server on 'stanley.winlink.ru':
User authentication failed.

If you want to use password authentication, you need to enable this authentication on the server.
To enable it, you should add a "PasswordAuthentication yes" line to the sshd_config(\Program Files\NetworkSimplicity\ssh\). If you have a "PasswordAuthentication no" line in this file, replace it with "PasswordAuthentication yes".

hmm... as I noted above I CAN connect to sshd using pass auth:

Code: Select all

login as: romb
[email protected]'s password:
Linux hshs 2.6.35-26-generic #46-Ubuntu SMP Sun Jan 30 06:59:07 UTC 2011 x86_64 GNU/Linux
Ubuntu 10.10

Welcome to Ubuntu!
 * Documentation:  https://help.ubuntu.com/

Last login: Thu Feb 10 14:41:41 2011 from nat-pool4-156.solvo.ru
romb@hshs:~$

server's config near auth statement:

Code: Select all

romb@hshs:~$ cat /etc/ssh/sshd_config
# Package generated configuration file
# See the sshd_config(5) manpage for details
......
# Change to no to disable tunnelled clear text passwords
#PasswordAuthentication yes
......

PasswordAuthentication yes is the default behavior afaik.
btw, all these citations are from ssh session

Also take look at dbForge Studio's documentation articles:
How To: Install and Set Up SSH Server
and
How To: Create SSH Connection

Have you managed to establish a connection successfully?

I've read docs. they contain nothing except how to fill general tab options... how could I attach screenshot?

.jp · Post by **.jp** » Thu 10 Feb 2011 12:39

I've read docs. they contain nothing except how to fill general tab options...

Provide full version of dbForge Studio for MySQL you are using, please.

stanley · Post by **stanley** » Thu 10 Feb 2011 14:43

4.50.313.1 russian edition

.jp · Post by **.jp** » Fri 11 Feb 2011 11:15

You may attach an image with help:

Code: Select all

http://imageshack.us/

Then specify the URL of the image at our forum. For example:

Code: Select all

[img]http://some_image_server.com/your_picture.jpg[/img]

Actually, such error usually occurs if the parameters on the first tab of the connection editor were not set or were set incorrectly.
To establish an SSH connection you should set the General tab parameters too.

stanley · Post by **stanley** » Mon 14 Feb 2011 11:49

checking ssh connection

.jp · Post by **.jp** » Mon 14 Feb 2011 13:55

1. Have you set the connection parameters on the General tab of the Connection Editor dialog box for your SSH connection? If not, you have to set them. (On the General tab set login information required to connect to the MySQL Server. It should be set relatively to the SSH Server. Specify the following:
Host - the name of the MySQL Server host. If SSH and MySQL Servers are on the same machine, the host name can be localhost.
Port - the TCP/IP port to connect to the MySQL Server. By default, it is 3306.
User - the name of the user account on the MySQL Server, it can be root.
Password - the password of the user account on the MySQL Server.)
Also please attach a screenshot shows the content of the General tab.

2. The Interactive mode check box is selected on the screenshot. Is authentication in interactive mode set on your server? If not, clear this check box and try establishing a connection again.

stanley · Post by **stanley** » Tue 15 Feb 2011 09:08

1

2
when interactive mode is off

.jp · Post by **.jp** » Wed 16 Feb 2011 08:25

In the first case (when you uploaded a screenshot illustrating an attempt to connect in the interactive mode for the first time) authentication fails because the SSH server doesn't allow keyboard-interactive.

In the second case (when you uploaded two screenshots), it's likely that connection to the SSH server was established, but the specified MySQL server host or port was incorrect (please try using IP Address explicitly and explicitly specify the port instead of localhost).

Also please check if you can connect to the SSH server in the password mode and after that change the username to a non-existent one (on the Security tab of the Database Connection Properties window), and in this case a user should get the "Authentification failed" message instead of the "Server did not respond... " one – it's a guarantee that there is no problem with SSH authentication in the second case (on those attached screenshots), but the problem is that host and/or MySQL server port was specified incorrectly.

stanley · Post by **stanley** » Wed 16 Feb 2011 09:09

bingo!

setting ip instead of localhost solves the problem. probably because of mysqld binding, I'll check it later.

anyway, the message concerning failed ssh connection is a bit messing, don't you think that?

thanks for your help.

.jp · Post by **.jp** » Wed 16 Feb 2011 10:09

setting ip instead of localhost solves the problem.

The question with specifying localhost or IP address depends on the Linux server configuration, there are no such problems for Windows server.

anyway, the message concerning failed ssh connection is a bit messing, don't you think that?

In the first case (when the "Authentification failed" message is displayed) MySQL throws an error without explaining reasons of the error, i.e. neither dbForge, nor user understands which information that was entered was wrong. We cannot do anything about this until MySQL gives more detailed messages.

In the second case (when the "Server did not respond... " message is displayed) we generate the message text ourselves, and, as you've noticed correctly for this very case, the message was generalized and no details were specified. I've added this to our bugtracker as a bug and it may be fixed in the nearest builds.

Kindly let us know if you have any other issues or questions regarding the product, we'll like to help.