Connection failure to Postgresql

Toad Edge
1

Hi All,

Trialling Toad Edge - we have a PostgreSQL database running on a VM with SSH authentication enabled. We have the SSH key and associated username defined in the Connection SSH tab, the database user, database name and password, and the IP address of the VM instance the database is running on. The database is up and running on the VM, but the Connection Wizard in Toad Edge throws a Connection Error (code:08001).

Relevant sections from the log4j log file are below. We have no problem connecting to the VM using the SSH key (via Putty and SuperPutty).

TIA for any help with this, very much appreciated.

Regards

Geoff.

2023-07-03 02:26:30,476 ERROR [AbstractConnectionDialog] The connection attempt failed.
2023-07-03 02:26:30,479 ERROR [Logger] java.lang.reflect.InvocationTargetException: The connection attempt failed.
2023-07-03 02:26:30,479 ERROR [Logger] at com.quest.toad.ui.connections.TestConnectionOperation.run(TestConnectionOperation.java:104)
2023-07-03 02:26:30,479 ERROR [Logger] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
2023-07-03 02:26:30,480 ERROR [Logger] Caused by: com.quest.toad.execution.ExecutionException: org.postgresql.util.PSQLException: The connection attempt failed.
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.execution.executor.SqlExecutor.getConnection(SqlExecutor.java:311)
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.postgre.core.sql.PgSqlExecutor.createConnection(Unknown Source)
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.execution.executor.SqlExecutor.doReconnect(SqlExecutor.java:187)
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.execution.executor.AbstractExecutor.reconnect(AbstractExecutor.java:213)
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.execution.executor.AbstractExecutor.logon(AbstractExecutor.java:204)
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool.createExecutor(ExecutorPool.java:432)
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.execution.executor.AbstractSqlExecutorPool.createExecutor(AbstractSqlExecutorPool.java:71)
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool.createDefaultExecutor(ExecutorPool.java:412)
2023-07-03 02:26:30,480 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool.access$4(ExecutorPool.java:410)
2023-07-03 02:26:30,481 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool$InternalExecutorPool.addDefaultExecutor(ExecutorPool.java:202)
2023-07-03 02:26:30,481 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool.logon(ExecutorPool.java:608)
2023-07-03 02:26:30,481 ERROR [Logger] at com.quest.toad.core.AbstractConnector.initSqlExecutorPool(AbstractConnector.java:426)
2023-07-03 02:26:30,481 ERROR [Logger] at com.quest.toad.core.AbstractConnector.connect(AbstractConnector.java:363)
2023-07-03 02:26:30,481 ERROR [Logger] at com.quest.toad.core.AbstractConnector.logonTesting(AbstractConnector.java:893)
2023-07-03 02:26:30,481 ERROR [Logger] at com.quest.toad.ui.connections.GetConnectorVersionCallable.call(GetConnectorVersionCallable.java:70)
2023-07-03 02:26:30,481 ERROR [Logger] at com.quest.toad.ui.connections.GetConnectorVersionCallable.call(GetConnectorVersionCallable.java:1)
2023-07-03 02:26:30,481 ERROR [Logger] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2023-07-03 02:26:30,481 ERROR [Logger] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2023-07-03 02:26:30,482 ERROR [Logger] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2023-07-03 02:26:30,482 ERROR [Logger] at java.base/java.lang.Thread.run(Thread.java:829)
2023-07-03 02:26:30,482 ERROR [Logger] Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
2023-07-03 02:26:30,482 ERROR [Logger] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:331)
2023-07-03 02:26:30,482 ERROR [Logger] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
2023-07-03 02:26:30,482 ERROR [Logger] at org.postgresql.jdbc.PgConnection.(PgConnection.java:247)
2023-07-03 02:26:30,482 ERROR [Logger] at org.postgresql.Driver.makeConnection(Driver.java:434)
2023-07-03 02:26:30,482 ERROR [Logger] at org.postgresql.Driver.connect(Driver.java:291)
2023-07-03 02:26:30,482 ERROR [Logger] at com.quest.toad.execution.executor.SqlExecutor.startConnection(SqlExecutor.java:907)
2023-07-03 02:26:30,482 ERROR [Logger] at com.quest.toad.execution.executor.SqlExecutor.lambda$1(SqlExecutor.java:293)
2023-07-03 02:26:30,483 ERROR [Logger] ... 4 more
2023-07-03 02:26:30,483 ERROR [Logger] Caused by: java.net.SocketTimeoutException: connect timed out
2023-07-03 02:26:30,483 ERROR [Logger] at java.base/java.net.PlainSocketImpl.waitForConnect(Native Method)
2023-07-03 02:26:30,483 ERROR [Logger] at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107)
2023-07-03 02:26:30,483 ERROR [Logger] at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
2023-07-03 02:26:30,483 ERROR [Logger] at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
2023-07-03 02:26:30,483 ERROR [Logger] at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
2023-07-03 02:26:30,483 ERROR [Logger] at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
2023-07-03 02:26:30,483 ERROR [Logger] at java.base/java.net.Socket.connect(Socket.java:609)
2023-07-03 02:26:30,483 ERROR [Logger] at org.postgresql.core.PGStream.createSocket(PGStream.java:241)
2023-07-03 02:26:30,484 ERROR [Logger] at org.postgresql.core.PGStream.(PGStream.java:98)
2023-07-03 02:26:30,484 ERROR [Logger] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:109)
2023-07-03 02:26:30,484 ERROR [Logger] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235)
2023-07-03 02:26:30,484 ERROR [Logger] ... 10 more
2023-07-03 02:27:05,677 ERROR [AbstractConnectionDialog] The connection attempt failed.
2023-07-03 02:27:05,678 ERROR [Logger] java.lang.reflect.InvocationTargetException: The connection attempt failed.
2023-07-03 02:27:05,678 ERROR [Logger] at com.quest.toad.ui.connections.TestConnectionOperation.run(TestConnectionOperation.java:104)
2023-07-03 02:27:05,679 ERROR [Logger] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
2023-07-03 02:27:05,679 ERROR [Logger] Caused by: com.quest.toad.execution.ExecutionException: org.postgresql.util.PSQLException: The connection attempt failed.
2023-07-03 02:27:05,679 ERROR [Logger] at com.quest.toad.execution.executor.SqlExecutor.getConnection(SqlExecutor.java:311)
2023-07-03 02:27:05,679 ERROR [Logger] at com.quest.toad.postgre.core.sql.PgSqlExecutor.createConnection(Unknown Source)
2023-07-03 02:27:05,679 ERROR [Logger] at com.quest.toad.execution.executor.SqlExecutor.doReconnect(SqlExecutor.java:187)
2023-07-03 02:27:05,679 ERROR [Logger] at com.quest.toad.execution.executor.AbstractExecutor.reconnect(AbstractExecutor.java:213)
2023-07-03 02:27:05,679 ERROR [Logger] at com.quest.toad.execution.executor.AbstractExecutor.logon(AbstractExecutor.java:204)
2023-07-03 02:27:05,679 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool.createExecutor(ExecutorPool.java:432)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.execution.executor.AbstractSqlExecutorPool.createExecutor(AbstractSqlExecutorPool.java:71)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool.createDefaultExecutor(ExecutorPool.java:412)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool.access$4(ExecutorPool.java:410)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool$InternalExecutorPool.addDefaultExecutor(ExecutorPool.java:202)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.execution.executor.ExecutorPool.logon(ExecutorPool.java:608)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.core.AbstractConnector.initSqlExecutorPool(AbstractConnector.java:426)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.core.AbstractConnector.connect(AbstractConnector.java:363)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.core.AbstractConnector.logonTesting(AbstractConnector.java:893)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.ui.connections.GetConnectorVersionCallable.call(GetConnectorVersionCallable.java:70)
2023-07-03 02:27:05,680 ERROR [Logger] at com.quest.toad.ui.connections.GetConnectorVersionCallable.call(GetConnectorVersionCallable.java:1)
2023-07-03 02:27:05,681 ERROR [Logger] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2023-07-03 02:27:05,681 ERROR [Logger] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2023-07-03 02:27:05,681 ERROR [Logger] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2023-07-03 02:27:05,681 ERROR [Logger] at java.base/java.lang.Thread.run(Thread.java:829)
2023-07-03 02:27:05,681 ERROR [Logger] Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
2023-07-03 02:27:05,681 ERROR [Logger] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:331)
2023-07-03 02:27:05,681 ERROR [Logger] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
2023-07-03 02:27:05,681 ERROR [Logger] at org.postgresql.jdbc.PgConnection.(PgConnection.java:247)
2023-07-03 02:27:05,682 ERROR [Logger] at org.postgresql.Driver.makeConnection(Driver.java:434)
2023-07-03 02:27:05,682 ERROR [Logger] at org.postgresql.Driver.connect(Driver.java:291)
2023-07-03 02:27:05,682 ERROR [Logger] at com.quest.toad.execution.executor.SqlExecutor.startConnection(SqlExecutor.java:907)
2023-07-03 02:27:05,682 ERROR [Logger] at com.quest.toad.execution.executor.SqlExecutor.lambda$1(SqlExecutor.java:293)
2023-07-03 02:27:05,682 ERROR [Logger] ... 4 more
2023-07-03 02:27:05,682 ERROR [Logger] Caused by: java.io.EOFException
2023-07-03 02:27:05,682 ERROR [Logger] at org.postgresql.core.PGStream.receiveChar(PGStream.java:455)
2023-07-03 02:27:05,683 ERROR [Logger] at org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:553)
2023-07-03 02:27:05,683 ERROR [Logger] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:168)
2023-07-03 02:27:05,683 ERROR [Logger] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235)
2023-07-03 02:27:05,683 ERROR [Logger] ... 10 more

2

Trying to get someone from Tech Support to look at this...

3

Hi Geof,
Your logs mainly show connection timeouts and so could be a network or database configuration problem. A recommendation would be to make sure the database is reachable from the SSH VM and check the latency setting of the connection.

If it's failing, then it's best to reach our Support Team and provide the above log file along with screenshot of the SSH and connection configuration. They'll be able to help you get connected.