#48082 [Com]: mysql_connect does not work with named pipes

From:	uwendel at mysql dot com	Date:	Mon, 29 Jun 2009 08:42:29 +0000
Subject:	#48082 [Com]: mysql_connect does not work with named pipes
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-138918@lists.php.net to get a copy of this message

 ID:               48082
 Comment by:       uwendel at mysql dot com
 Reported By:      andrew dot answer at gmail dot com
 Status:           Assigned
 Bug Type:         MySQL related
 Operating System: win32 only - Windows XP
 PHP Version:      5.3.0RC1
 Assigned To:      mysql
 New Comment:

Aren't named pipes considerable slower than TCP/IP: why use named pipes
?! I won't work on named pipe support for mysqlnd, if its slower, which
is the case AFAIK.


Previous Comments:
------------------------------------------------------------------------

[2009-06-20 11:36:19] pajoye@php.net

Andrei, fixable? or need help on this one? I'm not sure it is very
critical or widely used. it could wait for 5.3.1.

------------------------------------------------------------------------

[2009-04-27 16:27:34] andrew dot answer at gmail dot com

I think it's because you use new mysql library (mysqlnd) in background

of mysql-related functions, and break the default behavior.

------------------------------------------------------------------------

[2009-04-27 16:24:35] andrew dot answer at gmail dot com

php is php-5.3.0RC1-Win32-VC6-x86.msi, thread-safe version.

I think what behavior of mysql_connect should be same as in previous
php 
version(s). I check different host values for php 5.2.5:
null - FAILED
'' - FAILED
'localhost' - FAILED
'.' - OK
Please refer to php and mysql documentation and mysqli_ functions.

------------------------------------------------------------------------

[2009-04-27 00:04:04] mattwil@php.net

No it's not Jani. :-)

Confirmed. Looks like it's with the VC9 binaries -- is that what you
are using (not VC6)? Another difference related to getaddrinfo...

'' (empty string) and 'localhost' work. BTW localhost is actually using
TCP/IP, contrary to what the manual says. Also (even in 5.2), the empty
string is also changing to localhost -- I'm not sure when the behavior
changed (or if it's MySQL server-related), but that used to use a named
pipe without needing to specify '.' :-/

------------------------------------------------------------------------

[2009-04-26 21:07:14] jani@php.net

What if you pass proper parameters? "." as host is quite invalid..

------------------------------------------------------------------------

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/48082

-- 
Edit this bug report at http://bugs.php.net/?id=48082&edit=1



   

Thread (24 messages)

• andrew dot answer at gmail dot comSun, 26 Apr 2009 18:31:40 +0000
  • jani@php.netSun, 26 Apr 2009 21:07:15 +0000#48082 [Opn->Fbk]: mysql_connect not work with named pipes
  • mattwil@php.netMon, 27 Apr 2009 00:04:04 +0000#48082 [Fbk]: mysql_connect not work with named pipes
  • mattwil@php.netMon, 27 Apr 2009 00:04:28 +0000#48082 [Fbk->Ver]: mysql_connect not work with named pipes
  • andrew dot answer at gmail dot comMon, 27 Apr 2009 16:24:35 +0000#48082 [Ver]: mysql_connect not work with named pipes
  • andrew dot answer at gmail dot comMon, 27 Apr 2009 16:27:35 +0000#48082 [Ver]: mysql_connect not work with named pipes
  • pajoye@php.netSat, 20 Jun 2009 11:36:20 +0000#48082 [Ver->Asn]: mysql_connect does not work with named pipes
  • uwendel at mysql dot comMon, 29 Jun 2009 08:42:29 +0000#48082 [Com]: mysql_connect does not work with named pipes
  • andrew dot answer at gmail dot comMon, 29 Jun 2009 09:40:49 +0000#48082 [Asn]: mysql_connect does not work with named pipes
  • andrew dot answer at gmail dot comMon, 29 Jun 2009 09:43:04 +0000#48082 [Asn]: mysql_connect does not work with named pipes
  • kulakov74 at yandex dot ruTue, 20 Oct 2009 19:56:25 +0000#48082 [Com]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comTue, 02 Feb 2010 07:07:15 +0000#48082 [Com]: mysql_connect does not work with named pipes
  • quakvorgus at yahoo dot comWed, 17 Feb 2010 20:11:17 +0000#48082 [Com]: mysql_connect does not work with named pipes
  • dex_is_cool at loopmod dot comTue, 18 May 2010 18:31:07 +0000Bug #48082 [Com]: mysql_connect does not work with named pipes
  • andrey@php.netMon, 16 Aug 2010 14:38:57 +0000Req #48082 [Asn->Ana]: mysql_connect does not work with named pipes
  • andrey@php.netFri, 20 Aug 2010 10:24:54 +0000Req #48082 [Ana]: mysql_connect does not work with named pipes
  • andrey@php.netWed, 22 Sep 2010 15:16:40 +0000Req #48082 [Ana->Csd]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comTue, 28 Sep 2010 13:50:58 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • stevenmartin99 at gmail dot comWed, 01 Dec 2010 23:00:55 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • stevenmartin99 at gmail dot comWed, 01 Dec 2010 23:07:53 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • jose dot nobile at gmail dot comTue, 18 Jan 2011 01:48:44 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comFri, 04 Feb 2011 17:52:57 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comTue, 24 Apr 2012 14:44:07 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comTue, 24 Apr 2012 14:45:44 +0000Req #48082 [Com]: mysql_connect does not work with named pipes