[Amazon](500150)设置错误/关闭连接:连接超时 [英] [Amazon](500150) Error setting/closing connection: Connection timed out

问题描述

在尝试连接到Redshift Cluster时，我从Glue控制台遇到连接问题.我可以使用桌面上的确切凭据连接到Redshift集群.

I am having connectivity issue from Glue console while trying to connect to Redshift Cluster. I am able to connect to Redshift cluster with exact credentials from my Desktop.

我已遵循AWS文档，并为Redshift群集所在的安全组打开了"ALL TCP"连接.胶水和Redshift都在同一地区.还为Glue提供了AWSRedshiftFullAccess.

I have followed the AWS documentation and have "ALL TCP" connections open for Security Groups in which Redshift cluster resides. Both Glue and Redshift are in same Region. Also Glue has been given AWSRedshiftFullAccess.

我正在堵墙，如果您能向我提供解决此问题的指导，我们将不胜感激.我遵循了其他线程中推荐的步骤，但是没有运气(确保启用了DNSHostname和DNSResolution.

I am running a wall and appreciate if you provide me guidance to resolve this issue. I followed the steps recommended in other thread but no luck (Ensuring that DNSHostname and DNSResolution enabled.

感谢您的指导.

谢谢

V

推荐答案

检查redshiftcluster是否已启用ssl，如果已启用SSL，则需要将ssl配置附加到主机URL的末尾.如果未启用ssl，请检查redshift群集的安全性"组，它特别需要TCP/Redshift端口5439是开放入站的.

Check if your redshiftcluster is ssl enabled or not, if it is SSL enabled, then you need to append the ssl config to the end of your host url. If ssl is not enabled, check the Security groups of your redshift cluster, it particularly needs TCP/Redshift port 5439 is open inbound.

这篇关于[Amazon](500150)设置错误/关闭连接:连接超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！