MYSQL Communication Link Failure

Classic Servoy
1

I have set up many Drupal, Wordpress, Dolphin etc… installations but am a total newbie with Servoy and assistance would be apreciated.

I’m trying to add a newly created (empty) MYSQL database that is hosted with GoDaddy to a new Servoy project.

I continuously get a Communication Link Failure saying:

“The the last packet was sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.”

I have downloaded the latest SQL driver Java-5.1.13, searched through the forums and followed any clues that I might find but am totally stumped.

The database is hosted with GoDaddy and I am wondering whether it could be because Remote Direct Access may be required.

Details follow:
Database name, username and password have been triple-checked (and more).

URL: jdbc:mysql://p50mysql135.secureserver.net

DRIVERS:
com.mysql.jdbc.Driver
or
org.gjt.mm.mysql.Driver

Any help would be greatly appreciated!

John

2

Hi John,

Can you connect to the database using the MySQL tools like MySQL Administrator or MySQL Workbench ?
I.e. can you access the database remotely (other then with phpMyAdmin) ?
Also is Servoy server also hosted on the GoDaddy server?

3

Hi Johnbmtl:

Another issue; the user of the connection mysql has privileges to connect from any IP range?

GRANT ALL PRIVILEGES ON myDatabase.* TO userConnection@"%"  IDENTIFIED BY 'some_pass'

The symbol “%” indicates that any IP is valid for this user.

Regards.

4

ROCLASI:
Hi John,

Can you connect to the database using the MySQL tools like MySQL Administrator or MySQL Workbench ?
I.e. can you access the database remotely (other then with phpMyAdmin) ?
Also is Servoy server also hosted on the GoDaddy server?

I didn’t try hosting the server on GoDaddy.
I’ve been running it from my local Mac and trying to communicate with the hosted database.

I can’t find any documentation on installing Servoy on a hosted server.
Can someone help or point me to the right docs? I’d like to try to set it up on GoDaddy or Amazon EC2.

This could resolve my access problem.

Thanks!