Issues with GCP SQL

Terraform
1

I’m running into issues with using terraform (version 11.14) and GCP’s SQL api:

2019/06/27 18:18:44 [DEBUG] plugin: waiting for all plugin processes to complete...
Error: Error refreshing state: 1 error occurred:
	* google_sql_database_instance.loadtest-db: 1 error occurred:
2019-06-27T18:18:44.876-0400 [DEBUG] plugin.terraform-provider-google_v1.20.0_x4: 2019/06/27 18:18:44 [ERR] plugin: plugin server: accept unix /var/folders/5v/9clr5rgs3dg3y7363q9204rc0000gp/T/plugin261867312: use of closed network connection
2019-06-27T18:18:44.876-0400 [DEBUG] plugin.terraform-provider-google-beta_v1.20.0_x4: 2019/06/27 18:18:44 [ERR] plugin: plugin server: accept unix /var/folders/5v/9clr5rgs3dg3y7363q9204rc0000gp/T/plugin356238661: use of closed network connection
	* google_sql_database_instance.loadtest-db: google_sql_database_instance.loadtest-db: Error reading SQL Database Instance "lt20190627": googleapi: Error 403: Cloud SQL Admin API has not been used in project 563584335869 before or it is disabled. Enable it by visiting https://console.developers.google.com/apis/api/sqladmin.googleapis.com/overview?project=563584335869 then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry., accessNotConfigured

The problem is that isn’t any of my project ids, and creation of the database worked fine. Further, the API is certainly enabled for all my projects. Any help would be greatly appreciated, and I can turn this into a bug report if that would be better.

2

Actually, I’m no longer able to do anything with SQL on my google cloud project, but the error continues to refer to lack of API on a project I don’t own. I just double checked my personal google account (since I’m intending to use one of my company’s), but that ID doesn’t match either.

3

Hi @ckhrysze,

Did you figure out a resolution? There could be a variety of contributing factors, what method are you using to set up your Google provider and credentials?