/
sqlserver.go
109 lines (87 loc) · 2.96 KB
/
sqlserver.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
package sqlserver
import (
"context"
"database/sql"
"time"
regexp "github.com/wasilibs/go-re2"
mssql "github.com/microsoft/go-mssqldb"
"github.com/microsoft/go-mssqldb/msdsn"
"github.com/trufflesecurity/trufflehog/v3/pkg/pb/detectorspb"
"github.com/trufflesecurity/trufflehog/v3/pkg/detectors"
)
type Scanner struct{}
// Ensure the Scanner satisfies the interface at compile time.
var _ detectors.Detector = (*Scanner)(nil)
var (
// SQLServer connection string is a semicolon delimited set of case-insensitive parameters which may go in any order.
pattern = regexp.MustCompile("(?:\n|`|'|\"| )?((?:[A-Za-z0-9_ ]+=[^;$'`\"$]+;?){3,})(?:'|`|\"|\r\n|\n)?")
)
// Keywords are used for efficiently pre-filtering chunks.
// Use identifiers in the secret preferably, or the provider name.
func (s Scanner) Keywords() []string {
return []string{"sql", "database", "Data Source", "Server=", "Network address="}
}
// FromData will find and optionally verify SpotifyKey secrets in a given set of bytes.
func (s Scanner) FromData(ctx context.Context, verify bool, data []byte) (results []detectors.Result, err error) {
matches := pattern.FindAllStringSubmatch(string(data), -1)
for _, match := range matches {
paramsUnsafe, err := msdsn.Parse(match[1])
if err != nil {
continue
}
if paramsUnsafe.Password == "" {
continue
}
s1 := detectors.Result{
DetectorType: detectorspb.DetectorType_SQLServer,
Raw: []byte(paramsUnsafe.Password),
RawV2: []byte(paramsUnsafe.URL().String()),
Redacted: detectors.RedactURL(*paramsUnsafe.URL()),
}
if verify {
isVerified, err := ping(paramsUnsafe)
s1.Verified = isVerified
if mssqlErr, isMssqlErr := err.(mssql.Error); isMssqlErr && mssqlErr.Number == 18456 {
// Login failed
// Number taken from https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors?view=sql-server-ver16
// Nothing to do; determinate failure to verify
} else {
s1.SetVerificationError(err, paramsUnsafe.Password)
}
}
results = append(results, s1)
}
return results, nil
}
var ping = func(config msdsn.Config) (bool, error) {
cleanConfig := msdsn.Config{}
cleanConfig.Host = config.Host
cleanConfig.Port = config.Port
cleanConfig.User = config.User
cleanConfig.Password = config.Password
cleanConfig.Database = config.Database
cleanConfig.DisableRetry = true
cleanConfig.Encryption = config.Encryption
cleanConfig.TLSConfig = config.TLSConfig
cleanConfig.Instance = config.Instance
cleanConfig.DialTimeout = time.Second * 3
cleanConfig.ConnTimeout = time.Second * 3
url := cleanConfig.URL()
query := url.Query()
url.RawQuery = query.Encode()
conn, err := sql.Open("mssql", url.String())
if err != nil {
return false, err
}
defer func() {
_ = conn.Close()
}()
err = conn.Ping()
if err != nil {
return false, err
}
return true, nil
}
func (s Scanner) Type() detectorspb.DetectorType {
return detectorspb.DetectorType_SQLServer
}