Re: mysql command waiting endlessly (lenny)

[berenger.morel@neutralite.org]

Le 16.09.2014 19:46, Don Armstrong a écrit :
> On Tue, 16 Sep 2014, berenger.morel@neutralite.org wrote:
> > On a old lenny, we have a software which have to connect to a server 
> > of the
> > same LAN (we do not have physical access to any stuff, and we can 
> > only
> > connect through ssh to that client computer), but when it connect 
> > through
> > the mysql program, there is no prompt. Through the odbc program 
> > (isql), it
> > works fine (we fill mysql's parameters with some greps of the odbc's
> > configuration).
>
> [...]
>
> > Does someone have any idea about what could be the problem, and/or 
> > how
> > to fix it?
>
> The request in TIME_WAIT is almost certainly not your problem. Run 
> mysql
> under strace, and see precisely where it is failing to connect to the
> machine, then check your routing tables and firewall configuration.

Thanks for the hints.
From what I can understand, it seems that the client is waiting 
endlessly for a server's reply, which seems to never come. Strange that 
the server replies when isql is involved... and according to netstat, it 
really uses the same port. (1)
Could it be possible that the server is configured to only accept odbc 
client? But in that case, why would it accept to establish the 
connection, making the client waiting endlessly?
Anyway, it really seems that it's not a problem from our side... 
Hopefully I'll be able to find a solution to not maintain two versions 
of the same program because of that.

> Most likely, you've created a configuration where the machine in
> question is unable to access 3306.

I do not think so, since the isql command (which uses odbc driver) 
works, and is configured to use port 3306.

> You can also telnet 10.6.0.3 3306; (or use nc) from the afflicted
> machine to see if it even connects to mysql at all.

I already did some nc on the target: nc 10.6.0.3 -p 3306. It was how I 
guessed the mysql server's version.


1:
Every 1,0s: netstat -np|grep 3306                                       
                      Wed Sep 17 14:20:05 2014

tcp        0      0 10.6.0.200:43622        10.6.0.3:3306           
TIME_WAIT   -
tcp        0      0 10.6.0.200:43621        10.6.0.3:3306           
ESTABLISHED 21326/isql
tcp        0      0 10.6.0.200:43620        10.6.0.3:3306           
ESTABLISHED 21312/mysql