#34072 [Fbk->Opn]: MySQL module can't connect if port is not 3306

[pash_ka at fonbet dot info]

 ID:               34072
 User updated by:  pash_ka at fonbet dot info
 Reported By:      pash_ka at fonbet dot info
-Status:           Feedback
+Status:           Open
 Bug Type:         PDO related
 Operating System: Windows XP
 PHP Version:      5.1.0b3
 Assigned To:      wez
 New Comment:

I've tried it with latest (Aug 30 2005 08:37:40) build, and using
127.0.0.1 instead of localhost works.

I'm using this test script:
-------------------------------------------
<?php
if(!isset($argv)){
  header('Content-type: text/plain');
  header("Content-Disposition: inline; filename=dbotest.txt");
}

$cfg['host'] = 'localhost';
//$cfg['host'] = '127.0.0.1';
$cfg['port'] = 6733;
$cfg['database'] = 'www-new';
$cfg['username'] = 'pasha';
$cfg['password'] = '****';

connect_mysql($cfg);
echo "\n";
connect_pdo_mysql($cfg);

function connect_mysql($cfg){
  $dsn = $cfg['host'].':'.$cfg['port'];
  echo "Connecting to MYSQL (DSN = {$dsn}).\n";
  @$res = mysql_connect($dsn, $cfg['username'], $cfg['password']);
  echo 'Result: '.($res?'OK':mysql_error())."\n";
  return $res;
}
function connect_pdo_mysql($cfg){
  $dsn =
"mysql:host={$cfg['host']};port={$cfg['port']};dbname={$cfg['database']}";
  echo "Connecting to PDO_MYSQL (DSN = {$dsn}).\n";
  try{
    $res = new PDO($dsn, $cfg['username'], $cfg['password']);
    echo "Result: OK\n";
    return $res;
  }catch(PDOException $ex){
    echo 'Result: '.$ex->getMessage()."\n";
    return false;
  }
}
?>
-------------------------------------------

And this is the result when using localhost:
------------------------------------------
Connecting to MYSQL (DSN = localhost:6733).
Result: OK

Connecting to PDO_MYSQL (DSN =
mysql:host=localhost;port=6733;dbname=www-new).
Result: SQLSTATE[HY000] [2003] Can't connect to MySQL server on
'localhost' (10061)
------------------------------------------


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

[2005-08-30 01:05:46] [EMAIL PROTECTED]

Does it work if you change the hostname to 127.0.0.1?

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

[2005-08-10 18:44:28] [EMAIL PROTECTED]

Wez, could you plz check it out?

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

[2005-08-10 18:44:18] [EMAIL PROTECTED]

I've just copied your DSN and it worked for me.
But IIRC it's possible that it automagically uses local socket on my
Linux, which is not available on Win32.


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

[2005-08-10 18:38:40] pash_ka at fonbet dot info

Well, I've just downloaded php5-win32-latest.zip - it's the same one
(Aug 9 2005 ) and tried with it. The bug is still there for me.
Do i need to use "mysql:host=localhost;port=6733;dbname=www" dsn or
there is another syntax to specify port?

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

[2005-08-10 18:22:42] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip

Can't reproduce.

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

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

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