MYSQL connection problem (added info)

[David Jenkins]

On Wed, 1 December, 2004 12:16, mario.lobo at 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 <mss
> 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 <mss 16344,nop,wscale
> 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
> <nop,nop,timestamp 77449669 77449669>
>
> 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
> <nop,nop,timestamp 77449670 77449669>
>
> 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
> <nop,nop,timestamp 77449674 77449670>
>
> 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
> <nop,nop,timestamp 77449674 77449670>
>
> 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
> <nop,nop,timestamp 77449674 77449674>
>
> 7 packets captured
> 7 packets received by filter
> 0 packets dropped by kernel
>
>
> I hope this helps,
>
> --
>    //|  //||
>   // | // ||
> -//--//---|| ARIO LOBO
> //  //    ||
> ---------------------------------
> mario.lobo at 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