← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2011-11-08 11:31:13 UTC
  • Revision ID: package-import@ubuntu.com-20111108113113-3ulw01fvi4vn8m25
Tags: upstream-5.5.17
Import upstream version 5.5.17

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_ssl1.result
 
1
include/master-slave.inc
 
2
[connection master]
 
3
grant replication slave on *.* to replssl@localhost require ssl;
 
4
create table t1 (t int);
 
5
stop slave;
 
6
include/wait_for_slave_to_stop.inc
 
7
change master to master_user='replssl',master_password='';
 
8
start slave;
 
9
insert into t1 values (1);
 
10
select * from t1;
 
11
t
 
12
stop slave;
 
13
include/wait_for_slave_to_stop.inc
 
14
change master to master_ssl=1 , master_ssl_ca ='MYSQL_TEST_DIR/std_data/cacert.pem', master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem', master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem';
 
15
start slave;
 
16
include/wait_for_slave_to_start.inc
 
17
select * from t1;
 
18
t
 
19
1
 
20
Master_SSL_Allowed = 'Yes'
 
21
Master_SSL_CA_Path = ''
 
22
Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
 
23
Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
 
24
Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
 
25
include/check_slave_is_running.inc
 
26
stop slave;
 
27
include/wait_for_slave_to_stop.inc
 
28
change master to master_user='root',master_password='', master_ssl=0;
 
29
start slave;
 
30
include/wait_for_slave_to_start.inc
 
31
drop user replssl@localhost;
 
32
drop table t1;
 
33
Master_SSL_Allowed = 'No'
 
34
Master_SSL_CA_Path = ''
 
35
Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
 
36
Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
 
37
Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
 
38
include/check_slave_is_running.inc
 
39
stop slave;
 
40
include/wait_for_slave_to_stop.inc
 
41
change master to
 
42
master_host="localhost",
 
43
master_ssl=1 ,
 
44
master_ssl_ca ='MYSQL_TEST_DIR/std_data/cacert.pem',
 
45
master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem',
 
46
master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem',
 
47
master_ssl_verify_server_cert=1;
 
48
start slave;
 
49
include/wait_for_slave_to_start.inc
 
50
create table t1 (t int);
 
51
insert into t1 values (1);
 
52
on slave
 
53
select * from t1;
 
54
t
 
55
1
 
56
Master_SSL_Allowed = 'Yes'
 
57
Master_SSL_CA_Path = ''
 
58
Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
 
59
Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
 
60
Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
 
61
include/check_slave_is_running.inc
 
62
drop table t1;
 
63
include/stop_slave.inc
 
64
CHANGE MASTER TO
 
65
master_host="127.0.0.1",
 
66
master_ssl_ca ='',
 
67
master_ssl_cert='',
 
68
master_ssl_key='',
 
69
master_ssl_verify_server_cert=0,
 
70
master_ssl=0;
 
71
include/rpl_end.inc