LibO won't connect to remote database using Java Connector

[Theancientone]

Hi,

I’m using Libo base to manage my addresses and much more. But it seems I cannot connect to a remote database (mysql) using the java database driver.

On a localhost it will connect, however I have setup a database on a ubuntu server 12.04 LTS version somewhere on my LAN.

When I connect I get the following error:

SQL Status: 08S01

Communications link failure

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

It looks like there is a problem on the server end but I have setup the firewall to let port 3306 thru, so the firewall shouldn’t be a problem.

This is my setup.

Clientside:

• linux mint 13 LTS (maya)
• Libo: version 3.6.0.2 (Build ID: 360m1(Build:102))
• JDBC-driver: 5.1.22 (from Oracle/mysql)

Serverside:

• Ubuntu server 12.04.1 LTS
• Phpmyadmin 3.4.10.1deb1
• Mysql server 5.5.24

I do connect by IP. For Libre office should it be like: :3306

My question is, why is it not connecting to the server?

[mariosv]

Showing the URL string used to connect, maybe someone can verify it.

[Theancientone]

Thank you, i do connect via IP. So i fill out the fields like this: server: Port: 3306. I did try it be name also but no luck.

[qubit1]

Hi @Theancientone, Please file a bug about this problem. The QA team will be happy to help you track down this issue! Thanks!

[bart.a]

I’ve got just about the same problem…
I had to replace my server, re-installed on new hardware and now it doesn’t work anymore… I can connect from my workstation to the dbase with phpmyadmin, but not with LibreOffice… SQL Status: 08S01 Communications link failure.

Client side: Win7
Server side: Ubuntu 12.04.1

I think I have the same setup as before, but now it doesn’t work… I can’t figure out what’s wrong… Could it be the “mysql_secure_installation”? I think that is the only difference… Thanks…

[mariosv]

Take a look to this thread, about “Debugging Communication Link Failure exceptions in Connector/J”.

Debugging Communication Link Failure exceptions in Connector/J

[qubit1]

Hi @Theancientone,

Please file a bug about this problem, and provide a list of steps that can reproduce it. The QA team will be happy to help you track down this issue!

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.

Thanks!

[method]

still can`t connect to remote MySQL from

Windows7
mysql-connector-java-5.1.24
LibreOffice 4.0.2.2 (ID сборки: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)