Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

CLOUD_IAM_GROUP is not a valid option for google_sql_user type property #18169

Open
jarodevs opened this issue May 16, 2024 · 4 comments · May be fixed by GoogleCloudPlatform/magic-modules#10835
Open

CLOUD_IAM_GROUP is not a valid option for google_sql_user type property #18169

jarodevs opened this issue May 16, 2024 · 4 comments · May be fixed by GoogleCloudPlatform/magic-modules#10835
Labels
bug forward/linked service/sqladmin-infra

Comments

@jarodevs
Copy link

jarodevs commented May 16, 2024 •
edited by modular-magician

Community Note

  • Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request.
  • Please do not leave +1 or me too comments, they generate extra noise for issue followers and do not help prioritize the request.
  • If you are interested in working on this issue or have submitted a pull request, please leave a comment.
  • If an issue is assigned to a user, that user is claiming responsibility for the issue.
  • Customers working with a Google Technical Account Manager or Customer Engineer can ask them to reach out internally to expedite investigation and resolution of this issue.

Terraform Version & Provider Version(s)

Terraform v1.5.7
on darwin_arm64

  • provider registry.terraform.io/carlpett/sops v1.0.0
  • provider registry.terraform.io/hashicorp/google v4.51.0

Affected Resource(s)

google_sql_user

Terraform Configuration

resource "google_sql_database_instance" "main" {
  name             = "main"
  database_version = "POSTGRES_15"
  region           = "europe-west9"
  settings {
    tier = "db-f1-micro"
    database_flags {
      name  = "cloudsql.iam_authentication"
      value = "on"
    }
  }
  deletion_protection = true
}

resource "google_sql_database" "black_nest" {
  name     = "black_nest"
  instance = google_sql_database_instance.main.name
}

resource "google_sql_user" "iam_group_user" {
  name     = "[email protected]"
  instance = google_sql_database_instance.main.name
  type     = "CLOUD_IAM_GROUP"
}

Debug Output

