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?