Req #28075 [Asn->Wfx]: mysql ssl connection

Edit report at http://bugs.php.net/bug.php?id=28075&edit=1 ID: 28075 Updated by: uw@php.net Reported by: petre dot rodan at avira dot com Summary: mysql ssl connection -Status: Assigned +Status: Wont fix Type: Feature/Change Request Package: MySQL related Operating System: * PHP Version: * Assigned To: mysql Block user comment: N Private report: N New Comment: See previous comment: use mysqli. Previous Comments: ------------------------------------------------------------------------ [2011-01-06 17:14:31] uw@php.net ... don't think we should add functionality to ext/mysql. People should move forward and use mysqli. Also, there's a work around documented in the bug. ------------------------------------------------------------------------ [2007-07-13 10:45:45] Bruno dot Harbulot at manchester dot ac dot uk I have just tried this suggestion (using mysql_options to read the [client] section of the global mysql configuration file). It works. However, it doesn't seem like a good idea to use a global client configuration for all the MySQL connections from PHP. There can be scenarios where different certificates or CAs might be required. Perhaps it would be better to have a binding of mysql_ssl_set (part of the MySQL API) to the PHP MySQL extension. It seems that MySQLi supports it. See: http://dev.mysql.com/doc/refman/5.0/en/mysql-ssl-set.html http://www.php.net/manual/en/function.mysqli-ssl-set.php Regards, Bruno. ------------------------------------------------------------------------ [2004-04-20 15:54:40] derick@php.net Assigning to georg, the maintainer of this extension. ------------------------------------------------------------------------ [2004-04-20 12:34:11] petre dot rodan at avira dot com Description: ------------ I was tring to use SSL-enabled mysql connections using php and mod_php. The problem was that the libmysql library inside {,mod_}php detects that SSL is needed, but it doesn't know the location of the client certificate. by simply inserting the following line mysql_options(&mysql->conn,MYSQL_READ_DEFAULT_GROUP,"client"); before mysql_real_connect(..) in ext/mysql/php_mysql.c, the my.cnf file is read and all SSL-related configurations are imported from there. If my problem can be solved in another way, please drop me a line :). Successfuly tested with php-4.3.4-r4, mod_php-4.3.4-r4, mod_php-4.3.6-rc2, php-5.0_beta1-r1. see http://bugs.gentoo.org/show_bug.cgi?id=46340#c3 for scenario details the patch can be downloaded here: http://bugs.gentoo.org/attachment.cgi?id=28436&action=view ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=28075&edit=1