2024-05-16T23:14:26.215+0200 [INFO] Terraform version: 1.5.7
2024-05-16T23:14:26.215+0200 [DEBUG] using github.com/hashicorp/go-tfe v1.26.0
2024-05-16T23:14:26.215+0200 [DEBUG] using github.com/hashicorp/hcl/v2 v2.16.2
2024-05-16T23:14:26.215+0200 [DEBUG] using github.com/hashicorp/terraform-svchost v0.1.0
2024-05-16T23:14:26.215+0200 [DEBUG] using github.com/zclconf/go-cty v1.12.2
2024-05-16T23:14:26.215+0200 [INFO] Go runtime version: go1.21.1
2024-05-16T23:14:26.215+0200 [INFO] CLI args: []string{"terraform", "apply", "-var-file", "variables.tfvars"}
2024-05-16T23:14:26.215+0200 [DEBUG] Attempting to open CLI config file: /Users/jarodevs/.terraformrc
2024-05-16T23:14:26.215+0200 [DEBUG] File doesn't exist, but doesn't need to. Ignoring.
2024-05-16T23:14:26.215+0200 [DEBUG] ignoring non-existing provider search directory terraform.d/plugins
2024-05-16T23:14:26.215+0200 [DEBUG] ignoring non-existing provider search directory /Users/jarodevs/.terraform.d/plugins
2024-05-16T23:14:26.215+0200 [DEBUG] ignoring non-existing provider search directory /Users/jarodevs/Library/Application Support/io.terraform/plugins
2024-05-16T23:14:26.215+0200 [DEBUG] ignoring non-existing provider search directory /Library/Application Support/io.terraform/plugins
2024-05-16T23:14:26.215+0200 [INFO] CLI command args: []string{"apply", "-var-file", "variables.tfvars"}
2024-05-16T23:14:26.286+0200 [DEBUG] checking for provisioner in "."
2024-05-16T23:14:26.289+0200 [DEBUG] checking for provisioner in "/opt/homebrew/bin"
2024-05-16T23:14:26.290+0200 [INFO] backend/local: starting Apply operation
2024-05-16T23:14:26.642+0200 [DEBUG] created provider logger: level=debug
2024-05-16T23:14:26.642+0200 [INFO] provider: configuring client automatic mTLS2024-05-16T23:14:26.653+0200 [DEBUG] provider: starting plugin: path=.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0 args=[.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0]
2024-05-16T23:14:26.659+0200 [DEBUG] provider: plugin started: path=.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0 pid=94136
2024-05-16T23:14:26.660+0200 [DEBUG] provider: waiting for RPC address: path=.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0
2024-05-16T23:14:26.672+0200 [INFO] provider.terraform-provider-sops_v1.0.0: configuring server automatic mTLS: timestamp=2024-05-16T23:14:26.672+0200
2024-05-16T23:14:26.679+0200 [DEBUG] provider: using plugin: version=5
2024-05-16T23:14:26.679+0200 [DEBUG] provider.terraform-provider-sops_v1.0.0: plugin address: address=/var/folders/cg/9hdy8g611tzbyzpvqh9fzxwc0000gp/T/plugin305920858 network=unix timestamp=2024-05-16T23:14:26.679+0200
2024-05-16T23:14:26.685+0200 [DEBUG] provider.stdio: received EOF, stopping recv loop: err="rpc error: code = Unavailable desc = error reading from server: EOF"2024-05-16T23:14:26.686+0200 [DEBUG] provider: plugin process exited: path=.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0 pid=94136
2024-05-16T23:14:26.686+0200 [DEBUG] provider: plugin exited
2024-05-16T23:14:26.686+0200 [DEBUG] created provider logger: level=debug
2024-05-16T23:14:26.686+0200 [INFO] provider: configuring client automatic mTLS2024-05-16T23:14:26.688+0200 [DEBUG] provider: starting plugin: path=.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5 args=[.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5]
2024-05-16T23:14:26.692+0200 [DEBUG] provider: plugin started: path=.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5 pid=94137
2024-05-16T23:14:26.692+0200 [DEBUG] provider: waiting for RPC address: path=.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5
2024-05-16T23:14:26.705+0200 [INFO] provider.terraform-provider-google_v4.51.0_x5: configuring server automatic mTLS: timestamp=2024-05-16T23:14:26.705+0200
2024-05-16T23:14:26.720+0200 [DEBUG] provider: using plugin: version=5
2024-05-16T23:14:26.720+0200 [DEBUG] provider.terraform-provider-google_v4.51.0_x5: plugin address: address=/var/folders/cg/9hdy8g611tzbyzpvqh9fzxwc0000gp/T/plugin3940045462 network=unix timestamp=2024-05-16T23:14:26.720+0200
2024-05-16T23:14:26.781+0200 [DEBUG] provider.stdio: received EOF, stopping recv loop: err="rpc error: code = Unavailable desc = error reading from server: EOF"2024-05-16T23:14:26.783+0200 [DEBUG] provider: plugin process exited: path=.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5 pid=94137
2024-05-16T23:14:26.783+0200 [DEBUG] provider: plugin exited
2024-05-16T23:14:26.783+0200 [DEBUG] Building and walking validate graph
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.stripe_secret_key" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.brevo_secret_key" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.exaion_project_id_polygon_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.magic_secret_key" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.exaion_project_id_tezos_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.pinata_api_key_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.exaion_project_id_tezos" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.database_url_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.magic_secret_key_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_sql_user.iam_group_user" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "data.sops_file.secrets" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/carlpett/sops"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_project_iam_member.cloud_build_service_account_service_agent" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.pinata_api_secret" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_project_service.secret_manager_api" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.stripe_webhook_secret" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.firebase" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.crypto_secret_key" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.crypto_secret_key_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.exaion_project_id_polygon_testnet" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.784+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.exaion_project_id_polygon_testnet_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.stripe_secret_key_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.exaion_project_id_polygon" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_sql_database.black_nest" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_project_iam_member.cloud_build_service_account_secret_accessor" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.database_url" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_sql_database_instance.main" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.exaion_project_id_tezos_testnet_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.pinata_api_secret_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.jwt_secret" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.stripe_webhook_secret_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.jwt_secret_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.exaion_project_id_tezos_testnet" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.firebase_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret.pinata_api_key" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.785+0200 [DEBUG] ProviderTransformer: "google_secret_manager_secret_version.brevo_secret_key_version" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.786+0200 [DEBUG] ProviderTransformer: "google_service_account.cloud_build_service_account" (*terraform.NodeValidatableResource) needs provider["registry.terraform.io/hashicorp/google"]
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "provider["registry.terraform.io/hashicorp/google"]" references: [var.region var.project_id]
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.exaion_project_id_polygon_testnet_version" references: [google_secret_manager_secret.exaion_project_id_polygon_testnet data.sops_file.secrets]
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.exaion_project_id_tezos_testnet_version" references: [google_secret_manager_secret.exaion_project_id_tezos_testnet data.sops_file.secrets]
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_project_service.secret_manager_api" references: [var.project_id]
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.pinata_api_key_version" references: [google_secret_manager_secret.pinata_api_key data.sops_file.secrets]
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "var.region" references: []
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "provider["registry.terraform.io/carlpett/sops"]" references: []
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.stripe_secret_key" references: []
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.stripe_secret_key_version" references: [google_secret_manager_secret.stripe_secret_key data.sops_file.secrets]
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.magic_secret_key_version" references: [data.sops_file.secrets google_secret_manager_secret.magic_secret_key]
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.brevo_secret_key" references: []
2024-05-16T23:14:26.786+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.exaion_project_id_polygon_version" references: [google_secret_manager_secret.exaion_project_id_polygon data.sops_file.secrets]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.exaion_project_id_tezos" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.jwt_secret_version" references: [google_secret_manager_secret.jwt_secret data.sops_file.secrets]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.database_url_version" references: [data.sops_file.secrets google_secret_manager_secret.database_url]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_sql_user.iam_group_user" references: [google_sql_database_instance.main]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "var.gh_org" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.jwt_secret" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.crypto_secret_key_version" references: [google_secret_manager_secret.crypto_secret_key data.sops_file.secrets]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.exaion_project_id_tezos_testnet" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.pinata_api_secret_version" references: [google_secret_manager_secret.pinata_api_secret data.sops_file.secrets]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.stripe_webhook_secret" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "data.sops_file.secrets" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_project_iam_member.cloud_build_service_account_secret_accessor" references: [google_service_account.cloud_build_service_account var.project_id]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.brevo_secret_key_version" references: [google_secret_manager_secret.brevo_secret_key data.sops_file.secrets]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.exaion_project_id_tezos_version" references: [google_secret_manager_secret.exaion_project_id_tezos data.sops_file.secrets]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.magic_secret_key" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.exaion_project_id_polygon" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_service_account.cloud_build_service_account" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "var.gh_blackmint_repo" references: []
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.firebase_version" references: [google_secret_manager_secret.firebase data.sops_file.secrets]
2024-05-16T23:14:26.787+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.pinata_api_key" references: []
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.firebase" references: []
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "var.project_id" references: []
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_project_iam_member.cloud_build_service_account_service_agent" references: [google_service_account.cloud_build_service_account var.project_id]
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret_version.stripe_webhook_secret_version" references: [google_secret_manager_secret.stripe_webhook_secret data.sops_file.secrets]
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_sql_database.black_nest" references: [google_sql_database_instance.main]
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_sql_database_instance.main" references: []
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.pinata_api_secret" references: []
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.crypto_secret_key" references: []
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.database_url" references: []
2024-05-16T23:14:26.788+0200 [DEBUG] ReferenceTransformer: "google_secret_manager_secret.exaion_project_id_polygon_testnet" references: []
2024-05-16T23:14:26.789+0200 [DEBUG] Starting graph walk: walkValidate
2024-05-16T23:14:26.790+0200 [DEBUG] created provider logger: level=debug
2024-05-16T23:14:26.790+0200 [INFO] provider: configuring client automatic mTLS2024-05-16T23:14:26.792+0200 [DEBUG] provider: starting plugin: path=.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5 args=[.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5]
2024-05-16T23:14:26.796+0200 [DEBUG] provider: plugin started: path=.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5 pid=94138
2024-05-16T23:14:26.796+0200 [DEBUG] provider: waiting for RPC address: path=.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5
2024-05-16T23:14:26.808+0200 [INFO] provider.terraform-provider-google_v4.51.0_x5: configuring server automatic mTLS: timestamp=2024-05-16T23:14:26.808+0200
2024-05-16T23:14:26.824+0200 [DEBUG] provider.terraform-provider-google_v4.51.0_x5: plugin address: address=/var/folders/cg/9hdy8g611tzbyzpvqh9fzxwc0000gp/T/plugin1850021267 network=unix timestamp=2024-05-16T23:14:26.824+0200
2024-05-16T23:14:26.824+0200 [DEBUG] provider: using plugin: version=5
2024-05-16T23:14:26.833+0200 [DEBUG] created provider logger: level=debug
2024-05-16T23:14:26.833+0200 [INFO] provider: configuring client automatic mTLS2024-05-16T23:14:26.835+0200 [DEBUG] provider: starting plugin: path=.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0 args=[.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0]
2024-05-16T23:14:26.838+0200 [DEBUG] provider: plugin started: path=.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0 pid=94139
2024-05-16T23:14:26.838+0200 [DEBUG] provider: waiting for RPC address: path=.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0
2024-05-16T23:14:26.847+0200 [INFO] provider.terraform-provider-sops_v1.0.0: configuring server automatic mTLS: timestamp=2024-05-16T23:14:26.847+0200
2024-05-16T23:14:26.853+0200 [DEBUG] provider: using plugin: version=5
2024-05-16T23:14:26.853+0200 [DEBUG] provider.terraform-provider-sops_v1.0.0: plugin address: address=/var/folders/cg/9hdy8g611tzbyzpvqh9fzxwc0000gp/T/plugin3649220243 network=unix timestamp=2024-05-16T23:14:26.853+0200
2024-05-16T23:14:26.860+0200 [DEBUG] provider.stdio: received EOF, stopping recv loop: err="rpc error: code = Unavailable desc = error reading from server: EOF"2024-05-16T23:14:26.861+0200 [DEBUG] provider: plugin process exited: path=.terraform/providers/registry.terraform.io/carlpett/sops/1.0.0/darwin_arm64/terraform-provider-sops_v1.0.0 pid=94139
2024-05-16T23:14:26.861+0200 [DEBUG] provider: plugin exited
2024-05-16T23:14:26.901+0200 [ERROR] provider.terraform-provider-google_v4.51.0_x5: Response contains error diagnostic: diagnostic_attribute=AttributeName("type") diagnostic_detail= diagnostic_severity=ERROR @caller=github.com/hashicorp/[email protected]/tfprotov5/internal/diag/diagnostics.go:55 tf_req_id=9a14443f-264f-d6c1-d689-efac8dcb8d0f tf_rpc=ValidateResourceTypeConfig @module=sdk.proto diagnostic_summary="expected type to be one of [BUILT_IN CLOUD_IAM_USER CLOUD_IAM_SERVICE_ACCOUNT ], got CLOUD_IAM_GROUP" tf_resource_type=google_sql_user tf_proto_version=5.3 tf_provider_addr=provider timestamp=2024-05-16T23:14:26.901+0200
2024-05-16T23:14:26.901+0200 [ERROR] vertex "google_sql_user.iam_group_user" error: expected type to be one of [BUILT_IN CLOUD_IAM_USER CLOUD_IAM_SERVICE_ACCOUNT ], got CLOUD_IAM_GROUP
╷
│ Error: expected type to be one of [BUILT_IN CLOUD_IAM_USER CLOUD_IAM_SERVICE_ACCOUNT ], got CLOUD_IAM_GROUP
│
│ with google_sql_user.iam_group_user,
│ on main.tf line 262, in resource "google_sql_user" "iam_group_user":
│ 262: type = "CLOUD_IAM_GROUP"
│
╵
2024-05-16T23:14:26.941+0200 [DEBUG] provider.stdio: received EOF, stopping recv loop: err="rpc error: code = Unavailable desc = error reading from server: EOF"2024-05-16T23:14:26.942+0200 [DEBUG] provider: plugin process exited: path=.terraform/providers/registry.terraform.io/hashicorp/google/4.51.0/darwin_arm64/terraform-provider-google_v4.51.0_x5 pid=94138
2024-05-16T23:14:26.942+0200 [DEBUG] provider: plugin exited

