Error "Cannot create a publicly accessible DBInstance" when adding 1st RDS instance to CloudFormation

hackoregon / civic-devops

Master collection point for issues, procedures, and code to manage the HackOregon Civic platform

MIT License

11 stars 4 forks source link

Error "Cannot create a publicly accessible DBInstance" when adding 1st RDS instance to CloudFormation #281

Closed MikeTheCanuck closed 4 years ago

MikeTheCanuck commented 4 years ago

Attempting to add RDS to our CloudFormation stacks, and encountered this error:

Cannot create a publicly accessible DBInstance. The specified VPC does not support DNS resolution, DNS hostnames, or both. Update the VPC and then try again (Service: AmazonRDS; Status Code: 400; Error Code: InvalidVPCNetworkStateFault

This prevents us from adding any RDS instances.

MikeTheCanuck commented 4 years ago

A little research leads to this article: https://docs.aws.amazon.com/vpc/latest/userguide/vpc-dns.html

Which leads to the discovery that we have another unmanaged VPC in our midst, which is currently configured as the default VPC:

And that this is the state of the "hacko-integration" VPC:

MikeTheCanuck commented 4 years ago

And the resolution of this was to choose Actions, "Edit DNS hostnames" from the VPCs console and check the checkbox: