Return to bug55283.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysqli / tests

Annotation of embedaddon/php/ext/mysqli/tests/bug55283.phpt, revision 1.1.1.2

1.1       misho       1: --TEST--
                      2: Bug #55283 (SSL options set by mysqli_ssl_set ignored for MySQLi persistent connections)
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('skipifconnectfailure.inc');
                      7: require_once("connect.inc");
                      8: 
                      9: if ($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: 
                     12: if (!($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;
                     16: if ($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: 
                     29: if (empty($row))
                     30:        die(sprintf("skip Failed to test for MySQL SSL support, [%d] %s", $link->errno, $link->error));
                     31: 
1.1.1.2 ! misho      32: if (($row[1] == 'NO') || ($row[1] == 'DISABLED'))
1.1       misho      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:        $db1 = new mysqli();
                     41: 
                     42: 
                     43:        $flags = MYSQLI_CLIENT_SSL;
1.1.1.2 ! misho      44: 
1.1       misho      45:        $link = mysqli_init();
                     46:        mysqli_ssl_set($link, null, null, null, null, "RC4-MD5");
                     47:        if (my_mysqli_real_connect($link, 'p:' . $host, $user, $passwd, $db, $port, null, $flags)) {
                     48:                $r = $link->query("SHOW STATUS LIKE 'Ssl_cipher'");
                     49:                var_dump($r->fetch_row());
                     50:        }
                     51: 
                     52:        /* non-persistent connection */
                     53:        $link2 = mysqli_init();
                     54:        mysqli_ssl_set($link2, null, null, null, null, "RC4-MD5");
                     55:        if (my_mysqli_real_connect($link2, $host, $user, $passwd, $db, $port, null, $flags)) {
                     56:                $r2 = $link2->query("SHOW STATUS LIKE 'Ssl_cipher'");
                     57:                var_dump($r2->fetch_row());
                     58:        }
                     59: 
                     60:        echo "done\n";
                     61: ?>
                     62: --EXPECTF--
                     63: array(2) {
                     64:   [0]=>
                     65:   string(10) "Ssl_cipher"
                     66:   [1]=>
                     67:   string(7) "RC4-MD5"
                     68: }
                     69: array(2) {
                     70:   [0]=>
                     71:   string(10) "Ssl_cipher"
                     72:   [1]=>
                     73:   string(7) "RC4-MD5"
                     74: }
                     75: done