#45273 [Fbk->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: Feedback
+Status: Open
Bug Type: MySQLi related
Operating System: OS X, FreeBSD
PHP Version: 5.2.6
Assigned To: uw
New Comment:
I checked my MySQL and Apache logs, and neither had anything. :-(
I'll try CLI in a little bit.
I don't always get a 500 -- it depends on the server. On my MacBook Pro
(running Apache 1.x), I just get a message saying the server
"unexpectadly dropped the connection". On a FreeBSD server running
Apache (not sure which version), I get a 500.
I believe the FreeBSD is running PHP under FCGI, while my Mac is using
mod_, so that might explain the difference.
Previous Comments:
------------------------------------------------------------------------
[2008-07-16 21:57:34] uw@php.net
Yes, I'm asking if you can reproduce is using a CLI script. The idea is
to break the problem down into smaller pieces. Your current setup
consists of web server plus PHP. Would be cool if you could provide an
example where no web server is involved.
Code 500 sounds like internal server error and a crash or something
similar. Ideally we would skip debugging the web server. If not, :-(,
what does the web server log say... anything helpful?
Ulf
------------------------------------------------------------------------
[2008-07-14 20:57:41] jani@php.net
Kick out webserver == use PHP CLI..
------------------------------------------------------------------------
[2008-07-14 20:15:14] luciandipeso at yahoo dot com
I'm not sure what you mean by "kick out the web server and try a
command
line script."
I am able to connect to MySQL using SSL from the command line, but I
haven't tried PHP CLI if that's what you mean.
I'm not sure if this is a duplicate bug -- in #41778, the person
actually gets an error returned. For me, the script just hangs until it
times out and I get a 500 status code.
I've also tried specifying the SSL certs in a my.cnf file, and skipping
the $db->ssl_set call, but that doesn't work either.
------------------------------------------------------------------------
[2008-07-14 19:39:53] uw@php.net
Please check if your report is a duplicate of
http://bugs.php.net/bug.php?id=41778 . Kick out
the web server and try a
command line script. If its a duplicate, which I guess, we can close
this one.
------------------------------------------------------------------------
[2008-06-19 18:51:47] luciandipeso at yahoo dot com
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.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/45273
--
Edit this bug report at http://bugs.php.net/?id=45273&edit=1
Thread (9 messages)