~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_ssl1.result

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
ImportĀ upstreamĀ versionĀ 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
18
18
select * from t1;
19
19
t
20
20
1
21
 
show slave status;
22
 
Slave_IO_State  #
23
 
Master_Host     127.0.0.1
24
 
Master_User     replssl
25
 
Master_Port     MASTER_MYPORT
26
 
Connect_Retry   1
27
 
Master_Log_File #
28
 
Read_Master_Log_Pos     #
29
 
Relay_Log_File  #
30
 
Relay_Log_Pos   #
31
 
Relay_Master_Log_File   #
32
 
Slave_IO_Running        #
33
 
Slave_SQL_Running       Yes
34
 
Replicate_Do_DB 
35
 
Replicate_Ignore_DB     
36
 
Replicate_Do_Table      
37
 
Replicate_Ignore_Table  #
38
 
Replicate_Wild_Do_Table 
39
 
Replicate_Wild_Ignore_Table     
40
 
Last_Errno      0
41
 
Last_Error      
42
 
Skip_Counter    0
43
 
Exec_Master_Log_Pos     #
44
 
Relay_Log_Space #
45
 
Until_Condition None
46
 
Until_Log_File  
47
 
Until_Log_Pos   0
48
21
Master_SSL_Allowed      Yes
 
22
Master_SSL_CA_Path      
49
23
Master_SSL_CA_File      MYSQL_TEST_DIR/std_data/cacert.pem
50
 
Master_SSL_CA_Path      
51
24
Master_SSL_Cert MYSQL_TEST_DIR/std_data/client-cert.pem
52
 
Master_SSL_Cipher       
53
25
Master_SSL_Key  MYSQL_TEST_DIR/std_data/client-key.pem
54
 
Seconds_Behind_Master   #
55
 
Master_SSL_Verify_Server_Cert   No
56
 
Last_IO_Errno   #
57
 
Last_IO_Error   #
58
 
Last_SQL_Errno  0
59
 
Last_SQL_Error  
 
26
Checking that both slave threads are running.
60
27
stop slave;
61
28
change master to master_user='root',master_password='', master_ssl=0;
62
29
start slave;
63
30
drop user replssl@localhost;
64
31
drop table t1;
65
 
show slave status;
66
 
Slave_IO_State  #
67
 
Master_Host     127.0.0.1
68
 
Master_User     root
69
 
Master_Port     MASTER_MYPORT
70
 
Connect_Retry   1
71
 
Master_Log_File #
72
 
Read_Master_Log_Pos     #
73
 
Relay_Log_File  #
74
 
Relay_Log_Pos   #
75
 
Relay_Master_Log_File   #
76
 
Slave_IO_Running        #
77
 
Slave_SQL_Running       Yes
78
 
Replicate_Do_DB 
79
 
Replicate_Ignore_DB     
80
 
Replicate_Do_Table      
81
 
Replicate_Ignore_Table  #
82
 
Replicate_Wild_Do_Table 
83
 
Replicate_Wild_Ignore_Table     
84
 
Last_Errno      0
85
 
Last_Error      
86
 
Skip_Counter    0
87
 
Exec_Master_Log_Pos     #
88
 
Relay_Log_Space #
89
 
Until_Condition None
90
 
Until_Log_File  
91
 
Until_Log_Pos   0
92
32
Master_SSL_Allowed      No
 
33
Master_SSL_CA_Path      
93
34
Master_SSL_CA_File      MYSQL_TEST_DIR/std_data/cacert.pem
94
 
Master_SSL_CA_Path      
95
35
Master_SSL_Cert MYSQL_TEST_DIR/std_data/client-cert.pem
96
 
Master_SSL_Cipher       
97
36
Master_SSL_Key  MYSQL_TEST_DIR/std_data/client-key.pem
98
 
Seconds_Behind_Master   #
99
 
Master_SSL_Verify_Server_Cert   No
100
 
Last_IO_Errno   #
101
 
Last_IO_Error   #
102
 
Last_SQL_Errno  0
103
 
Last_SQL_Error  
 
37
Checking that both slave threads are running.
104
38
stop slave;
105
39
change master to
106
40
master_host="localhost",
116
50
select * from t1;
117
51
t
118
52
1
119
 
show slave status;
120
 
Slave_IO_State  #
121
 
Master_Host     localhost
122
 
Master_User     root
123
 
Master_Port     MASTER_MYPORT
124
 
Connect_Retry   1
125
 
Master_Log_File #
126
 
Read_Master_Log_Pos     #
127
 
Relay_Log_File  #
128
 
Relay_Log_Pos   #
129
 
Relay_Master_Log_File   #
130
 
Slave_IO_Running        #
131
 
Slave_SQL_Running       Yes
132
 
Replicate_Do_DB 
133
 
Replicate_Ignore_DB     
134
 
Replicate_Do_Table      
135
 
Replicate_Ignore_Table  #
136
 
Replicate_Wild_Do_Table 
137
 
Replicate_Wild_Ignore_Table     
138
 
Last_Errno      0
139
 
Last_Error      
140
 
Skip_Counter    0
141
 
Exec_Master_Log_Pos     #
142
 
Relay_Log_Space #
143
 
Until_Condition None
144
 
Until_Log_File  
145
 
Until_Log_Pos   0
146
53
Master_SSL_Allowed      Yes
 
54
Master_SSL_CA_Path      
147
55
Master_SSL_CA_File      MYSQL_TEST_DIR/std_data/cacert.pem
148
 
Master_SSL_CA_Path      
149
56
Master_SSL_Cert MYSQL_TEST_DIR/std_data/client-cert.pem
150
 
Master_SSL_Cipher       
151
57
Master_SSL_Key  MYSQL_TEST_DIR/std_data/client-key.pem
152
 
Seconds_Behind_Master   #
153
 
Master_SSL_Verify_Server_Cert   Yes
154
 
Last_IO_Errno   #
155
 
Last_IO_Error   #
156
 
Last_SQL_Errno  0
157
 
Last_SQL_Error  
 
58
Checking that both slave threads are running.
158
59
drop table t1;