CODEWITHSUNDEEP
google-app-maker
Morfinismo
Morfinismo

Reputation: 5253

Connect to custom SQL Database

I have two domains, one is production and the other one is test. I have set up GCP on the production domain and that is where the SQL databases reside. I have two instances, one is used for prod and the other is for testing. I am trying to connect the test domain to a custom cloud sql database that resides on the production domain, inside the testing instance, but I am getting the following error:

enter image description here

Now, before you might assume that it is a permission error; IT IS NOT, or at least that's what I believe. This was working fine until last week. I have doubled checked that the permissions are correct and here is the screenshot of the permission inside IAM & Admin:

enter image description here

I have checked and followed the documentation that James from AppMaker university shared but that is not what it's happening now. It's just NOT working.

Now, I suspect this is a bug or a recent change but I see no communication whatsoever regarding this behavior. I see no sense in creating another GCP account and another billing account in the test domain, when I already have a GCP account with an instance that I want to use. Would it be possible to continue doing this or the appmaker team decided to remove this ability?

Upvotes: 0

Views: 150

Answers (1)

Vasyl Petrushko
Vasyl Petrushko

Reputation: 366

App Maker application developer (a person which creates or updates the deployment in particular) should have "Cloud SQL Client" permission on the Cloud Project with Cloud SQL DB.

Upvotes: 2

Related Questions