[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC
- Subject: [libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC
- From: Alexander Thurgood <firstname.lastname@example.org>
- Date: Mon, 27 Jul 2020 15:28:54 +0200
- To: email@example.com
Le 27/07/2020 à 14:33, Michael Manning a écrit :
> I do not have a /etc/my.cnf file.
Well you have a configuration file somewhere in that XAMPP stack. The
question is where ?
BTW, not quite sure why you are using XAMPP rather than just installing
the distrib-provided versions of LAMP on the Ubuntu machine ?
> The only line that is not a comment in my /etc/mysql/my.cnf file is:
> !includedir /etc/mysql/conf.d/
Have you looked in /etc/mysql/conf.d/ to see which configuration files
are in there ?
> I should also mention that I am using XAMPP for the installation of MySQL
> and that this has also installed an apache web server and PHPMyAdmin which
> are all working correctly. Should this make any difference to the way that
> LibreOffice connects via the JDBC connector?
XAMPP will be running the mysql server instance (and the Apache server
and phpyadmin) using its own particular configuration files.
> - Server: Localhost via UNIX socket
> - Server type: MariaDB
> Is this a hint that sockets are being used and not port 3306 that
> LibreOffice is expecting? If so, how should I fix this?
That message tells you that the server instance is running locally
(localhost) on a Unix socket, accessible via the default port 3306.
In order for it to be available to LO, you need to be able to point to
the socket file in the driver configuration dialog when setting up your
connection from LO. I seem to recall that we have had this exchange
already on the bug report you filed.
If you can't point LO to the Unix socket file (for whatever reason, e.g.
XAMMP is running in a jail, or you don't have access rights to the file,
or the dialog won't recognize any other path than a hardcoded default
(which is perfectly possible), then you will need to find and edit the
configuration file of the mysql server to allow general TCP/IP connections.
Usually this is done by :
- commenting out the line "skip-networking" ;
- adding the keyword bind-address=0.0.0.0 (to allow access from any
TCP/IP address, which is a potential security risk) or else specifying
your local IP LAN mask, to limit access to the instance from the local
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|[libreoffice-users] Connecting libreoffice to MySQL/MariaDB via JDBC||Michael Manning <email@example.com>|
|[libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC||Alexander Thurgood <firstname.lastname@example.org>|
|[libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC||Michael Manning <email@example.com>|
- Prev by Date: [libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC
- Next by Date: [libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC
- Previous by thread: [libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC