Debian Codegraph @

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

raw
1 ############# mysql-test\t\old_passwords_func.test ############################
2 # #
3 # Variable Name: old_passwords #
4 # Scope: GLOBAL & SESSION #
5 # Access Type: Dynamic #
6 # Data Type: BOOLEAN #
7 # Default Value: FALSE #
8 # Values: TRUE, FALSE #
9 # #
10 # #
11 # Creation Date: 2008-03-12 #
12 # Author: Sharique Abdullah #
13 # #
14 # Description: Test Cases of Dynamic System Variable "old_passwords" #
15 # that checks behavior of this variable in the following ways #
16 # * Functionality based on different values #
17 # #
18 # Reference: http://dev.mysql.com/doc/refman/5.0/en #
19 # /server-options.html#option_mysqld_old-passwords #
20 # #
21 ###############################################################################
22
23 #
24 # Setup
25 #
26
27 --source include/not_embedded.inc
28
29 SET @global_old_passwords = @@GLOBAL.old_passwords;
30 SET @session_old_passwords = @@SESSION.old_passwords;
31 SET @global_secure_auth = @@GLOBAL.secure_auth;
32
33
34 --echo '#------------------------FN_DYNVARS_115_01---------------------------#'
35
36 connection default;
37
38 #
39 # 2 Users with FALSE value
40 #
41
42 CREATE USER 'userNewPass1'@'localhost' IDENTIFIED BY 'pass1';
43 CREATE USER 'userNewPass2'@'localhost' IDENTIFIED BY 'pass2';
44
45 SET GLOBAL old_passwords = TRUE;
46 SET SESSION old_passwords = TRUE;
47
48 #
49 # 1 User with TRUE value
50 #
51
52 CREATE USER 'userOldPass'@'localhost' IDENTIFIED BY 'pass3';
53
54 SET GLOBAL secure_auth = FALSE;
55
56 connect (con1,localhost,userNewPass1,pass1,);
57 SELECT CURRENT_USER();
58 --echo userNewPass1@localhost Expected
59
60 connect (con2,localhost,userNewPass2,pass2,);
61 SELECT CURRENT_USER();
62 --echo userNewPass2@localhost Expected
63
64 --replace_result $MASTER_MYSOCK MASTER_MYSOCK $MASTER_MYPORT MASTER_MYPORT
65 --error 5010
66 connect con3,localhost,userOldPass,pass3;
67 connect con3,localhost,userOldPass,pass3,,,,auth=mysql_old_password:mysql_native_password;
68
69 SELECT CURRENT_USER();
70 --echo userOldPass@localhost Expected
71
72 connection default;
73
74 disconnect con1;
75 disconnect con2;
76 disconnect con3;
77
78 --echo '#------------------------FN_DYNVARS_115_02---------------------------#'
79
80 SET GLOBAL secure_auth = TRUE;
81
82 connect (con1,localhost,userNewPass1,pass1,);
83 SELECT CURRENT_USER();
84 --echo userNewPass1@localhost Expected
85
86 connect (con2,localhost,userNewPass2,pass2,);
87 SELECT CURRENT_USER();
88 --echo userNewPass2@localhost Expected
89
90 --disable_query_log
91 --error ER_SERVER_IS_IN_SECURE_AUTH_MODE
92 connect (con3,localhost,userOldPass,pass3,);
93 --enable_query_log
94 --echo Expected Error 'Server is running in secure auth mode'
95 SELECT CURRENT_USER();
96 --echo userNewPass2@localhost Expected
97
98 connection default;
99
100 disconnect con1;
101 disconnect con2;
102
103 #
104 # Cleanup
105 #
106
107 DROP USER 'userNewPass1'@'localhost';
108 DROP USER 'userNewPass2'@'localhost';
109 DROP USER 'userOldPass'@'localhost';
110
111 SET @@GLOBAL.old_passwords = @global_old_passwords;
112 SET @@SESSION.old_passwords = @session_old_passwords;
113 SET @@GLOBAL.secure_auth = @global_secure_auth;