Bug #51079 [Com]: fsockopen will not work on 'localhost'

Edit report at http://bugs.php.net/bug.php?id=51079&edit=1 ID: 51079 Comment by: dontwantanyspam at mailinator dot com Reported by: tony at marston-home dot demon dot co dot uk Summary: fsockopen will not work on 'localhost' Status: Assigned Type: Bug Package: Sockets related Operating System: win32 only - Windows XP PHP Version: 5.2.12 Assigned To: pajoye New Comment: I can also confirm that this problem isn't there in PHP 5.3.0. Its there since 5.3.1. Unlike PHP 5.3.0, a 64 bit version of PHP 5.3.1 wasn't available at http://windows.php.net/qa/, so I tried compiling it myself. After compiling I noticed that a script that uses file_get_contents("http://localhost/...") wouldn't work until I change the "localhost" to "127.0.0.1". I didn't care about it much at that time since it seemed like a small problem. But then I noticed that none of the scripts that used mysql were working. I even tried to log in to phpMyAdmin and even that didn't work (same problem described by thijsputman). So I thought that it was probably a bug with the 64 bit binary and continued using PHP 5.3.0. But after PHP 5.3.2 was released, I tried compiling it also and noticed that the problem was still there. Thinking that it may be related to mysqlnd since the version used by PHP 5.3.0 is 5.0.5-dev and the one used by PHP 5.3.2 is 5.0.7- dev, I tried compiling the mysql, mysqli and pdo mysql extensions with libmysql. I has success with the mysql extension only. The mysqli and pdo mysql extension failed to compile with libmysql (there were a lot of build errors). Anyway, I tried the mysql extension compiled with libmysql and noticed that it was working fine! But I needed the mysqli extension to work also and since it failed to compile with libmysql, I messed around some more and finally realized that it was the same problem as with the file_get_contents. So I tried changing all the "localhost" references to "127.0.0.1" and it worked! Anyway, for whatever reason the mysql extension compiled with libmysql works fine with "localhost" but the one compiled with mysqlnd doesn't. So, I hope this helps you to find and squish the bug thats causing this. :D Previous Comments: ------------------------------------------------------------------------ [2010-03-10 12:31:15] thijsputman at gmail dot com Fair enough :) The reproduce code provided fails to connect to "localhost" with fsockopen() in PHP 5.3.2. When using PHP 5.3.0 fsockopen() connects to "localhost" without problems. ------------------------------------------------------------------------ [2010-03-10 12:03:59] pajoye@php.net It does not depend on PHP only but libmysql or mysql server. Please keep posting about the socket issue only here as the myslq&IPv6 questions have been covered numerous times in other reports. The one report per issue rule is also a good way to do not get distracted, thanks for your understanding :) ------------------------------------------------------------------------ [2010-03-10 11:38:07] thijsputman at gmail dot com Agreed, but that's not my point: Just like when using fsockopen() to connect to "localhost", I would expect mysql_connect("localhost") to also attempt to use IPv4, irrespective of whether "localhost" resolves to [::1] or 127.0.0.1. This is the same behaviour exhibited by Firefox on my system and apparently also the behaviour of several other PHP functions, as made clear in the initial post of this bug. ------------------------------------------------------------------------ [2010-03-10 10:53:40] pajoye@php.net Mysql is not related to this problem, IPv6 is not supported and you have to apply one of the solutions described here or one of the other numerous reports about mysql and IPv6. ------------------------------------------------------------------------ [2010-03-10 09:43:16] thijsputman at gmail dot com I can confirm that the problem is not present in PHP 5.3.0, but _is_ present in PHP 5.3.2... It appears the mysql(i) extension is suffering from the same issue: I just spend a couple hours going through various versions of phpMyAdmin (which after upgrading from 5.3.0 simply timed out with a blank page) until discovering this issue. Changing "localhost" into "127.0.0.1" did trick. Tested using 5.3.2 (VC9 NTS) on Windows Server 2008 (x64). On a side note, both Firefox and MS telnet don't have any issues connecting to localhost over IPv4. ------------------------------------------------------------------------ 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/bug.php?id=51079 -- Edit this bug report at http://bugs.php.net/bug.php?id=51079&edit=1