DNS Resolution Failing


#1

Issue Summary

I have Redash installed with the AMI and am trying to connect to an RDS Aurora PostgreSQL instance. I’ve verified the security groups and networking are setup correctly. I get the following error:

Connection Test Failed:
could not translate host name "****.****.us-west-2.rds.amazonaws.com" to address: Temporary failure in name resolution

It looks like the /etc/resolve.conf is set to 127.0.0.53. I check this

dig ****.****.us-west-2.rds.amazonaws.com

; <<>> DiG 9.11.3-1ubuntu1.1-Ubuntu <<>> ****.****.us-west-2.rds.amazonaws.com
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL, id: 57335
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 65494
;; QUESTION SECTION:
;****.****.us-west-2.rds.amazonaws.com. IN A

;; Query time: 0 msec
;; SERVER: 127.0.0.53#53(127.0.0.53)
;; WHEN: Fri Mar 01 16:52:25 UTC 2019
;; MSG SIZE  rcvd: 87

and it looks fine. But then I check the psql port through telnet:

telnet ****.****.us-west-2.rds.amazonaws.com 5432
telnet: could not resolve ****.****.us-west-2.rds.amazonaws.com/5432: Temporary failure in name resolution

and get the same error I get from the application. Locally, it’s fine:

 telnet ****.****.us-west-2.rds.amazonaws.com 5432
Trying **.**.***.**...
Connected to ec2-**-**-***-**.us-west-2.compute.amazonaws.com.
Escape character is '^]'.

Even a ping to aws.amazon.com fails:

ping aws.amazon.com
ping: aws.amazon.com: Temporary failure in name resolution

Technical details:

  • Redash Version: 5.0.2+b5486
  • Browser/OS: Firefox / MacOSX
  • How did you install Redash: Amazon EC2 ( ami-0e164aeccb29a1be7 ) t2.medium