[Libreoffice-bugs] [Bug 134982] FILEOPEN Base Cannot connect to mysql

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134982

--- Comment #4 from Alex Thurgood <iplaw67 at tuta.io> ---
There you have your answer :

- Server : Localhost via UNIX socket

socket = /opt/lampp/var/mysql/mysql.sock

Your server is only providing the Unix socket connection.

The fact that you can access it via your web browser using 127.0.0.1 or
localhost is down to the way your phpmyadmin instance is configured, which
redirects the call to the Unix socket.


The msyql connection setup wizard used to allow you to specify the path to the
Unix socket (this is not the same as the URL using an IP address), but I
believe that this is now hardcoded to some usual default of a normally
installed Linux mysql/MariaDB server, i.e. /var/local/tmp/ or some such
directory, so:

- either you create a symbolic link between your actual mysql Unix socket and
the place where LO expects it to be (with appropriate privileges), or you
reconfigure your server to create a Unix socket in the place where LO expects
to find it.

- or your reconfigure your mariadb server to use TCP/IP (see the bind-address
entry) instead of acessing the Unix socket - this is generally done by editing
the my/cnf file, but beware of the safety considerations in doing so
(especially if you have access from outside your network into your LAN.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200721/fc061cf2/attachment.htm>