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

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


Le 27/07/2020 à 09:06, Michael Manning a écrit :

Hi Michael,

>
> 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.
>

As Robert has indicated, could you be clearer on what you mean by
"creating a new database within LibreOffice ?"

Are you:
(1) trying to create a new database schema from within a running LO
instance ? As Robert has mentioned, you can't actually do this, the DB
schema needs to be created from the msyql command line or an alternative
GUI tool (such as e.g. phpmyadmin) ;

(2) trying to connect to an existing mysql DB schema, and receiving the
error message you have indicated ?


The error message itself might be slightly misleading, as this is
usually displayed when you can not even connect to the mariadb/mysql
instance.

What does your /etc/mysql/my.cnf or /etc/my.cnf contain next to :

bind-address
and
skip-networking




Alex


--
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 JDBCMichael Manning <michaelgmanning@gmail.com>
References:
[libreoffice-users] Connecting libreoffice to MySQL/MariaDB via JDBCMichael Manning <michaelgmanning@gmail.com>
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.