search

wagonhq / feedback

A place to discuss Wagon features and fixes, join us on Slack at
http://band.wagonhq.com
6 stars 0 forks source link

More helpful msg for Redshift connection errors? #40

Open hernamesbarbara opened 8 years ago

hernamesbarbara commented 8 years ago

I regularly have people from my team encounter the below error message:

image

We use Redshift, and I quickly determined that the cause of this error is rooted in Redshift security groups and the need to add known/trusted IPs to the whitelist.

It'd be pretty helpful to my users if you displayed something like:

Uh oh! Wagon couldn't connect to your database, but don't worry. It looks like Redshift does not recognize your IP address. 

Find your public IP by Googling "What's my IP" and add (or ask your AWS admin to add) it to your Redshift Security Group on AWS.

BONUS - grab the results of whatsmyip automatically and display it to the user to save him/her time Googling for it.

rfilmyer-turo commented 8 years ago

If the behavior is anything like connecting to EC2 instances via SSH, if you're not part of the security group it just silently ignores your connection. It would probably be difficult to tell whether you mistyped the URL altogether (eg "amazonawss.com") or just were blocked.