From: Operating system: Cent OS PHP version: 5.3.6 Package: MySQLi related Bug Type: Bug Bug description:SSL options set by mysqli_ssl_set ignored for MySQLi persistent connections
Description: ------------ The MySQLi ignores SSL options set with mysqli_ssl_set() for persistent connections (works fine for non-persistent connections). To reproduce: 1) Configure MySQL server with SSL support (http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html) 2) Run the attached test script Test script: --------------- <? $host = 'localhost'; $user = 'root'; $pass = ''; $db = null; $port = 3306; $flags = MYSQLI_CLIENT_SSL; /* persistent connection */ $link = mysqli_init(); mysqli_ssl_set($link, null, null, null, null, "RC4-MD5"); if (mysqli_real_connect($link, 'p:' . $host, $user, $pass, $db, $port, null, $flags)) { $r = $link->query("SHOW STATUS LIKE 'Ssl_cipher'"); var_dump($r->fetch_row()); } /* non-persistent connection */ $link = mysqli_init(); mysqli_ssl_set($link, null, null, null, null, "RC4-MD5"); if (mysqli_real_connect($link, $host, $user, $pass, $db, $port, null, $flags)) { $r = $link->query("SHOW STATUS LIKE 'Ssl_cipher'"); var_dump($r->fetch_row()); } Expected result: ---------------- array(2) { [0]=> string(10) "Ssl_cipher" [1]=> string(18) "RC4-MD5" } array(2) { [0]=> string(10) "Ssl_cipher" [1]=> string(7) "RC4-MD5" } Actual result: -------------- array(2) { [0]=> string(10) "Ssl_cipher" [1]=> string(18) "DHE-RSA-AES256-SHA" } array(2) { [0]=> string(10) "Ssl_cipher" [1]=> string(7) "RC4-MD5" } -- Edit bug report at https://bugs.php.net/bug.php?id=55283&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=55283&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=55283&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=55283&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=55283&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=55283&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=55283&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=55283&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=55283&r=needscript Try newer version: https://bugs.php.net/fix.php?id=55283&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=55283&r=support Expected behavior: https://bugs.php.net/fix.php?id=55283&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=55283&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=55283&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=55283&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=55283&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=55283&r=dst IIS Stability: https://bugs.php.net/fix.php?id=55283&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=55283&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=55283&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=55283&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=55283&r=mysqlcfg