Bug #53795 [Asn->Csd]: Connect Error from MySqli (mysqlnd) when using SSL

Edit report at http://bugs.php.net/bug.php?id=53795&edit=1 ID: 53795 Updated by: kalle@php.net Reported by: dave dot kelly at dawkco dot com Summary: Connect Error from MySqli (mysqlnd) when using SSL -Status: Assigned +Status: Closed Type: Bug Package: MySQLi related Operating System: Windows PHP Version: 5.3.5 Assigned To: kalle Block user comment: N Private report: N New Comment: This bug has been fixed in SVN. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2011-01-31 13:47:31] kalle@php.net Automatic comment from SVN on behalf of kalle Revision: http://svn.php.net/viewvc/?view=revision&revision=307880 Log: Fixed bug #53795 (Connect Error from MySqli (mysqlnd) when using SSL) ------------------------------------------------------------------------ [2011-01-30 11:35:52] kalle@php.net I got an idea why this fails, as MYSQLND_SSL_SUPPORTED is not defined on Windows, its a simple one line fix that I will commit shortly ------------------------------------------------------------------------ [2011-01-29 09:36:07] dave dot kelly at dawkco dot com FYI (you probably already know): there are currently no SSL/TLS options available to be set with the mysqli::options method. I tried using the mysqli::ssl_set method as follows, but it didn't work either (same connect error): $mysqli->ssl_set(NULL, // key file path or NULL NULL, // cert file path or NULL 'C:/ssl/ca-cert.pem', // ca cert file path or NULL NULL, // capath directory or NULL 'DHE-RSA-AES256-SHA'); // cipher or NULL Also, tried the following (no luck): $mysqli->ssl_set('C:/ssl/key.pem', // key file path or NULL 'C:/ssl/cert.pem', // cert file path or NULL 'C:/ssl/ca-cert.pem', // ca cert file path or NULL NULL, // capath directory or NULL NULL); // cipher or NULL As noted before, these all work with PHP 5.2.17, but not with PHP 5.3.5. A fix for mysqlnd would be great because trying to do a custom build on Windows with mysqlnd disabled has become a real ordeal. ------------------------------------------------------------------------ [2011-01-24 11:12:59] andrey@php.net No, mysqlnd doesn't use my.ini/my.cnf files, as libmysql did. You have to set your options manually. ------------------------------------------------------------------------ [2011-01-24 10:21:41] uw@php.net mysqlnd does not read default files, AFAIK. I think Andrey wants to deprecate that, Andrey? ------------------------------------------------------------------------ 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/bug.php?id=53795 -- Edit this bug report at http://bugs.php.net/bug.php?id=53795&edit=1