github.com/khulnasoft-lab/defsec@v1.0.5-0.20230827010352-5e9f46893d95/rules/cloud/policies/google/sql/encrypt_in_transit_data.go (about)

     1  package sql
     2  
     3  import (
     4  	"github.com/khulnasoft-lab/defsec/internal/rules"
     5  	"github.com/khulnasoft-lab/defsec/pkg/providers"
     6  	"github.com/khulnasoft-lab/defsec/pkg/scan"
     7  	"github.com/khulnasoft-lab/defsec/pkg/severity"
     8  	"github.com/khulnasoft-lab/defsec/pkg/state"
     9  )
    10  
    11  var CheckEncryptInTransitData = rules.Register(
    12  	scan.Rule{
    13  		AVDID:       "AVD-GCP-0015",
    14  		Provider:    providers.GoogleProvider,
    15  		Service:     "sql",
    16  		ShortCode:   "encrypt-in-transit-data",
    17  		Summary:     "SSL connections to a SQL database instance should be enforced.",
    18  		Impact:      "Intercepted data can be read in transit",
    19  		Resolution:  "Enforce SSL for all connections",
    20  		Explanation: `In-transit data should be encrypted so that if traffic is intercepted data will not be exposed in plaintext to attackers.`,
    21  		Links: []string{
    22  			"https://cloud.google.com/sql/docs/mysql/configure-ssl-instance",
    23  		},
    24  		Terraform: &scan.EngineMetadata{
    25  			GoodExamples:        terraformEncryptInTransitDataGoodExamples,
    26  			BadExamples:         terraformEncryptInTransitDataBadExamples,
    27  			Links:               terraformEncryptInTransitDataLinks,
    28  			RemediationMarkdown: terraformEncryptInTransitDataRemediationMarkdown,
    29  		},
    30  		Severity: severity.High,
    31  	},
    32  	func(s *state.State) (results scan.Results) {
    33  		for _, instance := range s.Google.SQL.Instances {
    34  			if instance.Metadata.IsUnmanaged() {
    35  				continue
    36  			}
    37  			if instance.Settings.IPConfiguration.RequireTLS.IsFalse() {
    38  				results.Add(
    39  					"Database instance does not require TLS for all connections.",
    40  					instance.Settings.IPConfiguration.RequireTLS,
    41  				)
    42  			} else {
    43  				results.AddPassed(&instance)
    44  			}
    45  		}
    46  		return
    47  	},
    48  )