Communications link failure.
Posted: Thu May 21, 2009 9:58 pm
I'm having difficulty connecting to a remote mysql server.
I have verified connectivity, and that the remote server is accepting requests from my client station. The problem is in setting up my connection in OO Database.
From a terminal window, I can connect to the remote server with "mysql --user=me --password=mypassword --host=mysql.somewhere.net" (not the actual names, but the ones I'm using work). That brings up the mysql client and I can "SHOW DATABASES;" "USE somedatabase;" and generally everything works. Just pointing this out up front so that anyone who starts out "your server is misconfigured" understands that all evidence points to the server working properly. This client station can connect to the database server. The server replies as expected. It's OpenOffice Database with JDBC that isn't working.
Here's what I'm doing. Perhaps someone can point out my error:
When I open OpenOffice database, I get the database wizard. First window: "Welcome to the OpenOffice.org Database Wizard ... What do you want to do ..." I select the bottom choice, "Connect to an existing database" and "mysql" on the drop down selction.
That takes me to step 2, "Set up MySQL connection." I select "Connect using JDBC" on that window.
Next, the wizard takes me to "Set up connection to a MySQL database using JDBC." I have 4 fields to fill in on that window:
Name of the database: mydatabase (changed, but it's one I can "USE" with the terminal mysql client on this station.)
Server URL: jdbc:3306//mysql.somewhere.net (again, it's the domain name that works from the terminal mode mysql client.)
Port: 3306
JDBC driver class: com.mysql.jdbc.Driver
When I press the "Test Class" button, it says the JDBC driver was loaded successfully.
Pressing the "Next" button brings up the "Set up user authentication" window. I type in "me" for my username (the name that works from the terminal mode mysqlclient), and check the password box. When I press the "Test Connection" button, it prompts for my password. When I give the correct password (cut and paste from where I put it on the command line in the terminal, so I know it's right), I get "Communications Link Failure" ... "Last Packet sent to the server was 0ms ago."
I'm stuck. What's the proper incantation? What have I misspelled? Mispunctuated? Or filled out wrong?
If it matters, I'm using OpenOffice 3.0.1 (build 9379) on Ubuntu Linux 9.04. I'm up to date on all updates.
I have verified connectivity, and that the remote server is accepting requests from my client station. The problem is in setting up my connection in OO Database.
From a terminal window, I can connect to the remote server with "mysql --user=me --password=mypassword --host=mysql.somewhere.net" (not the actual names, but the ones I'm using work). That brings up the mysql client and I can "SHOW DATABASES;" "USE somedatabase;" and generally everything works. Just pointing this out up front so that anyone who starts out "your server is misconfigured" understands that all evidence points to the server working properly. This client station can connect to the database server. The server replies as expected. It's OpenOffice Database with JDBC that isn't working.
Here's what I'm doing. Perhaps someone can point out my error:
When I open OpenOffice database, I get the database wizard. First window: "Welcome to the OpenOffice.org Database Wizard ... What do you want to do ..." I select the bottom choice, "Connect to an existing database" and "mysql" on the drop down selction.
That takes me to step 2, "Set up MySQL connection." I select "Connect using JDBC" on that window.
Next, the wizard takes me to "Set up connection to a MySQL database using JDBC." I have 4 fields to fill in on that window:
Name of the database: mydatabase (changed, but it's one I can "USE" with the terminal mysql client on this station.)
Server URL: jdbc:3306//mysql.somewhere.net (again, it's the domain name that works from the terminal mode mysql client.)
Port: 3306
JDBC driver class: com.mysql.jdbc.Driver
When I press the "Test Class" button, it says the JDBC driver was loaded successfully.
Pressing the "Next" button brings up the "Set up user authentication" window. I type in "me" for my username (the name that works from the terminal mode mysqlclient), and check the password box. When I press the "Test Connection" button, it prompts for my password. When I give the correct password (cut and paste from where I put it on the command line in the terminal, so I know it's right), I get "Communications Link Failure" ... "Last Packet sent to the server was 0ms ago."
I'm stuck. What's the proper incantation? What have I misspelled? Mispunctuated? Or filled out wrong?
If it matters, I'm using OpenOffice 3.0.1 (build 9379) on Ubuntu Linux 9.04. I'm up to date on all updates.