Debian Codegraph @

mysql-test/suite/auth_sec/include/multiple_plugins.inc

raw
1 #
2 # Input(s) :
3 # $server_default_authentication_plugin
4 #
5
6 --echo # Restart the server with $server_default_authentication_plugin as default authnetication plugin
7 let $restart_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect;
8 --exec echo "wait" > $restart_file
9 --shutdown_server
10 --source include/wait_until_disconnected.inc
11 --exec echo "restart:--default-authentication-plugin=$server_default_authentication_plugin" > $restart_file
12 --enable_reconnect
13 --source include/wait_until_connected_again.inc
14 --disable_reconnect
15
16
17 --echo # Create users
18
19 CREATE USER caching_sha2@localhost IDENTIFIED WITH 'caching_sha2_password' BY 'abcd';
20 CREATE USER native@localhost IDENTIFIED WITH 'mysql_native_password' BY 'abcd';
21 CREATE USER sha256@localhost IDENTIFIED WITH 'sha256_password' BY 'abcd';
22
23 --echo # Connection tests
24
25 --exec $MYSQL --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -ucaching_sha2 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
26 --exec $MYSQL --default-auth=mysql_native_password --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -ucaching_sha2 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
27 --exec $MYSQL --default-auth=sha256_password --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -ucaching_sha2 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
28 FLUSH PRIVILEGES;
29
30 --exec $MYSQL --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -ucaching_sha2 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
31 FLUSH PRIVILEGES;
32 --exec $MYSQL --default-auth=mysql_native_password --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -ucaching_sha2 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
33 FLUSH PRIVILEGES;
34 --exec $MYSQL --default-auth=sha256_password --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -ucaching_sha2 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
35 FLUSH PRIVILEGES;
36
37
38 --exec $MYSQL --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -unative -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
39 --exec $MYSQL --default-auth=mysql_native_password --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -unative -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
40 --exec $MYSQL --default-auth=sha256_password --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -unative -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
41 FLUSH PRIVILEGES;
42
43
44 --exec $MYSQL --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -usha256 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
45 --exec $MYSQL --default-auth=mysql_native_password --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -usha256 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
46 --exec $MYSQL --default-auth=sha256_password --protocol=TCP --host=127.0.0.1 -P$MASTER_MYPORT -usha256 -pabcd --ssl-mode=REQUIRED -e "SELECT CURRENT_USER()" 2>&1
47 FLUSH PRIVILEGES;
48
49 --echo # Change user tests
50
51 --connect(caching_sha2_conn, localhost, caching_sha2, abcd,,,,SSL)
52 --change_user native, abcd
53 SELECT CURRENT_USER();
54 --change_user sha256, abcd
55 SELECT CURRENT_USER();
56 --change_user
57 SELECT CURRENT_USER();
58
59 --connect(native_conn, localhost, native, abcd,,,,SSL)
60 --change_user caching_sha2, abcd
61 SELECT CURRENT_USER();
62 --change_user sha256, abcd
63 SELECT CURRENT_USER();
64 --change_user
65 SELECT CURRENT_USER();
66
67 --connect(sha256_conn, localhost, sha256, abcd,,,,SSL)
68 --change_user caching_sha2, abcd
69 SELECT CURRENT_USER();
70 --change_user native, abcd
71 SELECT CURRENT_USER();
72 --change_user
73 SELECT CURRENT_USER();
74
75 --connection default
76 --disconnect caching_sha2_conn
77 --disconnect native_conn
78 --disconnect sha256_conn
79
80 --echo # Drop users
81
82 DROP USER caching_sha2@localhost;
83 DROP USER native@localhost;
84 DROP USER sha256@localhost;
85
86 --source include/force_restart.inc