Description: I have KDE Neon with mysql-connectr provided in Synaptic, and after upgrading to 20.04 (Kubuntu packages) LibreOffice 6.4 (and 7.0) can't directly connect with mysql. I receive this error message: SQL Status: HY000 Error code: 2003 Can't connect to MySQL server on 'localhost' (111) /build/libreoffice-ron9it/libreoffice-7.0.0~rc3/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119 I have lampp in /opt In 6.0 all it's ok. Steps to Reproduce: 1. In LibreBase try to establish a direct connection with mysql 2. give user and pass, and socket location 3. you receive the erroir massage reporte above: "Error code: 2003 Can't connect to MySQL server on 'localhost' (111) Actual Results: No direct connection with mysql Expected Results: direct connection with mysql Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.1.2 Build ID: 00(Build:2) CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: it-IT (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.0.1_rc2-0ubuntu0.20.04.1 Calc: threaded
Isn't this a duplicate of bug134982 ? No problem here to connect to MariaDB with direct connection and the original packages from LO, versions LO 7.0.0.3 or LO 6.3.6.1 on OpenSUSE 15.1 64bit rpm Linux.
Maybe is the same problem, yes. But there someone says to do a symlink from the lampp socket (in /opt) to "the place where LO expects to find it". But can you kindly tell me where is this place? Thank you
(In reply to Duns from comment #2) > Maybe is the same problem, yes. > But there someone says to do a symlink from the lampp socket (in /opt) to > "the place where LO expects to find it". > But can you kindly tell me where is this place? > Thank you It depends on your Linux distrib and therefore has nothing to do with LO, per se. I would suggest looking up where Ubuntu 20.04 installs the Unix socket connection file when you install mysql server via the distrib provided package... at a guess, probably somewhere in /var/run/, cf. for example, here: https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04-fr
*** This bug has been marked as a duplicate of bug 134982 ***