Ask Your Question
0

LibO won't connect to remote database using Java Connector [closed]

asked 2012-09-28 10:32:21 +0200

Theancientone gravatar image

updated 2015-10-17 15:38:11 +0200

Alex Kemp gravatar image

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: <ipaddress>:3306

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

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-17 15:38:29.546422

Comments

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

m.a.riosv gravatar imagem.a.riosv ( 2012-09-29 02:35:26 +0200 )edit

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

Theancientone gravatar imageTheancientone ( 2012-09-29 20:21:45 +0200 )edit

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

qubit gravatar imagequbit ( 2013-01-31 07:18:19 +0200 )edit

4 Answers

Sort by » oldest newest most voted
0

answered 2013-02-24 12:22:04 +0200

qubit gravatar image

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!

edit flag offensive delete link more
0

answered 2013-02-04 21:54:49 +0200

m.a.riosv gravatar image

Take a look to this thread, about "Debugging Communication Link Failure exceptions in Connector/J". http://mysqlblog.fivefarmers.com/2010...

edit flag offensive delete link more
0

answered 2013-02-04 17:06:57 +0200

bart.a gravatar image

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..

edit flag offensive delete link more
0

answered 2013-05-01 10:01:49 +0200

method gravatar image

still can`t connect to remote MySQL from

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

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-09-28 10:32:21 +0200

Seen: 1,843 times

Last updated: May 01 '13