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: [email protected] -- To unsubscribe e-mail to: [email protected] 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
