xref: /PHP-8.1/ext/mysqli/tests/bug55283.phpt (revision b5a14e6c) 
1--TEST--
2Bug #55283 (SSL options set by mysqli_ssl_set ignored for MySQLi persistent connections)
3--EXTENSIONS--
4mysqli
5--SKIPIF--
6<?php
7require_once('skipifconnectfailure.inc');
8require_once("connect.inc");
9
10if (!defined('MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT'))
11    die("skip Requires MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT");
12
13if ($IS_MYSQLND && !extension_loaded("openssl"))
14    die("skip PHP streams lack support for SSL. mysqli is compiled to use mysqlnd which uses PHP streams in turn.");
15
16if (!($link = @my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)))
17    die(sprintf("skip Connect failed, [%d] %s", mysqli_connect_errno(), mysqli_connect_error()));
18
19if (false === strpos($link->host_info, 'TCP/IP'))
20    die(sprintf("skip SSL only supported on TCP/IP"));
21
22$row = NULL;
23if ($res = $link->query('SHOW VARIABLES LIKE "have_ssl"')) {
24    $row = $res->fetch_row();
25} else {
26    if ($link->errno == 1064 && ($res = $link->query("SHOW VARIABLES"))) {
27        while ($row = $res->fetch_row())
28            if ($row[0] == 'have_ssl')
29                break;
30    } else {
31        die(sprintf("skip Failed to test for MySQL SSL support, [%d] %s", $link->errno, $link->error));
32    }
33}
34
35
36if (empty($row))
37    die(sprintf("skip Failed to test for MySQL SSL support, [%d] %s", $link->errno, $link->error));
38
39if (($row[1] == 'NO') || ($row[1] == 'DISABLED'))
40    die(sprintf("skip MySQL has no SSL support, [%d] %s", $link->errno, $link->error));
41
42$link->close();
43?>
44--FILE--
45<?php
46    require_once "connect.inc";
47    $db1 = new mysqli();
48
49
50    $flags = MYSQLI_CLIENT_SSL | MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT;
51
52    $link = mysqli_init();
53    mysqli_ssl_set($link, null, null, null, null, "AES256-SHA");
54    if (my_mysqli_real_connect($link, 'p:' . $host, $user, $passwd, $db, $port, null, $flags)) {
55        $r = $link->query("SHOW STATUS LIKE 'Ssl_cipher'");
56        var_dump($r->fetch_row());
57    }
58
59    /* non-persistent connection */
60    $link2 = mysqli_init();
61    mysqli_ssl_set($link2, null, null, null, null, "AES256-SHA");
62    if (my_mysqli_real_connect($link2, $host, $user, $passwd, $db, $port, null, $flags)) {
63        $r2 = $link2->query("SHOW STATUS LIKE 'Ssl_cipher'");
64        var_dump($r2->fetch_row());
65    }
66
67    echo "done\n";
68?>
69--EXPECTF--
70array(2) {
71  [0]=>
72  string(10) "Ssl_cipher"
73  [1]=>
74  string(%d) "%rAES256-SHA|TLS_AES_256_GCM_SHA384%r"
75}
76array(2) {
77  [0]=>
78  string(10) "Ssl_cipher"
79  [1]=>
80  string(%d) "%rAES256-SHA|TLS_AES_256_GCM_SHA384%r"
81}
82done
83