Не могу покдлючить Vertica к DBeaver на Debian, ошибка подключения 127.0.0.1 по порту 5433
Не могу покдлючить Vertica к DBeaver на Debian, ошибка подключения 127.0.0.1 по порту 5433 .
Пытался открыть порт следующей коммандой:
sudo iptables -I INPUT -p tcp -m tcp --dport 5433 -j ACCEPT
root@debian:/home/rabovladelec/Загрузки# sudo netstat -ntulp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 545/cupsd
tcp6 0 0 127.0.0.1:40817 :::* LISTEN 1800/java
tcp6 0 0 127.0.0.1:30675 :::* LISTEN 1800/java
tcp6 0 0 ::1:631 :::* LISTEN 545/cupsd
udp 0 0 0.0.0.0:52976 0.0.0.0:* 541/avahi-daemon: r
udp 0 0 0.0.0.0:68 0.0.0.0:* 739/dhclient
udp 0 0 0.0.0.0:631 0.0.0.0:* 612/cups-browsed
udp 0 0 0.0.0.0:5353 0.0.0.0:* 541/avahi-daemon: r
udp6 0 0 :::40432 :::* 541/avahi-daemon: r
udp6 0 0 :::5353 :::* 541/avahi-daemon: r
root@debian:/home/rabovladelec/Загрузки# sudo iptables -L -n -v
Chain INPUT (policy ACCEPT 0 packets, 0 bytes)
pkts bytes target prot opt in out source destination
4 240 ACCEPT tcp -- * * 0.0.0.0/0 0.0.0.0/0 tcp dpt:5433
Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
pkts bytes target prot opt in out source destination
Chain OUTPUT (policy ACCEPT 0 packets, 0 bytes)
pkts bytes target prot opt in out source destination
Прошу помочь.
Лог от коннекта Vertica к DBeaver :
июл. 10 17:32:34.402 INFO 37 com.vertica.core.VConnection.setLogLevel: Log level set to debug
июл. 10 17:32:34.402 INFO 37 com.vertica.core.VConnection.setLogPackage: Log package set to com.vertica
июл. 10 17:32:34.403 INFO 37 com.vertica.core.VConnection.setResultBufferSize: ResultBufferSize set to 8192
июл. 10 17:32:34.403 INFO 37 com.vertica.core.VConnection.setLoginTimeout: Login timeout set to 30
июл. 10 17:32:34.403 INFO 37 com.vertica.core.VConnection.setSocketFactoryName: Socket Factory Name set to
июл. 10 17:32:34.403 INFO 37 com.vertica.core.VConnection.setSessionLabel: Session label is jdbc-10.01.0100-d322e946-503d-41ef-83b6-d16d89a31ed4
июл. 10 17:32:34.403 INFO 37 com.vertica.core.VConnection.setDirectBatchInsert: Direct batch insert disabled.
июл. 10 17:32:34.404 INFO 37 com.vertica.core.VConnection.setUseStrictCatalogFiltering: Strict catalog filtering disabled.
июл. 10 17:32:34.404 INFO 37 com.vertica.core.VConnection.setAddTzToTimestampParameters: AddTzToTimestampParametersdisabled.
июл. 10 17:32:34.404 INFO 37 com.vertica.core.VConnection.setTLSMode: TLSMode set to DISABLE
июл. 10 17:32:34.404 INFO 37 com.vertica.core.VConnection.setUseThreePartNaming: Three part naming enabled.
июл. 10 17:32:34.404 INFO 37 com.vertica.core.VConnection.setBackupServerNode: Backup server node set to
июл. 10 17:32:34.405 INFO 37 com.vertica.core.VConnection.setConnectionLoadBalance: Connection load balancing enabled.
июл. 10 17:32:34.405 INFO 37 com.vertica.core.VConnection.setJAASConfigName: JAAS config name set to verticajdbc
июл. 10 17:32:34.405 INFO 37 com.vertica.core.VConnection.setKerberosServiceName: Kerberos service set to vertica
июл. 10 17:32:34.405 INFO 37 com.vertica.core.VConnection.setKerberosHostName: Kerberos host set to 127.0.0.1
июл. 10 17:32:34.405 INFO 37 com.vertica.core.VConnection.setStreamingBatchInsert: Streaming batch inserts disabled.
июл. 10 17:32:34.405 INFO 37 com.vertica.core.VConnection.setDisableCopyLocal: COPY LOCAL is enabled.
июл. 10 17:32:34.406 INFO 37 com.vertica.core.VConnection.setEnableRoutableQueries: Routable queries disabled.
июл. 10 17:32:34.406 INFO 37 com.vertica.core.VConnection.setFailOnMultinodePlans: FailOnMultiNodePlans enabled.
июл. 10 17:32:34.406 INFO 37 com.vertica.core.VConnection.setMaxPooledConnectionUses: MaxPooledConnectionUses set to 1000
июл. 10 17:32:34.406 INFO 37 com.vertica.core.VConnection.setMaxPooledConnections: MaxPooledConnections set to 20
июл. 10 17:32:34.406 INFO 37 com.vertica.core.VConnection.setMaxPooledConnectionsPerNode: MaxPooledConnectionsPerNode set to 5
июл. 10 17:32:34.407 INFO 37 com.vertica.core.VConnection.setMetadataCacheLifetime: MetadataCacheLifeTime set to 300
июл. 10 17:32:34.407 INFO 37 com.vertica.core.VConnection.setNodeDownWaitTime: NodeDownWaitTime set to 60
июл. 10 17:32:34.407 INFO 37 com.vertica.core.VConnection.setPreferredAddressFamily: PreferredAddressFamily set to None
июл. 10 17:32:34.407 INFO 37 com.vertica.core.VConnection.connect: Connecting as user_db to test_db on 127.0.0.1:5433
июл. 10 17:32:34.408 INFO 47 com.vertica.io.VStream.establishConnection: Establishing connection to /127.0.0.1, port 5433
июл. 10 17:32:34.408 WARN 47 com.vertica.io.VStream.establishConnection: Failed to connect to /127.0.0.1
июл. 10 17:32:34.408 WARN 47 com.vertica.io.VStream.establishConnection: В соединении отказано (Connection refused)
java.net.ConnectException: В соединении отказано (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at com.vertica.io.VStream.establishConnection(Unknown Source)
at com.vertica.io.VStream.<init>(Unknown Source)
at com.vertica.io.ProtocolStream.<init>(Unknown Source)
at com.vertica.core.VConnection.tryConnect(Unknown Source)
at com.vertica.core.VConnection$TaskConnect.call(Unknown Source)
at com.vertica.core.VConnection$TaskConnect.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
июл. 10 17:32:34.409 ERROR 47 com.vertica.io.ProtocolStream.ProtocolStream: Failed to establish a connection to the primary server or any backup address.
java.io.IOException: Failed to establish a connection to the primary server or any backup address.
at com.vertica.io.VStream.establishConnection(Unknown Source)
at com.vertica.io.VStream.<init>(Unknown Source)
at com.vertica.io.ProtocolStream.<init>(Unknown Source)
at com.vertica.core.VConnection.tryConnect(Unknown Source)
at com.vertica.core.VConnection$TaskConnect.call(Unknown Source)
at com.vertica.core.VConnection$TaskConnect.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: В соединении отказано (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
... 10 more
июл. 10 17:32:34.409 ERROR 37 com.vertica.exceptions.ExceptionConverter.toSQLException: [Vertica][VJDBC](100176) Failed to connect to host 127.0.0.1 on port 5433. Reason: Failed to establish a connection to the primary server or any backup address.
java.sql.SQLNonTransientConnectionException: [Vertica][VJDBC](100176) Failed to connect to host 127.0.0.1 on port 5433. Reason: Failed to establish a connection to the primary server or any backup address.
at com.vertica.io.ProtocolStream.<init>(Unknown Source)
at com.vertica.core.VConnection.tryConnect(Unknown Source)
at com.vertica.core.VConnection$TaskConnect.call(Unknown Source)
at com.vertica.core.VConnection$TaskConnect.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.vertica.support.exceptions.NonTransientConnectionException: [Vertica][VJDBC](100176) Failed to connect to host 127.0.0.1 on port 5433. Reason: Failed to establish a connection to the primary server or any backup address.
... 8 more
Caused by: java.io.IOException: Failed to establish a connection to the primary server or any backup address.
at com.vertica.io.VStream.establishConnection(Unknown Source)
at com.vertica.io.VStream.<init>(Unknown Source)
... 8 more
Caused by: java.net.ConnectException: В соединении отказано (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
... 10 more