Ask Your Question
0

Problem: Base connection to remote MySQL DB from a Mac [closed]

asked 2012-06-01 21:15:08 +0200

RichA gravatar image

On a Linux machine (Ubuntu 11.04) I set up a connection between Base and a remote MySQL database. (I am using JDBC to connect, using class com.mysql.jdbc.Driver.)

I copied the ODB file from the Linux machine to a Windows 7 machine, and was able to use it in Base to connect to the remote MySQL database.

The same ODB file was copied to a Mac running OS X 10.5.8, and got the following error when it was used to try to connect to the remote MySQL DB:

SQL Status: 08001 Server connection failure during transaction. Due to underlying exception: 'java.net.ConnectException: Connection refused'.

Is there something different about the way we need to connect in Base on a Mac to a remote MySQL DB?

Is it possible we need to create a new ODB file on the Mac instead of using the copied ODB file?

I am trying to get some suggestions because I am not actually sitting at the Mac trying this. I am talking by phone to someone sitting at the Mac, who I am trying to give simple directions to, to get the connection set up there.

Note: On the Linux and Windows machines I had problems with frequent disconnects, which I resolved by adding parameters to the database name, in Base, as follows:

"name_of_mysql_database?connectTimeout=0&socketTimeout=0&autoReconnect=true"

Is it possible the parameters above appended to the database name can cause problems when used on the Mac?

Thanks in advance for any solutions or suggestions.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 15:19:04.779404

1 Answer

Sort by » oldest newest most voted
0

answered 2012-06-06 16:36:55 +0200

RichA gravatar image

This seems to be a network issue, not a Mac or Java issue: A laptop that connects to the DB okay elsewhere, cannot connect to the DB from the office where the Macs are located--even though the laptop does connect to the internet from that office.

So the problem is not solved, but the original problem description now seems irrelevant.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-06-01 21:15:08 +0200

Seen: 760 times

Last updated: Jun 06 '12