mirror of
https://github.com/MariaDB/server.git
synced 2025-08-01 03:47:19 +03:00
a1e5a284fc
Implement automatic creation of temporary accounts for SST and pass account credentials to SST script via socket as opposed to environment variables. Delete the user after the SST script returns, Respect wsrep_sst_auth set by the adminitrator in case some additional privilege grants are needed for particular SST method. mysqldump SST requires significant change to make use of the new automatic user generation facility. For now just make it compatible by ignoring automatically generated user and rely only on wsrep_sst_auth setting on the joiner node to keep backward compatibility. Adapt mysqldump SST to automatic SST user generation changes: - disable special treatment for mysqldump SST on donor - make mysqldump SST script compatible with the new SST script interface. Differentiate user privileges for different SST methods: - grant minimum required privileges for clone and xtrabackup SST accounts - grant all privileges to custom SST accounts as it is not known what is needed. - disable SST account generation for rsync SST since it is not needed. MTR tests: - add MTR tests for clone and xtrabackup SSTs without wsrep_sst_auth, - add MTR test for testing masking of wsrep_sst_auth. - don't attmept to restore original wsrep_sst_auth in MTR tests as it is always masked. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
40 lines
897 B
Plaintext
40 lines
897 B
Plaintext
--source include/have_wsrep.inc
|
|
|
|
--echo #
|
|
--echo # wsrep_sst_auth
|
|
--echo #
|
|
|
|
--echo # default
|
|
SELECT @@global.wsrep_sst_auth;
|
|
|
|
--echo
|
|
--echo # scope
|
|
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
|
|
SELECT @@session.wsrep_sst_auth;
|
|
SET @@global.wsrep_sst_auth='user:pass';
|
|
SELECT @@global.wsrep_sst_auth;
|
|
|
|
--echo
|
|
--echo # valid values
|
|
SET @@global.wsrep_sst_auth=user;
|
|
SELECT @@global.wsrep_sst_auth;
|
|
SET @@global.wsrep_sst_auth='user:1234';
|
|
SELECT @@global.wsrep_sst_auth;
|
|
SET @@global.wsrep_sst_auth='hyphenated-user-name:';
|
|
SELECT @@global.wsrep_sst_auth;
|
|
SET @@global.wsrep_sst_auth=default;
|
|
SELECT @@global.wsrep_sst_auth;
|
|
SET @@global.wsrep_sst_auth=NULL;
|
|
SELECT @@global.wsrep_sst_auth;
|
|
|
|
--echo
|
|
--echo # invalid values
|
|
--error ER_WRONG_TYPE_FOR_VAR
|
|
SET @@global.wsrep_sst_auth=1;
|
|
SELECT @@global.wsrep_sst_auth;
|
|
--error ER_PARSE_ERROR
|
|
SET @@global.wsrep_sst_auth=user:pass;
|
|
|
|
--echo
|
|
--echo # End of test
|