#45273 [NEW]: Unable to make SSL connection to MySQL DB using mysqli::real_connect
From: luciandipeso at yahoo dot com
Operating system: OS X, FreeBSD
PHP version: 5.2.6
PHP Bug Type: MySQLi related
Bug description: Unable to make SSL connection to MySQL DB using mysqli::real_connect
Description:
------------
When I supply the MYSQLI_CLIENT_SSL flag to mysqli::real_connect, the
script hangs until I either:
get a 500 response from the web server (tested on a shared host running
FreeBSD)
or simply get a "Server unexpectedly dropped the connection" response
(tested on my MacBook Pro running OS X 10.4.11).
I am able to connect fine via command line.
I looked in my Apache logs, and found no entries.
Reproduce code:
---------------
$db = new mysqli();
$db->init();
$db->ssl_set('/path/to/key.pem', '/path/to/cert.pem',
'/path/to/ca.pem',
NULL, NULL);
$db->real_connect('1.2.3.4', 'login', 'pass', 'database',
3167, '',
MYSQLI_CLIENT_SSL);
$query = $db->query("SHOW STATUS");
while($row = $query->fetch_assoc()) {
print_r($row);
echo('<br /><br />');
}
Expected result:
----------------
An SSL enabled connection to a remote MySQL database.
Actual result:
--------------
Either a 500 response or a "Server unexpectedly dropped the connection"
response.
--
Edit bug report at http://bugs.php.net/?id=45273&edit=1
--
Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=45273&r=trysnapshot52
Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=45273&r=trysnapshot53
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=45273&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=45273&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=45273&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=45273&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=45273&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=45273&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=45273&r=support
Expected behavior: http://bugs.php.net/fix.php?id=45273&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=45273&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=45273&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=45273&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=45273&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=45273&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=45273&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=45273&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=45273&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=45273&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=45273&r=mysqlcfg
Thread (9 messages)
- luciandipeso at yahoo dot com