Bug #55283 [NEW]: SSL options set by mysqli_ssl_set ignored for MySQLi persistent connections
| From: | aleksey at wepay dot com | Date: | Tue, 26 Jul 2011 00:20:59 +0000 |
| Subject: | Bug #55283 [NEW]: SSL options set by mysqli_ssl_set ignored for MySQLi persistent connections | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-162170@lists.php.net to get a copy of this message | ||
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