Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:15091
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
To: internals@lists.php.net
Content-Type: text/plain
Date: Fri, 18 Feb 2005 11:16:34 +0100
Message-ID: <1108721794.312.6.camel@localhost>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: PDO/MySQL connect broken for remote hosts
From: thekid@thekid.de (Timm Friebe)

Hi,
has anyone noticed PDO/MySQL will always try to connect locally
regardless of what I put in the host=... DSN part?

The statement:
  new PDO('mysql:host=php3.de', '****', '*******');

will only throw a PDOException:

Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)' in /usr/home/thekid/pdo.php:2

This here fixes it:

Index: ext/pdo_mysql/mysql_driver.c
===================================================================
RCS file: /repository/php-src/ext/pdo_mysql/mysql_driver.c,v
retrieving revision 1.36
diff -u -r1.36 mysql_driver.c
--- ext/pdo_mysql/mysql_driver.c        13 Feb 2005 17:16:24 -0000
1.36
+++ ext/pdo_mysql/mysql_driver.c        18 Feb 2005 10:00:31 -0000
@@ -327,6 +327,7 @@
        if (vars[2].optval && !strcmp("localhost", vars[2].optval)) {
                unix_socket = vars[4].optval;  
        } else {
+               host = vars[2].optval;
                port = atoi(vars[3].optval); 
        }
        dbname = vars[1].optval;

-- 
Timm
If it ain't broken, it doesn't have enough features yet