source include/have_ndb.inc; let $secret_key = $MYSQL_TMP_DIR/secret_key.txt; --echo Verify that ndb_secretsfile_reader prints the correct node master key --echo if valid secrets file (S0.sysfile) and correct filesystem-password are provided exec $NDB_SECRETSFILE_READER --filesystem-password=topsecret suite/ndb/ndbfs_files/8.0.31_le/NDBCNTR/S0.sysfile; exec $NDB_SECRETSFILE_READER --filesystem-password=topsecret suite/ndb/ndbfs_files/8.0.31_be/NDBCNTR/S0.sysfile; --echo --echo Verify that ndb_secretsfile_reader throws an error if provided filesystem-password is not correct --error 1 exec $NDB_SECRETSFILE_READER --filesystem-password=wrongpwd suite/ndb/ndbfs_files/8.0.31_le/NDBCNTR/S0.sysfile 2>&1; --echo --echo Verify that ndb_secretsfile_reader throws a warning if provided file is not encrypted --echo Create an unencrypted version of secrets file (S0.sysfile) exec $NDBXFRM --decrypt-password="topsecret" suite/ndb/ndbfs_files/8.0.31_le/NDBCNTR/S0.sysfile $MYSQL_TMP_DIR/S0_decrypted.sysfile; exec $NDB_SECRETSFILE_READER --filesystem-password=topsecret $MYSQL_TMP_DIR/S0_decrypted.sysfile 2>&1; --echo --echo Verify that ndb_secretsfile_reader throws an error if provided file is not a valid secretsfile --echo Create an invalid secrets file write_file $MYSQL_TMP_DIR/S0_invalid.sysfile; INVALID DATA EOF --error 1 exec $NDB_SECRETSFILE_READER --filesystem-password=topsecret $MYSQL_TMP_DIR/S0_invalid.sysfile 2>&1; --echo --echo Verify that NMK stored in secretsfile of current live cluster is valid and --echo can be used to successfully decrypt system files. --echo Extract NMK from secrets file exec $NDB_SECRETSFILE_READER --filesystem-password=topsecret $MYSQLTEST_VARDIR/mysql_cluster.1/ndbd.2/ndb_2_fs/D1/NDBCNTR/S0.sysfile > $secret_key; --echo Decrypt system file using the extracted NMK exec $NDBXFRM 2>&1 < $secret_key --decrypt-key-from-stdin $MYSQLTEST_VARDIR/mysql_cluster.1/ndbd.2/ndb_2_fs/D8/DBLQH/S0.FragLog $MYSQL_TMP_DIR/S0_decrypted.FragLog; --remove_file $secret_key --remove_file $MYSQL_TMP_DIR/S0_decrypted.sysfile --remove_file $MYSQL_TMP_DIR/S0_invalid.sysfile --remove_file $MYSQL_TMP_DIR/S0_decrypted.FragLog