From owner-freebsd-questions@FreeBSD.ORG Wed Dec 1 12:28:14 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DEC1A16A4CE; Wed, 1 Dec 2004 12:28:14 +0000 (GMT) Received: from gateway.unixusers.co.uk (unixusers.co.uk [82.133.118.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9D2A143D49; Wed, 1 Dec 2004 12:28:10 +0000 (GMT) (envelope-from david.jenkins@gmail.com) Received: by gateway.unixusers.co.uk (Postfix, from userid 80) id 1A4C05C11; Wed, 1 Dec 2004 12:28:25 +0000 (GMT) Received: from 194.168.3.18 (SquirrelMail authenticated user david); by unixusers.co.uk with HTTP; Wed, 1 Dec 2004 12:28:25 -0000 (GMT) Message-ID: <37297.194.168.3.18.1101904105.squirrel@194.168.3.18> In-Reply-To: <41AD8BFC.7650.590021@localhost> References: <41AD8BFC.7650.590021@localhost> Date: Wed, 1 Dec 2004 12:28:25 -0000 (GMT) From: "David Jenkins" To: mario.lobo@ipad.com.br User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-15 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal cc: freebsd-database@freebsd.org cc: freebsd-questions@freebsd.org Subject: Re: MYSQL connection problem (added info) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: david.jenkins@gmail.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 01 Dec 2004 12:28:15 -0000 On Wed, 1 December, 2004 12:16, mario.lobo@ipad.com.br said: > Adding the tcpdump output after changing mysqld to port 5004 (just a > try :(( ) and issuing: > > [~]>mysql --port=5004 --host=127.0.0.1 --user=xxxxxxx 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], > length: 64) localhost.58972 > > localhost.5004: S [tcp sum ok] 1832068379:1832068379(0) win 65535 16344,nop,nop,sackOK,nop,wscale 1,nop,nop,timestamp 77449669 0> > > 08:57:04.755654 IP (tos 0x0, ttl 64, id 5385, offset 0, flags [DF], > length: 64) localhost.5004 > > localhost.58972: S [tcp sum ok] 87927240:87927240(0) ack 1832068380 > win 65535 1,nop,nop,timestamp 77449669 77449669,nop,nop,sackOK> > > 08:57:04.755685 IP (tos 0x0, ttl 64, id 5386, offset 0, flags [DF], > length: 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], > length: 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], > length: 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], > length: 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], > length: 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 /* > > =============================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 difference 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 to connect via TCP/IP > doesn´t work !! command line client, java connectors (all possible > versions) none work. > > I´ve 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 hint of suggestion there > was. > > I really hope someone here has any clues to what is going on. > > I´ve posted this to hackers but no clues so far. I may (and probably am!) be way off on this but could you post the contents of /etc/hosts and /etc/resolv.conf for both machines please. Cheers, David