More helpful msg for Redshift connection errors?

[hernamesbarbara]

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

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]

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.