#34072 [Com]: MySQL module can't connect if port is not 3306
ID: 34072 Comment by: m6mkiller at hotmail dot com Reported By: pash_ka at fonbet dot info Status: No Feedback Bug Type: PDO related Operating System: Windows XP PHP Version: 5CVS-2005-08-30 Assigned To: wez New Comment: yo im not able to connect it says localhost not alowwed to access this and i cant access my servers or any thing i had to use mysql its like it deleted the server name Previous Comments: [2007-11-16 22:08:28] stratsnteles at wi dot rr dot com I've installed Apache 2.2, PHP5 and mysql 5.0.45. I have verified that Apache is running fine, along with PHP (running PHP test script). When I use various sample php scripts to connect to mysql, I get nothing. nada. zip. Not even 'die' error message. I'm suspecting it's a problem w/PHP 5. I am a PHP/MySql newbie, but an old PC pro. I am certain that I have the servers configured properly, Can anyone help? [2007-10-22 07:11:48] shanewaj at gmail dot com Hi Friends I am trying to connect a mysql and php5 with Apache2 PHP is working ok I can show php files no problem but when i try to connect with mysql nothing is happending simply nothing as I have tried this script as well I have tried my old scripts as well not no response it does not show any thing not even error msg. any idea I am lost ... Thanks Shanewaj [2006-08-13 11:50:39] waruiinu at gmail dot com I think there is some sort of bug in mysql client library. It just doesn't want to use tcp connection if you connect to localhost. For example if I add -P 3306 to mysql client binary, netstat will show the unix connection, not the tcp. Only if i use -h 127.0.0.1 mysql will use tcp (-h localhost doesn't solve anything). [2005-09-08 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". [2005-08-31 06:07:52] [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 try a new 5.1 snapshot please. Your bug is only occurs when you use 'localhost' (and not 127.0.0.1), so please check that. Thanks, George 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
#34072 [Com]: MySQL module can't connect if port is not 3306
ID: 34072 Comment by: stratsnteles at wi dot rr dot com Reported By: pash_ka at fonbet dot info Status: No Feedback Bug Type: PDO related Operating System: Windows XP PHP Version: 5CVS-2005-08-30 Assigned To: wez New Comment: I've installed Apache 2.2, PHP5 and mysql 5.0.45. I have verified that Apache is running fine, along with PHP (running PHP test script). When I use various sample php scripts to connect to mysql, I get nothing. nada. zip. Not even 'die' error message. I'm suspecting it's a problem w/PHP 5. I am a PHP/MySql newbie, but an old PC pro. I am certain that I have the servers configured properly, Can anyone help? Previous Comments: [2007-10-22 07:11:48] shanewaj at gmail dot com Hi Friends I am trying to connect a mysql and php5 with Apache2 PHP is working ok I can show php files no problem but when i try to connect with mysql nothing is happending simply nothing as I have tried this script as well I have tried my old scripts as well not no response it does not show any thing not even error msg. any idea I am lost ... Thanks Shanewaj [2006-08-13 11:50:39] waruiinu at gmail dot com I think there is some sort of bug in mysql client library. It just doesn't want to use tcp connection if you connect to localhost. For example if I add -P 3306 to mysql client binary, netstat will show the unix connection, not the tcp. Only if i use -h 127.0.0.1 mysql will use tcp (-h localhost doesn't solve anything). [2005-09-08 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". [2005-08-31 06:07:52] [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 try a new 5.1 snapshot please. Your bug is only occurs when you use 'localhost' (and not 127.0.0.1), so please check that. Thanks, George [2005-08-30 12:22:20] pash_ka at fonbet dot info I've also checked it with version 5.1.0b3 (Jul 14 2005 20:32:24), and it works fine for 127.0.0.1 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
#34072 [Com]: MySQL module can't connect if port is not 3306
ID: 34072 Comment by: shanewaj at gmail dot com Reported By: pash_ka at fonbet dot info Status: No Feedback Bug Type: PDO related Operating System: Windows XP PHP Version: 5CVS-2005-08-30 Assigned To: wez New Comment: Hi Friends I am trying to connect a mysql and php5 with Apache2 PHP is working ok I can show php files no problem but when i try to connect with mysql nothing is happending simply nothing as I have tried this script as well I have tried my old scripts as well not no response it does not show any thing not even error msg. any idea I am lost ... Thanks Shanewaj Previous Comments: [2006-08-13 11:50:39] waruiinu at gmail dot com I think there is some sort of bug in mysql client library. It just doesn't want to use tcp connection if you connect to localhost. For example if I add -P 3306 to mysql client binary, netstat will show the unix connection, not the tcp. Only if i use -h 127.0.0.1 mysql will use tcp (-h localhost doesn't solve anything). [2005-09-08 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". [2005-08-31 06:07:52] [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 try a new 5.1 snapshot please. Your bug is only occurs when you use 'localhost' (and not 127.0.0.1), so please check that. Thanks, George [2005-08-30 12:22:20] pash_ka at fonbet dot info I've also checked it with version 5.1.0b3 (Jul 14 2005 20:32:24), and it works fine for 127.0.0.1 [2005-08-30 12:00:23] pash_ka at fonbet dot info 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: --- 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) -- 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
#34072 [Com]: MySQL module can't connect if port is not 3306
ID: 34072 Comment by: waruiinu at gmail dot com Reported By: pash_ka at fonbet dot info Status: No Feedback Bug Type: PDO related Operating System: Windows XP PHP Version: 5CVS-2005-08-30 Assigned To: wez New Comment: I think there is some sort of bug in mysql client library. It just doesn't want to use tcp connection if you connect to localhost. For example if I add -P 3306 to mysql client binary, netstat will show the unix connection, not the tcp. Only if i use -h 127.0.0.1 mysql will use tcp (-h localhost doesn't solve anything). Previous Comments: [2005-09-08 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". [2005-08-31 06:07:52] [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 try a new 5.1 snapshot please. Your bug is only occurs when you use 'localhost' (and not 127.0.0.1), so please check that. Thanks, George [2005-08-30 12:22:20] pash_ka at fonbet dot info I've also checked it with version 5.1.0b3 (Jul 14 2005 20:32:24), and it works fine for 127.0.0.1 [2005-08-30 12:00:23] pash_ka at fonbet dot info 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: --- 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) -- [2005-08-30 01:05:46] [EMAIL PROTECTED] Does it work if you change the hostname to 127.0.0.1? 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