We have an app script projects that connect to our own MySQL database, we need to whitelist the IP of the Google app script to allow the connection.

Sometimes it's working, sometimes not so I think it is related to the IP used by the app script. We authorized all of the IPs from https://www.gstatic.com/ipranges/goog.txt but we still have errors sometimes.

What IPs are we also need to authorize?

Thanks

CodePudding user response：

can you not see the IPs that are attempting to connect to your MySQL DB from the connection log or from your System logs?

Also are you connecting from google cloud as it states that thee are different region specific IP's for these. https://www.gstatic.com/ipranges/cloud.json

Take a look at https://support.google.com/a/answer/10026322?hl=en which lists it all out.

Hope this helps

Tom

CodePudding user response：

This seems to be a bug.

This has been previously reported at Google Issue Tracker:

• JDBC Still Receiving Error "Failed to establish a database connection. Check connection string, username and password."

Anyone affected by this, consider starring the referenced issue in order to keep track of it and to help prioritize it.