Resolved : SSH Auth failure on PHPStorm
I have successfully connected to remote DBs using SSH tunnels for a year with PHPStorm so I know the connection settings are correct but recently that has stopped working. I have multiple SSH DB connections with different SSH keys and they are all broken, plus I have tested the SSH connection from the terminal so I know it is not the individual keys. For now I have resorted to using the open source MysqlWorkBench but this is not ideal flipping back and forth and it means I can't run Sql queries within PHP files which is one of the nice features of PHPStorm. Here is the error logs
Caused by: java.lang.RuntimeException: com.intellij.execution.ExecutionException: SSH: USERAUTH fail
at com.intellij.util.ExceptionUtil.rethrowAllAsUnchecked(ExceptionUtil.java:186)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.createInner(DatabaseConnectionManager.java:346)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.lambda$sync$2(DatabaseConnectionManager.java:300)
at com.intellij.database.dataSource.AsyncUtil.withAsyncFriendly(AsyncUtil.java:163)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.sync(DatabaseConnectionManager.java:297)
at com.intellij.database.dataSource.DatabaseConnectionManager$Builder.sync(DatabaseConnectionManager.java:111)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$static$1(DataSourceSyncManager.java:39)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor$1.perform(DataSourceSyncManager.java:240)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.updateDatabaseInfo(DatabaseModelLoader.java:288)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.run(DatabaseModelLoader.java:271)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor.performSync(DataSourceSyncManager.java:242)
at com.intellij.database.dataSource.AsyncUtil.lambda$null$6(AsyncUtil.java:54)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$12(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$13(AsyncUtil.java:137)
at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:548)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:493)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:94)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:137)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$7(AsyncUtil.java:54)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
Please sign in to leave a comment.
Please upload the full log after an unsuccessful connection attempt to some sharing service.
Also, please attach screenshots of the General and SSH/SSL tabs of the data source.
Thanks Eugene
will attempt to submit logs in separate message
2017-07-27 10:58:56,657 [ 0] INFO - #com.intellij.idea.Main - ------------------------------------------------------ IDE STARTED ------------------------------------------------------
2017-07-27 10:58:56,664 [ 7] INFO - #com.intellij.util.ui.JBUI - User scale factor: 1.0
2017-07-27 10:58:56,664 [ 7] INFO - #com.intellij.util.ui.JBUI - System scale factor: 1.25 (IDE-managed HiDPI)
2017-07-27 10:58:56,671 [ 14] INFO - #com.intellij.idea.Main - IDE: PhpStorm (build #PS-172.3317.83, 18 Jul 2017 13:56)
2017-07-27 10:58:56,671 [ 14] INFO - #com.intellij.idea.Main - OS: Linux (4.4.0-87-generic, amd64)
2017-07-27 10:58:56,671 [ 14] INFO - #com.intellij.idea.Main - JRE: 1.8.0_152-release-915-b5 (JetBrains s.r.o)
2017-07-27 10:58:56,671 [ 14] INFO - #com.intellij.idea.Main - JVM: 25.152-b5 (OpenJDK 64-Bit Server VM)
2017-07-27 10:58:56,674 [ 17] INFO - #com.intellij.idea.Main - JVM Args: -Xbootclasspath/a:/home/will/Downloads/PhpStorm-171.4694.2/lib/boot.jar -Xms128m -Xmx2000m -XX:ReservedCodeCacheSize=480m -XX:+UseConcMarkSweepGC -XX:SoftRefLRUPolicyMSPerMB=50 -ea -Dsun.io.useCanonCaches=false -Djava.net.preferIPv4Stack=true -XX:+HeapDumpOnOutOfMemoryError -XX:-OmitStackTraceInFastThrow -Dawt.useSystemAAFontSettings=lcd -Dsun.java2d.renderer=sun.java2d.marlin.MarlinRenderingEngine -XX:ErrorFile=/home/will/java_error_in_PHPSTORM_%p.log -XX:HeapDumpPath=/home/will/java_error_in_PHPSTORM.hprof -Didea.paths.selector=PhpStorm2017.2 -Djb.vmOptionsFile=/home/will/.PhpStorm2017.2/config/phpstorm64.vmoptions -Didea.platform.prefix=PhpStorm -Didea.jre.check=true
2017-07-27 10:58:56,674 [ 17] INFO - #com.intellij.idea.Main - ext: /home/will/Downloads/PhpStorm-171.4694.2/jre64/lib/ext: [jfxrt.jar, zipfs.jar, meta-index, jaccess.jar, cldrdata.jar, dnsns.jar, sunec.jar, localedata.jar, sunpkcs11.jar, sunjce_provider.jar, nashorn.jar]
2017-07-27 10:58:56,674 [ 17] INFO - #com.intellij.idea.Main - JNU charset: UTF-8
2017-07-27 10:58:56,685 [ 28] INFO - #com.intellij.idea.Main - JNA library (64-bit) loaded in 11 ms
2017-07-27 10:58:56,977 [ 320] INFO - .intellij.idea.IdeaApplication - WM detected: Compiz
2017-07-27 10:58:57,248 [ 591] INFO - llij.ide.plugins.PluginManager - Cannot find optional descriptor config.xml
2017-07-27 10:58:57,510 [ 853] INFO - llij.ide.plugins.PluginManager - Cannot find optional descriptor uml-properties-support.xml
2017-07-27 10:58:57,510 [ 853] INFO - llij.ide.plugins.PluginManager - Cannot find optional descriptor uml-java-support.xml
2017-07-27 10:58:57,574 [ 917] INFO - llij.ide.plugins.PluginManager - Cannot find optional descriptor yaml-specific.xml
2017-07-27 10:58:57,650 [ 993] INFO - llij.ide.plugins.PluginManager - Cannot find optional descriptor js-nashorn-support.xml
2017-07-27 10:58:57,779 [ 1122] INFO - llij.ide.plugins.PluginManager - Plugin 'EditorConfig' can't be loaded because: Plugin since-build or until-build don't match this product's build number
2017-07-27 10:58:57,861 [ 1204] INFO - llij.ide.plugins.PluginManager - 67 plugins initialized in 666 ms
2017-07-27 10:58:57,862 [ 1205] INFO - llij.ide.plugins.PluginManager - Loaded bundled plugins: ASP (0.1), AngularJS (172.3317.83), Apache config (.htaccess) support (172.3317.83), Behat Support (172.3317.83), Blade Support (172.3317.83), CSS Support (172.3317.83), CVS Integration (11), Codeception Framework (172.3317.83), CoffeeScript (2.0), Command Line Tool Support (172.3317.83), Copyright (8.1), Database Tools and SQL (172.3317.83), Docker integration (3.0.0), Drupal Support (172.3317.83), File Watchers (172.3317.83), GNU GetText files support (*.po) (172.3317.83), Gherkin (999.999), Git Integration (8.1), GitHub (172.3317.83), Google App Engine Support for PHP (172.3317.83), HTML Tools (2.0), Haml (172.3317.83), IDEA CORE (172.3317.83), Ini4Idea (172.3317.83), IntelliLang (8.0), JavaScript Debugger (1.0), JavaScript Intention Power Pack (0.9.4), JavaScript Support (1.0), Joomla! Support (172.3317.83), Less support (172.3317.83), Markdown support (172.3317.83), NodeJS (172.3317.83), PHP (172.3317.83), PHP Docker (172.3317.83), PHP Remote Interpreter (172.3317.83), PHPSpec BDD Framework (172.3317.83), Perforce Integration (2.0), Performance Testing (172.3317.83), Phing Support (172.3317.83), PhpStorm Workshop (172.3317.83), QuirksMode (172.3317.83), REST Client (172.3317.83), ReStructuredText Support (172.3317.83), Refactor-X (2.01), Remote Hosts Access (0.1), SSH Remote Run (0.1), Sass support (172.3317.83), Settings Repository (172.3317.83), Subversion Integration (1.1), Task Management (1.0), Terminal (0.1), TextMate bundles support (172.3317.83), Time Tracking (1.0), Twig Support (172.3317.83), UML Support (1.0), Vagrant (172.3317.83), W3C Validators (2.0), WordPress Support (172.3317.83), XPathView + XSLT Support (4), XSLT-Debugger (1.4), YAML (172.3317.83), hg4idea (10.0), tslint (172.3317.83)
2017-07-27 10:58:57,862 [ 1205] INFO - llij.ide.plugins.PluginManager - Loaded custom plugins: ESLint (1.0.34), IdeaVim (0.48), Php Inspections (EA Extended) (2.3.8.1)
2017-07-27 10:58:57,862 [ 1205] INFO - llij.ide.plugins.PluginManager - Disabled plugins: EditorConfig (171.2613.14)
2017-07-27 10:58:58,241 [ 1584] INFO - ellij.util.io.PagedFileStorage - lower=100; upper=500; buffer=10; max=1946
2017-07-27 10:58:58,289 [ 1632] INFO - pl.local.NativeFileWatcherImpl - Starting file watcher: /home/will/Downloads/PhpStorm-171.4694.2/bin/fsnotifier64
2017-07-27 10:58:58,295 [ 1638] INFO - pl.local.NativeFileWatcherImpl - Native file watcher is operational.
2017-07-27 10:58:58,366 [ 1709] INFO - pi.util.registry.RegistryState - Registry values changed by user:
2017-07-27 10:58:58,366 [ 1709] INFO - pi.util.registry.RegistryState - dumb.aware.run.configurations = true
2017-07-27 10:58:58,366 [ 1709] INFO - pi.util.registry.RegistryState - ide.windowSystem.autoShowProcessPopup = true
2017-07-27 10:58:58,790 [ 2133] INFO - com.intellij.ide.ui.UISettings - Loaded: fontSize=15, fontScale=0.0; restored: fontSize=15, fontScale=1.25
2017-07-27 10:58:59,106 [ 2449] INFO - til.net.ssl.CertificateManager - Default SSL context initialized
2017-07-27 10:58:59,190 [ 2533] INFO - rains.ide.BuiltInServerManager - built-in server started, port 63342
2017-07-27 10:58:59,228 [ 2571] INFO - gs.impl.UpdateCheckerComponent - channel: release
2017-07-27 10:58:59,324 [ 2667] INFO - il.indexing.FileBasedIndexImpl - Index exts enumerated:38
2017-07-27 10:58:59,328 [ 2671] INFO - il.indexing.FileBasedIndexImpl - Index scheduled:3
2017-07-27 10:58:59,353 [ 2696] INFO - tellij.psi.stubs.StubIndexImpl - All stub exts enumerated:17
2017-07-27 10:58:59,353 [ 2696] INFO - tellij.psi.stubs.StubIndexImpl - stub exts update scheduled:0
2017-07-27 10:58:59,474 [ 2817] INFO - j.ide.script.IdeStartupScripts - 0 startup script(s) found
2017-07-27 10:58:59,736 [ 3079] INFO - plication.impl.ApplicationImpl - 82 application components initialized in 2546ms
2017-07-27 10:58:59,739 [ 3082] INFO - .intellij.idea.IdeaApplication - App initialization took 3794 ms
2017-07-27 10:58:59,898 [ 3241] INFO - pl$FileIndexDataInitialization - Initialization done:569
2017-07-27 10:59:00,100 [ 3443] INFO - exImpl$StubIndexInitialization - Initialization done:201
2017-07-27 10:59:00,422 [ 3765] INFO - ction.BrowserConnectionManager - Browser connected: version 2.0.9, Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/59.0.3071.109 Chrome/59.0.3071.109 Safari/537.36
2017-07-27 10:59:01,490 [ 4833] INFO - com.intellij.ide.ui.UISettings - Loaded: fontSize=12, fontScale=1.0; restored: fontSize=15, fontScale=1.25
2017-07-27 10:59:01,490 [ 4833] INFO - com.intellij.ide.ui.UISettings - Loaded: fontSize=15, fontScale=1.25; restored: fontSize=15, fontScale=1.25
2017-07-27 10:59:01,839 [ 5182] INFO - .openapi.application.Preloader - Finished preloading com.intellij.openapi.actionSystem.impl.ActionPreloader@5be1cc62
2017-07-27 10:59:02,216 [ 5559] INFO - ellij.project.impl.ProjectImpl - 116 project components initialized in 1404 ms
2017-07-27 10:59:02,517 [ 5860] INFO - le.impl.ModuleManagerComponent - 1 module(s) loaded in 300 ms
2017-07-27 10:59:02,760 [ 6103] INFO - ellij.project.impl.ProjectImpl - 19 project components initialized in 23 ms
2017-07-27 10:59:02,765 [ 6108] INFO - .openapi.application.Preloader - Finished preloading com.intellij.ide.ui.search.SearchableOptionPreloader@31ee314a
2017-07-27 10:59:03,453 [ 6796] INFO - .openapi.application.Preloader - Finished preloading com.intellij.codeInsight.completion.CompletionPreloader@20c3f9de
2017-07-27 10:59:03,548 [ 6891] WARN - om.intellij.util.ProfilingUtil - Profiling agent is not enabled. Add -agentlib:yjpagent to idea.vmoptions if necessary to profile IDEA.
2017-07-27 10:59:04,048 [ 7391] INFO - PerformancePlugin - Performance Plugin is in silent mode
2017-07-27 10:59:06,934 [ 10277] INFO - tartup.impl.StartupManagerImpl - OpenFilesActivity run in 2117ms under project opening modal progress
2017-07-27 10:59:08,861 [ 12204] INFO - tartup.impl.StartupManagerImpl - JsbtStartupActivity run in 1830ms under project opening modal progress
2017-07-27 10:59:08,910 [ 12253] INFO - .diagnostic.PerformanceWatcher - Post-startup activities under progress took 4116ms; general responsiveness: ok; EDT responsiveness: 0/4 sluggish, 2/4 very slow
2017-07-27 10:59:10,254 [ 13597] INFO - .diagnostic.PerformanceWatcher - Pushing properties took 5351ms; general responsiveness: ok; EDT responsiveness: 0/5 sluggish, 3/5 very slow
2017-07-27 10:59:11,887 [ 15230] INFO - tartup.impl.StartupManagerImpl - /home/will/Code/fli/fl-gaf/.idea case-sensitivity: expected=true actual=true
2017-07-27 10:59:12,331 [ 15674] INFO - ServersWorkspaceStateComponent - Replacing existing server with the shared one with the same id
2017-07-27 10:59:14,337 [ 17680] INFO - tor.impl.FileEditorManagerImpl - Project opening took 13778 ms
2017-07-27 10:59:16,549 [ 19892] INFO - .diagnostic.PerformanceWatcher - Indexable file iteration took 6293ms; general responsiveness: ok; EDT responsiveness: 4/7 sluggish, 3/7 very slow
2017-07-27 10:59:16,550 [ 19893] INFO - indexing.UnindexedFilesUpdater - Unindexed files update started: 1 files to update
2017-07-27 10:59:16,798 [ 20141] INFO - .diagnostic.PerformanceWatcher - Unindexed files update took 248ms; general responsiveness: ok; EDT responsiveness: ok
2017-07-27 10:59:16,995 [ 20338] INFO - tartup.impl.StartupManagerImpl - Some post-startup activities freeze UI for noticeable time. Please consider making them DumbAware to do them in background under modal progress, or just making them faster to speed up project opening.
2017-07-27 10:59:16,995 [ 20338] INFO - tartup.impl.StartupManagerImpl - ProjectInspectionProfileStartUpActivity run in 153ms on UI thread
2017-07-27 10:59:20,139 [ 23482] INFO - .diagnostic.PerformanceWatcher - Pushing properties took 948ms; general responsiveness: ok; EDT responsiveness: ok
2017-07-27 10:59:20,178 [ 23521] INFO - .diagnostic.PerformanceWatcher - Indexable file iteration took 39ms; general responsiveness: ok; EDT responsiveness: ok
2017-07-27 10:59:20,984 [ 24327] INFO - tellij.xml.Html5SchemaProvider - HTML5_SCHEMA_LOCATION = /home/will/Downloads/PhpStorm-171.4694.2/lib/phpstorm.jar!/resources/html5-schema/html5.rnc
2017-07-27 10:59:20,984 [ 24327] INFO - tellij.xml.Html5SchemaProvider - XHTML5_SCHEMA_LOCATION = /home/will/Downloads/PhpStorm-171.4694.2/lib/phpstorm.jar!/resources/html5-schema/xhtml5.rnc
2017-07-27 10:59:20,984 [ 24327] INFO - tellij.xml.Html5SchemaProvider - CHARS_DTD_LOCATION = /home/will/Downloads/PhpStorm-171.4694.2/lib/phpstorm.jar!/resources/html5-schema/html5chars.ent
2017-07-27 11:04:34,256 [ 337599] WARN - ins.plugins.webDeployment.sftp - Permanently added 'wmelbourne.syd1.fln-dev.net' (RSA) to the list of known hosts.
2017-07-27 11:04:35,184 [ 338527] WARN - lij.database.util.ErrorHandler - java.lang.RuntimeException: com.intellij.execution.ExecutionException: SSH: USERAUTH fail
java.util.concurrent.CompletionException: java.lang.RuntimeException: com.intellij.execution.ExecutionException: SSH: USERAUTH fail
at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273)
at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:280)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1592)
at com.intellij.openapi.application.impl.ApplicationImpl$2.run(ApplicationImpl.java:343)
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)
Caused by: java.lang.RuntimeException: com.intellij.execution.ExecutionException: SSH: USERAUTH fail
at com.intellij.util.ExceptionUtil.rethrowAllAsUnchecked(ExceptionUtil.java:186)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.createInner(DatabaseConnectionManager.java:346)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.lambda$sync$2(DatabaseConnectionManager.java:300)
at com.intellij.database.dataSource.AsyncUtil.withAsyncFriendly(AsyncUtil.java:163)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.sync(DatabaseConnectionManager.java:297)
at com.intellij.database.dataSource.DatabaseConnectionManager$Builder.sync(DatabaseConnectionManager.java:111)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$static$1(DataSourceSyncManager.java:39)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor$1.perform(DataSourceSyncManager.java:240)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.updateDatabaseInfo(DatabaseModelLoader.java:288)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.run(DatabaseModelLoader.java:271)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor.performSync(DataSourceSyncManager.java:242)
at com.intellij.database.dataSource.AsyncUtil.lambda$null$6(AsyncUtil.java:54)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$12(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$13(AsyncUtil.java:137)
at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:548)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:493)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:94)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:137)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$7(AsyncUtil.java:54)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
... 6 more
Caused by: com.intellij.execution.ExecutionException: SSH: USERAUTH fail
at com.intellij.execution.rmi.RemoteProcessSupport.acquire(RemoteProcessSupport.java:159)
at com.intellij.database.console.JdbcDriverManagerImpl.getDriver(JdbcDriverManagerImpl.java:117)
at com.intellij.database.dataSource.DatabaseConnectionEstablisher.lambda$establishConnection$1(DatabaseConnectionEstablisher.java:56)
at com.intellij.database.dataSource.AsyncUtil.lambda$null$4(AsyncUtil.java:48)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$12(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$13(AsyncUtil.java:137)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:500)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:94)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:137)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$5(AsyncUtil.java:48)
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:380)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.createInner(DatabaseConnectionManager.java:320)
... 25 more
That's not likely, but maybe this is caused by faulty passwords saving.
Please navigate to the SSH/SSL tab, enter the keyphrase once again and click "Test Connection". Does it succeed?
hmm, I have tried that multiple times but no luck. I also tried running PHPStorm as super user (sudo) and no luck there either.
I also tried creating new project data sources but that didn't work either.
Hi,
How exactly login procedure works? Is there a two-step authentication?
Hey
I use an SSH tunnel to login. I have this working on a different machine now so must be something wrong with my setup. Thanks for the help though