From owner-freebsd-database@FreeBSD.ORG Wed Dec 1 12:13:20 2004 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D951016A4CE; Wed, 1 Dec 2004 12:13:20 +0000 (GMT) Received: from recife.ipadnet.com.br (recife.ipadnet.com.br [200.249.204.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id B644043D68; Wed, 1 Dec 2004 12:13:18 +0000 (GMT) (envelope-from mario.lobo@ipad.com.br) Received: from marioLobo ([200.249.204.142]) by recife.ipadnet.com.br (8.12.8/8.12.8) with ESMTP id iB1CIFMr013127; Wed, 1 Dec 2004 09:18:15 -0300 From: mario.lobo@ipad.com.br Organization: IPAD To: freebsd-database@freebsd.org Date: Wed, 01 Dec 2004 09:16:44 -0300 MIME-Version: 1.0 Message-ID: <41AD8BFC.7650.590021@localhost> Priority: normal X-mailer: Pegasus Mail for Windows (4.21c) Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: Quoted-printable Content-description: Mail message body cc: freebsd-hackers@freebsd.org cc: freebsd-questions@freebsd.org Subject: MYSQL connection problem (added info) X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: mario.lobo@ipad.com.br List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 01 Dec 2004 12:13:21 -0000 Adding the tcpdump output after changing mysqld to port 5004 (just a try := (( ) and issuing: [~]>mysql --port=3D5004 --host=3D127.0.0.1 --user=3Dxxxxxxx database -p [~]>tcpdump -vv -i lo0 port 5004 tcpdump: listening on lo0, link-type NULL (BSD loopback), capture size 96 = bytes 08:57:04.755597 IP (tos 0x0, ttl 64, id 5384, offset 0, flags [DF], lengt= h: 64) localhost.58972 > localhost.5004: S [tcp sum ok] 1832068379:1832068379(0) win 65535 08:57:04.755654 IP (tos 0x0, ttl 64, id 5385, offset 0, flags [DF], lengt= h: 64) localhost.5004 > localhost.58972: S [tcp sum ok] 87927240:87927240(0) ack 1832068380 win 65= 535 08:57:04.755685 IP (tos 0x0, ttl 64, id 5386, offset 0, flags [DF], lengt= h: 52) localhost.58972 > localhost.5004: . [tcp sum ok] 1:1(0) ack 1 win 35840 08:57:04.756399 IP (tos 0x0, ttl 64, id 5387, offset 0, flags [DF], lengt= h: 52) localhost.5004 > localhost.58972: F [tcp sum ok] 1:1(0) ack 1 win 35840 08:57:04.760855 IP (tos 0x8, ttl 64, id 5388, offset 0, flags [DF], lengt= h: 52) localhost.58972 > localhost.5004: . [tcp sum ok] 1:1(0) ack 2 win 35840 08:57:04.761035 IP (tos 0x8, ttl 64, id 5389, offset 0, flags [DF], lengt= h: 52) localhost.58972 > localhost.5004: F [tcp sum ok] 1:1(0) ack 2 win 35840 08:57:04.761067 IP (tos 0x0, ttl 64, id 5390, offset 0, flags [DF], lengt= h: 52) localhost.5004 > localhost.58972: . [tcp sum ok] 2:2(0) ack 2 win 35839 7 packets captured 7 packets received by filter 0 packets dropped by kernel I hope this helps, -- //| //|| // | // || -//--//---|| ARIO LOBO // // || --------------------------------- mario.lobo@ipad.com.br http://www.ipad.com.br -- First post /* =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D I have two machines: 1) Free 4.10 / mysql (5.0.0) listening on port 5006 2) Free 5.3 Release / mysql (5.0.0) listening on port 5007 On both, no firewalls, blocks or anything of that sort. Both machines have= the same configuration. Both mysql were compiled from the ports with the same options. The only di= fference between the two machines is the Free version and port mysql is listening on. Here are the outputs of the following commands on machine 1): >telnet localhost 5006 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 9 5.0.0-alpha}l'zRjBG,!js%Zxl6f"p3 (after a few seconds...) Connection closed by foreign host. --------------------------------------------- >mysql -u root -P 5006 -h 127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 5.0.0-alpha Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> ********************** Now, here are the outputs of the same commands on machine 2): ]>telnet localhost 5007 Trying ::1... Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. Connection closed by foreign host. (no wait for this line to show!) >mysql -u root -P 5007 -h 127.0.0.1 -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server during query (no wait for the above line to show either!) ************** I can only connect on machine 2) if I use a mysql.sock file. Any attempt t= o connect via TCP/IP doesn=B4t work !! command line client, java connectors (all possible versi= ons) none work. I=B4ve been into every single link google returned to me on the ERROR 2013= above for 2 days now and none of them had any info to get this working. Believe me, I tried every h= int of suggestion there was. I really hope someone here has any clues to what is going on. I=B4ve posted this to hackers but no clues so far. thanks, -- //| //|| // | // || -//--//---|| ARIO LOBO // // || --------------------------------- mario.lobo@ipad.com.br http://www.ipad.com.br