ExecutionException: SSH: Auth fail

Hi,

Could you provide your datasource SSH settings screen shot?

Thank you.

Thanks

I have the same problem

Same problem. DataGrip is not usable because of this

@vasily chernov ssh tunnels fail since 2016. Why is this such a problem to fix them? Simple and free sequel pro has no a single issue with this.

@Terion Hi,

Enhanced SSH functionality will be available in DataGrip 2017.3.
Thank you.

@vasily chernov

2017.3 is out

weeeell.... stack trace is now shorter. big progress

@Terion Hi,

Could you attach full IDE log? Do you ssh agent?

Thank you.

Same problem.

DataGrip 2017.3.3
Build #DB-173.4127.18, built on December 19, 2017
Licensed to DataGrip Evaluator
Expiration date: January 26, 2018
JRE: 1.8.0_152-release-1024-b8 x86_64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Mac OS X 10.13.2

I use ssh-agent.

com.jcraft.jsch.JSchException: Auth cancel
 at com.jcraft.jsch.Session.connect(Session.java:518)
 at com.jcraft.jsch.Session.connect(Session.java:183)
 at com.intellij.ssh.SshConnectionUtil.createSshSession(SshConnectionUtil.kt:143)
 at com.intellij.ssh.impl.SshConnection.a(SshConnection.kt:84)
 at com.intellij.ssh.impl.SshConnection.getSshSession(SshConnection.kt:73)
 at com.intellij.ssh.SshConnectionService.connect(SshConnectionService.kt:136)
 at com.intellij.ssh.Ssh.a(ssh.kt:204)
 at com.intellij.ssh.Ssh.access$connect(ssh.kt:1)
 at com.intellij.ssh.ConnectionBuilder.connect(ssh.kt:87)
 at com.intellij.database.dataSource.DataSourceSshTunnelConfiguration.createSshSession(DataSourceSshTunnelConfiguration.java:211)
 at com.intellij.database.dataSource.DataSourceSshTunnelConfiguration.createTunnel(DataSourceSshTunnelConfiguration.java:141)
 at com.intellij.database.console.JdbcDriverManagerImpl.createTunnel(JdbcDriverManagerImpl.java:177)
 at com.intellij.database.console.JdbcDriverManagerImpl.access$000(JdbcDriverManagerImpl.java:35)
 at com.intellij.database.console.JdbcDriverManagerImpl$1.getRunProfileState(JdbcDriverManagerImpl.java:78)
 at com.intellij.database.console.JdbcDriverManagerImpl$1.getRunProfileState(JdbcDriverManagerImpl.java:44)
 at com.intellij.execution.rmi.RemoteProcessSupport.a(RemoteProcessSupport.java:213)
 at com.intellij.execution.rmi.RemoteProcessSupport.acquire(RemoteProcessSupport.java:143)
 at com.intellij.database.console.JdbcDriverManagerImpl.getDriver(JdbcDriverManagerImpl.java:128)
 at com.intellij.database.dataSource.DatabaseConnectionEstablisher.lambda$establishConnection$1(DatabaseConnectionEstablisher.java:56)
 at com.intellij.database.dataSource.AsyncUtil.lambda$null$4(AsyncUtil.java:49)
 at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$14(AsyncUtil.java:127)
 at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:495)
 at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:94)
 at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:133)
 at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:127)
 at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$5(AsyncUtil.java:49)
 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.DatabaseConnectionEstablisher.establishConnection(DatabaseConnectionEstablisher.java:53)
 at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.supplyAsync(DatabaseConnectionManager.java:381)
 at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.createInner(DatabaseConnectionManager.java:321)
 at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.lambda$sync$2(DatabaseConnectionManager.java:301)
 at com.intellij.database.dataSource.AsyncUtil.withAsyncFriendly(AsyncUtil.java:159)
 at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.sync(DatabaseConnectionManager.java:298)
 at com.intellij.database.dataSource.DatabaseConnectionManager$Builder.sync(DatabaseConnectionManager.java:112)
 at com.intellij.database.dataSource.DataSourceSyncManager.lambda$static$1(DataSourceSyncManager.java:39)
 at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor$1.perform(DataSourceSyncManager.java:242)
 at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.updateDatabaseInfo(DatabaseModelLoader.java:283)
 at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.run(DatabaseModelLoader.java:266)
 at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor.performSync(DataSourceSyncManager.java:244)
 at com.intellij.database.dataSource.AsyncUtil.lambda$null$6(AsyncUtil.java:55)
 at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$14(AsyncUtil.java:127)
 at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:543)
 at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:488)
 at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:94)
 at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:133)
 at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:127)
 at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$7(AsyncUtil.java:55)
 at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
 at com.intellij.openapi.application.impl.ApplicationImpl$1.run(ApplicationImpl.java:315)
 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) (no stack trace).
com.intellij.execution.ExecutionException

How to get full IDE log?

By the way. Setting "Auth type" to option "OpenSSH config and authentication agent" helps in my case

@ Pablo Nuñez Hi,

Do you connect with root@159.203.106.23 user? Try with root only.

Thank you.

@vasily chernov

I've already opened a ticket in your bug tracker and already asked you about how to get this log =)

@Terion what is the ticket id?

@Sanders https://youtrack.jetbrains.com/issue/DBE-5649

Our office started getting the `jcraft.jsch.JSchException: Auth fail` exception today. I don't know if this is related to the original poster's problem, but we found re-entering SSH key passwords restored functionality.

Reentering ssh key worked for me as well. Thanks @Mike Heyns!

I ran into this after updating macOS. Re-adding key to ssh-agent worked for me:

ssh-add -K ~/.ssh/id_rsa

Using PyCharm with same error. But as Ben suggested, moving key to ssh-agent, and then modifying settings in PyCharm to use ssh-agent instead of OpenSSH pair worked.

Thanks Ben, re-adding key worked for me.

I have the same problem. I can connect successfully with Putty but couldn't via IntelliJ.

It is ridiculous, I can connect via the terminal coming with IntelliJ by ssh username@host.com, but I could not connect by "Start SSH session" also could not connect via Database explorer. (I am using the option "OpenSSH config and authentication agent")

Stack trace producing from "Start SSH session"

@R Donuk,

Thank you for stack trace.

Do you load your keys into ssh agent?
Could you specify signing algorithm for your ssh keys?

I am having the same issue - is there a resolution for this? 

@Alan Quach,

The same questions for you:

1. Do you load ssh keys into ssh agent?
2. What is ssh keys signing algorithm?

almost 3 years and now I'm downloading fresh datagrip — and still can't connect via ssh tunnel. I have no words, jetbrains. vasily chernov seriously?

Terion,

Could you file an issue in our YouTrack https://youtrack.jetbrains.com/issues/DBE ?

Also, try Auth type OpenSSH config & auth agent

vasily chernov it's there for 2  years already https://youtrack.jetbrains.com/issue/DBE-5649

@Terion,

Could you describe you problems in the issue https://youtrack.jetbrains.com/issue/DBE-5649?

Is it related to ssh passphrase? If it is, follow steps described in https://youtrack.jetbrains.com/issue/IDEA-214583#focus=streamItem-27-3901920.0-0

vasily chernov, Volodymyr Kornilov  in comments in youtrack — that's me