#44555 [Opn->Fbk]: mysql.connect_timeout ignored

ID: 44555 Updated by: andrey@php.net Reported By: tstarling at wikimedia dot org -Status: Open +Status: Feedback Bug Type: MySQL related Operating System: Windows XP PHP Version: 5.2.5 Assigned To: uw New Comment: Hi, \I suspect a problem in libmysql, not PHP. The ext/mysql sources do set the connect_timeout if (connect_timeout != -1) { mysql_options(&mysql->conn, MYSQL_OPT_CONNECT_TIMEOUT, (const char *)&connect_timeout); } Are you sure you don't have several libmysql.dll on your system? Previous Comments: ------------------------------------------------------------------------ [2008-07-17 09:44:56] tstarling at wikimedia dot org I don't know what you're talking about. The bug is not DNS-related. ------------------------------------------------------------------------ [2008-07-16 22:36:08] uw@php.net As I see it the upper wait time is set to 100s. Your Windows gives a DNS timeout after 20s. PHP bails at you after 20s. 20s < 100s, all fine. ------------------------------------------------------------------------ [2008-07-15 16:21:05] tstarling at wikimedia dot org s/ARIN/IANA ------------------------------------------------------------------------ [2008-07-15 15:27:20] tstarling at wikimedia dot org No of course the host "1.2.3.4" doesn't exist, it's an IP address in the unused 1.0.0.0/8 block reserved by ARIN, that's the point. If I instead use a hostname for a host which responds to DNS rapidly, but drops ignores SYN packets on the port in question (such as www.google.com), the result is the same. Are you asking me this question because you've tried it and can't reproduce it? If so, maybe I can help to isolate the configuration. ------------------------------------------------------------------------ [2008-07-14 16:57:08] uw@php.net Does the host 1.2.3.4 exist? If not, you're probably running into the default DNS lookup timeout of your system -> bogus, not a bug. Try changing your system settings, http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/regentry/96406.mspx?mfr=true ------------------------------------------------------------------------ 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/44555 -- Edit this bug report at http://bugs.php.net/?id=44555&edit=1