#44471 [Fbk->Csd]: mysql_connect times out when a port is specified
ID: 44471
User updated by: jad at hungover dot org
Reported By: jad at hungover dot org
-Status: Feedback
+Status: Closed
Bug Type: MySQL related
Operating System: RHEL3
PHP Version: 5.2.5
New Comment:
Doh...my oops - PHP was picking up some mysql4 libraries...
Thanks for all the help though.
Previous Comments:
[2008-03-20 14:27:51] [EMAIL PROTECTED]
Works for me:
php > var_dump(mysql_connect('192.168.1.102:3308','root','...'));
resource(1) of type (mysql link)
Which libmysql version are you using and might you create a tcpdump log
or similar so we can analyze that? Thanks.
------------
[2008-03-19 00:31:45] jad at hungover dot org
Sorry, that made no difference - same results as before.
[2008-03-18 21:47:40] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows (zip):
http://snaps.php.net/win32/php5.2-win32-latest.zip
For Windows (installer):
http://snaps.php.net/win32/php5.2-win32-installer-latest.msi
------------
[2008-03-18 17:57:14] jad at hungover dot org
Description:
When using mysql_connect with host:port parameter, with port other than
3306, the connection times out.
Am able to telnet to the DB host on the alternative port, with mysql
responding as expected.
Tried using latest snapshot, as well as 5.2.5
Reproduce code:
---
Expected result:
3306 connected OK
3307 connected OK
Actual result:
--
[EMAIL PROTECTED] default]# /root/newphp/php5.2-200803181530/sapi/cli/php
test.php
3306 connected OK
Warning: mysql_connect(): Can't connect to MySQL server on
'192.168.151.116' (4) in /var/www/sites/default/htdocs/test.php on line
7
3307 failed connect
[EMAIL PROTECTED] default]#
--
Edit this bug report at http://bugs.php.net/?id=44471&edit=1
#44471 [Fbk->Opn]: mysql_connect times out when a port is specified
ID: 44471 User updated by: jad at hungover dot org Reported By: jad at hungover dot org -Status: Feedback +Status: Open Bug Type: MySQL related Operating System: RHEL3 PHP Version: 5.2.5 New Comment: Sorry, that made no difference - same results as before. Previous Comments: [2008-03-18 21:47:40] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi [2008-03-18 17:57:14] jad at hungover dot org Description: When using mysql_connect with host:port parameter, with port other than 3306, the connection times out. Am able to telnet to the DB host on the alternative port, with mysql responding as expected. Tried using latest snapshot, as well as 5.2.5 Reproduce code: --- Expected result: 3306 connected OK 3307 connected OK Actual result: -- [EMAIL PROTECTED] default]# /root/newphp/php5.2-200803181530/sapi/cli/php test.php 3306 connected OK Warning: mysql_connect(): Can't connect to MySQL server on '192.168.151.116' (4) in /var/www/sites/default/htdocs/test.php on line 7 3307 failed connect [EMAIL PROTECTED] default]# -- Edit this bug report at http://bugs.php.net/?id=44471&edit=1
#44471 [NEW]: mysql_connect times out when a port is specified
From: jad at hungover dot org Operating system: RHEL3 PHP version: 5.2.5 PHP Bug Type: MySQL related Bug description: mysql_connect times out when a port is specified Description: When using mysql_connect with host:port parameter, with port other than 3306, the connection times out. Am able to telnet to the DB host on the alternative port, with mysql responding as expected. Tried using latest snapshot, as well as 5.2.5 Reproduce code: --- Expected result: 3306 connected OK 3307 connected OK Actual result: -- [EMAIL PROTECTED] default]# /root/newphp/php5.2-200803181530/sapi/cli/php test.php 3306 connected OK Warning: mysql_connect(): Can't connect to MySQL server on '192.168.151.116' (4) in /var/www/sites/default/htdocs/test.php on line 7 3307 failed connect [EMAIL PROTECTED] default]# -- Edit bug report at http://bugs.php.net/?id=44471&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=44471&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=44471&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=44471&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=44471&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=44471&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=44471&r=needtrace Need Reproduce Script:http://bugs.php.net/fix.php?id=44471&r=needscript Try newer version:http://bugs.php.net/fix.php?id=44471&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=44471&r=support Expected behavior:http://bugs.php.net/fix.php?id=44471&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=44471&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=44471&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=44471&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=44471&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=44471&r=dst IIS Stability:http://bugs.php.net/fix.php?id=44471&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=44471&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=44471&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=44471&r=nozend MySQL Configuration Error:http://bugs.php.net/fix.php?id=44471&r=mysqlcfg
