ID: 27079 Updated by: [EMAIL PROTECTED] Reported By: evan at mirrored dot ca -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Solaris 8 PHP Version: 4.3.4 New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Dump of large quantities of totally useless and irrelevant information does not make your bug any less bogus. Previous Comments: ------------------------------------------------------------------------ [2004-01-28 16:03:33] evan at mirrored dot ca How do you figure it doesn't imply a php bug? The cli works, the module doesn't and yet both were built at the exact same time... tcpdump'ing the connections it's like the module version doesn't open the TCP connection properly as you never see the version stamp from the server sent back to the client and only 4 packets are transmited (syn, syn+ack, then the two rst) 16:02:58.327665 jujitsu.disk.61547 > ragga-jungle.disk.mysql: S 3907734401:3907734401(0) win 24820 <nop,nop,sackOK,mss 1460> (DF) 0x0000 4500 0030 0e26 4000 4006 b438 0a32 3202 E..0.&@[EMAIL PROTECTED] 0x0010 0a32 3204 f06b 0cea e8eb 4b81 0000 0000 .22..k....K..... 0x0020 7002 60f4 77fe 0000 0101 0402 0204 05b4 p.`.w........... 16:02:58.327745 ragga-jungle.disk.mysql > jujitsu.disk.61547: S 4026494771:4026494771(0) ack 3907734402 win 5840 <mss 1460> (DF) 0x0000 4500 002c 0000 4000 4006 c262 0a32 3204 E..,[EMAIL PROTECTED]@..b.22. 0x0010 0a32 3202 0cea f06b efff 6f33 e8eb 4b82 .22....k..o3..K. 0x0020 6012 16d0 77e5 0000 0204 05b4 `...w....... 16:02:58.327767 jujitsu.disk.61547 > ragga-jungle.disk.mysql: R 3907734402:3907734402(0) win 24820 (DF) 0x0000 4500 0028 0e27 4000 4006 b43f 0a32 3202 E..(.'@[EMAIL PROTECTED] 0x0010 0a32 3204 f06b 0cea e8eb 4b82 0000 0000 .22..k....K..... 0x0020 5004 60f4 a4be 0000 5555 5555 5555 P.`.....UUUUUU 16:02:58.327898 jujitsu.disk.61547 > ragga-jungle.disk.mysql: R 3907734402:3907734402(0) win 0 (DF) 0x0000 4500 0028 0e28 4000 4006 b43e 0a32 3202 E..(.(@[EMAIL PROTECTED]>.22. 0x0010 0a32 3204 f06b 0cea e8eb 4b82 0000 0000 .22..k....K..... 0x0020 5004 0000 05b3 0000 5555 5555 5555 P.......UUUUUU Where as on the cli version it connects properly and on the 6th packet sends the username. 16:02:07.765900 jujitsu.disk.61545 > ragga-jungle.disk.mysql: S 3325586428:3325586428(0) win 24820 <nop, nop,sackOK,mss 1460> (DF) 0x0000 4500 0030 0e1c 4000 4006 b442 0a32 3202 [EMAIL PROTECTED]@..B.22. 0x0010 0a32 3204 f069 0cea c638 6bfc 0000 0000 .22..i...8k..... 0x0020 7002 60f4 7a38 0000 0101 0402 0204 05b4 p.`.z8.......... 16:02:07.766007 ragga-jungle.disk.mysql > jujitsu.disk.61545: S 3957557224:3957557224(0) ack 3325586429 win 5840 <mss 1460> (DF) 0x0000 4500 002c 0000 4000 4006 c262 0a32 3204 E..,[EMAIL PROTECTED]@..b.22. 0x0010 0a32 3202 0cea f069 ebe3 87e8 c638 6bfd .22....i.....8k. 0x0020 6012 16d0 6586 0000 0204 05b4 `...e....... 16:02:07.766209 jujitsu.disk.61545 > ragga-jungle.disk.mysql: . ack 1 win 24820 (DF) 0x0000 4500 0028 0e1d 4000 4006 b449 0a32 3202 E..([EMAIL PROTECTED]@..I.22. 0x0010 0a32 3204 f069 0cea c638 6bfd ebe3 87e9 .22..i...8k..... 0x0020 5010 60f4 331f 0000 5555 5555 5555 P.`.3...UUUUUU 16:02:07.766772 ragga-jungle.disk.mysql > jujitsu.disk.61545: P 1:53(52) ack 1 win 5840 (DF) [tos 0x8] 0x0000 4508 005c 32fe 4000 4006 8f2c 0a32 3204 [EMAIL PROTECTED]@..,.22. 0x0010 0a32 3202 0cea f069 ebe3 87e9 c638 6bfd .22....i.....8k. 0x0020 5018 16d0 69f3 0000 3000 0000 0a34 2e30 P...i...0....4.0 0x0030 2e31 372d 7374 616e 6461 7264 006f 4800 .17-standard.oH. 0x0040 002d 2e3d 2a58 5f54 6500 2c20 0802 0000 .-.=*X_Te.,..... 0x0050 0000 .. 16:02:07.766918 jujitsu.disk.61545 > ragga-jungle.disk.mysql: . ack 53 win 24820 (DF) 0x0000 4500 0028 0e1e 4000 4006 b448 0a32 3202 E..([EMAIL PROTECTED]@..H.22. 0x0010 0a32 3204 f069 0cea c638 6bfd ebe3 881d .22..i...8k..... 0x0020 5010 60f4 32eb 0000 5555 5555 5555 P.`.2...UUUUUU 16:02:07.767976 jujitsu.disk.61545 > ragga-jungle.disk.mysql: P 1:24(23) ack 53 win 24820 (DF) [tos 0x8] 0x0000 4508 003f 0e1f 4000 4006 b428 0a32 3202 [EMAIL PROTECTED]@..(.22. 0x0010 0a32 3204 f069 0cea c638 6bfd ebe3 881d .22..i...8k..... 0x0020 5018 60f4 221c 0000 1300 0001 0520 0000 P.`."........... 0x0030 0070 6870 6262 005d 4c4d 5a56 414b 45 .phpbb.]LMZVAKE How can this not be a problem with the php module when clearly the module is not connecting to the server properly. ------------------------------------------------------------------------ [2004-01-28 15:21:14] [EMAIL PROTECTED] Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Ask support questions elsewhere, there is no bug here. ------------------------------------------------------------------------ [2004-01-28 15:16:07] evan at mirrored dot ca Description: ------------ I created the following file in my web root. # more test.php <pre> <?php $link = mysql_connect("10.50.50.4", "phpbb", "PASSWORD"); echo mysql_get_server_info() . "\n"; echo mysql_get_host_info() . "\n"; echo mysql_get_client_info() . "\n"; if ($link) { mysql_close($link); } ?> ok </pre> And when it's run from the CLI version everything is fine. # /usr/local/bin/php -f test.php <pre> 4.0.17-standard 10.50.50.4 via TCP/IP 4.0.16 ok </pre> However when I try to pull it up via the web interface I get: Warning: mysql_connect(): Can't connect to MySQL server on '10.50.50.4' (2) in /export/mirrors2/ragga-jungle.com/phpBB-2.0.6/test.php on line 4 Warning: mysql_get_server_info(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /export/mirrors2/ragga-jungle.com/phpBB-2.0.6/test.php on line 5 Warning: mysql_get_server_info(): A link to the server could not be established in /export/mirrors2/ragga-jungle.com/phpBB-2.0.6/test.php on line 5 Warning: mysql_get_host_info(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /export/mirrors2/ragga-jungle.com/phpBB-2.0.6/test.php on line 6 Warning: mysql_get_host_info(): A link to the server could not be established in /export/mirrors2/ragga-jungle.com/phpBB-2.0.6/test.php on line 6 4.0.16 ok -- SOFTWARE USED: php 4.3.4 (./configure --with-apxs2=/usr/local/apache/bin/apxs --with-gd --with-zlib --with-jpeg-dir=/usr/local --with-png-dir=/usr/local --with-mysql=/usr/local/mysql --with-xml) mysql 4.0.17 (./configure --without-server --without-debug --without-docs --without-bench --prefix=/usr/local/mysql) apache 2.0.48 (./configure --prefix=/usr/local/apache --with-mpm=worker --enable-modules="so dl rewrite") Here's some output from config.status in the php build directory: hostname = jujitsu uname -m = sun4u uname -r = 5.8 uname -s = SunOS uname -v = Generic_108528-24 /usr/bin/uname -p = sparc /bin/uname -X = System = SunOS Node = jujitsu Release = 5.8 KernelID = Generic_108528-24 Machine = sun4u BusType = <unknown> Serial = <unknown> Users = <unknown> OEM# = 0 Origin# = 1 NumCPU = 2 Reproduce code: --------------- see description Expected result: ---------------- see description Actual result: -------------- see description ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27079&edit=1
