Batch Registration of AppSheet IPs to Cloud SQL Connection

When using Cloud SQL, we need to register the AppSheet server IP to the Connection.
There are 45 of them! :confounded:


Registering them by hand from the console is a lot of work, so let’s not do it…


With the following command, we can do the bulk registration from Cloud Shell.

> gcloud sql instances patch [INSTANCE_NAME] --authorized-networks=20.189.130.98/32,20.189.132.63/32,40.67.216.152/32,40.67.216.182/32,40.67.219.84/32,138.91.195.239/32,20.189.139.27/32,20.189.138.55/32,20.189.138.139/32,20.189.139.109/32,20.189.139.123/32,20.189.138.180/32,20.189.138.40/32,52.149.110.221/32,52.149.111.209/32,52.149.111.211/32,52.149.111.248/32,51.144.56.20/32,51.144.57.117/32,52.138.118.136/32,52.138.118.137/32,34.87.131.237/32,34.87.103.64/32,35.197.185.203/32,35.244.126.141/32,35.204.213.55/32,34.91.161.74/32,35.222.253.144/32,34.71.7.214/32,35.194.89.186/32,35.245.209.204/32,35.203.191.15/32,35.247.56.116/32,35.240.247.148/32,34.87.159.166/32,34.87.233.115/32,35.244.107.184/32,35.204.102.20/32,35.204.159.159/32,35.239.203.99/32,35.239.112.17/32,34.86.96.199/32,35.245.229.252/32,34.83.247.7/32,35.247.40.210/32

Appendix

10 Likes

Greatly appreciate this type of information! Extremely useful and not something many of us would know without stumbling across it.

2 Likes

“Cries in AWS RDS :cry:

3 Likes

Take a deeeeep breath :cry: @Austin_Lambeth