connect to Mysql using ssh tunnel with user/password

Avatar
Permanently deleted user
创建于

I'm trying to connect to our MySQL database via SSH tunnel and every time I'm getting
SSH: Auth cancel
with the same credentials I can login successfully on HeidiSQL and MySqlWorkbench.

Votes

0

分享

6 条评论
Avatar
Permanently deleted user
创建于

Hello,

What PhpStorm version do you use?

What auth type you have in sshd_config?

0
Avatar
Permanently deleted user
创建于

I'm using PhpStorm 2017.1.4
I'm not sure which sshd_config it's using.
I have installed PhpStorm 2017.1.4 on Windows 7.

0
Avatar
Dmitry Tronin
创建于

What auth type do you have in SSH/SSL tab of database connection: password or key pair? Could you please try to reproduce this error once again and upload idea.log somewhere so we could take a look at it?

0
Avatar
Permanently deleted user
创建于

What auth type do you have in SSH/SSL tab of database connection: password or key pair?
I have user/password
Could you please try to reproduce this error once again and upload idea.log somewhere so we could take a look at it?
for security reasons I changed remote IP with *.*.*.*

2017-05-24 11:19:10,505 [1740761]   INFO - lij.diagnostic.DebugLogManager - Set DEBUG for the following categories: com.jetbrains.php, com.jetbrains.plugins.webDeployment
2017-05-24 11:19:15,600 [1745856]  DEBUG - m.jetbrains.php.run.PhpRunUtil - PHP home is not specified or invalid.
2017-05-24 11:19:20,184 [1750440]  DEBUG - m.jetbrains.php.run.PhpRunUtil - PHP home is not specified or invalid.
2017-05-24 11:20:41,637 [1831893]  DEBUG - ins.plugins.webDeployment.sftp - Connecting to *.*.*.* port 22
2017-05-24 11:20:41,639 [1831895]  DEBUG - ins.plugins.webDeployment.sftp - Connection established
2017-05-24 11:20:41,650 [1831906]  DEBUG - ins.plugins.webDeployment.sftp - Remote version string: SSH-2.0-OpenSSH_6.6.1_hpn13v11 FreeBSD-20140420
2017-05-24 11:20:41,650 [1831906]  DEBUG - ins.plugins.webDeployment.sftp - Local version string: SSH-2.0-JSCH-0.1.54
2017-05-24 11:20:41,650 [1831906]  DEBUG - ins.plugins.webDeployment.sftp - CheckCiphers: aes256-ctr,aes192-ctr,aes128-ctr,aes256-cbc,aes192-cbc,aes128-cbc,3des-ctr,arcfour,arcfour128,arcfour256
2017-05-24 11:20:41,651 [1831907]  DEBUG - ins.plugins.webDeployment.sftp - aes256-ctr is not available.
2017-05-24 11:20:41,651 [1831907]  DEBUG - ins.plugins.webDeployment.sftp - aes192-ctr is not available.
2017-05-24 11:20:41,651 [1831907]  DEBUG - ins.plugins.webDeployment.sftp - aes256-cbc is not available.
2017-05-24 11:20:41,651 [1831907]  DEBUG - ins.plugins.webDeployment.sftp - aes192-cbc is not available.
2017-05-24 11:20:41,651 [1831907]  DEBUG - ins.plugins.webDeployment.sftp - CheckKexes: diffie-hellman-group14-sha1,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521
2017-05-24 11:20:41,652 [1831908]  DEBUG - m.jetbrains.php.run.PhpRunUtil - PHP home is not specified or invalid.
2017-05-24 11:20:41,682 [1831938]  DEBUG - ins.plugins.webDeployment.sftp - CheckSignatures: ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - SSH_MSG_KEXINIT sent
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - SSH_MSG_KEXINIT received
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server: curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,ssh-ed25519
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server: aes128-ctr,aes192-ctr,aes256-ctr,arcfour256,arcfour128,aes128-gcm@openssh.com,aes256-gcm@openssh.com,chacha20-poly1305@openssh.com,aes128-cbc,3des-cbc,blowfish-cbc,cast128-cbc,aes192-cbc,aes256-cbc,arcfour,rijndael-cbc@lysator.liu.se
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server: aes128-ctr,aes192-ctr,aes256-ctr,arcfour256,arcfour128,aes128-gcm@openssh.com,aes256-gcm@openssh.com,chacha20-poly1305@openssh.com,aes128-cbc,3des-cbc,blowfish-cbc,cast128-cbc,aes192-cbc,aes256-cbc,arcfour,rijndael-cbc@lysator.liu.se
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server: hmac-md5-etm@openssh.com,hmac-sha1-etm@openssh.com,umac-64-etm@openssh.com,umac-128-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-ripemd160-etm@openssh.com,hmac-sha1-96-etm@openssh.com,hmac-md5-96-etm@openssh.com,hmac-md5,hmac-sha1,umac-64@openssh.com,umac-128@openssh.com,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-ripemd160@openssh.com,hmac-sha1-96,hmac-md5-96
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server: hmac-md5-etm@openssh.com,hmac-sha1-etm@openssh.com,umac-64-etm@openssh.com,umac-128-etm@openssh.com,hmac-sha2-256-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-ripemd160-etm@openssh.com,hmac-sha1-96-etm@openssh.com,hmac-md5-96-etm@openssh.com,hmac-md5,hmac-sha1,umac-64@openssh.com,umac-128@openssh.com,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-ripemd160@openssh.com,hmac-sha1-96,hmac-md5-96
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server: none,zlib@openssh.com
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server: none,zlib@openssh.com
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server:  
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: server:  
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: client: diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,diffie-hellman-group-exchange-sha1,diffie-hellman-group-exchange-sha256
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: client: ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: client: aes128-ctr,aes128-cbc,3des-ctr,3des-cbc,blowfish-cbc
2017-05-24 11:20:41,683 [1831939]  DEBUG - ins.plugins.webDeployment.sftp - kex: client: aes128-ctr,aes128-cbc,3des-ctr,3des-cbc,blowfish-cbc
2017-05-24 11:20:41,684 [1831940]  DEBUG - ins.plugins.webDeployment.sftp - kex: client: hmac-md5,hmac-sha1,hmac-sha2-256,hmac-sha1-96,hmac-md5-96
2017-05-24 11:20:41,684 [1831940]  DEBUG - ins.plugins.webDeployment.sftp - kex: client: hmac-md5,hmac-sha1,hmac-sha2-256,hmac-sha1-96,hmac-md5-96
2017-05-24 11:20:41,684 [1831940]  DEBUG - ins.plugins.webDeployment.sftp - kex: client: none
2017-05-24 11:20:41,684 [1831940]  DEBUG - ins.plugins.webDeployment.sftp - kex: client: none
2017-05-24 11:20:41,684 [1831940]  DEBUG - ins.plugins.webDeployment.sftp - kex: client:  
2017-05-24 11:20:41,684 [1831940]  DEBUG - ins.plugins.webDeployment.sftp - kex: client:  
2017-05-24 11:20:41,684 [1831940]  DEBUG - ins.plugins.webDeployment.sftp - kex: server->client aes128-ctr hmac-md5 none
2017-05-24 11:20:41,684 [1831940]  DEBUG - ins.plugins.webDeployment.sftp - kex: client->server aes128-ctr hmac-md5 none
2017-05-24 11:20:41,687 [1831943]  DEBUG - ins.plugins.webDeployment.sftp - SSH_MSG_KEXDH_INIT sent
2017-05-24 11:20:41,687 [1831943]  DEBUG - ins.plugins.webDeployment.sftp - expecting SSH_MSG_KEXDH_REPLY
2017-05-24 11:20:41,694 [1831950]  DEBUG - ins.plugins.webDeployment.sftp - ssh_rsa_verify: signature true
2017-05-24 11:20:41,694 [1831950]   WARN - ins.plugins.webDeployment.sftp - Permanently added '*.*.*.*' (RSA) to the list of known hosts.
2017-05-24 11:20:41,694 [1831950]  DEBUG - ins.plugins.webDeployment.sftp - SSH_MSG_NEWKEYS sent
2017-05-24 11:20:41,695 [1831951]  DEBUG - ins.plugins.webDeployment.sftp - SSH_MSG_NEWKEYS received
2017-05-24 11:20:41,695 [1831951]  DEBUG - ins.plugins.webDeployment.sftp - SSH_MSG_SERVICE_REQUEST sent
2017-05-24 11:20:41,695 [1831951]  DEBUG - ins.plugins.webDeployment.sftp - SSH_MSG_SERVICE_ACCEPT received
2017-05-24 11:20:41,699 [1831955]  DEBUG - ins.plugins.webDeployment.sftp - Authentications that can continue: publickey,keyboard-interactive,password
2017-05-24 11:20:41,699 [1831955]  DEBUG - ins.plugins.webDeployment.sftp - Next authentication method: publickey
2017-05-24 11:20:41,699 [1831955]  DEBUG - ins.plugins.webDeployment.sftp - Authentications that can continue: keyboard-interactive,password
2017-05-24 11:20:41,699 [1831955]  DEBUG - ins.plugins.webDeployment.sftp - Next authentication method: keyboard-interactive
2017-05-24 11:20:41,708 [1831964]  DEBUG - ins.plugins.webDeployment.sftp - Login trials exceeds 1
2017-05-24 11:20:41,708 [1831964]  DEBUG - ins.plugins.webDeployment.sftp - Disconnecting from *.*.*.* port 22
2017-05-24 11:20:41,717 [1831973]   WARN - lij.database.util.ErrorHandler - SSH: Auth cancel
com.intellij.execution.ExecutionException: SSH: Auth cancel
    at com.intellij.execution.rmi.RemoteProcessSupport.acquire(RemoteProcessSupport.java:159)
    at com.intellij.database.console.JdbcDriverManagerImpl.getDriver(JdbcDriverManagerImpl.java:116)
    at com.intellij.database.dataSource.DatabaseConnectionManager.lambda$getConnection$2(DatabaseConnectionManager.java:104)
    at com.intellij.database.dataSource.AsyncUtil.lambda$null$4(AsyncUtil.java:44)
    at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$9(AsyncUtil.java:98)
    at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$10(AsyncUtil.java:104)
    at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:508)
    at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:66)
    at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:104)
    at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:98)
    at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$5(AsyncUtil.java:44)
    at java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:981)
    at java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2124)
    at java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:110)
    at com.intellij.database.dataSource.DatabaseConnectionManager.getConnection(DatabaseConnectionManager.java:101)
    at com.intellij.database.dataSource.DatabaseConnectionManager.getConnection(DatabaseConnectionManager.java:93)
    at com.intellij.database.dataSource.DatabaseConnectionManager$JdbcOperationExecutor.async(DatabaseConnectionManager.java:283)
    at com.intellij.database.dataSource.DatabaseConnectionManager.performJdbcOperationAsync(DatabaseConnectionManager.java:251)
    at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor.refresh(DataSourceSyncManager.java:176)
    at com.intellij.database.dataSource.AsyncUtil.lambda$supplyAsync$8(AsyncUtil.java:93)
    at com.intellij.database.dataSource.AsyncUtil.lambda$null$4(AsyncUtil.java:44)
    at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$9(AsyncUtil.java:98)
    at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$10(AsyncUtil.java:104)
    at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:556)
    at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:501)
    at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:66)
    at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:104)
    at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:98)
    at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$5(AsyncUtil.java:44)
    at java.util.concurrent.CompletableFuture.uniCompose(CompletableFuture.java:952)
    at java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:926)
    at java.util.concurrent.CompletableFuture$Completion.run(CompletableFuture.java:442)
    at com.intellij.openapi.application.impl.ApplicationImpl$2.run(ApplicationImpl.java:334)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
2017-05-24 11:20:51,829 [1842085]  DEBUG - m.jetbrains.php.run.PhpRunUtil - PHP home is not specified or invalid.
2017-05-24 11:21:00,352 [1850608]   INFO - ide.actions.ShowFilePathAction -
Exit code 1

0
Avatar
Permanently deleted user
创建于

From the log we can see that SSH server is configured for "keyboard-interactive" auth type.

We already have a related request submitted to our tracker here: <https://youtrack.jetbrains.com/issue/DBE-3241>. Please vote for it (thumb up button) in order to move it up in the queue and receive notifications regarding the progress of the issue. See more information on working with tracker at <https://intellij-support.jetbrains.com/hc/en-us/articles/207241135-How-to-follow-YouTrack-issues-and-receive-notifications>.

0
Avatar
Permanently deleted user
创建于

Thanks for your response! I'll vote surely.

0

请先登录再写评论。