Hi,dear Gurus! I'm having serious troubles connecting from a Windows XP machine (and yes, the FW is down) and a MySQL 4.1.1 database using MYSQL Connector/J 3.1 (3.0.11 and 3.1 Nightly build aswell) running on a Redhat Linux 9 box.

It all started when I upgraded the DB server from 3.23 to a 4.1.1 server (Compiled from source). Suddenly the ODBC connector 3.51 stopped working and after some digging I discovered the "--old-passwords" option to mysqld. ODBC started working again and I moved on to more interesting stuff... getting my development up and running.

KAABLAAAM!!! Suddenly I couldn't connect at all from my Java applications. All connections resulted in an error and a stack trace...whatever I tried to do. So I disabled the "--old-password" option again...

The packet trace from a failed connection:

------- C:\System\se\test>java -cp "C:\jar\mysql-connector-java-3.1.1-alpha-bin.jar;." jdbctest Exception at: jdbctest.main SQLState: 08S01 Message: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

** BEGIN NESTED EXCEPTION **

java.io.IOException MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) at com.mysql.jdbc.Connection.<init>(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at jdbctest.main(jdbctest.java:12)

** END NESTED EXCEPTION **

Vendor: 0

C:\System\se\test>

-------

Then I pulled out my trustworthy Ethereal network sniffer to examine the packets sent between the server and the client.

And here I saw some strange behavior: (Packet trace follows)

------------------------------------------------------------ No. Time Source Destination Protocol Info 211 8.278942 www.server.com www.client.com MySQL Server Greeting Protocol : 10 ,version: 4.1.1-alpha-log Caps: 0xffffa22c 212 8.290853 www.client.com www.server.com MySQL Login Request Caps: 0xffffc087 ,user: ÿÿ ,password: test 214 8.291008 www.server.com www.client.com MySQL Response Error Code: 413

------------------------------------------------------------

The funny thing is in the user part of the login request packet... Whatever I write in the getConnection I get this behaviour and this is the call resulting in the above packet exchange:

------------------------------------------------------------ Connection conn =

);

------------------------------------------------------------ The really strange thing is that it worked until I upgraded the server...

So now I'm out of options... anyone got any ideas on how to get this up and running. (The really strange thing is that it all works if I run the Java code on the server)

My current setup: Server: 1. Redhat Linux 9 (with the FW disabled) 2. MySQL Server 4.1.1 built from sources 3. java version "1.4.1_02" 4. MySQL Connector/J 3.1 (3.0.10 or 3.1.1 20040412)