Libre Base on a Mac M2 - Error: the connection to the data source could not be established using a JDBC connection to MySQL server. Error says: “communication link failure. the last packet sent was sent 0 milliseconds ago. the driver has not received any packets from the server”.
It is working on PC in the same Libre Base using a MySQL connection to a MySQL Server PC Windows 11.
Mac has the ARM java and JDBC installed and set in Libre on the Mac. IP address to the MySql server PC is set in the Base config. MySql Server is on another PC server to the one that is using Libre base and is working on the PC workstation. Libre office 25.8.6.2 on PC - same on Mac. MySQL 9.0.
The LibreBase.odb file is on the PC Server where the MySQL is and Mac is to able access this. It does work on the Mac when using a Firebird internal odb - but not multiuser.
Any ideas please?
Have a look at Tools → Options → LibreOffice → Advanced. Does LO recognize you have installed Java?
Have never got such an error. Might be there is something like a firewall running on Mac?
Thanks for the reply Robert,
Yes, the LO > options > Advanced does have the path to Java set as well as an entry for JDBC.
There is a basic Mac firewall as I understand.
I wonder if anyone else has done this with the same systems?
IMHO, this indicates that there is a driver and a connection to the server, but the server does not answer. A working firewall?
Out of interest, why aren’t you using the native MySQL driver instead of jdbc connector?
How are you loading the ODB file on your Mac ? Presumably, if the ODB file is shared from a PC, then it is being done over SMB?
What happens if you copy the odb file to your Mac and load it directly from the Mac, taking care to correct the configuration of the driver to the local copy of the jdbc connector.
Do you have a local copy of the JDBC connector Jar on the Mac? Remember, it can’t use a driver that is on another system.
Hmm. Thanks. The ODB is on the PC server, so yes, it is over SMB.
The JDBC set up is local to the Mac.
When the user and the Mac are back early next week I will get them to try both scenarios, but as local files - an ODB pointing to MySQL driver and one to the JDBC.
Distribute the database document and the JDBC driver to the clients.
Make sure, the document uses the right URL (menu:Edit>Database>Connection).
Much Appreciated.
I set the MySQL server references to being an IP addresses rather than DNS and I got the user to run it from the Mac desktop and it worked using the MySQL setup. They didn’t venture on to trying the JDBC! So great.
Somehow the next day it seems that they lost the desktop odb file and ran the IP version from the PC server and it worked? So it seems to be a DNS issue.
What is odd is that I have fields in the Tables that have file references as file://myServer/mydrive/… and smb://myServer/myDrive and these worked on the Mac when using Firebird & MySQL on the Mac. So, I had assumed that the DNS was fully supported. Am I right to assume that it is different on the DBMS interface as to the the data UI? Should I lodge this anywhere?
I might need to set the Server as a fixed IP address - I hope not.
Many thanks for your support.
I’d have to check, but it should work with DNS lookup. However, these might be blocked by macOS system firewall rules, so you’d need to check that you reach the DNS from the macOS machine, e.g. from the terminal. This wouldn’t be a LO specific problem necessarily, unless you could show that even with a valid and accessible DNS, you still couldn’t connect to your server instance over LO.