MYSQL connection problem (added info)

[mario.lobo at ipad.com.br]

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.

thanks,

-- 
   //|  //||
  // | // ||
-//--//---|| ARIO LOBO
//  //    ||
---------------------------------
mario.lobo at ipad.com.br
http://www.ipad.com.br