Amazon AWS连接错误 [英] Amazon AWS connection error

问题描述

我刚刚设置了我的第一个Redshift集群，并尝试通过SQL Workbench连接到它，以便能够创建表.

I have just setup my first Redshift cluster and attempting to connect to it via SQL Workbench to be able to create tables.

我已按照此处的指示安装和配置SQL Workbench:

I have followed the directions for installing and configuring SQL Workbench here: http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-using-workbench.html

我还下载并配置了Redshift JDBC驱动程序的4.0和4.1版本，并尝试同时使用这两个版本.

I have also downloaded and configured both the 4.0 and 4.1 version of the Redshift JDBC driver and attempted to use both.

当我使用群集配置中提供的JDBC URL配置连接时，SQL Workbench尝试连接，然后收到以下错误:

When I configure a connection using the JDBC URL provided in the cluster configuration, the SQL Workbench attempts to connect and then I receive the following error:

Amazon(500150)设置/关闭连接时出错:连接超时: 连接.

Amazon(500150) Error setting/closing connection: Connection timed out: connect.

推荐答案

1. 转到EC2 Console =>安全"组，编辑入站规则，添加Redshift Select Source MYIP，它将由您的IP [CIDR]

1. go to to EC2 Console=>Security group , edit the inbound rule add Redshift Select Source MYIP , It will be autofilled by your IP[CIDR]

试图使用JDBC URL/SQL连接到Redshift问题未解决，后来我断开了与公司LAN的连接，并使用了我的个人WI FI网络连接到Internet.

tried to connect to Redshift using JDBC URL/SQL WORKBENCH Issue is not resolved , Later I disconnected from corporate LAN and used my personal WI FI Network to connect to Internet.

转到EC2 Console =>安全"组，编辑入站规则，然后添加Redshift Select Source MYIP，它将由您的IP [CIDR]自动填充，您的CIDR与步骤1中的不一样

go to to EC2 Console=>Security group , edit the inbound rule add Redshift Select Source MYIP , It will be autofilled by your IP[CIDR] , your CIDR will not be same as in step-1

现在我使用JDBC URL/SQL WORKBENCH与REDSHIFT的连接正常.

now my connection with REDSHIFT using JDBC URL/SQL WORKBENCH is working fine.

查找问题是由于公司LAN的代理服务器设置所致.

Looks Issue is because of Proxy setting of corporate LAN.

这篇关于Amazon AWS连接错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！