1set local sql_mode="";
2set global sql_mode="";
3drop table if exists t1;
4create table t1(f1 int);
5insert into t1 values (5);
6grant select on test.* to ssl_user1@localhost require SSL;
7grant select on test.* to ssl_user3@localhost require SUBJECT "/C=FI/ST=Helsinki/L=Helsinki/O=MariaDB/CN=client";
8grant select on test.* to ssl_user4@localhost require SUBJECT "/C=FI/ST=Helsinki/L=Helsinki/O=MariaDB/CN=client" ISSUER "/CN=cacert/C=FI/ST=Helsinki/L=Helsinki/O=MariaDB";
9grant select on test.* to ssl_user5@localhost require SUBJECT "xxx";
10flush privileges;
11connect  con1,localhost,ssl_user1,,,,,SSL;
12connect  con3,localhost,ssl_user3,,,,,SSL;
13connect  con4,localhost,ssl_user4,,,,,SSL;
14connect(localhost,ssl_user5,,test,MASTER_PORT,MASTER_SOCKET);
15connect  con5,localhost,ssl_user5,,,,,SSL;
16ERROR 28000: Access denied for user 'ssl_user5'@'localhost' (using password: NO)
17connection con1;
18SELECT VARIABLE_VALUE <> '' AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher';
19have_ssl
201
21select * from t1;
22f1
235
24delete from t1;
25ERROR 42000: DELETE command denied to user 'ssl_user1'@'localhost' for table 't1'
26connection con3;
27SELECT VARIABLE_VALUE <> '' AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher';
28have_ssl
291
30select * from t1;
31f1
325
33delete from t1;
34ERROR 42000: DELETE command denied to user 'ssl_user3'@'localhost' for table 't1'
35connection con4;
36SELECT VARIABLE_VALUE <> '' AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher';
37have_ssl
381
39select * from t1;
40f1
415
42delete from t1;
43ERROR 42000: DELETE command denied to user 'ssl_user4'@'localhost' for table 't1'
44connection default;
45disconnect con1;
46disconnect con3;
47disconnect con4;
48drop user ssl_user1@localhost, ssl_user3@localhost, ssl_user4@localhost, ssl_user5@localhost;
49drop table t1;
50mysqltest: Could not open connection 'default': 2026 SSL connection error: xxxx
51mysqltest: Could not open connection 'default': 2026 SSL connection error: xxxx
52mysqltest: Could not open connection 'default': 2026 SSL connection error: xxxx
53mysqltest: Could not open connection 'default': 2026 SSL connection error: xxxx
54mysqltest: Could not open connection 'default': 2026 SSL connection error: xxxx
55have_ssl
561
57End of 5.0 tests
58DROP TABLE IF EXISTS thread_status;
59DROP EVENT IF EXISTS event_status;
60SET GLOBAL event_scheduler=1;
61CREATE EVENT event_status
62ON SCHEDULE AT NOW()
63ON COMPLETION NOT PRESERVE
64DO
65BEGIN
66CREATE TABLE thread_status
67SELECT variable_name, variable_value
68FROM information_schema.session_status
69WHERE variable_name LIKE 'SSL_ACCEPTS' OR
70variable_name LIKE 'SSL_CALLBACK_CACHE_HITS';
71END$$
72SELECT variable_name, variable_value FROM thread_status;
73variable_name	variable_value
74SSL_ACCEPTS	#
75SSL_CALLBACK_CACHE_HITS	#
76DROP TABLE thread_status;
77SET GLOBAL event_scheduler=0;
78CREATE TABLE t1(a int);
79INSERT INTO t1 VALUES (1), (2);
80
81/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
82/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
83/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
84/*!40101 SET NAMES utf8mb4 */;
85/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
86/*!40103 SET TIME_ZONE='+00:00' */;
87/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
88/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
89/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
90/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
91DROP TABLE IF EXISTS `t1`;
92/*!40101 SET @saved_cs_client     = @@character_set_client */;
93/*!40101 SET character_set_client = utf8 */;
94CREATE TABLE `t1` (
95  `a` int(11) DEFAULT NULL
96);
97/*!40101 SET character_set_client = @saved_cs_client */;
98
99LOCK TABLES `t1` WRITE;
100/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
101INSERT INTO `t1` VALUES (1),(2);
102/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
103UNLOCK TABLES;
104/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
105
106/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
107/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
108/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
109/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
110/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
111/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
112/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
113
114
115/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
116/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
117/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
118/*!40101 SET NAMES utf8mb4 */;
119/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
120/*!40103 SET TIME_ZONE='+00:00' */;
121/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
122/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
123/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
124/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
125DROP TABLE IF EXISTS `t1`;
126/*!40101 SET @saved_cs_client     = @@character_set_client */;
127/*!40101 SET character_set_client = utf8 */;
128CREATE TABLE `t1` (
129  `a` int(11) DEFAULT NULL
130);
131/*!40101 SET character_set_client = @saved_cs_client */;
132
133LOCK TABLES `t1` WRITE;
134/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
135INSERT INTO `t1` VALUES (1),(2);
136/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
137UNLOCK TABLES;
138/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
139
140/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
141/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
142/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
143/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
144/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
145/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
146/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
147
148
149/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
150/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
151/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
152/*!40101 SET NAMES utf8mb4 */;
153/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
154/*!40103 SET TIME_ZONE='+00:00' */;
155/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
156/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
157/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
158/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
159DROP TABLE IF EXISTS `t1`;
160/*!40101 SET @saved_cs_client     = @@character_set_client */;
161/*!40101 SET character_set_client = utf8 */;
162CREATE TABLE `t1` (
163  `a` int(11) DEFAULT NULL
164);
165/*!40101 SET character_set_client = @saved_cs_client */;
166
167LOCK TABLES `t1` WRITE;
168/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
169INSERT INTO `t1` VALUES (1),(2);
170/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
171UNLOCK TABLES;
172/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
173
174/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
175/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
176/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
177/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
178/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
179/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
180/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
181
182mysqldump: Got error: 2026: "SSL connection error: xxxx
183DROP TABLE t1;
184GRANT SELECT ON test.* TO bug42158@localhost REQUIRE X509;
185FLUSH PRIVILEGES;
186connect con1,localhost,bug42158,,,,,SSL;
187SELECT VARIABLE_VALUE <> '' AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher';
188have_ssl
1891
190disconnect con1;
191connection default;
192DROP USER bug42158@localhost;
193set global sql_mode=default;
194End of 5.1 tests
195/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
196/*!40019 SET @@session.max_insert_delayed_threads=0*/;
197/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
198DELIMITER /*!*/;
199ERROR: Failed on connect: SSL connection error