Expected Behavior

CLOUD_IAM_GROUP should be an accepted option

Actual Behavior

CLOUD_IAM_GROUP is not a valid value for type

Steps to reproduce

  1. terraform apply

Important Factoids

No response

References

No response

b/342183683
@jarodevs jarodevs added the bug label May 16, 2024
@github-actions github-actions bot added forward/review In review; remove label to forward service/sqladmin-infra labels May 16, 2024
@ggtisc
Copy link
Collaborator

ggtisc commented May 22, 2024

Confirmed issue!

Error message:

Error message: expected type to be one of [BUILT_IN CLOUD_IAM_USER CLOUD_IAM_SERVICE_ACCOUNT], got CLOUD_IAM_GROUP

Terraform registry specifies that CLOUD_IAM_GROUP is valid, as well as Google Cloud Documentation

@ggtisc ggtisc assigned ggtisc and unassigned ggtisc May 22, 2024
@ggtisc ggtisc removed the forward/review In review; remove label to forward label May 22, 2024
@c2thorn
Copy link
Collaborator

c2thorn commented May 24, 2024

I was notified by the service team that Postgres IAM Group auth feature is not supported right now.

@c2thorn c2thorn closed this as completed May 24, 2024
@jarodevs
Copy link
Author

Okay? So should the docs be updated?

@c2thorn c2thorn linked a pull request May 30, 2024 that will close this issue
Open
@c2thorn c2thorn reopened this May 30, 2024
@c2thorn
Copy link
Collaborator

c2thorn commented May 30, 2024

Okay? So should the docs be updated?

fair point, made GoogleCloudPlatform/magic-modules#10835

GCP rest API docs are already accurate since there is both
https://cloud.google.com/sql/docs/postgres/admin-api/rest/v1beta4/users#sqlusertype and https://cloud.google.com/sql/docs/mysql/admin-api/rest/v1beta4/users#sqlusertype separately

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug forward/linked service/sqladmin-infra
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Update sql_user type c2thorn/magic-modules
4 participants
@c2thorn @jarodevs @modular-magician @ggtisc