Edit report at http://bugs.php.net/bug.php?id=49234&edit=1
ID: 49234 Updated by: and...@php.net Reported by: thalashir at gmail dot com Summary: method not found ssl_set -Status: Assigned +Status: Closed Type: Bug Package: MySQLi related Operating System: windows xp PHP Version: 5.3.0 Assigned To: mysql New Comment: Fixed in 5.3.3 Previous Comments: ------------------------------------------------------------------------ [2010-04-15 13:01:32] and...@php.net Automatic comment from SVN on behalf of andrey Revision: http://svn.php.net/viewvc/?view=revision&revision=298023 Log: Fix for bug#49234 method not found ssl_set Patch was tested and compiles on Windows. (Thanks Kalle) ------------------------------------------------------------------------ [2009-08-27 08:57:21] and...@php.net 5.3 + mysqlnd doesn't support SSL (as well as compression). If you need to use SSL then you have to use 5.3 + libmysql. This is a feature request, more or less. ------------------------------------------------------------------------ [2009-08-13 09:31:58] Thalashir at gmail dot com Ok, thanks. Any suggestions how could I do the connection? I tried with $mysqli->options(MYSQLI_READ_DEFAULT_FILE,'/path/to/cert_my.cnf'); where cert_my.cnf is ssl-ca='path/to/cacert.pem' ssl-cert='path/to/cert.pem' ssl-key='path/to/key.pem' but denies access to user. Tried to access via mysql command line with options --ssl-ca=... --ssl-cert=... --ssl-key... and it works. ------------------------------------------------------------------------ [2009-08-12 12:26:50] paj...@php.net It is not available with mysqlnd. No idea why, assigned to the mysql team :) ------------------------------------------------------------------------ [2009-08-12 11:04:31] thalashir at gmail dot com Description: ------------ When I try to connect to a Mysql database using SSL and mysqli, it says that the method ssl_set don't exists. I used function get_class_methods(mysqli) and is not listed. I checked mysql support, mysqli support and openssl support with phpinfo and they are all supported. Here is the list returned from get_class_methods: autocommit change_user character_set_name client_encoding close commit connect dump_debug_info debug get_charset get_client_info get_connection_stats get_server_info get_warnings init kill multi_query mysqli more_results next_result options ping prepare query real_connect real_escape_string poll reap_async_query escape_string real_query rollback select_db set_charset set_opt stat stmt_init store_result thread_safe use_result refresh Reproduce code: --------------- $mysqli= mysqli_init(); if (!$mysqli) { die('mysqli_init failed'); } $mysqli->ssl_set('path/to/key.pem','path/to/cert.pem','path/to/cacert.pem',null,null); $mysqli_real_connect('1.2.3.4','ssluser','sslpassword','db',port,MYSQLI_CLIENT_SSL); //queries $mysqli->close(); Expected result: ---------------- A secure connection to mysql Actual result: -------------- Fatal error: Call to undefined method mysqli::ssl_set() in ... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=49234&edit=1
