Beispiel #1
0
func (s *MainTestSuite) TestNonInteractiveInstallWithMissingApiKey(t *C) {
	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-interactive=false",
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "API key is required, please provide it with -api-key option.\n")
	t.Check(cmdTest.ReadLine(), Equals, "API Key is available at "+s.apphost+"/api-key\n")

	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, ErrorMatches, "exit status 1")

	s.expectConfigs([]string{}, t)
	s.expectMysqlUserNotExists(t)
}
Beispiel #2
0
func (s *MainTestSuite) TestWithAgentMySQLUser(t *C) {

	// Register required api handlers
	s.fakeApi.AppendPing()
	s.fakeApi.AppendInstancesServer(1, s.serverInstance)
	s.fakeApi.AppendInstancesServerId(1, s.serverInstance)
	s.fakeApi.AppendInstancesMysql(1, s.mysqlInstance)
	s.fakeApi.AppendInstancesMysqlId(1, s.mysqlInstance)
	s.fakeApi.AppendConfigsMmDefaultServer()
	s.fakeApi.AppendConfigsQanDefault()
	s.fakeApi.AppendConfigsMmDefaultMysql()
	s.fakeApi.AppendSysconfigDefaultMysql()
	s.fakeApi.AppendAgents(s.agent)
	s.fakeApi.AppendAgentsUuid(s.agent)

	user := "******"
	pass := "******"
	host := "localhost"
	maxCons := 10

	// Create a temporary user because on some installations the default user & pass
	// are empty and for testing -agent-mysql-user & -agent-mysql-pass, we need non-empty
	// user & pass parameters
	grantQuery := fmt.Sprintf("GRANT SUPER, PROCESS, USAGE, SELECT ON *.* TO '%s'@'%s' IDENTIFIED BY '%s' WITH MAX_USER_CONNECTIONS %d", user, host, pass, maxCons)
	s.rootConn.Exec(grantQuery)

	basedir, err := ioutil.TempDir("/tmp", "agent-installer-test-basedir-")
	cmd := exec.Command(
		s.bin,
		"-basedir="+basedir,
		"-api-host="+s.fakeApi.URL(),
		"-agent-mysql-user="******"-agent-mysql-pass="******"-interactive=false",
		"-api-key="+s.apiKey,
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")
	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")
	t.Check(cmdTest.ReadLine(), Equals, "Created agent: uuid=0001\n")
	// Use the s flag (?s) to let .* match \n
	t.Assert(cmdTest.ReadLine(), Matches, fmt.Sprintf("Created server instance: hostname=%s id=%d\n", s.serverInstance.Hostname, s.serverInstance.Id))
	t.Check(cmdTest.ReadLine(), Equals, "Using provided user/pass for mysql-agent user. DSN: some-user:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)\n")
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created MySQL instance: dsn=%s hostname=%s id=%d\n", s.mysqlInstance.DSN, s.mysqlInstance.Hostname, s.mysqlInstance.Id))
	t.Check(cmdTest.ReadLine(), Equals, "")

	err = cmd.Wait()
	t.Assert(err, IsNil)

	// Remove the user we just created for this test
	s.rootConn.Exec(fmt.Sprintf("DROP USER '%s'@'%s'", user, host))
}
Beispiel #3
0
func (s *MainTestSuite) TestInstallFailsOnAgentsLimit(t *C) {
	agentLimit := 5

	// Register required api handlers
	s.fakeApi.AppendPing()
	s.fakeApi.Append("/agents", func(w http.ResponseWriter, r *http.Request) {
		w.Header().Set("X-Percona-Agents-Limit", fmt.Sprintf("%d", agentLimit))
		// Send response
		w.WriteHeader(http.StatusForbidden)
	})

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-mysql-defaults-file="+test.RootDir+"/installer/my.cnf-root_user",
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "No API Key Defined.\n")
	t.Check(cmdTest.ReadLine(), Equals, "Please Enter your API Key, it is available at "+s.apphost+"/api-key\n")
	t.Check(cmdTest.ReadLine(), Equals, "API key: ")
	cmdTest.Write(s.apiKey + "\n")

	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Maximum number of %d agents exceeded.\n", agentLimit))
	t.Check(cmdTest.ReadLine(), Equals, "Go to https://cloud.percona.com/agents and remove unused agents or contact Percona to increase limit.\n")
	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Check(err, ErrorMatches, "exit status 1")

	s.expectConfigs([]string{}, t)
	s.expectMysqlUserNotExists(t)
}
Beispiel #4
0
func (s *MainTestSuite) TestInstallWithWrongApiKey(t *C) {
	s.fakeApi.Append("/ping", http.HandlerFunc(func(w http.ResponseWriter, r *http.Request) {
		w.WriteHeader(http.StatusInternalServerError)
	}))

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	apiKey := "WrongApiKey"
	t.Check(cmdTest.ReadLine(), Equals, "No API Key Defined.\n")
	t.Check(cmdTest.ReadLine(), Equals, "Please Enter your API Key, it is available at "+s.apphost+"/api-key\n")
	t.Assert(cmdTest.ReadLine(), Equals, "API key: ")
	cmdTest.Write(apiKey + "\n")
	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+apiKey+"...\n")
	t.Check(cmdTest.ReadLine(), Equals, "Sorry, there's an API problem (status code 500). Please try to install again. If the problem continues, contact Percona.\n")

	t.Assert(cmdTest.ReadLine(), Equals, "Try again? (Y): ")
	cmdTest.Write("N\n")
	t.Check(cmdTest.ReadLine(), Equals, "Failed to verify API key\n")

	t.Assert(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, ErrorMatches, "exit status 1")

	s.expectConfigs([]string{}, t)
	s.expectMysqlUserNotExists(t)
}
Beispiel #5
0
func (s *MainTestSuite) TestInstallWithFlagOldPasswordsTrue(t *C) {
	// Register required api handlers
	s.fakeApi.AppendPing()
	serverInstance := &proto.ServerInstance{}
	s.fakeApi.AppendInstancesServer(s.serverInstance.Id, serverInstance)
	s.fakeApi.AppendInstancesServerId(s.serverInstance.Id, serverInstance)
	mysqlInstance := &proto.MySQLInstance{}
	s.fakeApi.AppendInstancesMysql(s.mysqlInstance.Id, mysqlInstance)
	s.fakeApi.AppendInstancesMysqlId(s.mysqlInstance.Id, mysqlInstance)
	s.fakeApi.AppendConfigsMmDefaultServer()
	s.fakeApi.AppendConfigsMmDefaultMysql()
	s.fakeApi.AppendSysconfigDefaultMysql()
	s.fakeApi.AppendConfigsQanDefault()
	s.fakeApi.AppendAgents(s.agent)
	s.fakeApi.AppendAgentsUuid(s.agent)

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-mysql-defaults-file="+test.RootDir+"/installer/my.cnf-root_user",
		"-old-passwords=true",
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "No API Key Defined.\n")
	t.Check(cmdTest.ReadLine(), Equals, "Please Enter your API Key, it is available at "+s.apphost+"/api-key\n")
	t.Check(cmdTest.ReadLine(), Equals, "API key: ")
	cmdTest.Write(s.apiKey + "\n")

	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created agent: uuid=%s\n", s.agent.Uuid))
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created server instance: hostname=%s id=%d\n", s.serverInstance.Hostname, s.serverInstance.Id))

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("MySQL root DSN: %s:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)\n", s.username))
	// Flag -old-passwords=true should add &allowOldPasswords=true to DSN
	t.Check(cmdTest.ReadLine(), Equals, "Created MySQL user: percona-agent:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)/?parseTime=true&allowOldPasswords=true\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created MySQL instance: dsn=%s hostname=%s id=%d\n", mysqlInstance.DSN, s.mysqlInstance.Hostname, s.mysqlInstance.Id))
	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, IsNil)

	s.expectConfigs(
		[]string{
			"agent.conf",
			"data.conf",
			"log.conf",
			fmt.Sprintf("mm-mysql-%d.conf", s.mysqlInstance.Id),
			fmt.Sprintf("mm-server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("mysql-%d.conf", s.mysqlInstance.Id),
			"qan.conf",
			fmt.Sprintf("server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("sysconfig-mysql-%d.conf", s.mysqlInstance.Id),
		},
		t,
	)

	s.expectDefaultAgentConfig(t)
	s.expectDefaultDataConfig(t)
	s.expectDefaultLogConfig(t)
	s.expectDefaultMmMysqlConfig(t)
	s.expectDefaultMmServerConfig(t)
	s.expectMysqlConfig(*mysqlInstance, t)
	s.expectDefaultQanConfig(t)
	s.expectServerConfig(*serverInstance, t)
	s.expectDefaultSysconfigMysqlConfig(t)

	// Should create percona-agent user with grants on *.* and performance_schema.*.
	s.expectMysqlUserExists(t)
}
Beispiel #6
0
// todo what's the point of -create-agent flag? for what is it usefull?
func (s *MainTestSuite) TestInstallWithFlagCreateAgentFalse(t *C) {
	// Register required api handlers
	s.fakeApi.AppendPing()
	serverInstance := &proto.ServerInstance{}
	s.fakeApi.AppendInstancesServer(s.serverInstance.Id, serverInstance)
	s.fakeApi.AppendInstancesServerId(s.serverInstance.Id, serverInstance)
	mysqlInstance := &proto.MySQLInstance{}
	s.fakeApi.AppendInstancesMysql(s.mysqlInstance.Id, mysqlInstance)
	s.fakeApi.AppendInstancesMysqlId(s.mysqlInstance.Id, mysqlInstance)
	s.fakeApi.AppendConfigsMmDefaultServer()
	s.fakeApi.AppendConfigsMmDefaultMysql()
	s.fakeApi.AppendSysconfigDefaultMysql()
	s.fakeApi.AppendConfigsQanDefault()
	// Flag -create-agent=false implies that agent
	// shouldn't query below api routes
	//s.fakeApi.AppendAgents(s.agent)
	//s.fakeApi.AppendAgentsUuid(s.agent)

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-mysql-defaults-file="+test.RootDir+"/installer/my.cnf-root_user",
		"-create-agent=false", // we are testing this flag
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "No API Key Defined.\n")
	t.Check(cmdTest.ReadLine(), Equals, "Please Enter your API Key, it is available at "+s.apphost+"/api-key\n")
	t.Check(cmdTest.ReadLine(), Equals, "API key: ")
	cmdTest.Write(s.apiKey + "\n")
	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created server instance: hostname=%s id=%d\n", s.serverInstance.Hostname, s.serverInstance.Id))

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("MySQL root DSN: %s:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)\n", s.username))
	t.Check(cmdTest.ReadLine(), Equals, "Created MySQL user: percona-agent:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)/?parseTime=true\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created MySQL instance: dsn=%s hostname=%s id=%d\n", mysqlInstance.DSN, s.mysqlInstance.Hostname, s.mysqlInstance.Id))
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Not creating agent (-create-agent=false)\n"))
	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, IsNil)

	s.expectConfigs(
		[]string{
			//fmt.Sprintf("mm-mysql-%d.conf", s.mysqlInstance.Id),
			//fmt.Sprintf("mm-server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("mysql-%d.conf", s.mysqlInstance.Id),
			//"qan.conf",
			fmt.Sprintf("server-%d.conf", s.serverInstance.Id),
			//fmt.Sprintf("sysconfig-mysql-%d.conf", s.mysqlInstance.Id),
		},
		t,
	)

	//s.expectDefaultMmMysqlConfig(t)
	//s.expectDefaultMmServerConfig(t)
	s.expectMysqlConfig(*mysqlInstance, t)
	//s.expectDefaultQanConfig(t)
	s.expectServerConfig(*serverInstance, t)
	//s.expectDefaultSysconfigMysqlConfig(t)

	s.expectMysqlUserExists(t)
}
Beispiel #7
0
func (s *MainTestSuite) TestInstallFailsOnUpdatingMySQLInstance(t *C) {
	// Register required api handlers
	s.fakeApi.AppendPing()
	serverInstance := &proto.ServerInstance{}
	s.fakeApi.AppendInstancesServer(s.serverInstance.Id, serverInstance)
	s.fakeApi.AppendInstancesServerId(s.serverInstance.Id, serverInstance)
	s.fakeApi.Append("/instances/mysql", func(w http.ResponseWriter, r *http.Request) {
		w.Header().Set("Location", fmt.Sprintf("%s/instances/mysql/%d", s.fakeApi.URL(), s.mysqlInstance.Id))
		w.WriteHeader(http.StatusConflict) // Instance already exists
	})
	s.fakeApi.Append(fmt.Sprintf("/instances/mysql/%d", s.mysqlInstance.Id), func(w http.ResponseWriter, r *http.Request) {
		switch r.Method {
		case "PUT":
			w.WriteHeader(http.StatusInternalServerError)
		default:
			w.WriteHeader(600)
		}
	})
	s.fakeApi.AppendConfigsMmDefaultServer()
	s.fakeApi.AppendConfigsMmDefaultMysql()
	s.fakeApi.AppendSysconfigDefaultMysql()
	s.fakeApi.AppendAgents(s.agent)
	s.fakeApi.AppendAgentsUuid(s.agent)

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-mysql-defaults-file="+test.RootDir+"/installer/my.cnf-root_user",
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "No API Key Defined.\n")
	t.Check(cmdTest.ReadLine(), Equals, "Please Enter your API Key, it is available at "+s.apphost+"/api-key\n")
	t.Check(cmdTest.ReadLine(), Equals, "API key: ")
	cmdTest.Write(s.apiKey + "\n")

	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created agent: uuid=%s\n", s.agent.Uuid))
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created server instance: hostname=%s id=%d\n", s.serverInstance.Hostname, s.serverInstance.Id))

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("MySQL root DSN: %s:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)\n", s.username))
	t.Check(cmdTest.ReadLine(), Equals, "Created MySQL user: percona-agent:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)/?parseTime=true\n")

	t.Check(cmdTest.ReadLine(), Equals, "Failed to update MySQL instance (status code 500)\n")
	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, ErrorMatches, "exit status 1")

	s.expectConfigs([]string{}, t)
	s.expectMysqlUserExists(t) // @todo this is wrong
}
Beispiel #8
0
func (s *MainTestSuite) TestInstallWorksWithExistingMySQLInstanceAndInstanceIsUpdated(t *C) {
	// Register required api handlers
	s.fakeApi.AppendPing()
	serverInstance := &proto.ServerInstance{}
	s.fakeApi.AppendInstancesServer(s.serverInstance.Id, serverInstance)
	s.fakeApi.AppendInstancesServerId(s.serverInstance.Id, serverInstance)
	mysqlInstance := &proto.MySQLInstance{}
	s.fakeApi.Append("/instances/mysql", func(w http.ResponseWriter, r *http.Request) {
		w.Header().Set("Location", fmt.Sprintf("%s/instances/mysql/%d", s.fakeApi.URL(), s.mysqlInstance.Id))
		w.WriteHeader(http.StatusConflict) // Instance already exists
	})
	s.fakeApi.Append(fmt.Sprintf("/instances/mysql/%d", s.mysqlInstance.Id), func(w http.ResponseWriter, r *http.Request) {
		switch r.Method {
		case "GET":
			w.WriteHeader(http.StatusOK)
			data, _ := json.Marshal(mysqlInstance)
			w.Write(data)
		case "PUT":
			body, err := ioutil.ReadAll(r.Body)
			if err != nil {
				panic(err)
			}
			err = json.Unmarshal(body, mysqlInstance)
			if err != nil {
				panic(err)
			}
			mysqlInstance.Id = s.mysqlInstance.Id
			w.WriteHeader(http.StatusOK)
		default:
			w.WriteHeader(600)
		}
	})
	s.fakeApi.AppendConfigsMmDefaultServer()
	s.fakeApi.AppendConfigsMmDefaultMysql()
	s.fakeApi.AppendSysconfigDefaultMysql()
	s.fakeApi.AppendConfigsQanDefault()
	s.fakeApi.AppendAgents(s.agent)
	s.fakeApi.AppendAgentsUuid(s.agent)

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-mysql-defaults-file="+test.RootDir+"/installer/my.cnf-root_user",
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "No API Key Defined.\n")
	t.Check(cmdTest.ReadLine(), Equals, "Please Enter your API Key, it is available at "+s.apphost+"/api-key\n")
	t.Check(cmdTest.ReadLine(), Equals, "API key: ")
	cmdTest.Write(s.apiKey + "\n")

	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created agent: uuid=%s\n", s.agent.Uuid))
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created server instance: hostname=%s id=%d\n", s.serverInstance.Hostname, s.serverInstance.Id))

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("MySQL root DSN: %s:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)\n", s.username))
	t.Check(cmdTest.ReadLine(), Equals, "Created MySQL user: percona-agent:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)/?parseTime=true\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created MySQL instance: dsn=%s hostname=%s id=%d\n", mysqlInstance.DSN, s.mysqlInstance.Hostname, s.mysqlInstance.Id))
	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, IsNil)

	s.expectConfigs(
		[]string{
			"agent.conf",
			"data.conf",
			"log.conf",
			fmt.Sprintf("mm-mysql-%d.conf", s.mysqlInstance.Id),
			fmt.Sprintf("mm-server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("mysql-%d.conf", s.mysqlInstance.Id),
			"qan.conf",
			fmt.Sprintf("server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("sysconfig-mysql-%d.conf", s.mysqlInstance.Id),
		},
		t,
	)

	s.expectDefaultAgentConfig(t)
	s.expectDefaultDataConfig(t)
	s.expectDefaultLogConfig(t)
	s.expectDefaultMmMysqlConfig(t)
	s.expectDefaultMmServerConfig(t)
	s.expectMysqlConfig(*mysqlInstance, t)
	s.expectDefaultQanConfig(t)
	s.expectServerConfig(*serverInstance, t)
	s.expectDefaultSysconfigMysqlConfig(t)

	// Should create percona-agent user with grants on *.* and performance_schema.*.
	s.expectMysqlUserExists(t)
}
Beispiel #9
0
func (s *MainTestSuite) TestInstall(t *C) {
	// Register required api handlers
	s.fakeApi.AppendPing()
	serverInstance := &proto.ServerInstance{}
	s.fakeApi.AppendInstancesServer(s.serverInstance.Id, serverInstance)
	s.fakeApi.AppendInstancesServerId(s.serverInstance.Id, serverInstance)
	mysqlInstance := &proto.MySQLInstance{}
	s.fakeApi.AppendInstancesMysql(s.mysqlInstance.Id, mysqlInstance)
	s.fakeApi.AppendInstancesMysqlId(s.mysqlInstance.Id, mysqlInstance)
	s.fakeApi.AppendConfigsMmDefaultServer()
	s.fakeApi.AppendConfigsMmDefaultMysql()
	s.fakeApi.AppendSysconfigDefaultMysql()
	s.fakeApi.AppendConfigsQanDefault()
	s.fakeApi.Append("/agents", func(w http.ResponseWriter, r *http.Request) {
		// Validate
		expectedProtoAgent := proto.Agent{
			Uuid:     "",
			Hostname: s.agent.Hostname,
			Version:  s.agent.Version,
		}
		protoAgent := proto.Agent{}
		body, err := ioutil.ReadAll(r.Body)
		t.Assert(err, IsNil)
		err = json.Unmarshal(body, &protoAgent)
		t.Assert(err, IsNil)
		for i := range protoAgent.Configs {
			protoAgent.Configs[i].Updated = time.Time{}
		}
		t.Assert(protoAgent, DeepEquals, expectedProtoAgent)

		// Send response
		w.Header().Set("Location", fmt.Sprintf("%s/agents/%s", s.fakeApi.URL(), s.agent.Uuid))
		w.WriteHeader(http.StatusCreated)
	})
	s.fakeApi.AppendAgentsUuid(s.agent)

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-mysql-defaults-file="+test.RootDir+"/installer/my.cnf-root_user",
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "No API Key Defined.\n")
	t.Check(cmdTest.ReadLine(), Equals, "Please Enter your API Key, it is available at "+s.apphost+"/api-key\n")
	t.Check(cmdTest.ReadLine(), Equals, "API key: ")
	cmdTest.Write(s.apiKey + "\n")

	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created agent: uuid=%s\n", s.agent.Uuid))
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created server instance: hostname=%s id=%d\n", s.serverInstance.Hostname, s.serverInstance.Id))

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("MySQL root DSN: %s:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)\n", s.username))
	t.Check(cmdTest.ReadLine(), Equals, "Created MySQL user: percona-agent:<password-hidden>@unix(/var/run/mysqld/mysqld.sock)/?parseTime=true\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created MySQL instance: dsn=%s hostname=%s id=%d\n", mysqlInstance.DSN, s.mysqlInstance.Hostname, s.mysqlInstance.Id))
	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, IsNil)

	s.expectConfigs(
		[]string{
			"agent.conf",
			"data.conf",
			"log.conf",
			fmt.Sprintf("mm-mysql-%d.conf", s.mysqlInstance.Id),
			fmt.Sprintf("mm-server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("mysql-%d.conf", s.mysqlInstance.Id),
			"qan.conf",
			fmt.Sprintf("server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("sysconfig-mysql-%d.conf", s.mysqlInstance.Id),
		},
		t,
	)

	s.expectDefaultAgentConfig(t)
	s.expectDefaultDataConfig(t)
	s.expectDefaultLogConfig(t)
	s.expectDefaultMmMysqlConfig(t)
	s.expectDefaultMmServerConfig(t)
	s.expectMysqlConfig(*mysqlInstance, t)
	s.expectDefaultQanConfig(t)
	s.expectServerConfig(*serverInstance, t)
	s.expectDefaultSysconfigMysqlConfig(t)

	// Should create percona-agent user with grants on *.* and performance_schema.*.
	s.expectMysqlUserExists(t)
}
Beispiel #10
0
func (s *MainTestSuite) TestNonInteractiveInstallWithFlagCreateMySQLUserFalse(t *C) {
	// Register required api handlers
	s.fakeApi.AppendPing()
	serverInstance := &proto.ServerInstance{}
	s.fakeApi.AppendInstancesServer(s.serverInstance.Id, serverInstance)
	s.fakeApi.AppendInstancesServerId(s.serverInstance.Id, serverInstance)
	mysqlInstance := &proto.MySQLInstance{}
	s.fakeApi.AppendInstancesMysql(s.mysqlInstance.Id, mysqlInstance)
	s.fakeApi.AppendInstancesMysqlId(s.mysqlInstance.Id, mysqlInstance)
	s.fakeApi.AppendConfigsMmDefaultServer()
	s.fakeApi.AppendConfigsMmDefaultMysql()
	s.fakeApi.AppendConfigsQanDefault()
	s.fakeApi.AppendSysconfigDefaultMysql()
	s.fakeApi.AppendAgents(s.agent)
	s.fakeApi.AppendAgentsUuid(s.agent)

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-create-mysql-user=false", // We are testing this flag
		"-interactive=false",       // -create-mysql-user=false works only in non-interactive mode
		"-api-key="+s.apiKey,       // Required because of non-interactive mode
		"-mysql-defaults-file="+test.RootDir+"/installer/my.cnf-percona_user",
	)

	cmdTest := cmdtest.NewCmdTest(cmd)

	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created agent: uuid=%s\n", s.agent.Uuid))
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created server instance: hostname=%s id=%d\n", s.serverInstance.Hostname, s.serverInstance.Id))

	t.Check(cmdTest.ReadLine(), Equals, "Skip creating MySQL user (-create-mysql-user=false)\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created MySQL instance: dsn=%s hostname=%s id=%d\n", mysqlInstance.DSN, s.mysqlInstance.Hostname, s.mysqlInstance.Id))
	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, IsNil)

	s.expectConfigs(
		[]string{
			"agent.conf",
			"data.conf",
			"log.conf",
			fmt.Sprintf("mm-mysql-%d.conf", s.mysqlInstance.Id),
			fmt.Sprintf("mm-server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("mysql-%d.conf", s.mysqlInstance.Id),
			"qan.conf",
			fmt.Sprintf("server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("sysconfig-mysql-%d.conf", s.mysqlInstance.Id),
		},
		t,
	)

	s.expectDefaultAgentConfig(t)
	s.expectDefaultDataConfig(t)
	s.expectDefaultLogConfig(t)
	s.expectDefaultMmMysqlConfig(t)
	s.expectDefaultMmServerConfig(t)
	s.expectMysqlConfig(*mysqlInstance, t)
	s.expectDefaultQanConfig(t)
	s.expectServerConfig(*serverInstance, t)
	s.expectDefaultSysconfigMysqlConfig(t)

	// -create-mysql-user=false
	s.expectMysqlUserNotExists(t)
}
Beispiel #11
0
func (s *MainTestSuite) TestInstallWithFlagMysqlFalse(t *C) {
	// Register required api handlers
	s.fakeApi.AppendPing()
	serverInstance := &proto.ServerInstance{}
	s.fakeApi.AppendInstancesServer(s.serverInstance.Id, serverInstance)
	s.fakeApi.AppendInstancesServerId(s.serverInstance.Id, serverInstance)
	// Flag -mysql=false implies that agent
	// shouldn't query below api routes
	//s.fakeApi.AppendInstancesMysql(s.mysqlInstance)
	//s.fakeApi.AppendInstancesMysqlId(s.mysqlInstance)
	s.fakeApi.AppendConfigsMmDefaultServer()
	//s.fakeApi.AppendConfigsMmDefaultMysql()
	//s.fakeApi.AppendSysconfigDefaultMysql()
	//s.fakeApi.AppendConfigsQanDefault()
	s.fakeApi.AppendAgents(s.agent)
	s.fakeApi.AppendAgentsUuid(s.agent)

	cmd := exec.Command(
		s.bin,
		"-basedir="+pct.Basedir.Path(),
		"-api-host="+s.fakeApi.URL(),
		"-api-key="+s.apiKey,
		"-mysql=false", // We are testing this flag
	)

	cmdTest := cmdtest.NewCmdTest(cmd)
	if err := cmd.Start(); err != nil {
		log.Fatal(err)
	}

	t.Check(cmdTest.ReadLine(), Equals, "CTRL-C at any time to quit\n")
	t.Check(cmdTest.ReadLine(), Equals, "API host: "+s.fakeApi.URL()+"\n")

	t.Check(cmdTest.ReadLine(), Equals, "Verifying API key "+s.apiKey+"...\n")

	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created agent: uuid=%s\n", s.agent.Uuid))
	t.Check(cmdTest.ReadLine(), Equals, fmt.Sprintf("Created server instance: hostname=%s id=%d\n", s.serverInstance.Hostname, s.serverInstance.Id))

	t.Check(cmdTest.ReadLine(), Equals, "Not starting MySQL services (-start-mysql-services=false)\n")
	t.Check(cmdTest.ReadLine(), Equals, "") // No more data

	err := cmd.Wait()
	t.Assert(err, IsNil)

	s.expectConfigs(
		[]string{
			"agent.conf",
			"data.conf",
			"log.conf",
			fmt.Sprintf("mm-server-%d.conf", s.serverInstance.Id),
			fmt.Sprintf("server-%d.conf", s.serverInstance.Id),
		},
		t,
	)

	s.expectDefaultAgentConfig(t)
	s.expectDefaultDataConfig(t)
	s.expectDefaultLogConfig(t)
	s.expectDefaultMmServerConfig(t)
	s.expectServerConfig(*serverInstance, t)

	// Should NOT create percona-agent user with grants on *.* and performance_schema.*.
	s.expectMysqlUserNotExists(t)
}