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?
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!
still can`t connect to remote MySQL from
Windows7 mysql-connector-java-5.1.24 LibreOffice 4.0.2.2 (ID сборки: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)
Take a look to this thread, about "Debugging Communication Link Failure exceptions in Connector/J". http://mysqlblog.fivefarmers.com/2010/09/06/debugging-communication-link-failure-exceptions-in-connectorj/
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..
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-28 10:32:21 +0200
Seen: 344 times
Last updated: May 01
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Showing the URL string used to connect, maybe someone can verify it.
mariosv ( 2012-09-29 02:35:26 +0200 )editThank 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 ( 2012-09-29 20:21:45 +0200 )editHi @Theancientone, Please file a bug about this problem. The QA team will be happy to help you track down this issue! Thanks!
qubit ( 2013-01-31 07:18:19 +0200 )edit