Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue on testing Connection Redshift (Cloudbeaver EE - Trial) #3146

Open
dng19059 opened this issue Dec 23, 2024 · 4 comments
Open

Issue on testing Connection Redshift (Cloudbeaver EE - Trial) #3146

dng19059 opened this issue Dec 23, 2024 · 4 comments
Labels
question Further information is requested wait for response xf:connection

Comments

@dng19059
Copy link

dng19059 commented Dec 23, 2024

hello

I use docker images (CloudBeaver Enterprise Edition) and and I have this issue when i try to connect to my Redshift
(for information it's a trial licence)
Telnet seems to be good when i try to connect to target port Redshift (5439)

org.postgresql.util.PSQLException: Connection attempt timed out.
at org.postgresql.Driver$ConnectThread.getResult(Driver.java:410)
at org.postgresql.Driver.connect(Driver.java:305)
at org.jkiss.dbeaver.model.impl.jdbc.JDBCConnectionOpener.run(JDBCConnectionOpener.java:109)
at org.jkiss.dbeaver.model.impl.jdbc.JDBCConnectionOpener.run(JDBCConnectionOpener.java:83)
at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.openConnection(JDBCDataSource.java:214)
at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.openConnection(JDBCDataSource.java:133)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreDataSource.openConnection(PostgreDataSource.java:552)
at org.jkiss.dbeaver.model.impl.jdbc.JDBCExecutionContext.connect(JDBCExecutionContext.java:124)
at org.jkiss.dbeaver.model.impl.jdbc.JDBCRemoteInstance.initializeMainContext(JDBCRemoteInstance.java:102)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreDatabase.checkInstanceConnection(PostgreDatabase.java:235)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreDatabase.(PostgreDatabase.java:122)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreDataSource.createDatabaseImpl(PostgreDataSource.java:269)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreDataSource.initializeRemoteInstance(PostgreDataSource.java:165)
at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.(JDBCDataSource.java:109)
at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.(JDBCDataSource.java:100)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreDataSource.(PostgreDataSource.java:105)
at org.jkiss.dbeaver.ext.postgresql.PostgreDataSourceProvider.openDataSource(PostgreDataSourceProvider.java:115)
at org.jkiss.dbeaver.registry.DataSourceDescriptor.openDataSource(DataSourceDescriptor.java:1395)
at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect0(DataSourceDescriptor.java:1266)
at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect(DataSourceDescriptor.java:1056)
at org.jkiss.dbeaver.runtime.jobs.ConnectJob.run(ConnectJob.java:78)
at org.jkiss.dbeaver.runtime.jobs.ConnectionTestJob.run(ConnectionTestJob.java:103)
at io.cloudbeaver.service.core.impl.WebServiceCore.testConnection(WebServiceCore.java:748)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:569)

@dng19059 dng19059 added question Further information is requested wait for review labels Dec 23, 2024
@dng19059 dng19059 changed the title Connexion to Redshift or RDS (Postgres) Issue on testing Connection Redshift (Cloudbeaver EE - Trial) Dec 23, 2024
@EvgeniaBzzz
Copy link
Contributor

Hi @dng19059
I just have successfully connected to Redshift with PostgreSQL driver in Community version.
If you're using right credentials and Redshift instance is running, then please check if the instance has public access.

@dng19059
Copy link
Author

Many thanks @EvgeniaBzzz , are you specify Redshift (5439) port or Postgres natif port (5432) ?

@EvgeniaBzzz
Copy link
Contributor

I specified 5439

@dng19059
Copy link
Author

Thanks @EvgeniaBzzz i'm going to try it and i tell You

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested wait for response xf:connection
Projects
None yet
Development

No branches or pull requests

2 participants