#49965 [Opn->Asn]: Setting MYSQLI_OPT_CONNECT_TIMEOUT does not seem to have an effect on timeout

ID: 49965 Updated by: jani@php.net Reported By: ed at bellcpa dot com -Status: Open +Status: Assigned Bug Type: MySQLi related -Operating System: any +Operating System: * PHP Version: 5.*, 6.* Assigned To: mysql Previous Comments: ------------------------------------------------------------------------ [2009-10-29 18:19:45] uw@php.net I discussed this with Andrey. We propose to change ext/mysqli to cast $value passed to mysqli_options to an appropriate type internally. Old code should not notice the change because it should be using an appropriate type for $value in mysqli_options($link, $option, $value) already. I'll soon patch ext/mysqli. ------------------------------------------------------------------------ [2009-10-28 23:58:12] ed at bellcpa dot com Ah, makes perfect sense. Glad it wasn't something more serious and sorry for the oversight. Enclosing my option value in intval() solved it as expected. Thanks! ------------------------------------------------------------------------ [2009-10-28 23:48:10] uw@php.net Hi Ed, thanks for the additional information given in a private mail. Yes, it matters what type the option value has that you pass to mysqli_options(). It matters ever since 5.0. It is irrelevant if you use mysqlnd or libmysql. mysqli_options(mysqli $link, int $option, mixed $value) inspects the type of the $value parameter. If you pass a string value, as stated in your private mail, ext/mysqli forwards a string to mysqlnd resp. libmysql. Both mysqlnd and libmysql expect that the data they get is of the appropriate type for $option allowing them to use a simple cast to interpret the data. String is not the appropriate type for MYSQLI_OPT_CONNECT_TIMEOUT - the cast inside mysqlnd/libmysql causes a bogus value to be used... This will not work: $timeout = "5" mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, $timeout); mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, "5"); You must use the following: $timeout = 5; mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, $timeout); mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 5); ------------------------------------------------------------------------ [2009-10-28 17:52:26] uw@php.net Interesting. I assume it does not matter if you use 5.3.0 or 5.3.2-dev? Thanks so far! Ulf ------------------------------------------------------------------------ [2009-10-28 17:40:27] ed at bellcpa dot com Ulf, Here is the fsockopen() result, looks like timeout works as expected: C:\temp2>php testme.php PHP Warning: fsockopen(): unable to connect to tcp://192.168.201.222:3306 (A co nnection attempt failed because the connected party did not properly respond aft er a period of time, or established connection failed because connected host has failed to respond. ) in C:\temp2\testme.php on line 6 PHP Stack trace: PHP 1. {main}() C:\temp2\testme.php:0 PHP 2. fsockopen() C:\temp2\testme.php:6 Warning: fsockopen(): unable to connect to tcp://192.168.201.222:3306 (A connect ion attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has fail ed to respond. ) in C:\temp2\testme.php on line 6 Call Stack: 0.0312 324832 1. {main}() C:\temp2\testme.php:0 0.0491 325280 2. fsockopen() C:\temp2\testme.php:6 bool(false) int(10060) string(185) "A connection attempt failed because the connected party did not pro perly respond after a period of time, or established connection failed because c onnected host has failed to respond. " float(5.1100761890411) ------------------------------------------------------------------------ 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/49965 -- Edit this bug report at http://bugs.php.net/?id=49965&edit=1