Debian Codegraph @

mysql-test/suite/sys_vars/t/mysql_native_password_proxy_users_cmdl.test

raw
1 # #
2 # Variable Name: mysql_native_passwrod_proxy_users #
3 # Scope: GLOBAL #
4 # Access Type: Dynamic #
5 # Creation Date: 2015-02-06 #
6 # Author: Horst Hunger #
7 # Description: Test of mysql_native_password_proxy_users on commandline #
8 # #
9 ###############################################################################
10
11 --source include/not_windows.inc
12
13 SELECT @@global.mysql_native_password_proxy_users;
14
15
16 --echo '#----- 2.1.1 Valid values on cmd line -----------------------#'
17 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
18 --shutdown_server
19 --source include/wait_until_disconnected.inc
20 --enable_reconnect
21 --exec echo "restart:--mysql-native-password-proxy-users=1" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
22 --source include/wait_until_connected_again.inc
23 SELECT @@global.mysql_native_password_proxy_users;
24
25 --echo '#----- 2.1.2 Valid values on cmd line -----------------------#'
26 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
27 --shutdown_server
28 --source include/wait_until_disconnected.inc
29 --enable_reconnect
30 --exec echo "restart:--mysql-native-password-proxy-users=TRUE" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
31 --source include/wait_until_connected_again.inc
32 SELECT @@global.mysql_native_password_proxy_users;
33
34 --echo '#----- 2.1.3 Invalid values on cmd line -----------------------#'
35 CALL mtr.add_suppression("option 'mysql_native_password_proxy_users': boolean value '-1' was not recognized. Set to OFF.");
36 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
37 --shutdown_server
38 --source include/wait_until_disconnected.inc
39 --enable_reconnect
40 --exec echo "restart:--mysql-native-password-proxy-users=-1" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
41 --source include/wait_until_connected_again.inc
42 SELECT @@global.mysql_native_password_proxy_users;
43
44 CALL mtr.add_suppression("option 'mysql_native_password_proxy_users': boolean value '43698' was not recognized. Set to OFF.");
45 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
46 --shutdown_server
47 --source include/wait_until_disconnected.inc
48 --enable_reconnect
49 --exec echo "restart:--mysql-native-password-proxy-users=43698" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
50 --source include/wait_until_connected_again.inc
51 SELECT @@global.mysql_native_password_proxy_users;
52
53 CALL mtr.add_suppression("option 'mysql_native_password_proxy_users': boolean value 'TEST' was not recognized. Set to OFF.");
54 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
55 --shutdown_server
56 --source include/wait_until_disconnected.inc
57 --enable_reconnect
58 --exec echo "restart:--mysql-native-password-proxy-users=TEST" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
59 --source include/wait_until_connected_again.inc
60 SELECT @@global.mysql_native_password_proxy_users;
61
62 --echo '#----- 2.1.4 Invalid values on cmd line -----------------------#'
63 CALL mtr.add_suppression("option 'mysql_native_password_proxy_users': boolean value ''test'' was not recognized. Set to OFF.");
64 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
65 --shutdown_server
66 --source include/wait_until_disconnected.inc
67 --enable_reconnect
68 --exec echo "restart:--mysql-native-password-proxy-users='test'" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
69 --source include/wait_until_connected_again.inc
70 SELECT @@global.mysql_native_password_proxy_users;
71
72 --echo '#----- 2.1.5 empty values on cmd line -----------------------#'
73 CALL mtr.add_suppression("option 'mysql_native_password_proxy_users': boolean value '' was not recognized. Set to OFF.");
74 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
75 --shutdown_server
76 --source include/wait_until_disconnected.inc
77 --enable_reconnect
78 --exec echo "restart:--mysql-native-password-proxy-users=" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
79 --source include/wait_until_connected_again.inc
80 SELECT @@global.mysql_native_password_proxy_users;
81
82 # Restore default settings in opt file
83 let $restart_parameters = restart:;
84 source include/restart_mysqld.inc;