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