Database not publicly accessible after deleting IP whitelist

Hello,

Earlier today I restricted public access to one of my databases to the IP address of my VPN provider. I was then able to access the database over the VPN. However, after removing the IP address from the Access Control section, I am unable to access the db with the VPN off. When I add the IP back, I can access it again over the VPN.

It seems that the ACL is cached; the delete operation is not removing it immediately. Can someone confirm this behavior in Render? This non-deterministic behavior makes me a little nervous :slight_smile:

Thanks.

Ok, I figured out the issue.

It looks like the default CIDR block 0.0.0.0/0 needs to be manually added back in for public access. I assumed that clearing out custom IPs would default automatically to the allow-all rule.

Hopefully this helps someone else who might be in the same boat.

1 Like