Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SSH Tunneling not working in 19.2 - Overriding the global section with a specific one at line 3: Hos

Guy-OracleNov 27 2019

This works in 19.1 and earlier versions

This stopped working in 19.2 (both Mac OS and Linux, have not tried Windows)

When using SQL Developer 19.2 (Version 19.2.1.247) selecting a connection which uses a SSH Host tunnel results in -

An error occurred while adding the port forward.

Overriding the global section with a specific one at line 3: Host *

java.io.StreamCorruptedException: Overriding the global section with a specific one at line 3: Host *

    at org.apache.sshd.client.config.hosts.HostConfigEntry.readHostConfigEntries(HostConfigEntry.java:864)

    at org.apache.sshd.client.config.hosts.HostConfigEntry.readHostConfigEntries(HostConfigEntry.java:806)

    at org.apache.sshd.client.config.hosts.HostConfigEntry.readHostConfigEntries(HostConfigEntry.java:800)

    at org.apache.sshd.client.config.hosts.HostConfigEntry.readHostConfigEntries(HostConfigEntry.java:788)

    at org.apache.sshd.client.config.hosts.ConfigFileHostEntryResolver.reloadHostConfigEntries(ConfigFileHostEntryResolver.java:105)

    at org.apache.sshd.client.config.hosts.DefaultConfigFileHostEntryResolver.reloadHostConfigEntries(DefaultConfigFileHostEntryResolver.java:85)

    at org.apache.sshd.client.config.hosts.ConfigFileHostEntryResolver.resolveEffectiveResolver(ConfigFileHostEntryResolver.java:90)

    at org.apache.sshd.client.config.hosts.ConfigFileHostEntryResolver.resolveEffectiveHost(ConfigFileHostEntryResolver.java:59)

    at org.apache.sshd.client.SshClient.connect(SshClient.java:464)

    at org.apache.sshd.client.session.ClientSessionCreator.connect(ClientSessionCreator.java:62)

    at org.apache.sshd.client.session.ClientSessionCreator.connect(ClientSessionCreator.java:44)

    at oracle.dbtools.raptor.ssh.core.Client.createSession(Client.java:178)

    at oracle.dbtools.raptor.ssh.core.Client.openConnection(Client.java:288)

    at oracle.dbtools.raptor.ssh.core.Client.openTunnel(Client.java:332)

    at oracle.dbtools.raptor.ssh.navigator.SshController$4.doWork(SshController.java:252)

    at oracle.dbtools.raptor.ssh.navigator.SshController$4.doWork(SshController.java:248)

    at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)

    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

    at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)

    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:1149)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

    at java.lang.Thread.run(Thread.java:748)

I think this might be because the host we are connecting to uses a security type banner before asking you for the username.

I have found a (sort of) workaround

In SSH Hosts section; click on the Host used for the tunnel, then right mouse click and in the context menu pick "connect" (sometimes you need to do this 2-3 more times as you still get the error). Eventually you'll get the SSH Authorization dialog, enter your password.

Once this works you can the click on any connection which uses this ssh host for tunneling and can connect without any errors.

Comments
Post Details
Added on Nov 27 2019
0 comments
1,625 views