xref: /PHP-7.2/ext/mysqli/tests/bug51647.phpt (revision 6d51b7b2) 
1--TEST--
2Bug #51647 (Certificate file without private key (pk in another file) doesn't work)
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6require_once('skipifconnectfailure.inc');
7require_once("connect.inc");
8
9if ($IS_MYSQLND && !extension_loaded("openssl"))
10	die("skip PHP streams lack support for SSL. mysqli is compiled to use mysqlnd which uses PHP streams in turn.");
11
12if (!($link = @my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)))
13	die(sprintf("skip Connect failed, [%d] %s", mysqli_connect_errno(), mysqli_connect_error()));
14
15$row = NULL;
16if ($res = $link->query('SHOW VARIABLES LIKE "have_ssl"')) {
17	$row = $res->fetch_row();
18} else {
19	if ($link->errno == 1064 && ($res = $link->query("SHOW VARIABLES"))) {
20		while ($row = $res->fetch_row())
21			if ($row[0] == 'have_ssl')
22				break;
23	} else {
24		die(sprintf("skip Failed to test for MySQL SSL support, [%d] %s", $link->errno, $link->error));
25	}
26}
27
28
29if (empty($row))
30	die(sprintf("skip Failed to test for MySQL SSL support, [%d] %s", $link->errno, $link->error));
31
32if (($row[1] == 'NO') || ($row[1] == 'DISABLED'))
33	die(sprintf("skip MySQL has no SSL support, [%d] %s", $link->errno, $link->error));
34
35$link->close();
36?>
37--FILE--
38<?php
39	include ("connect.inc");
40
41	if (!is_object($link = mysqli_init()))
42		printf("[001] Cannot create link\n");
43
44	if (!my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket, MYSQLI_CLIENT_SSL | MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT)) {
45		printf("[003] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
46	}
47
48	if (!$res = $link->query('SHOW STATUS like "Ssl_cipher"')) {
49		if (1064 == $link->errno) {
50			/* ERROR 1064 (42000): You have an error in your SQL syntax;  = sql strict mode */
51			if ($res = $link->query("SHOW STATUS")) {
52				while ($row = $res->fetch_assoc())
53					if ($row['Variable_name'] == 'Ssl_cipher')
54						break;
55			} else {
56				printf("[005] [%d] %s\n", $link->errno, $link->error);
57			}
58		} else {
59			printf("[004] [%d] %s\n", $link->errno, $link->error);
60		}
61	} else {
62		if (!$row = $res->fetch_assoc())
63			printf("[006] [%d] %s\n", $link->errno, $link->error);
64		if (!strlen($row["Value"]))
65			printf("[007] Empty cipher. No encrytion!");
66		var_dump($row);
67	}
68
69	$link->close();
70
71	if (!is_object($link = mysqli_init()))
72		printf("[008] Cannot create link\n");
73
74	if (!my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket, MYSQLI_CLIENT_SSL)) {
75		printf("[009] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
76	}
77
78	if (!$res = $link->query('SHOW STATUS like "Ssl_cipher"')) {
79		if (1064 == $link->errno) {
80			/* ERROR 1064 (42000): You have an error in your SQL syntax;  = sql strict mode */
81			if ($res = $link->query("SHOW STATUS")) {
82				while ($row = $res->fetch_assoc())
83					if ($row['Variable_name'] == 'Ssl_cipher')
84						break;
85			} else {
86				printf("[010] [%d] %s\n", $link->errno, $link->error);
87			}
88		} else {
89			printf("[011] [%d] %s\n", $link->errno, $link->error);
90		}
91	} else {
92		if (!$row = $res->fetch_assoc())
93			printf("[012] [%d] %s\n", $link->errno, $link->error);
94		if (!strlen($row["Value"]))
95			printf("[013] Empty cipher. No encrytion!");
96		var_dump($row);
97	}
98
99	$link->close();
100
101	print "done!";
102?>
103--EXPECTF--
104array(2) {
105  ["Variable_name"]=>
106  string(10) "Ssl_cipher"
107  ["Value"]=>
108  string(%d) "%S"
109}
110array(2) {
111  ["Variable_name"]=>
112  string(10) "Ssl_cipher"
113  ["Value"]=>
114  string(%d) "%S"
115}
116done!
117