Join Log in
Score:0
avatar Server

Can't Connect to an RDS from my home computer in AWS

bb flag
Some Guy Trying To Do Math

I need to connect to an RDS from my home computer.

This is an established database, I'm migrating it to a new system.

I can not connect to it from my home computer.

I have set the security to Public Accessibility.

I've set VPC the Security rules to allows in bound connections.

What do I do next to debug it

RDS Screen enter image description here Security Groups enter image description here VPC enter image description here

I've included information on the Subnet is that relevant?

enter image description here enter image description here

205
1 + 0
Score:0
Tim avatar Server
gp flag
Tim

Great that you provided screenshots, makes it much easier to help :)

It looks to me like your database is in a private subnet, which means there is no route from the internet to your database. The way to fix it is on this AWS page, which in summary says "change your route table to make your private subnet a public subnet by adding a route from the internet to the subnet".

The "allow public access" doesn't magically provide access from the internet to your database. I didn't know what it did now as I have never needed to do that, but this page tells me it simply allocates the RDS instance a public IP. Without a public IP there's no way to connect direct from the internet, it's only accessible from the VPC IP range. After ticking it you still need to provide security groups, routes, etc.

Make sure your security group allows ingress only from your public IP, not from 0.0.0.0/0.

0 + 0
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.