First time here? Check out the FAQ!
asked 2012-09-28 10:32:21 +0200Theancientone
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 18.104.22.168 (Build ID: 360m1(Build:102)) - JDBC-driver: 5.1.22 (from Oracle/mysql)
Serverside: - Ubuntu server 12.04.1 LTS - Phpmyadmin 22.214.171.124deb1 - 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?
answered 2013-02-24 12:22:04 +0200qubit
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".
answered 2013-05-01 10:01:49 +0200method
still can`t connect to remote MySQL from
Windows7 mysql-connector-java-5.1.24 LibreOffice 126.96.36.199 (ID сборки: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)
answered 2013-02-04 21:54:49 +0200mariosv
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/
answered 2013-02-04 17:06:57 +0200bart.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..
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