MySQL Communication failure

Classic Servoy
1

Servoy R2 2.1.2
Java version 1.4.2-38 (Mac OS X)
running on a Mac OSX 10.3.7
I created a new server conncting to a remote server hosting a MySQL database.
Everithing is working fine.

At the moment of migrating the same solution on the deploying machine,
Servoy R2 2.1.2
Java version 1.4.1-24 (Mac OS X)
running on a Mac OSX 10.2.8

the server is unable to start.
This is message:
"java.sql.SQLExeption: Communication failure during handshake. Is there a server running on xxx.xx.xx.xx:3306?

Both the connections are using the default MySQL driver in bundle:
org.gjt.mm.mysql.Driver

any idea?
Thanks

Armando

2

AGhisalberti:
Servoy R2 2.1.2
the server is unable to start.
This is message:
"java.sql.SQLExeption: Communication failure during handshake. Is there a server running on xxx.xx.xx.xx:3306?

Both the connections are using the default MySQL driver in bundle:
org.gjt.mm.mysql.Driver

any idea?
Thanks

Armando

What MySQL version are you using on the production machine?

Are the permissions ok for the user that servoy uses to connect to the backend on localhost?

Download the latest jdbc driver from http://www.mysql.com, the one shipping with Servoy has some problems with recent MySQL builds (there’s a license problem holding them from distributing the official mysql jdbc driver).

Double check the folder /Library/Java/Extensions and /Users/*/Library/Java/Extensions, on MacOSX if there is a jdbc driver there it will be used instead of the one in the Servoy Drivers folder, other java apps install their driver there (at least eSuite4xJ does).

If you can’t resolve the problem try to tell us more on you’re configuration.

3

ngervasi:
What MySQL version are you using on the production machine?

MySQL 4.1

Are the permissions ok for the user that servoy uses to connect to the backend on localhost?

yes

…Double check the folder /Library/Java/Extensions and /Users/*/Library/Java/Extensions, on MacOSX if there is a jdbc driver there it will be used instead of the one in the Servoy Drivers folder, other java apps install their driver there (at least eSuite4xJ does).

i checked both my /Library/Java/Extensions/

on OSX 10.2.8: it was empty

on OSX 10.3.7: these files
caucho-jdbc-mysql-2.1.0.jar
JDBCPlugin.jar
FOLDER:mysql-connector-java-3.0.15-ga
mysql-connector-java-3.0.15-ga-bin.jar

i simply copied the 10.3.7’s Extensions folder on the deploy machine and that MADE IT!
I tested also through YourSQL, it works now.

It seems that OSX 10.2.n lacks some Java Extensions.

Great Nicola! thanks.
Armando

4

The problem was indeed the jdbc driver: mysql 4.1 needs a new driver and that made the trick.

Have fun!