Edit report at http://bugs.php.net/bug.php?id=49234&edit=1
ID: 49234
Updated by: [email protected]
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] [email protected]
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] [email protected]
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] [email protected]
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.