[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[libreoffice-users] Connecting libreoffice to MySQL/MariaDB via JDBC


I am trying to connect Libreoffice to MariaDB databases.

I am using the following configuration
- Linux Mint 19.2,
- MariaDB - Server version: 10.4.6-MariaDB and have connected successfully
via the mysql command line, and via PHPMyAdmin to create databases, tables
and to successfully search these tables.
- LibreOffice Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.10
- Java version openjdk 11.0.7 2020-04-14
OpenJDK Runtime Environment (build 11.0.7+10-post-Ubuntu-2ubuntu218.04)
OpenJDK 64-Bit Server VM (build 11.0.7+10-post-Ubuntu-2ubuntu218.04, mixed
mode, sharing)
- the JDBC connectors from either MySQL or MariaDB. These have included
from MySQL connector versions: 5.0.3, 5.1.36, 5.1.49 and MariaDB connector
versions: 1.5.9, 2.5.4, and 2.6.1. When these are configured in the Java
CLASSPATH, these drivers are loaded successfully.

Issues arise when attempting to create a new database within Libreoffice.
When I test connecting to a database, I get the following error message:
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.

I am not sure what to test/check next. I have spent quite a while
searching for answers to this issue but have not yet turned up a solution.
Is anyone connecting to MySQL/MariaDB databases using Linux and JDBC
successfully?

cheers
Mike
email: michaelgmanning@gmail.com

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Follow-Ups:
[libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBCAlexander Thurgood <alex.thurgood@gmail.com>
Re: [libreoffice-users] Connecting libreoffice to MySQL/MariaDB via JDBCRobert Gro├čkopf <robert@familiegrosskopf.de>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.