Le 16.09.2014 19:46, Don Armstrong a écrit :
On Tue, 16 Sep 2014, berenger.mo...@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
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Archive:
https://lists.debian.org/e0e548e91a9f162b281d6b0ae724e...@neutralite.org
