Beispiel #1
0
func (s MysqlService) Bind(serviceInstance string, bindID string, req broker.BindRequest, planConfig config.PlanConfig) (resp broker.BindResponse, err error) {

	cred := broker.BindCredentials{Host: s.conf.Host, Port: s.conf.Port}

	// md5Sum := md5.Sum([]byte(bindID))
	// cred.Username = fmt.Sprintf("%x", md5Sum[0:8]) //Mysql supports username <= 16 chars.

	cred.Username = bindID[0:16] //Mysql supports username <= 16 chars.
	cred.Password = utils.Rand_str(16)
	cred.Database = serviceInstance
	cred.Uri = fmt.Sprintf("mysql://%s:%s@%s:%d/%s", cred.Username, cred.Password, cred.Host, cred.Port, cred.Database)

	resp = broker.BindResponse{Credentials: cred}

	sql := fmt.Sprintf("CREATE USER '%s'@'%%' IDENTIFIED BY '%s'", cred.Username, cred.Password)
	_, err = s.db.Exec(sql)
	if err != nil {
		return
	}

	sql = fmt.Sprintf("GRANT ALL ON `%s`.* TO '%s'@'%%' WITH MAX_USER_CONNECTIONS %d", cred.Database, cred.Username, planConfig.Concurrency)
	_, err = s.db.Exec(sql)
	if err != nil {
		return
	}

	_, err = s.db.Exec("FLUSH PRIVILEGES")
	return

	return broker.BindResponse{}, nil
}
Beispiel #2
0
func (s *PostgresService) Bind(serviceInstance string, bindID string, req broker.BindRequest, planConfig config.PlanConfig) (resp broker.BindResponse, err error) {

	cred := broker.BindCredentials{Host: s.conf.Host, Port: s.conf.Port}
	cred.Username = bindID
	cred.Password = utils.Rand_str(16)
	cred.Database = serviceInstance
	cred.Uri = fmt.Sprintf("postgres://%s:%s@%s:%d/%s", cred.Username, cred.Password, cred.Host, cred.Port, cred.Database)

	resp = broker.BindResponse{Credentials: cred}

	sql := fmt.Sprintf("CREATE USER \"%s\" WITH PASSWORD '%s'", cred.Username, cred.Password)
	_, err = s.db.Exec(sql)
	if err != nil {
		return
	}

	sql = fmt.Sprintf("GRANT ALL PRIVILEGES ON DATABASE \"%s\" TO \"%s\"", cred.Database, cred.Username)
	_, err = s.db.Exec(sql)
	return
}