#45273 [Opn]: Unable to make SSL connection to MySQL DB using mysqli::real_connect
ID: 45273
User updated by: luciandipeso at yahoo dot com
Reported By: luciandipeso at yahoo dot com
Status: Open
Bug Type: MySQLi related
Operating System: OS X, FreeBSD
PHP Version: 5.2.6
New Comment:
I'm starting to think that the problem is that mysqli_ssl_set() is not
working -- no certs are being specified, and so when PHP tries to
connect over SSL to MySQL, it just hangs.
Previous Comments:
[2008-06-14 23:22:39] luciandipeso at yahoo dot com
-- Should say "When I supply the MYSQLI_CLIENT_SSL flag to
mysqli::real_connect, the
script hangs until it either" not "I either" :)
[2008-06-14 23:21:58] luciandipeso at yahoo dot com
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('');
}
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 this bug report at http://bugs.php.net/?id=45273&edit=1
#45273 [Opn]: Unable to make SSL connection to MySQL DB using mysqli::real_connect
ID: 45273
User updated by: luciandipeso at yahoo dot com
Reported By: luciandipeso at yahoo dot com
Status: Open
Bug Type: MySQLi related
Operating System: OS X, FreeBSD
PHP Version: 5.2.6
New Comment:
-- Should say "When I supply the MYSQLI_CLIENT_SSL flag to
mysqli::real_connect, the
script hangs until it either" not "I either" :)
Previous Comments:
[2008-06-14 23:21:58] luciandipeso at yahoo dot com
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('');
}
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 this bug report at http://bugs.php.net/?id=45273&edit=1
