Attempting to copy Sequel Pro setup with SSH into DBeaver leads to Can't initialize tunnel error

[nkudeba]

I am trying to migrate some connections I have with Sequel Pro into DBeaver. I have no issues for connections that do not require an SSH Host. However, for those that do, I am getting some errors. Below are screenshots of my working setup in Sequel Pro and what I've tried to replicate in DBeaver. One difference I've noticed is with Sequel Pro, I have left the port blank (it is optional), whereas if I remove the port in DBeaver SSH, I get an SSH port not specified error (last picture).

Is there something I'm doing wrong here?

[E1izabeth]

Please provide the log files. You can find instructions here https://dbeaver.com/docs/wiki/Log-files/.

[nkudeba]

Hi, please find the log entry below. Thanks.

!ENTRY org.jkiss.dbeaver.model 4 0 2023-07-21 13:50:40.265
!MESSAGE Cannot establish tunnel to ww01-v60.mysetup.prod:22
!SUBENTRY 1 org.jkiss.dbeaver.model 4 0 2023-07-21 13:50:40.265
!MESSAGE ww01-v60.mysetup.prod
!STACK 0
java.net.UnknownHostException: ww01-v60.mysetup.prod
at java.base/sun.nio.ch.NioSocketImpl.connect(Unknown Source)
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at net.schmizz.sshj.SocketClient.connect(SocketClient.java:68)
at org.jkiss.dbeaver.model.net.ssh.SSHImplementationSshj.setupTunnel(SSHImplementationSshj.java:102)
at org.jkiss.dbeaver.model.net.ssh.SSHImplementationAbstract.initTunnel(SSHImplementationAbstract.java:135)
at org.jkiss.dbeaver.model.net.ssh.SSHTunnelImpl.initializeHandler(SSHTunnelImpl.java:77)
at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect(DataSourceDescriptor.java:1059)
at org.jkiss.dbeaver.runtime.jobs.ConnectJob.run(ConnectJob.java:77)
at org.jkiss.dbeaver.runtime.jobs.ConnectJob.runSync(ConnectJob.java:104)
at org.jkiss.dbeaver.ui.actions.datasource.DataSourceHandler.connectToDataSource(DataSourceHandler.java:115)
at org.jkiss.dbeaver.ui.actions.datasource.UIServiceConnectionsImpl.initConnection(UIServiceConnectionsImpl.java:87)
at org.jkiss.dbeaver.model.navigator.DBNDataSource.initializeNode(DBNDataSource.java:158)
at org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.getChildren(DBNDatabaseNode.java:225)
at org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.getChildren(DBNDatabaseNode.java:1)
at org.jkiss.dbeaver.model.navigator.DBNUtils.getNodeChildrenFiltered(DBNUtils.java:80)
at org.jkiss.dbeaver.ui.navigator.database.load.TreeLoadService.evaluate(TreeLoadService.java:49)
at org.jkiss.dbeaver.ui.navigator.database.load.TreeLoadService.evaluate(TreeLoadService.java:1)
at org.jkiss.dbeaver.ui.LoadingJob.run(LoadingJob.java:88)
at org.jkiss.dbeaver.ui.LoadingJob.run(LoadingJob.java:72)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

[E1izabeth]

Probably, you want to put localhost into the Server Host field. Could you try?

[E1izabeth]

Never mind, I messed it up. Hmm

[E1izabeth]

Does host www01-v60.... is available? Could you ping it from your machine?