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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
|
// Copyright 2020 PingCAP, Inc.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// See the License for the specific language governing permissions and
// limitations under the License.
package command
import (
"database/sql"
"fmt"
"strings"
"github.com/fatih/color"
"github.com/pingcap/tiup/pkg/cluster/spec"
"github.com/pingcap/tiup/pkg/cluster/task"
"github.com/pingcap/tiup/pkg/crypto/rand"
"github.com/pingcap/tiup/pkg/proxy"
"github.com/pingcap/tiup/pkg/utils"
"github.com/spf13/cobra"
// for sql/driver
_ "github.com/go-sql-driver/mysql"
)
func newStartCmd() *cobra.Command {
var (
initPasswd bool
restoreLeader bool
)
cmd := &cobra.Command{
Use: "start <cluster-name>",
Short: "Start a TiDB cluster",
RunE: func(cmd *cobra.Command, args []string) error {
if len(args) != 1 {
return cmd.Help()
}
if err := validRoles(gOpt.Roles); err != nil {
return err
}
clusterName := args[0]
if err := cm.StartCluster(clusterName, gOpt, restoreLeader, func(b *task.Builder, metadata spec.Metadata) {
b.UpdateTopology(
clusterName,
tidbSpec.Path(clusterName),
metadata.(*spec.ClusterMeta),
nil, /* deleteNodeIds */
)
}); err != nil {
return err
}
// init password
if initPasswd {
pwd, err := initPassword(clusterName)
if err != nil {
log.Errorf("Failed to set root password of TiDB database to '%s'", pwd)
if strings.Contains(strings.ToLower(err.Error()), "error 1045") {
log.Errorf("Initializing is only working when the root password is empty")
log.Errorf("%s", color.YellowString("Did you already set root password before?"))
}
return err
}
log.Warnf("The root password of TiDB database has been changed.")
fmt.Printf("The new password is: '%s'.\n", color.HiYellowString(pwd)) // use fmt to avoid printing to audit log
log.Warnf("Copy and record it to somewhere safe, %s, and will not be stored.", color.HiRedString("it is only displayed once"))
log.Warnf("The generated password %s.", color.HiRedString("can NOT be get and shown again"))
}
return nil
},
ValidArgsFunction: func(cmd *cobra.Command, args []string, toComplete string) ([]string, cobra.ShellCompDirective) {
switch len(args) {
case 0:
return shellCompGetClusterName(cm, toComplete)
default:
return nil, cobra.ShellCompDirectiveNoFileComp
}
},
}
cmd.Flags().BoolVar(&initPasswd, "init", false, "Initialize a secure root password for the database")
cmd.Flags().BoolVar(&restoreLeader, "restore-leaders", false, "Allow leaders to be scheduled to stores after start")
cmd.Flags().StringSliceVarP(&gOpt.Roles, "role", "R", nil, "Only start specified roles")
cmd.Flags().StringSliceVarP(&gOpt.Nodes, "node", "N", nil, "Only start specified nodes")
_ = cmd.Flags().MarkHidden("restore-leaders")
return cmd
}
func initPassword(clusterName string) (string, error) {
metadata, err := spec.ClusterMetadata(clusterName)
if err != nil {
return "", err
}
tcpProxy := proxy.GetTCPProxy()
// generate password
pwd, err := rand.Password(18)
if err != nil {
return pwd, err
}
var lastErr error
for _, spec := range metadata.Topology.TiDBServers {
endpoint := utils.JoinHostPort(spec.Host, spec.Port)
if tcpProxy != nil {
closeC := tcpProxy.Run([]string{endpoint})
defer tcpProxy.Close(closeC)
endpoint = tcpProxy.GetEndpoints()[0]
}
db, err := createDB(endpoint)
if err != nil {
lastErr = err
continue
}
defer db.Close()
sqlStr := fmt.Sprintf("SET PASSWORD FOR 'root'@'%%' = '%s'; FLUSH PRIVILEGES;", pwd)
_, err = db.Exec(sqlStr)
if err != nil {
lastErr = err
continue
}
return pwd, nil
}
return pwd, lastErr
}
func createDB(endpoint string) (db *sql.DB, err error) {
dsn := fmt.Sprintf("root:@tcp(%s)/?charset=utf8mb4,utf8&multiStatements=true", endpoint)
db, err = sql.Open("mysql", dsn)
return
}
|
